How do I set up catch-up bookkeeping for a business with missing receipts and old unreconciled accounts?

Here’s a practical way to set up catch-up bookkeeping when you have missing receipts and old unreconciled accounts.

1) Stop the bleeding first

Before entering old data:

• Freeze current bookkeeping processes so you’re not mixing catch-up work with ongoing bookkeeping.
• Set a cutoff date: decide how far back you need to go.
• Gather every available source:
  • bank/credit card statements
  • loan statements
  • payroll records
  • tax returns
  • prior bookkeeping files
  • invoices, bills, contracts
  • merchant processor reports (Stripe, Square, PayPal, etc.)
  • accounting system exports

2) Choose a catch-up order

A good sequence is:

1. Bank and credit card accounts
2. Loans and lines of credit
3. Sales/revenue records
4. Vendor bills and expenses
5. Payroll and taxes
6. Fixed assets and equity
7. Adjustments and missing items

This order helps you build accurate books from the actual cash movement outward.

3) Recreate the books from statements

If receipts are missing, don’t wait for perfection. Use bank/credit card statements as the backbone:

• Match transactions to any available support
• Use deposit details, invoice numbers, merchant reports, and vendor names
• Categorize expenses based on:
  • vendor identity
  • transaction memo
  • historical patterns
  • tax return categories
• For income, tie deposits to:
  • invoices
  • sales reports
  • payment processor payouts
  • recurring customer receipts

4) Handle missing receipts sensibly

For missing receipts:

• Try to obtain duplicates from vendors, email, portals, or card statements
• If you can’t, create a reasonable replacement record:
  • note the transaction date, amount, vendor, and purpose
  • store any backup evidence you do have
  • mark it as “receipt missing” or “supporting documentation incomplete”
• For tax purposes, some expenses may still be deductible with adequate substantiation, but rules vary by jurisdiction and expense type.

5) Reconcile old accounts one by one

For each bank and credit card account:

• Start with the oldest unreconciled statement
• Compare statement ending balance to the ledger
• Identify:
  • missing entries
  • duplicate entries
  • wrong dates
  • wrong amounts
  • uncategorized transfers
• Reconcile sequentially until current

If a prior period is too messy:

• reconcile to a known accurate statement date
• record an adjusting entry for the difference
• document the reason clearly

6) Clean up transfers and owner draws

A common catch-up issue is misclassified transfers:

• Match bank-to-bank transfers
• Distinguish:
  • owner contributions
  • owner draws/distributions
  • loan proceeds
  • repayments
  • intercompany transfers

These are often the cause of “out of balance” books.

7) Identify missing liabilities and unpaid items

Look for:

• unpaid vendor bills
• accrued payroll
• sales tax payable
• income tax estimates
• credit card balances
• loan principal vs. interest
• subscriptions or services received but not yet billed

This step prevents overstating profit.

8) Check fixed assets and depreciation

If you purchased equipment, vehicles, software, or property:

• verify purchase dates and amounts
• determine whether items should be capitalized
• calculate or reconstruct depreciation/amortization
• review prior-year tax treatment if needed

9) Make and document adjusting entries

Common adjusting entries include:

• bank fees or interest not recorded
• loan interest allocation
• depreciation/amortization
• payroll accruals
• sales tax liability corrections
• prior-period error corrections
• bad debt write-offs
• owner equity corrections

Keep a cleanup log showing:

• what was changed
• why it was changed
• source document or evidence
• date and amount

10) Decide how to treat prior-period problems

If older periods are materially wrong:

• fix them in the historical period if possible
• otherwise post to a prior-period adjustment
• consult your accountant/CPA if the changes may affect prior tax filings or financial statements

11) Set up a bookkeeping system going forward

Once caught up:

• create a monthly close checklist
• reconcile bank/credit cards every month
• require receipt capture within 24–72 hours
• use a receipt app or cloud storage
• assign coding rules for recurring vendors
• review accounts payable, receivable, and payroll monthly

12) Use a tracking spreadsheet during cleanup

A simple catch-up tracker helps a lot. Columns:

• date
• account
• amount
• vendor/payee
• type
• category
• status
• support available?
• action needed
• notes

13) Know when to bring in a professional

Get help from a bookkeeper/CPA if:

• multiple years are missing
• taxes were filed with unreliable numbers
• payroll or sales tax is involved
• you have loans, grants, or investor reporting
• you need audited or lender-ready statements

Best-practice workflow

A solid workflow is:

1. collect statements and source docs
2. enter all bank/credit card transactions
3. categorize and match revenue/expenses
4. reconcile each account
5. fix transfers and equity
6. record accruals and adjustments
7. review financial statements
8. lock the period and move to monthly maintenance

If you want, I can also give you:

• a step-by-step catch-up bookkeeping checklist
• a cleanup spreadsheet template
• or a QuickBooks/Xero-specific process