Most year-end problems are not year-end problems. They are eleven months of small shortcuts that finally show up when your accountant asks for a clean set of books. A bank feed with 200 transactions nobody reviewed, a customer payment sitting in Undeposited Funds since March, a personal grocery bill coded to Office Supplies.
None of this is unusual. But it is much cheaper to fix in October or November than in the week your tax return is due. Here is the checklist I work through when I clean up a QuickBooks file before year-end, in the order that saves the most rework.
"Year-end" here means your own fiscal year-end. For many businesses that is December 31, but it could just as easily be March 31 or June 30, so adjust the timing to your calendar.
Reconcile every bank and credit card account first
Reconciliation comes first because everything else depends on it. If the bank account is wrong, your income, expenses and cash position are all wrong with it.
Reconcile each bank, credit card and loan account through your year-end date, not just the main checking account. I have seen businesses with a perfectly reconciled operating account and a credit card that had not been touched in eight months. In QuickBooks Online, go to Reconcile, pick the account, and enter the statement ending date and balance exactly as they appear on the statement.
If the difference will not reach zero, the cause is almost always one of three things: a duplicate transaction, a transaction recorded in the wrong period, or an incorrect opening balance from when the file was first set up. Check the first reconciliation in the file before hunting through recent months.
Review the bank feed before you reconcile
A bank feed is not bookkeeping until each line has been reviewed. Open the For Review tab and look at what is sitting there. Take a fictional design studio, Maple & Reed, with 214 feed transactions that had been auto-accepted without a second look. When we reviewed them, 19 were duplicates of manually entered expenses, and the books were overstating costs by about 4,100.
Clear the feed, match what already exists, and categorize what does not. Do this before you reconcile, not after.
Clean up Undeposited Funds and accounts receivable
Undeposited Funds should be close to zero at year-end. It is a holding account, not a place for money to live. If it carries a balance, payments were received but never matched to a bank deposit, or the deposit was recorded separately and the income was counted twice.
At Maple & Reed, Undeposited Funds held 9,275 across 11 customer payments. The deposits had been entered straight into the bank account as new income, so revenue was overstated by the same amount. The fix was to delete the duplicate deposits and use Bank Deposit to group the 11 payments properly.
Then run the A/R Aging Summary report. Anything over 90 days deserves a decision. Some invoices are simply unpaid and need a collection call. Others were paid by a method nobody recorded, or the client was never going to pay. If an invoice is uncollectible, write it off in a way your accountant agrees with rather than letting it inflate your income and your balance sheet. Maple & Reed had five invoices over 90 days totalling 12,400, and two of them had actually been paid.
Check accounts payable and unrecorded bills
Run the A/P Aging report and compare it against what you really owe. Bills that were paid but never recorded as paid will show as outstanding forever. Bills received after year-end but for services delivered before it belong in the old year if you use accrual accounting.
On cash basis, the question is simpler: were payments actually made before the year-end date? Either way, confirm which method your return is prepared on, because the same invoice lands in a different year depending on the answer.
Fix payroll liabilities and tips
Payroll is where I find the most expensive mistakes. Taxes withheld from employees' pay are not your expense. They are money you hold for the government until you remit it, so they belong in a liability account.
Look at your payroll tax accounts on the Balance Sheet. A liability balance that should have cleared after your last remittance means a payment was coded as an expense, or the payment was never recorded at all. Similarly, tips collected from customers and passed on to staff are a liability, not income, and should not appear in your revenue totals.
Reconcile payroll reports from QuickBooks Payroll, Gusto, or whichever provider you use against the payroll expense in your books. The totals should agree with your quarterly filings. Jurisdictions differ on forms and deadlines (IRS Form 941 in the US, PAYE returns to HMRC in the UK, PAYE to KRA in Kenya), so check the schedule that applies to you.
Separate personal and business transactions
Owners mix money more often than they admit. A fuel purchase here, a family streaming subscription there. In the diagnostic work I do, personal spending run through the business account often turns up in dozens of small transactions rather than one big one.
Search the expense accounts for items that do not belong, then reclassify them. For a sole proprietor or LLC, these go to Owner's Draw. For a corporation, they may be a shareholder loan or a taxable benefit, depending on the jurisdiction. At Maple & Reed, 47 personal transactions totalling 6,830 were coded across Meals, Software and Supplies, which would have reduced taxable profit incorrectly.
If you are unsure how a personal item should be treated for tax, ask before you reclassify it.
Review fixed assets, loans and opening balances
Did you buy equipment this year? Confirm it was recorded as an asset, not a plain expense, unless it falls under a small-asset threshold your tax rules allow. Depreciation or capital allowances are usually handled by your accountant, but they need an accurate asset list to work from.
For loans, compare the balance in QuickBooks with the lender's year-end statement. Principal repayments reduce the liability. Only the interest is an expense. When a whole loan payment is coded as an expense, profit is understated and the loan balance never goes down.
Also glance at the Opening Balance Equity account. It should be zero. A leftover balance means the file was set up with unresolved numbers.
Run the reports an accountant will want
Once the clean-up is done, run the Profit and Loss and Balance Sheet for the full year and read them like a stranger would. Ask what looks odd. A sudden drop in a monthly expense, a negative balance in an asset account, or an income category that is double what you expected all deserve a closer look.
Compare the Profit and Loss with last year, month by month. Then check that the cash balance on the Balance Sheet matches your bank statements to the last cent.
Sales tax or VAT deserves its own check. Reconcile your tax payable account against what you filed (sales tax in the US, GST/HST in Canada, VAT in the UK, GST in Australia). Rates, filing frequency and rules are set by each jurisdiction, so use your own authority's current guidance.
Gather year-end paperwork and lock the books
Collect the documents that do not live in QuickBooks: final bank and loan statements, payroll summaries, receipts for large purchases, and contractor details. In the US, that includes the information you need to issue 1099s to contractors, and the reporting thresholds change from time to time, so confirm the current figure with the IRS. Other countries have their own contractor and supplier reporting rules.
When everything agrees, set a closing date. In QuickBooks Online this is under Account and settings, then Advanced, then Accounting, where you can close the books and require a password for changes made before that date. This stops an accidental edit in March from quietly changing a year you have already reported.
A practical way to use this list
You do not need to do all of this in one weekend. Start with reconciliations and the bank feed, then work through receivables, payroll and owner transactions. Most of the time is spent on the first two steps, and the rest tends to be quicker once the foundation is right.
If you reach the end of a section and the numbers still will not agree, that is a good point to get a second pair of eyes on the file. I help small business owners clean up QuickBooks and get ready for year-end, whether you need a full review or just help with the reconciliations that will not balance.