Month-end close process: a bookkeeper's guide to closing client books

A month-end close is the set of steps that turns a month of raw transactions into figures a client can rely on, and then stops those figures from moving. For a bookkeeper with one client it is a routine. For a bookkeeper with thirty it is a production line, and the difference between a calm month and a bad one is whether every file goes through the same phases in the same order. This guide sets out that order, the cut-off rules that decide what belongs in the month, the checks that catch errors before the client does, and how to lock the period in Xero and QuickBooks Online. Software behaviour and the one benchmark quoted here are linked in the Sources section.

What “closed” means

A month is closed when three things are true:

1. Every transaction that belongs to the month is in the ledger. Miss this and the profit figure is wrong.
2. Every balance sheet account agrees to something outside the ledger: a bank statement, an aged listing, a loan schedule. Miss this and errors roll forward into every later month.
3. The period is locked, so nothing can be backdated into it. Miss this and a figure you have already reported can change without anyone noticing.

Practices run the close at two depths. A soft close posts the routine entries, reconciles the bank, and accepts estimates for the smaller accruals, so management figures go out fast. A hard close reconciles every balance sheet account, posts every adjustment, and locks the period. A common pattern is to soft-close the first two months of a quarter and hard-close the third, when the VAT or GST return is due and the figures will be filed.

How long it should take

The figure most often quoted comes from APQC’s General Accounting Open Standards Benchmarking survey ^[1] . Read it for what it is: mid-size and large organisations producing consolidated statements, measured in calendar days, published in 2018. No comparable public dataset exists for small-business client files.

Set your own baseline instead. For three months, record the working day on which each client file was locked. The pattern shows which files are slow, and when you look at why, the slow phase is rarely reconciliation. It is waiting for documents.

The five phases, in order

The order is not a preference. Reconciliation cannot finish until everything is posted, adjustments cannot be calculated until balances are reconciled, and review is pointless on unadjusted figures.

1. Cut off and collect

Decide what belongs in the month (the rules are in the next section) and get the documents: supplier bills, receipts, expense claims, sales invoices raised outside the ledger, payroll reports, loan and card statements. Send the client one list of what is missing, not a message per item.

2. Post and code

Enter every bill, receipt, and invoice with its account and tax code. Clear the bank feed of anything that only needs coding (bank charges, direct debits, card fees).

3. Reconcile

Agree each balance sheet account to its outside evidence. The table below lists what each account agrees to.

4. Adjust

Post the journals that put costs and income in the right month: accruals, prepayments, depreciation, stock, payroll.

5. Review, lock, report

Read the reports with a critical eye, fix what is wrong, lock the period, and send the figures.

An example calendar for a client who expects figures by working day 8. This is an illustration to adapt, not a benchmark:

Cut-off: what belongs in the month

Most close errors are cut-off errors: the right transaction in the wrong month. Four rules cover nearly every case.

• Sales belong to the month the work was done or the goods were delivered. An invoice raised on the 2nd for work finished on the 28th is income of the earlier month.
• Costs belong to the month the goods or service were received, not the month the bill arrived or was paid. A bill dated the 3rd for last month’s electricity is an accrual in last month’s close.
• Bank transactions belong to the month the bank processed them. A payment sent on the 30th that leaves the account on the 1st is an outstanding item at month end, not an error.
• Payroll belongs to the period worked. If the pay run straddles the month end, accrue the unpaid days.

Clients whose books are kept on a cash basis skip accruals and prepayments, but every reconciliation below still applies.

The reconciliations that make up a close

A balance is reconciled when you can point to an outside document that shows the same number, or a list that explains the difference item by item.

In Xero, the Reconciliation Reports pack runs most of this evidence for one date range: the Trial Balance, Aged Receivables Summary, Aged Payables Summary, a Bank Reconciliation Summary for each active bank account, Fixed Asset Reconciliation, General Ledger Exceptions, and the Journal report ^[2] . In QuickBooks Online, each completed bank or card reconciliation saves its own report, found under History by account on the Reconcile page ^[3] .

The bank reconciliation has its own walkthroughs: bank reconciliation in Xero and bank reconciliation in QuickBooks Online.

Adjusting journals

The standard set, most of which repeat every month and can be set up as recurring or reversing entries:

• Accruals for goods and services received but not yet billed. Reverse them on the first day of the next month so the real bill does not double the cost. See recording accruals in Xero.
• Prepayments: release this month’s share of costs paid in advance, such as insurance and annual software. See recording prepayments in Xero.
• Depreciation on the fixed asset register. See recording depreciation in Xero.
• Stock: adjust to the month-end count or valuation where the client holds inventory.
• Payroll journal, if payroll runs outside the ledger.
• Loan interest, splitting each repayment between interest and capital.

Review before you lock

Posting is not the same as checking. Read the reports as the client’s accountant would.

• Profit and loss against last month and the same month last year. Set a threshold per client and explain every line that moved by more than it.
• Gross margin. A swing with no change in the business usually means a cost in the wrong month or the wrong account.
• Balances that cannot exist. A bank account in credit with no overdraft, a debit balance in payables, a credit balance in receivables.
• Suspense and clearing accounts at zero.
• Dumping grounds. Anything large sitting in general expenses or sundry gets recoded now.
• Duplicates. Sort bills by supplier and amount and look for pairs.

Where the practice has more than one person, the reviewer should not be the person who prepared the file.

Locking the period

Xero. In the Accounting menu, select Accounting settings, then Financial settings, and enter a date under Lock Dates. Once set, users cannot add or edit transactions dated on or before the lock date, although they can still create draft invoices, bills, and expense claims and save draft manual journals. You can set one lock date for all user roles and another for all roles except the administrator, and only an administrator can set or change them ^[4] . A common practice is to move the first date forward at every month end and the second once the year-end accounts are final.

QuickBooks Online. Go to Settings, then Account and settings, open the Advanced tab, select Edit in the Accounting section, turn on Close the books, and enter a closing date. Choose between allowing changes after a warning, or after a warning and a password. Only a primary or company admin can do this ^[5] . The password option is the one that works as a control.

The click-by-click version for Xero is in how to record end of month in Xero.

Running the close across a client base

One close is a checklist. Thirty closes is scheduling.

• Tier clients by deadline, not by size. Group files by the working day the client expects figures, and start each group on a fixed day.
• One checklist, one copy per client. The month-end close checklist gives a row per task with owner, target day, and status. Delete what does not apply to a client and keep the copy.
• Close bank-fed files first. They need the least from the client, so they clear the board early.
• Track phase, not percentage. A board with one row per client and a column per phase shows at a glance which files are stuck in collection.
• Fix the cause of repeat delays. If the same client is late with documents three months running, change how the documents reach you. A reminder will not do it.
• Keep the evidence. Save the reconciliation reports and journal support for each month. What to keep and how to file it is covered in workpapers and audit trail.

Where ExpenseFlow fits

ExpenseFlow works on the first two phases, where the waiting happens. Clients and their staff send bills and receipts as they arise, by uploading them, forwarding them to a per-client email address, or picking them from Google Drive. Each document is read line by line and given a ledger account and tax treatment, then held in a review queue beside the original image with a confidence score. Nothing reaches the ledger until a person approves it. Approved items sync to Xero or QuickBooks Online. In Xero, the source document is attached to the transaction and the capture and approval history is written to its history and notes.

ExpenseFlow does not reconcile bank accounts, post accruals, lock periods, or produce management reports. Those phases stay in the ledger and with the bookkeeper. What changes is day one of the close: the payables and expense coding has been reviewed through the month, so the close starts at reconciliation. If chasing documents is the real bottleneck, see how to stop chasing client receipts.