CORAA
University · Related parties

Related Party Transaction Flag Worksheet.

Paste a transaction listing and enter the related party list you have from management. The tool matches names, flags look-alike names and keyword hits for parties not on the list, and shows items with no pricing basis. Flags are leads for inquiry, not conclusions.

Transactions and related party list

Paste from Excel or CSV. Columns are found by header names; if a name is not recognised the default position above is used.

Related party definitions and disclosure thresholds come from the Companies Act, Ind AS 24 or AS 18 and, for listed entities, SEBI rules. Check the current text for your entity. This tool applies only the list and settings you enter.

Flagged transactions
Transactions read6
Matched to your related party list5
Value matched to the list61,30,000.00
Lines flagged for any reason5
Rows that could not be read0
Party (normalised)TransactionsTotal
kapoor family trust125,00,000.00
asha traders224,90,000.00
rohit sharma director19,00,000.00
meena kapoor12,40,000.00
DatePartyNatureAmountFlags
2026-08-21Kapoor Family TrustLoan given25,00,000.00Related party on your list; No pricing basis recorded; At or above your amount threshold
2026-04-10Asha Traders LLPPurchase of goods18,50,000.00Related party on your list; At or above your amount threshold
2026-06-02Meena KapoorRent paid2,40,000.00Related party on your list; No pricing basis recorded
2026-09-30Rohit Sharma (Director)Remuneration9,00,000.00Name resembles listed party "Rohit Sharma"
2026-10-05Asha TradersPurchase of goods6,40,000.00Related party on your list

Completeness is the hard part.

The risk with related party transactions is rarely the ones management lists. It is the ones that are missed, or that are on terms that would not have been agreed between strangers. Matching the ledger to the list, then looking at names that resemble listed parties or carry words such as director or trust, gives you leads to ask about. Items with no recorded pricing basis are where the question of whether terms were arm's length starts.

Section 188 RPT threshold calculatorSection 185 loan checker

How the matching works

Names are normalised by removing punctuation and common suffixes such as Pvt, Ltd and LLP. A transaction matches your list when the normalised names are equal. It resembles a listed party when one name contains the other.

Parties not on the list are flagged if the name or nature contains one of your keywords. For related party lines the tool also flags a blank pricing basis and amounts at or above the threshold you set.

A summary shows the number and total value of transactions by matched party.

Worked example — name that differs slightly

The list has "Asha Traders LLP". The ledger shows a purchase from "Asha Traders" for 6,40,000.

Inputs
Listed partyAsha Traders LLP
Ledger partyAsha Traders
Output
MatchRelated party on your list
After removing the LLP suffix the names are the same, so the line is picked up even though the spelling in the ledger differs.

Common mistakes

Relying on management's list alone
Ask about the process used to build it, and test the ledger for parties that look related but are not listed.
Looking only at amounts
Small transactions on unusual terms can matter as much as large ones. Check the pricing basis.
Treating keyword hits as proof
A keyword is only a lead. Confirm the relationship before treating a party as related.

Frequently asked questions

Does the tool decide who is a related party?+
No. The definitions are in the law and standards that apply to your entity. You supply the list.
What columns does the pasted data need?+
A header row, then date, party, nature, amount and pricing basis. Other orders work if the header names contain words such as party, nature, amount or basis.
Is my data uploaded?+
No. Everything is processed in your browser.

Authoritative sources

ICAI — SA 550, Related Parties — Identifying related party relationships and transactions. Check the current text.
Always confirm against the latest version of the source. Regulations evolve and amendments are common.
Related calculators
Section 188 RPT threshold calculator →Section 185 loan checker →Journal entry test filter →
Share this tool
Last reviewed: 2026-10-17 · For informational purposes only — not professional advice.