Skip to the main content.

Logiframe is an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity / expression, national origin, protected veteran status, or any other characteristic protected under federal, state or local law, where applicable, and those with criminal histories will be considered in a manner consistent with applicable state and local laws.

Monthly Bookkeeping in Xero
 
The month doesn't close itself, even in Xero.
 
Xero automates a great deal of bookkeeping — and that automation is exactly why so many businesses end the month with a file that looks complete and isn't. This is what a real monthly cycle in Xero involves: the full task list, which Xero features carry which parts, the mistakes that quietly compound, and how to tell whether yours is actually working.
 
 
Definition
 
What monthly bookkeeping actually covers
 
Monthly bookkeeping is the recurring work of recording every financial transaction accurately, agreeing your records against external sources, and producing a set of numbers you can rely on — repeated on a monthly cadence rather than assembled once a year.

The distinction that matters is between recording and proving. Recording is entering and coding transactions: bills, invoices, receipts, payments. Proving is confirming that what you recorded matches reality — that the bank agrees, the supplier statements agree, the payroll totals agree, and nothing is sitting unexplained.

Xero is excellent at the recording half. Bank feeds pull transactions in, bank rules code them, repeating invoices go out on schedule, and connected apps capture documents. The proving half is still human work, and it's the half that gets skipped — because nothing in the software prompts you to do it, and the file looks fine without it.

A month is genuinely done when someone could ask "why is this number what it is?" about any figure on the profit and loss, and you could answer from the file rather than from memory.
Cadence
 
The shape of the month
 
Monthly bookkeeping works best when it isn't actually monthly. Spreading the work across the month and reserving the first week of the following month for closing turns a stressful two-day scramble into something closer to maintenance.

Throughout

Capture and Code

Bills, receipts and bank transactions handled as they arrive. Queries raised while the answer is still easy to get.

Weekly

Clear and Check

Reconcile queue cleared, bank feeds confirmed as live, invoicing and payment runs on schedule.

Month End

Agree and Adjust

Balances agreed to statements, accruals and prepayments posted, subledgers tied to the general ledger.

First Week

Review and Lock

Reports reviewed for sense, variances explained, period locked so the numbers stop moving.

The pattern to avoid: touching the file only at month end. Coding a month's transactions in one sitting means guessing at anything unclear, because the context is gone. Almost every miscoded transaction we find was coded weeks after it happened by someone who no longer remembered what it was for.

The List
 
The full monthly bookkeeping checklist for Xero
 
Not every business needs every line. Inventory, multi-currency, fixed assets and payroll apply selectively — but everything in the cash, purchases, sales and review groups applies to essentially every business running Xero.
TASK WHY IT MATTERS
Cash And Banking
Clear the reconcile queue for every account
Unmatched transactions distort every report drawn from the ledger
Agree each bank balance to the statement
The only check that catches transactions the feed never delivered
Reconcile credit cards to the statement period
Card cycles close mid-month, so calendar-month reconciliation proves nothing
Confirm transfers between own accounts are coded as transfers
Miscoded transfers inflate both revenue and expenses simultaneously
Clear the suspense or holding account to zero
A permanent balance here means unexplained transactions have become permanent
Purchases and Payables
Enter all bills received, including those not yet due
Expenses belong in the month incurred, not the month paid
Reconcile supplier statements
Catches missing bills, unapplied credits and duplicates using an external record
Review aged payables for anomalies
Old balances usually mean a duplicate, a credit never applied, or a dispute
Match expense claims and card spend to receipts
Undocumented spend is a problem at year end and a serious one under examination
Sales and Receivables
Confirm all revenue for the period is invoiced
Unbilled work is missing revenue and missing cash
Apply all receipts to the correct invoices
Unapplied cash makes the aged report fiction and triggers chasing paid customers
Review aged receivables and give each aged item a reason
A total tells you nothing; a reason tells you what to do
Check deferred or prepaid revenue treatment
Cash received in advance isn't revenue yet, and getting this wrong overstates profit
Adjustments
Post accruals for costs incurred but not yet billed
Without these, margin swings month to month for no operational reason
Release prepayments for the period
Annual costs paid upfront should spread across the months they cover
Post depreciation and update the fixed asset register
Skipping it overstates profit and leaves the balance sheet wrong
Record inventory movement and cost of goods sold
Gross margin is meaningless if COGS isn't matched to the revenue it produced
Revalue foreign currency balances
Unrealized gains and losses distort the balance sheet if never recognized
Reconcile payroll totals to the ledger
Payroll is usually the largest cost and the easiest to post incompletely
Review and Close
Tie subledgers to the general ledger
Aged payables and receivables must agree to their control accounts
Review the balance sheet line by line
Every balance should be something you can explain and evidence
Compare the P&L to prior month and budget
Variance review catches coding errors nothing else will find
Set the lock date
Stops the closed period silently changing after you've reported on it
Tooling
 
Which Xero features carry which parts of the cycle
 
Most businesses use perhaps a third of what Xero offers for monthly work. These are the features that meaningfully reduce the monthly workload when they're set up properly — and create problems when they're set up carelessly.

Bank Feeds

Automatic import of transactions from your bank. The essential foundation, with one caveat worth knowing: feeds can stop delivering without an obvious alert, and connections may require periodic re-authorization. Checking that each feed is still live should be a weekly habit, not an annual discovery.

Bank Rules

Automatic coding for recurring transactions matching conditions you define. Genuinely powerful for predictable items — the monthly software subscription, the utility direct debit. The risk is over-application: a broad rule silently codes things you never reviewed, and the errors are invisible precisely because the rule worked. Write rules narrowly, and review what they've captured periodically rather than trusting them indefinitely.

