How to automate the monthly bookkeeping workflow

Automating bookkeeping does not mean the books do themselves. It means the repetitive parts (getting transactions in, coding the obvious ones, sending the same invoice every month, paying people whose pay has not changed) happen without you typing, so the hours you spend go on the parts that need a person. This is the setup I use for small businesses and for my own practice, piece by piece, with the failure modes of each. Product details were checked in September 2026 and will drift.

Bank feeds, and where they fall short

The feed is the foundation. Xero and QuickBooks Online both connect to most mainstream banks and pull posted transactions into a review queue every day or so. The gaps are what nobody mentions during the sales demo.

Feeds drop. A connection can stop silently: the bank changes its login flow, a consent under UK Open Banking or a similar regime expires, or the aggregator behind the feed has an outage. Xero publishes a page listing current feed disruptions and QuickBooks shows an error badge on the account, but neither will chase you. The first sign is often a review queue that has been empty for a week.

Feeds miss days. After a drop and reconnect, both products backfill a limited window. QuickBooks Online's help pages say it brings in roughly 90 days on connection and cannot download anything older; some banks give less. A feed that was down for four months leaves a hole that the reconnect will not fill. Feeds also carry only posted transactions, so anything pending at the cut-off arrives later than the statement shows it.

Some accounts have no feed at all: smaller credit unions, some business and store cards, foreign-currency accounts, many loan accounts, and payment processors that only give you a downloadable statement. In my client base there is nearly always one, usually the account with the untidy spending on it.

So the first decision, per account, is: is there a feed, is it reliable, and what is the fallback. Write that down. It is the first line of the month-end checklist.

Getting statements in when there is no feed

Where a feed is missing or broken, the statement becomes the source, and the job is to get its rows in without retyping them.

CSV export. Most online banking portals export a CSV for a date range, and both Xero and QuickBooks Online import it with column mapping. The catches are date formats, sign conventions (one signed amount column versus separate debit and credit columns) and QuickBooks Online's size limit per file. The mapping steps are in importing bank statements into Xero and importing bank transactions into QuickBooks.

OFX, QFX and QBO. If the bank offers one of these, prefer it over CSV. Each transaction carries an ID, which is what lets the software recognise a line it has already imported and skip it. QuickBooks Online reads .qbo, .qfx and .ofx; Xero reads OFX but not QBO.

PDF only. Some banks and card issuers, and nearly every account you are looking at retrospectively, give you a PDF and nothing else. Retyping a 200-line statement costs an evening and introduces the transposition errors that reconciliation then has to find. A converter is the automation here. stmtai reads PDF, scanned image, CSV, QIF and OFX statements, re-adds the rows against the printed opening and closing balances, flags the row that breaks the check, and exports Excel, CSV, QuickBooks .qbo or Xero CSV; the same job is available as a REST API, and the operator can enable a mailbox so a forwarded statement comes back converted. If you only need a spreadsheet, converting a PDF statement to Excel covers the manual and automated routes.

Whichever route the rows take, importing is not reconciling; the bank reconciliation guide is the check that closes the loop.

Bank rules: what they can and cannot do

Once rows are in, rules code the recurring ones. Both products match on description text and amount and assign an account, tax rate and contact or payee. QuickBooks Online has an auto-add option that posts a matched line without review; Xero always leaves the coded line waiting for you to click OK. Rules are ordered in QuickBooks Online, so the specific rule sits above the general one.

What rules do well: rent, subscriptions, loan repayments, utilities, the same three suppliers you pay every week, bank fees, payroll clearing. Anything where the description is stable and the meaning never changes.

What they cannot do: tell what a purchase at a general retailer was for, separate a personal card swipe from a business one, recognise a refund as a negative expense rather than income, or know that a transfer between your own accounts is not revenue. Those lines need a receipt or a human. Set rules up for the top twenty or thirty payees and review the remainder weekly. The detail on writing rules that keep working is in categorising bank transactions automatically.

Receipt capture

The receipt answers the question the bank line cannot: what was bought and what tax was charged. The automation is getting it to the software the moment it exists rather than in a shoebox in January. Three tools I see most, with the features that exist as of this writing:

• Dext (formerly Receipt Bank): mobile photo capture, a dedicated email-in address, and per-supplier rules that set a default category, tax rate, payment method and paid status so the extracted document arrives pre-coded. It publishes to Xero, QuickBooks Online and others with the image attached.
• Hubdoc: bundled with most Xero plans, extracts supplier, amount, invoice number and due date, and creates a draft bill in Xero with the document attached. Its automatic fetching from supplier portals was retired in 2022, so documents arrive by upload, photo or email forward. Xero has been rolling out its own document capture during 2026; check which your plan gives you.
• QuickBooks Online receipts: snap in the mobile app, or forward to a custom address you set up under Receipts. QuickBooks extracts the details and suggests a match to a bank line in the review queue.

