Agreeing schedules to the balance sheet and income statement
A schedule is only finished when its closing balance agrees to the balance sheet and its charge for the period agrees to the income statement. Blink pulls both statements into the same workbook, so the check is a formula that updates with every refresh.
Set it up once
- Pull the balance sheet as at the period end and the profit and loss for the period, each to its own tab.
- On each schedule, add a check: the schedule’s closing balance less the balance sheet account. It should be nil.
- Add a second check: the schedule’s expense or revenue for the period less the profit and loss account. It should also be nil.
- Bring every check onto one summary tab, so a reviewer sees all the differences in one place.
The trial balance works as well if you prefer one tab, since it carries both balance sheet and income statement accounts.
Getting the periods to match
- Use the same date on the balance sheet as on the schedule.
- Match the profit and loss period to what the schedule shows. If the schedule shows one month’s release, compare it with that month, not year to date. Pull the profit and loss with columns by month to get each month side by side.
When it does not agree
The usual causes, in the order worth checking:
- A new bill or invoice coded to the balance sheet account that is not yet on the schedule.
- A journal posted to the account outside the schedule.
- An item coded straight to the expense or revenue account that should have gone to the balance sheet.
- The month’s release journal not yet posted, or posted for a different amount.
To see what went through the account, pull its transactions for the period: Account Transactions in Xero, or the General Ledger in QuickBooks Online.
Each month
Roll forward moves each statement tab on one period and pulls it again, and Refresh All picks up late entries. The checks recalculate on their own, so the summary tab shows at once whether anything has moved.
Signing it off
The Reconcile tab records the check. Pick the account, point Blink at the cell with your schedule balance, and click Certify. If they differ, Blink asks for an explanation. If the ledger balance or the cell changes later, the certification shows as Stale until someone looks at it again.
Get started with Blink
Add Blink to Excel yourself, or send us the workbook and we’ll set it up with you.
