The First Thing I Fix When a Client Hands Me a Broken QuickBooks File

I have reviewed hundreds of QuickBooks files over 30 years as a Chartered Accountant and QuickBooks ProAdvisor. The businesses that hand me a clean file almost always got the setup right at the beginning. The businesses that hand me a problem — a P&L that doesn't make sense, a bank reconciliation that won't close, a tax return that takes twice as long to prepare — almost always have the same five setup problems.

None of these are difficult to fix. But they need to be fixed in the right order, because each one affects everything downstream.

1. The Company Settings Are Wrong

The first thing I check is not the accounts or the transactions. It is the company settings, because these determine how every subsequent transaction is recorded.

The two most common errors are the fiscal year start date and the accounting method. QuickBooks defaults to January 1 as the fiscal year start and cash basis as the accounting method. If your business has a different fiscal year, or if you operate on accrual basis (which most businesses with outstanding invoices or unpaid bills should), both of these need to be corrected before anything else is touched.

The fiscal year error affects every period comparison report. If QuickBooks thinks your year starts in January and your actual year starts in April, your quarterly P&Ls, your year-to-date figures, and your budget comparisons are all misaligned.

The accounting method error is more consequential. A business reporting on cash basis shows income when it is received and expenses when they are paid. A business reporting on accrual basis shows income when it is earned and expenses when they are incurred. For any business with meaningful accounts receivable or accounts payable — which includes most businesses billing on invoice — cash basis understates income in growth periods and overstates it in slow periods. The decisions you make from cash basis reports are based on a distorted picture.

Fix: Settings → Company Settings → Advanced. Correct fiscal year, switch to accrual basis.

2. The Chart of Accounts Has Not Been Cleaned Up Since Setup

The second thing I look at is the Chart of Accounts — specifically how many accounts there are, whether they are logically structured, and whether any personal expenses have been miscategorised as business expenses.

The typical problem file has between 150 and 300 accounts. Many of these are QuickBooks defaults that were never removed, accounts that were created twice under slightly different names, or accounts that were set up for one transaction and never used again. The result is a P&L that no one can read and an expense structure that hides the real cost picture.

The other version of this problem is the opposite: one income account called "Sales" that captures every revenue stream, making it impossible to understand which part of the business is actually growing.

A well-structured Chart of Accounts for a small business has 15 to 25 expense accounts, separate income accounts for each meaningful revenue stream, and no personal expenses hiding in business expense categories.

Fix: Review every account. Inactivate or merge duplicates. Separate income by service line. Move personal transactions to Owner's Draw.

3. Bank Feeds Are Being Added Instead of Matched

This is the single most common day-to-day error in QuickBooks and the one that creates the most downstream damage.

When a payment comes in from a client, QuickBooks sees two things: the invoice you created when the work was done, and the bank transaction when the payment arrived. These are the same event. The correct action is to match the bank transaction to the existing invoice — this marks the invoice as paid and correctly records the income.

What most users do instead is click "Add" on the bank transaction. QuickBooks creates a new income entry. Now the income is recorded twice — once as the original invoice (which is still open, showing as unpaid) and once as the new bank entry. The accounts receivable balance is wrong. The income is overstated. The bank reconciliation won't close cleanly.

This problem compounds over time. A file that has been running on "Add" instead of "Match" for two years has hundreds of duplicate entries, an accounts receivable balance that bears no relationship to reality, and a bank reconciliation that requires manual adjustments to close.

Fix: In the Banking tab, always use "Match" when a transaction corresponds to an existing invoice or bill. Use "Add" only for transactions that have no corresponding entry — bank fees, direct debits, transfers.

4. Payroll Is Not Integrated or Is Incorrectly Set Up

Payroll is where QuickBooks errors have the most serious consequences, because payroll errors affect tax deposits, W-2s, and employment compliance — not just internal reporting.

The most common payroll setup errors are: payroll taxes being mapped to the wrong expense accounts; employer contributions to benefits not being recorded; and payroll being entered manually rather than through the integrated QuickBooks Payroll module, creating mismatches between the payroll register and the general ledger.

When payroll is set up correctly and fully integrated, the payroll run automatically creates the correct journal entries — gross wages to salary expense, tax withholdings to the correct liability accounts, employer contributions to the correct expense accounts, and net pay to the bank. When payroll is entered manually or partially, these entries are often incomplete, creating a liability account that doesn't match what was actually deposited.

Fix: Use QuickBooks Payroll integration. Map payroll items to the correct accounts at setup. Reconcile payroll liabilities monthly, not just at year-end.

5. Reconciliation Has Not Been Done — Or Has Been Done Wrong

The final and most revealing check is the bank reconciliation history. A clean file has a completed reconciliation for every month since the file was created, with a zero difference.

A problem file has either no reconciliations at all, or reconciliations that were forced to close with an unexplained difference that got posted to "Reconciliation Discrepancies."

The Reconciliation Discrepancies account is where QuickBooks problems go to hide. If this account has a balance, it means at some point a reconciliation was closed even though the books did not match the bank statement. The difference was posted as an adjustment rather than investigated. Every month this compounds.

The fix for a file with accumulated reconciliation discrepancies is to work backwards from the oldest unreconciled period, identify each discrepancy, correct the underlying error, and re-reconcile. This is painstaking work. It is also unavoidable — the alternative is financial statements that are permanently unreliable.

Fix: Reconcile every account every month. Never force-close a reconciliation with a discrepancy. If you cannot reconcile cleanly, find the error before closing.

Why Setup Matters More Than Ongoing Bookkeeping

The businesses I work with that have the cleanest books are not necessarily the ones doing the most careful day-to-day bookkeeping. They are the ones that got the setup right at the beginning — correct company settings, logical Chart of Accounts, proper bank feed matching, integrated payroll, and monthly reconciliation from day one.

When setup is right, ongoing bookkeeping is fast and errors are visible immediately. When setup is wrong, every month adds more complexity and the problems become progressively harder to unwind.

If your QuickBooks reports feel unreliable, your bank reconciliation won't close, or your accountant keeps asking you to explain line items that should be self-explanatory, the setup is almost certainly where the problem starts.

At Aryan Consultancy, a QuickBooks setup review and cleanup is one of our most common engagements. We review the five areas above, identify the specific issues in your file, and fix them in the right order so that the downstream reports are reliable from the point of cleanup forward. Book a free 30-minute consultation to walk through your current setup. Book a free consultation →