Download X: Balance Sheet Reconciliation Tracker (.xlsx)
What it does
Lists every balance sheet account, compares the ledger with the supporting schedule, records reconciling items, preparer and reviewer, works out the review due date in working days, ages open items and scores completion by risk rating.
Who it is for
Controllers and finance managers.
How to use it
- Go to 'Settings'. Type the month end, the number of working days allowed after month end, the difference threshold and your holidays.
- Go to 'Accounts'. List each balance sheet account with its risk rating and owner. Paste the trial balance figure in 'GL balance' and the total of the supporting schedule in 'Schedule balance'.
- Type the reconciling items that explain any difference (with their oldest item date), then the preparer, reviewer and the dates they signed off.
- Read the 'Status' column. 'Complete' means the account agrees within the threshold, was prepared and reviewed by different people, and was reviewed on time.
- Go to 'Summary' for completion by risk rating and the Checks box.
Tabs in the file
| Tab | What it holds |
|---|---|
| Settings | Month end, timing rule, threshold and holidays. |
| Accounts | Account-wise reconciliation status. |
| Summary | Completion by risk and checks. |
Learn the topic
For computation and reconciliation assistance only; not a substitute for formal statutory audit or legal tax advice. All sample data is illustrative and made up. Rates, limits and rules must be checked against current law and your own agreements before use. No tax saving, audit outcome or compliance result is promised.