Short answer: to catch up on bookkeeping, gather every statement first, then work through your books one month at a time, oldest month first: bring in the transactions, categorize them, and reconcile each account before moving to the next month. Do not start with the current month. Fixing the past in order is what makes your balances, and your tax numbers, come out right.
Step 1: Decide how far back you need to go
Start from the last month your books were truly reconciled and correct. If you are not sure, go back to the start of the last tax year you have not filed. Everything after that point needs to be caught up.
Step 2: Gather your records before you touch QuickBooks
- Bank statements for every business checking and savings account
- Credit card statements for every business card
- Loan statements, merchant processor reports (Stripe, Square, PayPal) and payroll reports
- Receipts and bills for larger purchases
- Last year’s tax return, if one was filed, so your opening balances can match it
Having everything in one place first saves hours of stopping and starting.
Step 3: Get the transactions into QuickBooks
Connect your bank and card accounts under the banking area of QuickBooks Online. Bank feeds usually only download recent history, so for older months, download statement files from your bank (CSV, QBO or OFX) and use Upload from file to bring them in. Watch for duplicates where a transaction was already entered by hand.
Step 4: Work month by month, oldest first
For each month, for each account:
- Categorize every transaction to the right account
- Match transfers between your own accounts so they are not counted as income or expense
- Reconcile the account to that month’s statement until the difference is zero
Only then move to the next month. Our guide on reconciling QuickBooks Online when you are months behind covers the reconciliation step in detail.
Step 5: Review the results with your tax deadline in mind
Once every month is reconciled, run your Profit & Loss and Balance Sheet and check that they make sense: bank balances match statements, loan balances match lender statements, and owner draws are not showing up as expenses. Common federal deadlines for calendar-year businesses are March 15 for partnerships and S corporations, and April 15 for sole proprietors and C corporations. Extensions give you more time to file, not to pay, so it is worth being caught up before the original date.
Step 6: Stay current so it never happens again
A catch-up only helps if the books stay current. Set aside time every month, or hand it off. On our monthly plans, your books are reconciled and your reports arrive by the 10th, or that month is free.
When to hand it off instead
Doing a catch-up yourself makes sense for a few months of a simple business. Consider getting help if you are more than six months behind, have several accounts, have payroll or inventory, or if your opening balances do not match your last tax return. A fixed-price catch-up is usually cheaper than paying your CPA to fix books at tax time.
Not sure how bad it is? Start with a free QuickBooks Health Check. You get a written report on your file within 2 business days and, if you need it, a fixed quote. You can also get a rough idea first with our cleanup cost calculator or read what a QuickBooks cleanup costs.