QuickBooks year-end cleanup guide
Duplicate transactions, unreconciled accounts, stale uncleared items, and missing receipts can turn year-end into a scramble. Use this checklist to get organized, then use your free Bookkeeping Disaster Score to see what may need attention in your own file.
The checklist
Work in this order when possible. It reduces rework and gives you a clearer record of the questions that need an accountant’s input.
Duplicates often appear when bank feeds, manual entries, receipt apps, or imported files overlap. Compare transactions by date, amount, payee, and account before deleting anything. If you are unsure which entry is valid, flag it for review instead of guessing.
Match QuickBooks activity to each statement through the end of the period. A bank balance that looks close is not enough: reconciliation confirms that the cleared transactions and ending balance agree with the statement.
Look for payments, deposits, cheques, and transfers that have been sitting uncleared for months. They can be timing differences, duplicates, entries posted to the wrong account, or items that were never actually paid. Investigate the source before clearing or deleting them.
Scan your profit and loss for expenses parked in Uncategorized Expense, Ask My Accountant, owner draws, or broad catch-all accounts. Make sure recurring purchases are consistently categorized and that personal spending is separated from business activity.
For material purchases, subcontractors, vehicle costs, travel, meals, and unusual transactions, attach or organize the receipt, invoice, or contract that explains the entry. Clear documentation makes it faster to answer your accountant’s questions and support the expense if it is reviewed later.
Check that taxable sales, zero-rated or exempt sales, and input tax credits are not mixed together by accident. Also flag owner payments, payroll-related entries, sales tax payments, and large adjustments for your accountant or tax adviser. Cleanup is not a substitute for tax advice or filing review.
Prepare reconciled bank and credit card statements, a profit and loss, balance sheet, accounts receivable and payable aging, loan statements, payroll records, sales tax filings, and notes for anything unusual. Your accountant can then start with organized evidence instead of a scavenger hunt.
Not sure where to begin?
Upload your QuickBooks reports to receive a free Bookkeeping Disaster Score. It gives you a focused starting point before you spend hours clicking through transactions.
Avoidable year-end friction
These are common, fixable issues. Addressing them early saves back-and-forth, makes your reports more reliable, and keeps the conversation focused on decisions instead of detective work.
01
The same supplier bill or card purchase appears twice, overstating expenses and forcing someone to trace which entry is real.
02
Old cheques, deposits, and transfers remain on the books without an explanation, leaving account balances hard to trust.
03
Large or unusual expenses have no invoice, receipt, or note attached, so the purpose and tax treatment cannot be confirmed quickly.
Quick answers
A useful cleanup reviews reconciliations, duplicate transactions, old uncleared items, transaction categories, supporting documentation, GST or tax review flags, and the records your accountant needs to begin year-end work.
Yes. The free score is designed to highlight visible risks in exported QuickBooks reports, including possible duplicate transactions, old uncleared items, categorization concerns, missing documentation, and GST review flags.
No. Black-Tek Ledger helps organize and clean up the bookkeeping so your accountant can spend less time untangling records. Your accountant remains responsible for tax advice, tax filings, and final accounting decisions.
Receipt Rescue is one all-inclusive recurring plan at CA$30/month, paid monthly through MadeThis hosted checkout.
Provide reconciled account statements, financial reports, receivable and payable aging, loan and payroll records, sales tax filings, key receipts or invoices, and concise notes about unusual transactions or changes in the business.
Before tax time gets urgent
Start with your free Bookkeeping Disaster Score, then add all-inclusive monthly Receipt Rescue support when you are ready for hands-on help.