Repeating Invoices and Bills

Scheduled generation of recurring transactions. Removes the most common cause of late invoicing, which is someone forgetting. Worth reviewing quarterly, since repeating templates outlive the arrangements they were created for — we regularly find businesses invoicing at rates that changed a year ago.

Tracking Categories

Xero's dimension for segmenting the ledger by department, location, project or fund. Applied at the point of entry, they make management reporting possible without a separate system. Applied later, they're a reconstruction exercise. For non-profits handling restricted funds, getting this right at entry is close to essential.

Fixed Assets

A register that calculates and posts depreciation on a schedule. Underused, and its absence is why so many small business balance sheets carry assets at original cost indefinitely — which overstates both assets and profit.

Document Capture

Hubdoc, included with most Xero plans, or an alternative like Dext. Attaches the source document to the transaction. The value shows up later: when your CPA, a lender or an examiner asks what a payment was for, the answer is attached to the entry rather than in someone's inbox.

The Overlooked One
 
Lock dates: the discipline almost nobody uses
 
Xero lets you set a lock date that prevents changes to transactions before a chosen date. Most small businesses never set one — and it's the single most consequential omission in the monthly cycle.

Here's why it matters. Without a lock date, a closed month stays editable forever. Someone reconciling in March can adjust a January transaction — not maliciously, just tidying something that looked wrong. January's profit and loss now differs from the version you reviewed, reported to your board, sent to your lender, or gave your CPA.

This produces the maddening situation where a report run today doesn't match the same report run two months ago, and nobody can explain why. It undermines trust in the numbers more effectively than an actual error would, because an error can be found and fixed while a drifting history cannot.

The discipline is simple: once a month is reviewed and reported, lock it. If something genuinely needs correcting afterwards, unlock deliberately, make the correction with a note explaining it, and re-lock. The point isn't to make change impossible — it's to make change visible and intentional rather than silent.

The test for whether this matters to you

Run last quarter's profit and loss. Now find the version you looked at when that quarter closed. If they don't match, and you can't explain the difference, you have a lock date problem — and every historical figure you've reported is provisional in a way you probably didn't realize.

Pitfalls
 
Six mistakes that compound
 
These aren't unusual. They're what we find in most Xero files that have been maintained without a defined monthly process — and each one gets more expensive the longer it runs.

Treating Coding as Reconciling

Clearing the reconcile queue feels like finishing. It isn't — it only accounts for transactions the feed delivered, never the ones it missed.

Trusting Bank Rules Indefinitely

Rules written for one situation keep firing after the situation changes. The coding stays consistent and consistently wrong.

Using A Suspense Account as Storage

Anything unclear goes to a holding account "for now." Two years later it holds a balance nobody can decompose.

Recording Expenses When Paid, Not Incurred

Costs land in the month the money left rather than the month the work happened, so monthly margin becomes noise.

Never Reviewing The Balance Sheet

Owners read the P&L and ignore the balance sheet. Nearly every long-running bookkeeping error shows up there first.

Leaving The Period Unlocked

Closed months keep changing. The report you gave your lender in March no longer matches the file today.

Diagnostic
 
How to tell whether your monthly bookkeeping is working
 
Not by whether the file looks tidy. By whether it can answer questions. Work through these — each one you can't answer confidently points at a specific gap.

  You can produce last month's profit and loss within a week of month end, without a scramble.

  Every bank and card account agrees to a statement, and you know the date each was last agreed.

  You can explain every balance on the balance sheet, including the small ones you've stopped noticing.

  The suspense or holding account is zero.

  Aged payables and receivables agree to their control accounts in the general ledger.

  Every aged receivable over 60 days has a reason attached, not just an amount.

  Monthly gross margin is stable enough that a real change would stand out.

  Prior periods are locked, and reports run today match what they showed when the period closed.

  Your CPA doesn't have to ask you what things were at year end.

How to read your score. Seven or more: your process is working; tighten the gaps. Four to six: the recording is happening but the proving isn't, which is the most common pattern and the one that stays hidden longest. Three or fewer: the file needs a catch-up and clean-up before a monthly rhythm will hold, because a monthly process built on an unreliable opening position just documents the problem more regularly.

Scope
 
Where monthly bookkeeping ends
 
Bookkeeping, month-end close, accounting and tax get used interchangeably, which makes it hard to know what you're actually buying or doing. They're distinct.
ACTIVITY WHAT IT COVERS WHO DOES IT
Monthly Bookkeeping
Recording and proving transactions: coding, reconciliation, subledger maintenance

Bookkeeper or outsourced accounting team

Month-End Close
The adjustments and review that turn a recorded month into a reportable one: accruals, prepayments, depreciation, variance review, locking

Bookkeeper or accountant, depending on complexity

Management Reporting
Turning closed numbers into something decisions can be made from: commentary, KPIs, segment views
Accountant, controller or advisory partner
Tax Preparation and Filing
Returns, elections, positions and filings
A licensed tax professional or CPA
Audit or Review
Independent opinion on the financial statements
An independent licensed firm, which cannot be the party maintaining the records

The practical implication: good monthly bookkeeping makes every row below it cheaper. Most of what a CPA charges for at year end is reconstructing what should have been recorded correctly during the year. A clean, reconciled, locked Xero file is the single largest lever on your annual accounting cost.

Questions
 
Monthly bookkeeping in Xero, answered
 
Next
 
Inventory Management
 
Want someone to run this every month?
 
We manage the full monthly cycle in Xero for startups, growing businesses and non-profits — as a Xero Gold Champion Partner and two-time Xero Asia Partner of the Year.