How to Track Accrued Liabilities Without a Spreadsheet
Accrued liabilities are easy to forget and hard to reconcile in Excel. Here is a better way to record, track, and reverse them every month.
A guide to managing intercompany accruals — including timing differences, elimination entries, and practical reconciliation approaches.
Intercompany accruals are one of the most complex areas in multi-entity accounting. When one entity provides services to another, the receiving entity must accrue the expense if an invoice has not yet been received by month-end. The providing entity records revenue. At consolidation, these balances must be eliminated — but only if both sides agree.
In a multi-entity group, services, management fees, and shared costs flow between entities. The timing of invoices rarely aligns with the period in which the service was provided. Without accruals, one entity's expenses would be understated and the group's intercompany balances would not eliminate cleanly.
Entity A accrues £10,000 for services from Entity B. Entity B has not yet raised the invoice, so it has not recorded the revenue. At consolidation, A has a payable of £10,000 and B has no receivable. The balances do not match and cannot be eliminated. This creates intercompany differences that must be investigated.
The most common source of intercompany reconciliation breaks is timing — one entity accrues and the other does not. Agreement on amounts and timing before the close process starts prevents this.
Intercompany accruals should be reversed when the actual invoice is processed. If the accrual was £10,000 and the invoice comes in at £10,200, the reversal clears the accrual and the £200 difference flows through as an expense variance. Document any differences above your threshold.
Each intercompany accrual should be tracked as a separate item with the counterparty entity identified. This makes reconciliation possible. A tool that tracks accrued liabilities by entity and provides an as-of-date view makes the consolidation process significantly faster.
CloseKit replaces your spreadsheets with instant balance sheet reconciliations. Start a free trial — no credit card required.
Accrued liabilities are easy to forget and hard to reconcile in Excel. Here is a better way to record, track, and reverse them every month.
Not all accruals work the same way. Recurring accruals need a different management approach to one-off estimates. Here is how to handle both.
A step-by-step guide to reconciling your balance sheet accounts at month-end, with a focus on prepaid expenses and accrued liabilities.
Learn how to correctly record, track, and amortize prepaid expenses so your balance sheet is always accurate — without Excel.