When you onboard a bookkeeping client with no records, the engagement usually starts the same way: a shoebox of logins, a half-finished QuickBooks file, and twelve months of activity nobody has touched. Good new client onboarding bookkeeping isn’t about heroics — it’s about a repeatable way to rebuild books from statements quickly and accurately, so you can get to a clean trial balance and start the actual work. The trick is to treat the statements, not the broken ledger, as your source of truth.
Start from the statements, not the mess
When you onboard a bookkeeping client with no records, resist the urge to fix the existing file. A half-coded ledger with mystery entries is often slower to repair than to rebuild. Instead, decide your start date — usually the beginning of the last clean fiscal year or the period your engagement covers — and gather every pdf/csv/excel bank and credit-card statement from that date forward. The statements are complete, dated, and authoritative. That’s your foundation.
Rebuild books from statements, account by account
Work one account at a time so nothing slips:
1. Inventory the accounts. List every bank and credit-card account the business used in the period, even closed ones. Closed and non-connected accounts are exactly where bank feeds fail you, so the statement is the only reliable record. 2. Collect statements end to end. No gaps. A missing month becomes a missing reconciliation later. 3. Categorize each statement. Read the transactions, assign accounts, and produce a coded file per account. 4. Import into the ledger. Push each coded file in as a QuickBooks “batch transactions import file” or a Xero “precoded import file.” (The step-by-step is in Import Bank Statements into QuickBooks: 3 methods.) 5. Reconcile to each statement’s ending balance. This is your proof the rebuild is complete.
This catch up onboarding sequence gives you a defensible set of books because every transaction traces back to a statement line.
Remove the data-entry bottleneck
The slow part of any rebuild is reading and coding hundreds — sometimes thousands — of historical transactions. That’s where I use Bookmonstic. It reads a pdf/csv/excel bank or credit-card statement, categorizes every transaction, and exports a QuickBooks “batch transactions import file” or a Xero “precoded import file.” No rules to build, no API, no bank feed needed — which is the whole point when you’re working from old statements on accounts that were never connected. (Disclosure: I’m a CPA and Bookmonstic is my own tool.)
The benefit that matters for onboarding is turnaround. Instead of billing a client twenty hours of keystrokes just to start, you compress the capture step into minutes per account and spend your judgment on the things that actually need it: opening balances, intercompany transfers, owner contributions, and prior-period cleanup.
Set the relationship up right
A clean rebuild is also your chance to set expectations. Once the books are caught up, document your categorization mapping so month-to-month coding stays consistent, agree on how statements will reach you each period, and note which accounts are non-connected so the team knows to work from the statement. Good catch up onboarding ends with not just clean books, but a process that keeps them clean.
Frequently asked questions
Should I fix the client’s existing QuickBooks file or start over? If the file is materially wrong or half-coded, rebuilding from statements is usually faster and more defensible than untangling someone else’s errors. Reserve repair for files that are mostly right.
How far back should I go to rebuild books from statements? Match your engagement scope — typically the start of the last clean fiscal year, or whatever period the tax or compliance need requires. Then collect every statement from that date with no gaps.
What about accounts that no longer have an online login? Request paper or PDF statements directly from the client or bank. Since the rebuild works from the statement itself, a closed or non-connected account is no obstacle.
How do I keep new client onboarding bookkeeping from blowing the budget? Compress the mechanical capture step. The hours that wreck onboarding budgets are data entry, not judgment — so categorize and import in bulk, and bill your time for cleanup decisions, not typing.
Written by the founder of Bookmonstic, a practicing CPA. Bookmonstic turns PDF/CSV/Excel bank statements into AI-categorized, import-ready files for QuickBooks and Xero — no rules to build, no API. Try it free →
Leave a Reply