Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.
Register of every account to reconcile
Most reconciliation gaps start with an account nobody remembered: the old savings pot, the fuel card, the second credit card, the equipment loan. Listing every bank, card, loan, overdraft and deposit account the business holds, matched to its ledger account, sets the scope for everything else in this area and shows at once which ones have never been reconciled.
First tasks
- List every account from your online banking, card portals and lender letters
- Match each account to its ledger account in the accounting software
- Flag ledger bank accounts that have no real account behind them
- Note the last reconciled date for each account in the register
- Recheck the register for new or closed accounts @recurring(yearly)
Official statement archive for every account
Bank feeds are a convenience, not evidence: they drop transactions, duplicate others and rarely show the closing balance the bank stands behind. Keeping the official monthly statement for each account in one place, with a consistent file name, gives every reconciliation a fixed figure to agree to and gives the accountant or tax authority the proof they will ask for.
First tasks
- Create one statement folder per account in the register
- Download the current and last financial year's statements as PDFs
- Rename each file with account, year and month
- Request any missing statements from the bank in writing
- Save every account's new monthly statement into the archive @recurring(monthly:3)
Agreed starting balance for each account
Reconciling forward is impossible until there is one date on which the books and the statement are known to agree. Choosing that date for each account, usually the last year end your accountant signed off, and proving the ledger balance matches the statement on it, means every later difference belongs to a known period instead of the whole history.
First tasks
- Ask your accountant on which date the books last agreed to the bank
- Pull the statement balance and ledger balance for that date
- List and explain any difference between the two figures
- Save the starting balance and its evidence in each account's folder