Bookkeeping Cleanup Project Example for Small Firms
A bookkeeping cleanup is usually requested after a business owner needs a loan, prepares for year-end tax filing, falls behind on GST, or simply stops trusting the numbers in QuickBooks Online. This bookkeeping cleanup project example shows what the work can look like for a growing Alberta service business and, more importantly, what changes once the records are reliable.
The example is fictional, but the issues are common: unreconciled bank accounts, transactions posted to the wrong categories, duplicate expenses, missing receipts, and GST balances that do not match the activity in the books. A cleanup is not just data entry for old months. It is a structured process to rebuild records that management, an accountant, and the CRA can use with confidence.
A Bookkeeping Cleanup Project Example
Consider an Edmonton-based contractor with annual revenue of approximately $720,000. The business has two operating bank accounts, two credit cards, a vehicle loan, and one QuickBooks Online file. It processes roughly 450 to 600 transactions per month and charges GST on most work.
The owner had been categorizing transactions when time allowed. A former employee also entered some expenses, and the tax accountant received an annual export at year-end. After nine months, the owner could see a profit-and-loss statement, but could not explain why the bank balance, sales totals, and GST payable did not appear to agree.
The immediate request was simple: catch up the books before the next GST filing and prepare financial reports for a lender. The actual scope required more care. Before correcting anything, the bookkeeper needed to determine which balances were dependable, which records were incomplete, and whether prior GST filings had been based on accurate information.
Starting condition
The QuickBooks Online file showed a healthy profit, but several warning signs appeared during the initial review. The main bank account had not been reconciled for seven months. Credit card payments had been recorded as expenses instead of transfers, which overstated operating costs. Customer deposits were sometimes posted directly to income before the related work was completed.
There were also uncategorized transactions, duplicate software charges, and shareholder or owner purchases mixed with business expenses. The GST payable account had a balance that did not match the most recent filed return. That does not automatically mean a return is wrong, but it does mean the filing history must be compared to the books before an adjustment is made.
This is why a cleanup begins with a document and account review rather than immediately changing categories. Fast corrections without source documents can create a cleaner-looking file that is still incorrect.
What the bookkeeping cleanup project included
The project covered nine months of activity, with a defined objective: reconcile all balance sheet accounts, correct material coding errors, produce usable monthly reports, and identify GST items requiring review. The business owner provided bank and credit card statements, loan documents, sales summaries, copies of filed GST returns, major supplier invoices, and access to QuickBooks Online.
The work was completed in stages so that each month could be supported before moving to the next one.
1. Establishing opening balances
The bookkeeper started with the last period that had been reconciled and verified the opening bank, credit card, loan, and GST balances. If the starting point is wrong, every later reconciliation can appear to work while carrying an error forward.
The vehicle loan was a useful example. Monthly payments had been entirely coded to vehicle expense. The cleanup separated the interest portion from the principal repayment and aligned the loan liability with the lender statement. This reduced expenses in the current period but gave the owner a more accurate view of both debt and operating profit.
2. Reconciling bank and credit card activity
Each bank and credit card account was reconciled to its monthly statement. This process confirmed that transactions in QuickBooks Online matched the actual movement of cash and identified charges that had been missed, duplicated, or recorded in the wrong month.
Several owner-paid expenses were found on the credit card statement but had not been entered. These were recorded with supporting documentation and classified appropriately. Personal purchases were moved out of operating expenses and recorded to the owner draw or shareholder account, depending on the company structure and advice from the tax professional.
Credit card payments were then corrected from expense entries to transfers against the credit card liability. That one correction removed a significant double-counting issue from the profit-and-loss statement.
3. Correcting income and expense categories
Cleanup work should focus on decisions, not cosmetic perfection. A $12 office supply error may not change how a business is managed. Repeatedly misclassifying subcontractor costs, vehicle expenses, merchant fees, or customer deposits can materially distort margins and cash forecasts.
In this example, customer deposits were reviewed against completed work. Amounts earned were recognized as income, while deposits for work not yet completed were recorded as a liability where appropriate. The owner could then distinguish cash received from revenue actually earned in the period.
Recurring transactions were also standardized. Software subscriptions, insurance, phone costs, fuel, and contractor payments were assigned consistent categories. The goal was to make future reports comparable month to month rather than requiring the same questions every reporting period.
4. Reviewing GST before filing or amending
GST cleanup requires caution. The bookkeeper compared taxable sales and eligible input tax credits in QuickBooks Online to the GST returns already filed. Transactions without sufficient support were flagged rather than automatically claimed as input tax credits.
The review found that several expenses had been entered with GST when the supplier invoice did not show GST. Other eligible purchases had been entered without tax. After corrections, the GST account was recalculated by filing period and compared to amounts remitted.
Where a material difference remained, the owner and tax accountant could decide whether an adjustment or amended filing was needed. The right approach depends on the amount, the filing period, available documentation, and the business's tax advice. A bookkeeping firm can organize and reconcile the records, but legal tax positions should be confirmed with the appropriate professional when circumstances are unclear.
The reports produced after cleanup
At the end of the project, the owner received a reconciled balance sheet, monthly profit-and-loss statements, a cash activity review, and a list of open questions or documents still needed. The reports were more useful because the underlying accounts had been reconciled rather than estimated.
The cleaned profit-and-loss statement showed that gross margin was lower than the owner expected, largely because subcontractor costs had been understated in earlier reports. That was difficult news, but it was actionable. The business adjusted estimates on new jobs and reviewed pricing on lower-margin work.
The cash position was also clearer. The company was profitable on paper but had predictable pressure before large supplier payments and payroll-related withdrawals. With accurate transaction timing, the owner could begin using a short-term cash forecast instead of relying on the bank balance alone.
Moving from cleanup to ongoing control
A cleanup project should not become an annual habit. Once records are corrected, the next priority is creating a monthly process that matches the business's transaction volume and complexity.
For a self-employed, cash-based operator with limited accounts and revenue below $250,000, this may mean monthly transaction management, bank reconciliation, and annual GST filing support. An established business with hundreds of monthly transactions, multiple financial accounts, and revenue closer to $500,000 to $1.5 million generally needs more frequent oversight and regular reporting.
The practical standard is straightforward: every bank and credit card account should be reconciled on schedule, supporting records should be available for material transactions, and the profit-and-loss statement should be reviewed while there is still time to act on it. Accounts payable, customer deposits, loans, payroll, and GST may require additional scope depending on how the business operates.
Accurate Bookkeeping Alberta approaches cleanup with the same discipline used for ongoing bookkeeping: define the accounts, transaction volume, reporting needs, GST schedule, and unresolved issues before setting the scope. That prevents a fixed-price cleanup from becoming an open-ended exercise and gives the owner a clear view of what will be delivered.
A clean QuickBooks Online file will not make every business decision easy. It does give you something far more useful than a guess: current financial information that can support pricing, spending, tax planning, and the next conversation with your lender or accountant.