How to clean up messy books before year-end: the order that saves the most time

Messy books get cleaned up fastest in a fixed order, and it is not the order most owners choose. The instinct is to open the uncategorized list and start assigning expenses. We start earlier than that, by proving every transaction is actually in the file, and we finish later, by tying every balance sheet account to an outside document. Categories sit in the middle. Work in that sequence and you touch each transaction once; work in any other order and you redo September three times. Below is the triage we run on a neglected file in the weeks before a year-end.

Step one: make every bank and card feed complete before you categorize anything

List every account the business touches: chequing, savings, each credit card, the line of credit, every loan, and every processor that holds money for you such as Stripe, Square, PayPal or Shopify Payments. Each one needs a feed or a statement import covering the entire year. Then check the feed for gaps. Bank connections drop silently when a password changes or the bank updates its security, and when they reconnect they often skip the weeks in between. The test is simple: for each month, the closing balance in your accounting file should match the closing balance on the statement. Where it does not, download the missing period as a CSV and import it.

Do this first because every downstream decision depends on it. A duplicate you remove today reappears when a missed month is imported next week, and an HST return prepared from an incomplete feed is wrong by construction. Merchant accounts deserve particular care: set each one up as its own bank-type account so that gross sales, processor fees and the net payout are all visible, rather than recording only the net deposit that reaches your chequing account.

Step two: strip out duplicates, then clear the uncategorized pile by vendor

Duplicates

Duplicates come from two habits: entering a bill or invoice payment manually and then also accepting the feed transaction instead of matching it, and reconnecting a feed that re-imports transactions already in the register. Sort the register by amount and look for identical pairs a day or two apart. Delete the manually created copy and match the feed line to the original document. Never delete the bank line itself; that breaks the reconciliation you will do in step five.

Uncategorized transactions

Sort the pile by payee, not by date. Forty transactions from the same fuel station are one decision. QuickBooks Online's Reclassify Transactions tool in the accountant toolbox and Xero's Find and Recode let you move a whole vendor's history in one action, and a bank rule then keeps future transactions correct. Two rules we hold to: do not invent a new account to avoid a decision, and keep any suspense or ask-my-accountant account to a short list you will actually resolve. Our cloud accounting stack guide covers the tools we rely on for this stage.

Step three: pull personal spending out and fix the HST coding

Personal versus business

A personal purchase on the business card is not an expense. For a sole proprietor it is an owner's draw; for a corporation it is a debit to the shareholder loan account. A business cost paid from a personal card runs the other way, as an owner contribution or an amount due to the shareholder. Mixed-use items such as a phone plan, a vehicle or a home office are recorded in full during the year and reduced to the business-use share at year-end, with the mileage log or floor-area calculation kept on file. If the same personal vendors keep appearing, the fix is a separate card, which we set out in how to separate business and personal expenses.

HST codes

The sales tax code on every purchase line drives the input tax credits on your return, so miscoding is a direct CRA exposure rather than a cosmetic problem. The errors we correct most often are subscriptions billed from outside Canada coded as if 13% HST had been charged when the invoice shows none, insurance and bank charges coded as taxable when they are exempt, meals claimed at a full credit when only half the HST is recoverable, and sales to US customers coded at 13% when they are zero-rated. Then reconcile the HST payable account: its balance at each filing date should equal the net tax on the return you filed, and the payment should clear it. See how input tax credits work and our list of GST/HST mistakes small businesses make.

Step four: make the balance sheet agree with the outside world

Receivables and payables aging

Run the aged receivables report and read it as a list of claims to verify, not as an asset. Anything older than 90 days is usually one of three things: paid but never matched to the deposit, paid against a different customer record, or uncollectible. Match the first two and write off the third; when you write off a bad debt you may also recover the HST you remitted on it, provided you claim the adjustment within four years. Negative customer balances mean a payment was recorded twice. Run the same exercise on payables, where old open bills are usually paid bills that were expensed a second time through the feed.

Undeposited funds

The undeposited funds account should be close to zero after the last deposit of the year. A large balance means customer payments were recorded but never matched to the bank deposit, and in almost every file where we see this the revenue was counted twice, once through the invoice and once through the deposit.

Loans, leases and credit cards

Open every lender statement at the year-end date and make the liability in your books equal the balance the lender shows. Payments split into principal and interest, and only the interest is an expense. Vehicle loans, equipment financing and the line of credit all follow the same rule, and a loan account that has drifted from the statement is a sign that payments were coded as expenses all year.

Fixed assets

Equipment, vehicles, computers and leasehold improvements belong on the balance sheet so they can be depreciated through capital cost allowance, not in the expense accounts where a large purchase distorts a month. Assets you sold or scrapped need to come off. Keep the purchase invoice with the asset record; the CCA class is assigned at year-end and the invoice is what supports it.

Owner draws and the shareholder loan

For a sole proprietor, draws are equity movements and never expenses. For a corporation the shareholder loan is the account the CRA reads first. If it shows that you owe the corporation money at year-end, the balance must be repaid within one year after the end of the corporation's taxation year in which you borrowed it, or it is added to your personal income. Clearing it before year-end, by declaring a dividend, paying a bonus or repaying it, is far cheaper than explaining it later. The mechanics are in how to record owner draws and contributions and what happens if a shareholder loan is not repaid.

Step five: reconcile everything, then read the reports critically

Reconciliation is the proof that steps one to four worked. Every bank, credit card, loan and merchant account gets reconciled to its statement at the year-end date with no unexplained difference. Resist the adjusting entry that forces a reconciliation to balance; the difference is a missing or duplicated transaction and it will surface again. Our answer on what a bank reconciliation is and how often to do one explains the routine that keeps this from piling up again.

Only now do the reports mean anything. Run the profit and loss by month and look for a month that spikes or drops to zero, which points to a coding or timing error. Compare the year to the prior year line by line. Read the balance sheet for negative balances and accounts that have not moved. Compare payroll expense to your T4 summary and the HST accounts to the returns you filed. The statements a small business should be producing are covered in what financial statements a small business needs.

What done looks like at each step

How long it takes, and when to hand it over

Time depends less on revenue than on the number of accounts and the state of the feeds. A service business with one bank account, one card, a working feed and a year of neglect is a handful of focused sessions. Add inventory, a second currency, several merchant processors or a feed that was broken for months and the same year becomes weeks of part-time work, most of it in step one. A receipt-capture tool such as Dext or Hubdoc removes the hunt for invoices, and we explain when it earns its fee in what Dext is and whether you need it.

We suggest handing the clean-up to a bookkeeping team when any of the following is true:

• More than one fiscal year is unreconciled, in which case the approach in how to catch up on years of unfiled bookkeeping applies.
• HST returns were filed from bank balances or estimates rather than from the books.
• The corporation has a shareholder loan balance nobody can explain.
• A CRA letter, review or audit notice has already arrived.
• You have redone the same month more than once because the feed kept changing under you.

Our accounting and bookkeeping service takes a file from this state to reconciled and year-end ready, then keeps it there monthly, and the year-end tax planning checklist picks up where the clean-up leaves off. The CRA expects the records behind all of this to be kept for six years from the end of the tax year they relate to, so the invoices and statements you gather now are worth filing properly.

Sources: CRA — Keeping records.