Form 3CEB Reconciliation: Matching Transactions with Books and Financial Statements
Different totals can be correct only when their differences are explained. Build a transaction-level bridge from books to Form 3CEB and the related-party note.
AI Summary
Scope: FY 2025-26 / AY 2026-27 under Sections 92 to 92F of the Income-tax Act, 1961 and relevant Income-tax Rules, 1962; later tax years require their own law/form check. Verification date: 11 October 2026.
Reconcile at transaction level
A single total of group transactions is difficult to review. It can hide a missing service charge offset by an overstated purchase amount. Build the working by AE, transaction nature and supporting ledger before comparing totals.
Form 3CEB and accounting disclosures serve different purposes. The objective is not necessarily identical totals; it is complete data and a documented explanation of the reporting basis. Begin with approved books, the AE register and the relevant form requirements.
Build the source matrix
Record AE legal name and identifier, transaction category, agreement, invoice/reference, transaction currency, foreign-currency amount, booked INR amount, adjustment and final reporting amount. Add links to ledger extracts and the pricing working.
Maintain separate columns for current-year transactions and opening/closing balances. A receivable outstanding at year-end is not another sale merely because both appear in the supporting information.
A worked bridge
Assume a fictional company records ₹83 lakh of sales to an AE, ₹2 lakh of sales returns relating to those sales and ₹4 lakh of separate services provided. Its net trading revenue is ₹81 lakh; the combined booked revenue for these two categories is ₹85 lakh.
| Nature | Source | Book working |
|---|---|---|
| Sales | AE invoice listing | ₹83 lakh gross |
| Returns | Credit-note listing | ₹2 lakh reduction |
| Services | Separate service ledger | ₹4 lakh |
| Closing receivable | Outstanding ledger | ₹20 lakh, tracked separately |
Decide the required Form 3CEB treatment using the form, facts and technical review. Do not add the ₹20 lakh receivable to ₹85 lakh as if it were a further revenue transaction. If receivables require a separate reporting or pricing assessment, document that assessment without corrupting the revenue bridge.
Explain common sources of differences
- Currency: invoice values and the booked INR amount may differ from a calculation using one assumed exchange rate.
- Presentation: ledgers may show gross invoices while financial statements show returns or other adjustments separately.
- Capitalisation: some AE charges enter assets rather than current P&L expense.
- Timing: accruals and later invoices need a reporting-period review.
- Scope: accounting related parties and income-tax AEs may differ.
Use the applicable currency conversion and reporting basis, retaining a bridge to the books. Do not choose an average rate solely to make a number agree. Investigate tax components and pass-through amounts using the actual transaction terms.
Check pricing data against the same population
A transfer pricing study can become inconsistent with Form 3CEB when each uses a different extract. Agree turnover, costs, transaction categories and segment information between the files. Keep a record of changes after the first draft.
If an accrual is adjusted late, identify which parts of the report, financial statements and return need updating. A correction to one PDF alone does not repair the underlying transaction working.
Final review checklist
- Agree AE names and identifiers with approved records.
- Reconcile each transaction category to ledgers.
- Explain every material financial-statement difference.
- Verify currencies, periods and gross/net treatment.
- Agree the final population with the pricing analysis and relevant return disclosures.
For financials prepared in assureOffice, use the approved related-party and revenue workings as reconciliation inputs. Maintain a separately approved Form 3CEB matrix with clear references. This reduces repeated requests and helps the reviewer trace a number all the way back to its source.
Control rounding and reporting units
Keep the underlying reconciliation in consistent base units and record how report presentation is rounded. Small differences caused by rounding should be identified separately from scope differences, foreign-exchange differences or missing transactions. Do not use a general rounding line to absorb an unexplained balance.
When records are refreshed, compare the new transaction population with the previous approved extract. Identify new rows, changed values and deleted items by stable reference. Reassess the connected pricing working and reporting matrix before approving the replacement totals. This prevents the accounting reconciliation and the transfer pricing analysis from quietly drifting onto different versions.
Related articles
- Related Parties in Financial Statements and Transfer Pricing: Why the Lists May Differ
- How to Identify Associated Enterprises before Preparing Form 3CEB
- International Transactions for Form 3CEB: What Teams Commonly Miss