Accounting and bookkeeping

Month-end review across several bookkeeping platforms

A CPA firm keeps its client books wherever each client already works, so the bookkeeper moves between hosted QuickBooks Desktop, QuickBooks Online, Wave and Excel in the same week. Some of those files sit on client servers reached by remote desktop, so month end starts with logging in before any review can happen.

Who it is forAccounting and bookkeeping firms with 5 to 50 staff
Who decidesThe bookkeeper
Where the work livesQuickBooks Desktop, QuickBooks Online, Wave, Excel → one month-end review list
BuildTen business days
An office desk seen from above with four closed binders in a row, each with a spine label, a small server box with a blinking light beside them, a printed spreadsheet with a pencil on top, and a coffee mug.

Who does what

The hours go to logging in and copying figures, not to reviewing them.

Getting into each client's books The agent signs into hosted QuickBooks Desktop, QuickBooks Online and Wave, and opens the Excel files, using access the firm grants per client.The agent
Pulling the month-end figures It reads bank and card balances, reconciliation status, uncategorized transactions, receivables and payables from each platform.The agent
Comparing with the checklist and last month It checks each figure against the firm's month-end checklist and the prior month, and flags what moved outside the client's usual range.The agent
Building the review list It puts every client in one list, with the platform, what tied out, and what needs a look.The agent
Deciding on the flagged items The bookkeeper reviews the flags, follows up with the client where needed, and decides when the books are closed.The bookkeeper

What you get

One month-end review list per client, with balances, unreconciled items and open questions pulled from whichever platform holds that client's books.

Draft for review

Client file
October close for a retail client kept in QuickBooks Desktop Enterprise on the client's own server, reached by remote desktop.
Draft
Review list entry: operating account reconciled through October 31, card account reconciled, 14 uncategorized transactions, undeposited funds up sharply from September, payables in line with the prior three months.
Based on
The firm's month-end checklist for this client and the September and earlier closes recorded in the same file.
How sure it is Moderate
Why a person decides The jump in undeposited funds may be a timing issue or missed deposits, and only the bookkeeper can decide which after checking with the client.

The rules it follows

It follows the firm's month-end checklist for each client from the first day.

These are your company's own rules, written down and confirmed with your team during the build. It works on its own only within limits you set.

  • Each client's month-end checklist, including which accounts must be reconciled before close.
  • Each client's chart of accounts and categories, wherever the books are kept.
  • The amount below which a change from last month needs no review.
  • Which platform and access route holds each client's books, and which clients keep their own books in Wave.

What it learns when your team adjusts its work

Useful from the first day, and it keeps getting better. The bookkeeper reviews its work.

The busywork it takes off the bookkeeper. It takes over signing into four platforms and re-entering each client's figures into a review sheet. That time goes back to the work only they can do.

What it starts out knowing

  • Which platform each client's books live on
  • The firm's month-end checklist for each client
  • Each client's chart of accounts and categories
  • The review threshold for changes from the prior month

It works from these sources, shows which one an answer came from, and asks when the answer is not there.

Who reviews its work, and when review can stop

The bookkeeper reviews every list at first. For a routine type, such as a client whose books tie out month after month, review stops once its record on them is good and the firm agrees, and the agent works on its own only within limits the firm sets.

Flagged items, client follow-up and the decision to close each client's books stay with the bookkeeper.

It no longer needs review once its record on them is good and you agree, one type of task at a time. New, unusual and high-stakes work stays with a person.

When your team adjusts its work

When the bookkeeper changes a flag on an Excel client to note that the loan account is only reconciled each quarter, the change is saved as an exception for that client, and next month the agent lists the loan account as not due instead of flagging it.

It learns how your company does this job. It does not watch, rate or profile your employees. Your team decides what it learns. You can read everything it has learned and remove anything. Whoever runs it, your team or our engineers, makes sure on a regular cycle that what it learned stays inside the bounds you agreed.

From a request a business posted

A CPA firm owner, on an accounting podcast interview.

The firm described running client books on four platforms at the same time. Most clients were in QuickBooks Desktop, either in the firm's hosted setup or on the client's own server reached by remote desktop, with some still on Enterprise. Others were in QuickBooks Online, a few kept their own books in Wave, and a handful were still tracked in Excel spreadsheets.

Paraphrased from a public post, not quoted, and not a client engagement.

From first principles

Which client books are ready to close this month, and what still needs a person to look at it?

Before we build anything, we take the work down to what has to be true. What is left over is habit. Habit gets deleted, not automated.

  1. What has to be true

    • Each client's figures must come from the platform that holds them.
    • The firm's month-end checklist must be applied the same way on every platform.
    • Anything that does not tie out must reach the bookkeeper before the close.
  2. What is only habit

    Copying each client's balances into a firm spreadsheet is habit, not part of the review. So is opening every file in the same order whether it changed or not.

  3. What we delete before building anything

    We delete the separate tracking sheet the team rebuilds by hand each month, and the step of re-entering figures that already exist in the client's books.

  4. What is left

    The agent. The agent opens each client's books on its platform, pulls the month-end figures the checklist asks for, compares them with last month, and builds one review list with the items it cannot tie out flagged.

    A person. The bookkeeper reviews each list, decides what the flagged items mean, and signs off the close.

The kind of work: Systems that don't talk to each other. This is the work of carrying the same facts from one system into another: a client's details into each carrier site, a client's figures into a review sheet, a booking into a door code. Connecting the systems moves the data, but it does not read the email, check the figures against the rules or chase the missing piece, so people still do that part by hand.

What the engagement needs

What we need from you, and how it runs.

The engagement needs read access to each client's books on QuickBooks Desktop, QuickBooks Online and Wave, plus the Excel files the firm keeps. For desktop files on client servers, it needs the same remote access the team uses today. It also needs the firm's month-end checklist and the last few closes for each client.

How the engagement runs

  1. 01

    Fit test first

    We check the time this job takes, access to your systems and how you would review the result. If a ready-made tool is enough, we say so.

  2. 02

    Build in ten business days

    Senior engineers agree the rules with the bookkeeper, test on past cases and set approval limits and a way to switch it off.

  3. 03

    Ninety days of support, included

    Work with the agent in Slack, Teams or text messages. We fix problems and adjust it as unusual cases come up.

  4. 04

    Keep improving it, with your choice of operator

    You own the agent and keep its source, tests and guide either way. Your team runs it, or our engineers run it with a monthly report. Learning continues on your own servers, in your own cloud account or in our data center.

When we'd point you elsewhere

Sometimes a ready-made tool is enough.

The fit test checks this first. If one of these covers your case, we tell you, and you keep the map of the work.

  • All clients are on one cloud accounting platform The platform's own accountant dashboard, which already shows reconciliation status across clients
  • The firm only needs to track who has closed which client A practice management tool with month-end task checklists
  • The firm is ready to move every client onto one platform A one-time data migration service for the books

Honest limits

What this page does not claim.

The month-end review list is our reading of the job; the source described the platforms, not the review step itself.

The situation is drawn from a public account a CPA firm owner gave, paraphrased, not a client engagement.

Show us the work

More use cases

More work of the same kind: systems that don't talk to each other.