TL;DR: A 6-month bookkeeping backlog can be cleared in a weekend: Friday evening to gather statements and set up your tool, Saturday to import and auto-categorize, Sunday to review exceptions and reconcile. Most founders finish with 4–8 hours of actual work.
I know the feeling. You open your accounting software in November and realize you have not touched your books since April. Tax season is coming. You either pay a CPA $1,500 to clean it up or you spend a weekend fixing it yourself.
This is the weekend approach.
Before You Start (Friday Evening — 1 Hour)
Step 1: Gather your statements
Log into every bank account and credit card. Download statements for every month you are missing. Create a folder on your desktop: /catch-up/statements/[month]/.
If you use Mercury, you can export a CSV of all transactions for a date range. Same with most modern banks. This is faster than uploading statement PDFs one by one.
Step 2: List every account
Write down every account that had business transactions during the backlog period:
- Business checking (Mercury, Chase, or similar)
- Business credit cards
- Stripe, PayPal, or other payment processors
You will reconcile each of these separately. Knowing the full list upfront prevents you from finishing Saturday and realizing you forgot your Amex.
Saturday: Import and Auto-Categorize
Step 3: Import your transactions
If you use Prosper, connect your accounts and the system imports historical transactions automatically. If you use QuickBooks or Xero, import via CSV for each account.
Do not try to categorize as you import. Import everything first, then categorize.
Step 4: Run auto-categorization
Prosper's engine categorizes 80–90% of transactions automatically based on merchant name, amount patterns, and your prior categorizations. For QuickBooks or Xero, set up rules for recurring vendors — AWS, Stripe, your SaaS subscriptions — to batch-process the obvious ones.
After auto-categorization, you should have a much shorter list of exceptions.
Step 5: Work through the exceptions
Go through uncategorized or low-confidence transactions one by one. For each one ask:
- Is this a business expense? (If yes, what category?)
- Is this personal spending through a business account? (Mark as owner's draw)
- Is this a transfer between accounts? (Match it to the corresponding entry)
Budget 2–4 hours for this step, depending on how many exceptions remain.
Sunday: Reconcile and Close
Step 6: Reconcile each account
For each account, pull the statement closing balance for the last month you are catching up through. Compare to what your software shows. Fix any differences before moving on.
Step 7: Handle Stripe fees
If you process payments through Stripe, make sure fees are recorded separately from gross revenue. See our Stripe and Mercury reconciliation guide for the exact process.
Step 8: Export and hand off
Export a trial balance and income statement for the period. Email it to your CPA with a note: "Books are clean through [date]." Watch their response change.
If you would rather not spend the weekend
Connect your accounts to Prosper — it handles steps 3–7 automatically and surfaces only the decisions that genuinely need your judgment. Most founders finish the review portion in under 2 hours instead of 8.
FAQ
How long does it take to catch up on 6 months of bookkeeping? For a solo founder with 50–150 transactions per month, expect 6–12 hours of focused work for a 6-month backlog. With a tool that auto-categorizes, you might spend 2–4 hours reviewing exceptions. Without automation, plan a full weekend.
Is it better to do catch-up bookkeeping myself or hire someone? If you are 1–6 months behind with simple books (one or two accounts, no payroll), do it yourself with the right tool. If you are 12+ months behind or have multiple entities, the time cost of DIY may exceed hiring a bookkeeper for a one-time cleanup.
What if I am missing bank statements for past months? Log into your bank online and download statements for the missing months. Most banks offer 12–24 months of history online. If you need older statements, contact your bank directly — they typically provide them for a small fee.