Falling behind on bookkeeping is common. The busy season takes over, the person who did the books leaves, or the receipts pile up until starting feels impossible. The good news is that catching up follows a clear order, and doing it in that order makes it much faster.
Step 1: Find your starting point
Find the last month where your books were complete and reconciled. That's your starting point. If you're not sure, check when each bank account was last reconciled.
If nothing was ever reconciled, start from the beginning of the financial year or the date the business opened its accounts.
Step 2: Gather statements for every account
Collect statements for every bank account, credit card and loan from your starting point to today. Include accounts you rarely use. Missing one account is the most common reason catch-up books still don't balance.
Also gather what you can of sales invoices, receipts, payroll reports and any loan documents.
Step 3: Don't rely on bank feeds alone
Bank feeds in QuickBooks Online and Xero save time, but they often only go back a limited period when first connected. Older months may need to be imported from statement files or entered by hand. Your bank statements, not the feed, are the record you reconcile against.
Step 4: Work forward one month at a time
Start with the oldest month. Record its transactions, then reconcile every account for that month before moving on.
It's tempting to enter everything first and reconcile at the end. Don't. An error in month one carries into every month after it. Reconciling as you go catches problems while they're small.
Step 5: Record income from the source
Use your sales invoices, card settlement reports and deposit records to record income. Check that deposits match what customers actually paid. Watch for the same payment appearing in two places, such as a check that shows on its own and again on a deposit slip.
Step 6: Code your expenses
Code each expense to the right account in your chart of accounts. Set up rules in QuickBooks or Xero for recurring suppliers to save time. Keep personal spending out of business expenses, or record it as an owner's draw.
Step 7: Handle payroll, loans and owner transactions
Post payroll from your payroll reports. Split loan payments into interest and principal. Record money the owner put in or took out as owner's equity or draws, not as income or expenses.
Step 8: Review and lock the books
When every month is reconciled, review the profit and loss statement and balance sheet for anything that looks wrong. Then set a closing date in QuickBooks Online, or a lock date in Xero, so the finished months can't be changed by accident.
How long does catch-up bookkeeping take?
It depends on how many months you're behind, how many accounts you have and how complete your records are. As a guide, a bookkeeper can catch up a few months for a small business in about a week. A full year usually takes around three weeks.
Should you do it yourself?
If you're a few months behind with one or two accounts and good records, you can catch up yourself by following these steps. If you're a year or more behind, or your records are incomplete, a bookkeeper will usually get there faster and catch problems you might miss.
How to avoid falling behind again
Set a monthly routine: record transactions weekly, reconcile as soon as statements arrive, and review your reports before the next month starts. Or hand the routine to a monthly bookkeeper.