The habit matters more than the tool. Forward supplier invoices to the email-in address automatically, put the app on the phone of everyone who holds a card, and agree that a card purchase without a receipt is coded to drawings until one turns up.

Recurring invoices and payment reminders

If you bill the same customers the same amount each month, the software should raise and send the invoice. Xero calls these repeating invoices; each template can be saved as a draft, approved, or approved and emailed on the schedule. QuickBooks Online has recurring templates of three types: scheduled (created automatically, optionally sent), reminder (you get a prompt and finish the invoice by hand, useful when the amount varies) and unscheduled (a saved template for when you need it). A scheduled template in QuickBooks Online can also charge a stored card or bank account through its payments service for customers who agree to it.

Reminders. Xero's invoice reminders are one organisation-wide schedule of up to five messages, each firing a chosen number of days before or after the due date, with a minimum-amount cut-off; you can switch them off per customer or per invoice. QuickBooks Online allows up to three reminder schedules per company. Neither writes a different sequence per customer without an add-on, so keep the wording neutral enough for your best client to receive it.

Recurring bills work the same way on the cost side, so a fixed rent or lease bill is already in the books when the bank line arrives.

Payroll by country

Payroll automation is worth having only when it files with the tax authority as well as calculating pay.

• United Kingdom: Xero Payroll and QuickBooks Online Payroll both file RTI submissions with HMRC on each pay run and assess pension auto-enrolment. QuickBooks offers Auto Payroll for salaried staff whose pay does not change.
• Australia: Xero Payroll reports Single Touch Payroll to the ATO each pay day and calculates superannuation. QuickBooks Online in Australia bundles a third-party payroll product.
• New Zealand: Xero Payroll handles payday filing with Inland Revenue, KiwiSaver and student loan deductions.
• United States: QuickBooks Online Payroll runs Auto Payroll, direct deposit and federal and state filing. Xero has no US payroll of its own and integrates with Gusto.
• Canada: QuickBooks Online Payroll supports Auto Payroll and CRA remittances. Xero relies on partner apps.

Automate the run for fixed salaries, leave hourly staff on a reminder that waits for approved hours, and put the filing deadline itself on the checklist. Software misses a deadline as easily as a person if nobody approved the run.

Month-end checklist automation

The checklist turns a collection of automations into a closed month. Mine runs in this order for every client: confirm every feed is live to month end; import statements for accounts without feeds; clear the review queue; code the exceptions; chase missing receipts; raise remaining invoices; post payroll journals; reconcile every account to its statement; read the profit and loss by category; lock the period; send the report pack.

The automation is making that list appear by itself each month. QuickBooks Online Accountant has a Work area with recurring projects and tasks; Xero practices tend to use Xero Practice Manager or a practice tool such as Karbon, Financial Cents or Keeper. For a business doing its own books, a recurring task in any task manager is fine. The point is that the list exists before you open the software, so nothing is skipped because it was not remembered.

Two steps deserve a hard stop rather than a tick. The reconciliation must agree to the statement balance, not merely show an empty queue. And the lock date in Xero or the closing date in QuickBooks Online is the final step, so a stray edit next month cannot reopen a month you have already reported on.

Report scheduling

QuickBooks Online lets you save a customised report or report group and set an email schedule for it, so a profit and loss, balance sheet and aged receivables land in the owner's inbox on the third without anyone logging in. Xero did not offer scheduled report emails natively when this was checked; the workaround is a saved report layout you publish once the checklist finishes, or a reporting add-on. Either way, schedule the pack for after the period lock, or the owner receives numbers that then change.

When not to automate

Some decisions need a person each time, and an automation that makes them will make them wrong quietly.

Personal versus business. A rule cannot see who was at the lunch. Owner spending on the business card is coded by hand to drawings or the director's loan account, every time.

Capitalise versus expense. A 1,400 purchase from an electronics retailer might be a laptop (an asset, depreciated) or a year of printer toner. The description is identical. Leave the retailer out of the rule set and code from the receipt.

Anything with a tax consequence that turns on facts: entertainment, mixed-purpose travel, home office costs, grants and refunds from a tax authority.

Corrections. Do not build a rule to tidy a recurring mistake; fix the cause. A payment processor that lands in the wrong account every month needs its payout settings changed, not a rule that moves it.

If the reason you want a rule is that you are tired of deciding, that is the signal the decision matters.

A realistic monthly timeline

Take a business with two bank accounts, one company card with no feed, around forty sales invoices and two salaried staff. The table is an illustration of the shape of the month, not a measurement.

Before, the month closed somewhere between the 15th and the 25th and the reconciliation was the step that got dropped. After, the close moves to the first week and the reconciliation gets done, because it is the one job still waiting for a person. That is the real return: the hours landing on the work that needed them.