How we used AI to close our 2026 books in QuickBooks Online

Brown Walrus used AI agents to close the books on its 2026 fiscal year (September 1, 2025 to August 31, 2026) in QuickBooks Online. An AI agent is software that carries out tasks, like entering and matching transactions, instead of only answering questions. The agents did the repetitive work. Our owner approved changes like write-offs before we made them.

These are our own company's books, and we used the same approach we offer clients. Our outside accountant received a clean, documented file, and their year-end review was under way at the time of writing.

Every bank and credit card statement for the year matched to the penny, and all 29 pay runs checked out against the payroll provider's reports. Then we ran an independent review of the closed books to look for mistakes. It found four real problems. We fixed all four and traced each one to its cause.

What made our books complicated

Like a lot of small businesses, we had books that had grown more complicated than the way we kept them:

• Accounts: Two bank accounts, one in Canadian dollars and one in U.S. dollars, plus two credit cards. We replaced one of the cards partway through the year.
• Payments: Customers paid by bank transfer, cheque, QuickBooks card payments and Stripe. QuickBooks and Stripe each took their card fees out in a different way.
• Payroll: Our payroll provider adds its own bookkeeping records (journal entries) to QuickBooks.
• Equipment: Some purchases were for our own use and some were for clients.
• Sales tax: The rules for sales tax (GST/HST) differ for Canadian customers, U.S. customers and foreign suppliers.
• Receipts: Ours were scattered across email.

Books can balance and still be wrong. We needed ours to balance for the right reasons: no money counted twice, no missing fees, correct sales tax, and a record explaining each decision.

What we did to close the year

• Bank and card statements: We reconciled every statement for all four accounts in the year. That means we matched our books line by line against each bank or card statement. Each one matched to the penny, including the eight statements that crossed the August 31 year-end.
• Payroll: All 29 pay runs in the year matched the payroll provider's reports. We also tracked down a small leftover balance in the payroll account and cleared it.
• Receipts: We found more than 120 receipts and statements and attached each one to its transaction in QuickBooks. Anything we couldn't find went on a tracked list.
• Sales tax: The books now record last year's tax filing the right way. We corrected sales tax our books had claimed back on advertising bills that never charged any, since the CRA can ask for that money back. We also confirmed that U.S. customers are billed without Canadian tax.
• Card and Stripe payments: Before, we took estimated fees off invoices up front, so the books showed neither the full sale nor the true fee. Now each payment shows the full amount the customer paid, with the processor's actual fee on its own line.
• Equipment: We reviewed each technology purchase to decide whether it was ours or bought for a client. Our own equipment is now on the books as assets, meaning things of value the business owns.
• Unpaid invoices: We wrote off old invoices that won't be paid, meaning we took them off the total our books show as owed to us. The owner approved them first, and that total now counts only money we expect to collect.
• Accountant's package: We wrote up each change we proposed for year-end with its evidence, and checked it against the books before the accountant saw it. The accountant now works in the same QuickBooks file we do.
• Owner's report: We built a "virtual CFO" report with charts, the kind of summary a finance chief would bring to an owner. It shows the year at a glance, four years side by side, and how much revenue comes from recurring services versus one-off projects.

Four problems the review caught

Matching every statement proves the books agree with the bank and card statements. It doesn't prove everything else in them is right. After the close, the independent review turned up these four problems:

• Payments with no money behind them: A handful of customer payments and sales were on the books, but the money never reached the bank. Left in, they would make the books show money the business never received. With the owner's approval, we removed them and fixed what let them in.
• Payroll amounts in the sales tax account: Our payroll provider's setup was sending vacation pay and employment insurance into the sales tax account, which gave that account the wrong balance. We corrected the year's entries, and the vacation pay we owe is now right. A fix is under way at the payroll provider to stop it happening again.
• Duplicate invoice numbers: Three invoice numbers had each been used twice, which makes two different bills easy to mix up. Each invoice now has its own number.
• Card fees we could avoid: We switched off card payments for several regular customers who can pay by bank transfer, so we no longer pay card fees on their invoices.

How the owner stays in charge

We held ourselves to five rules on our own books, and we'd keep the same ones on yours:

• You make the decisions: Each decision that matters, such as which old invoices to write off, comes to you in plain language for your approval. You aren't asked about every transaction.
• The AI never moves money: It records what the bank already did. It doesn't send payments, emails or invoices to anyone.
• Every change is on record: Each change shows who made it, who approved it and how we checked it. Mistakes go on the record too, including the AI's, and so do their corrections.
• Nothing counts as done until it's checked: Matching a statement to the penny is the minimum, not the finish line. Every statement we match has to pass more checks before we call it finished.
• When something looks wrong, the work stops: The AI reports it instead of improvising, and a person decides what happens next. If it's a decision about your money, that person is you.

For sensitive tax papers, like personal tax slips and government notices, we used Qwen3.8, an AI model we run on our own computer with an NVIDIA RTX 3090 graphics card. Those papers never had to leave the company.

Where the books stand now

Each reconciled statement has its report on file, and each proposed change has its evidence. The written record of this year's decisions will make next year's close faster and easier to check.

Who this is for

This suits businesses that have outgrown "the bookkeeper just knows" (even when the bookkeeper is you) and want to keep QuickBooks Online. It helps most if you have more than one currency, card payments through Stripe or a similar service, a payroll provider or several cards. It also helps with receipts buried in email or a bookkeeping backlog.