Related Party Register – Excel File
159
Related Parties Register: Documents related parties, transactions, balances, terms, and approvals, with contract references and transaction nature. Delivers RPT disclosure-ready data for financial statements and governance.
Still Tracking Related Party Transactions on Scattered Spreadsheets?
One missing disclosure can trigger an audit qualification. This ready-made Excel register gives you a complete, IAS 24-compliant system to record every related party, every transaction, and every approval — so your financial statements are audit-ready from day one, not the night before.
🛡️ 7-Day Guarantee
📊 IAS 24 Compliant
5 Signs You Need This Register Right Now
1Incomplete Party Records: You rely on memory or outdated lists to identify who qualifies as a related party — and every year the auditors find someone you missed.
2No Approval Trail: Board or management approvals for related party deals exist only as scattered emails or PDF scans with no central tracking.
3Manual Disclosure Drafting: At year-end you scramble to pull transaction details from multiple sources just to draft the IAS 24 note.
4Balance Reconciliation Gaps: Receivables and payables with related parties don’t tie back to the trial balance, creating last-minute audit queries.
5Audit Friction Every Cycle: The tie-out between your RPT schedule and the general ledger takes hours of manual checking and still produces errors.
What You Get
Six integrated worksheets that cover the full related party lifecycle — from identification to signed-off disclosure.
| Related Party Master List | Central register of all related parties (subsidiaries, associates, key management, major shareholders) with relationship type, ownership %, and status tracking. |
| RPT Transactions Log | Detailed log for every transaction (sales, purchases, loans, leases, service agreements) with amounts, dates, and terms — all cross-referenced to the master list. |
| Approvals Tracker | Tracks board and management approvals per transaction, including approval date, authority level, and sign-off status for full governance compliance. |
| RPT Balances Schedule | Period-end balance summary for each related party (receivables, payables, loans) with aging analysis ready for disclosure notes. |
| TB Tie-out | Automated reconciliation between RPT balances and your trial balance — highlights differences instantly so nothing slips through. |
| Disclosure Pack | Pre-formatted IAS 24 disclosure template: nature of relationships, transaction summaries, outstanding balances, and sign-off section. |
How to Use It in 4 Simple Steps
Build Your Related Party Master List
Open the Master List sheet and enter every related party: company name, relationship category (subsidiary, associate, key management, major shareholder), ownership percentage, and effective date. This becomes your single source of truth.
Log Transactions and Approvals
Record each transaction in the Transactions Log with full details — then track its approval in the Approvals Tracker. Every deal now has a clear paper trail from initiation to sign-off.
Reconcile Balances to Trial Balance
Update the Balances Schedule at period-end, then run the TB Tie-out sheet. Differences between your RPT records and the general ledger are flagged automatically — resolve them before the auditors arrive.
Generate Your Disclosure Pack
The Disclosure Pack pulls together relationship summaries, transaction totals, and outstanding balances into an IAS 24-ready format. Review, sign off, and hand it straight to your auditors.
Before vs. After This Register
| Aspect | ❌ Without | ✅ With This Register |
|---|---|---|
| Party Identification | Informal lists updated once a year | Centralized Master List updated in real time |
| Approval Tracking | Emails and PDFs buried in folders | Approvals Tracker with status, date, and authority |
| Balance Reconciliation | Manual TB matching — hours of work | Automated Tie-out flags mismatches instantly |
| Audit Disclosure | Drafted from scratch under deadline pressure | Disclosure Pack ready for review and sign-off |
You are an accountant, financial controller, or auditor who needs a structured, IAS 24-compliant way to track related parties, log transactions, secure approvals, and produce disclosure-ready schedules — especially if you work in Excel-based environments.
Your organization has no related party transactions, or you already use a fully integrated ERP module that handles RPT tracking and disclosure automatically — and you have no need for an Excel-based solution.
Is this register aligned with IAS 24 requirements?
Yes. The register is designed around IAS 24 disclosure requirements — covering relationship identification, transaction categorization, outstanding balances, terms and conditions, and key management personnel compensation.
Can I customize the file for my company?
Absolutely. The file is a standard Excel workbook — you can add columns, modify categories, insert your company logo, and adapt it to your specific reporting needs.
How long does the initial setup take?
Most users complete the setup (master list + historical transactions) in 30 to 60 minutes, depending on the number of related parties. After that, ongoing maintenance is just a few minutes per transaction.
Does it handle intercompany loans and balances?
Yes. The Balances Schedule includes dedicated fields for loans receivable and payable, with aging categories and currency columns to support multi-entity group reporting.
Ready to Make Related Party Compliance Effortless?
Get a complete, audit-ready RPT register — track, reconcile, and disclose with confidence.
| الفئات | IFRS & Financial Consolidation |
|---|---|
| Job Title | Chief Accountant |
| Level | Advanced |
| Format | Excel |
Reviews
Clear filtersThere are no reviews yet.