By OptiVal Editorial Desk

Remote Bookkeeper Weekly Report: What to Ask For Every Friday in Canada

Most owners check on a remote bookkeeper by asking, how are the books going? The answer is always fine, right up until it is not. A proper remote bookkeeper weekly report replaces that vague check-in with one page of numbers, every Friday, in the same format. You see cash, receivables, payables, HST and payroll at a glance, and problems surface while they are still small and cheap to fix.

Here is the exact pack to ask for, plus how to set the routine so it sticks.

What a remote bookkeeper weekly report should show, in one page

Keep the report to one page. If it grows into a spreadsheet maze, you will stop reading it, and a report nobody reads creates false comfort. Five sections are enough for most Canadian small businesses: cash position, money owed to you, money you owe, tax money set aside, and an exceptions list. Everything else belongs in the month-end package.

Ask for the same five sections, in the same order, every week. Consistency is the point. When the format never changes, a missing section or a number that jumps stands out in seconds, even if you only give the report two minutes between meetings.

Section 1: Cash, stated plainly

The first line is the bank balance for each account, reconciled to the bookkeeping file, not copied from online banking. Those two numbers differ whenever cheques are outstanding or deposits are still clearing, and the reconciled figure is the one you can actually spend against. Beside it, show last week’s balance so the movement is obvious.

Add one forward line: large payments already scheduled in the next 14 days, such as a payroll run, a rent payment, or a CRA remittance. A healthy balance means little if $18,000 leaves on Tuesday. A simple example: a Hamilton contractor with $64,200 reconciled in the bank, $21,500 in payroll and remittances due within two weeks, and $9,800 in customer deposits not yet received has about $33,000 of real room, not $64,200. That single adjustment changes spending decisions.

Section 2: Who owes you money, and how old it is

Receivables belong in age buckets: current, 31 to 60 days, 61 to 90 days, and over 90 days. The total matters less than the movement. An invoice sliding from current into the 31 to 60 bucket is your cue to call this week, while it is still a friendly nudge.

Ask your bookkeeper to name the three oldest invoices individually, with the customer, the amount, and the last contact date. Naming them forces follow-up. It also stops the quiet problem where one large, disputed invoice hides inside a total that looks acceptable. If you want the task split that produces clean receivables in the first place, see our guide on what to delegate first to a remote bookkeeper.

Section 3: What you owe, and when it is due

Payables get the mirror treatment: bills due in the next 7 days, the next 30 days, and anything already overdue, listed by supplier. Overdue items should carry a one-line reason: waiting on delivery, price dispute, or simply missed. Missed is fixable the same day, but only if someone reports it.

This section also protects supplier relationships you cannot see from a remote setup. A local bookkeeper hears about a late payment in the hallway. A remote bookkeeper has to write it down, or you hear about it from the supplier first.

Section 4: Tax money, tracked before the deadline

Canadian owners get caught by tax timing more than tax rates. The weekly report should carry a running HST or GST estimate for the current filing period: tax collected on sales, minus input tax credits on purchases, equals the amount building up for the CRA. If you file quarterly, remember the July to September return is due October 31, and because that date falls on a Saturday this year, a return or payment received on Monday, November 2 counts as on time.

Payroll belongs on the same page. For a regular monthly remitter, source deductions are due on the 15th of the following month. The report should confirm the last remittance was made, state the next due date and amount, and flag any new hires or terminations that affect the next T4 season. Two lines a week prevent the two most common CRA penalty letters a small business receives.

Section 5: Exceptions, questions and stuck items

This is the most valuable section, and the one most bookkeepers skip unless you ask. It lists everything that did not fit neatly: unclassified transactions waiting on your answer, missing receipts, a bank feed that stopped syncing, a customer who short-paid an invoice. Each item gets an owner and an age. An unanswered question that is three days old is normal. The same question at three weeks old is a process failure, and the report makes it visible without an argument.

Set a house rule: nothing stays on the exceptions list longer than two Fridays without being escalated to you directly. That rule alone will clean up most of the loose ends that otherwise land in a year-end cleanup bill.

How to set the routine in the first two weeks

Agree the template in a short call, then have your bookkeeper send a sample report before the first real Friday. Fix the format once, in writing, and store it with your procedures so a backup person can produce the same report during a vacation. Timing matters too: pick a deadline you will honour, such as the report in your inbox by noon Friday, and your replies to the exceptions list by end of day Monday. Reporting rhythms fail when answers stall, not when reports do. For the wider meeting and message rhythm around the report, our communication cadence for a remote finance team covers the full pattern, and the month-end close checklist shows how the weekly pack feeds the monthly close.

Expect the first two or three reports to need small corrections. That is the system working. By week four, reading the pack should take five minutes, replacing the scattered texts and end-of-quarter surprises remote arrangements usually run on.

The bottom line for owners

You do not manage a remote bookkeeper by watching them work. You manage the output: one page, five sections, every Friday, no exceptions. Cash you can trust, receivables with names attached, payables with due dates, tax money tracked before the CRA deadline, and a stuck-items list that cannot quietly age. Ask for that, read it every week, and answer the questions it raises. The books stay current because the rhythm makes drifting impossible to hide.

At OptiVal, our remote staffing engagements build this Friday report into the role from day one, alongside bookkeeping from $199 per month. Our team is led by qualified professionals with more than 75 years of combined experience, PwC-trained, with experience in CFO-level positions at world-leading multinationals. If your current reporting is a shrug and a bank balance, book a free consultation and we will show you the template we use. You can also compare options on our remote staffing page and full pricing page.