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.

Xero Bank & Credit Card Reconciliation
 
A green tick is not a reconciled bank account.
 
Xero makes matching transactions fast, which is why so many businesses believe their books are reconciled when they aren't. This is what reconciliation actually means in Xero, the problems that quietly accumulate when it's done by clicking rather than checking, and how to fix each one.
 
 
Definitions
 
What bank reconciliation actually means
 
Bank reconciliation is the process of proving that the cash balance in your accounting records agrees with the balance the bank says you hold — and explaining, item by item, any difference between them.

That definition contains the part most people skip. Reconciliation is not the act of categorizing transactions. It's the act of agreeing two independent records and accounting for every discrepancy. Categorizing is bookkeeping; agreeing the balances is the control.

In Xero the day-to-day work looks like this: your bank feed imports transactions, Xero suggests a match for each one — an existing invoice, bill, or a coding rule — and you confirm or correct it. Confirmed items disappear from the reconcile queue. That process is fast and genuinely good, and it does most of the work.

But confirming Xero's suggestions is only step one. The reconciliation is complete when the balance in Xero agrees with the closing balance on your bank statement, and any difference is explained by known timing items. If nobody ever compares those two numbers, you have a categorized ledger, not a reconciled one — and the difference between them is where errors live undetected for months.
The Misconception
 
Why an empty reconcile queue proves less than it appears to
 
Xero's reconcile screen shows you what's waiting to be matched. When the queue is empty, it feels finished. But an empty queue only tells you that every transaction the feed delivered has been dealt with — it says nothing about transactions the feed never delivered.

That's the gap. If the bank feed missed three days last month, those transactions were never in the queue to begin with, so clearing the queue doesn't surface their absence. The only thing that catches a missing transaction is comparing your Xero balance against the actual bank statement balance.

What most people do

Open the reconcile screen, work through the queue accepting Xero's suggested matches, get to zero, and consider the account reconciled for the month.

This catches miscoded transactions. It does not catch missing transactions, duplicated transactions, a feed that stopped delivering, or an opening balance that was wrong from the start.

What reconciliation requires

Clear the queue, then compare the balance in Xero against the closing balance on the bank statement for the same date, and explain every difference.

If the two agree, the account is reconciled. If they don't, the difference is a real error somewhere — and finding it now takes minutes, where finding it in nine months takes a day.

The practical test: pull your bank statement for the last day of the month and compare its closing balance to what Xero shows for that account on that date. If you can't do that comparison quickly, or the numbers don't agree and nobody knows why, the account isn't reconciled regardless of what the reconcile screen says.

Credit Cards
 
Why credit cards are harder than bank accounts
 
Credit card reconciliation follows the same principle but breaks in different places. Businesses that reconcile their bank accounts cleanly often have card accounts that haven't agreed to a statement in a year.

The statement period doesn't match your month

Bank statements typically run to month end. Card statements run on a billing cycle that closes mid-month. Reconciling a card to the calendar month means you're never comparing against a document the issuer produced, so there's no independent record to agree to. Reconcile to the statement period, then confirm the month-end liability separately.

Pending versus posted

Card transactions appear as pending, then post — sometimes at a different amount, as anyone who has used a card at a restaurant or a gas pump knows. Feeds can deliver pending transactions that later change, leaving a matched entry that no longer reflects reality.

The balance is a liability, not an asset

A card account is money you owe. The reconciled balance should agree to the amount outstanding on the statement, and the payment you make to the card issuer is a transfer between two accounts you control — not an expense. Coding card payments as expenses is one of the most common errors we find, and it double-counts every purchase: once when the transaction posts, again when the card is paid.

Personal spend on business cards

Common in owner-managed businesses and messy in every direction. These transactions need identifying and coding to the correct account rather than buried in expenses — and the longer it goes unaddressed, the harder the untangling. This is a place where clear treatment protects you.

Receipts that never arrive

A card feed tells you an amount and a merchant. It doesn't tell you what was bought or why. Without a receipt capture habit, card spend becomes a large block of expenses supported by nothing — a problem at year end for your CPA and a serious one in an audit or examination.

Diagnosis
 
Eight problems that accumulate, and how each one is fixed
 
These are the issues we find most often when we take over a Xero file. Each has a distinct cause, and each has a fix that gets harder the longer it waits.
SYMPTOM USUAL CAUSE HOW IT'S FIXED
Xero Balance Doesn't Match The Bank Statement
Missing feed transactions, a manually entered duplicate, or an incorrect opening balance when the account was set up
Work backwards to the last date the two agreed, then isolate the period where they diverged and identify the specific item
Duplicate Transactions
A feed re-import after a connection issue, or someone entering a payment manually that the feed later delivered
Identify and remove the duplicate — not just un-reconcile it — then confirm the balance agrees before moving on
Feed Stopped Delivering
Bank connection expired or requires re-authorization; some connections need periodic renewal
Re-authorize the feed, then import the gap period from a bank-provided file and check for both missing and duplicated items at the join
Large "Suspense" or Holding Balance
Transactions coded to a placeholder account when nobody knew the treatment, and never revisited
Work through each item with source documentation and recode; the balance should be zero, not a permanent fixture
Transfers Counted Twice
Money moved between two accounts you own, coded as income in one and an expense in the other instead of as a transfer
Recode both sides as a transfer; this overstates both revenue and expenses until corrected

Card Payments Treated as Expenses

The payment to the card issuer coded to an expense account rather than against the card liability
Recode as a transfer to the card account; until fixed, every card purchase is counted twice

Old Unreconciled Items From Prior Periods

Items nobody could resolve, left in place and inherited by each new person who touches the file
Investigate, resolve what's resolvable, and write off the remainder with documented reasoning and approval rather than leaving them indefinitely

Foreign Currency Differences

Exchange rate movement between transaction date and settlement date, with no recognition of the gain or loss
Post the realized difference to a foreign exchange account so the underlying balance reconciles cleanly

The compounding problem

Every one of these is straightforward to fix in the month it occurs and difficult to fix a year later — not because the fix changes, but because the evidence disappears. Bank portals limit how far back statements are available, the person who made the payment has left, and the reason for a transaction that made obvious sense at the time is now unrecoverable.

This is why reconciliation frequency matters more than reconciliation thoroughness. Monthly and adequate beats annual and rigorous, every time.

Why It Exists
 
Reconciliation is a control, not an admin task
 
Reconciliation gets treated as data entry, which is why it gets postponed. But it's the only routine check that compares your records against an independent external source. Everything else in your books is your own account of events; the bank statement is someone else's.

That independence is what gives reconciliation its power. It's the check that catches an unauthorized payment, a subscription nobody remembers signing up for, a supplier taking a direct debit at the wrong amount, and a duplicate payment that would otherwise sit undetected. None of these announce themselves. They surface because two records disagree.

Who should perform it

The person who reconciles should not be the person who can move money. When the same individual makes payments and reconciles the account, the check loses its meaning — any discrepancy they created is a discrepancy they can quietly resolve.

For a small business this is often impossible internally, which is one of the practical arguments for outsourcing the function. We reconcile; you retain payment authority. The separation exists across two organizations rather than requiring a second employee.

What depends on it

Every downstream number. Your profit and loss, cash flow position, aged payables and receivables, tax filings your CPA prepares, covenant calculations a lender reviews, and any due diligence a buyer or investor runs. An unreconciled cash balance means every one of those is unverified — and the discovery usually comes at the worst possible moment, when someone finally checks.

Working With Us
 
Having someone else run it
 
Most of the above is work you can do yourself, and if you have the discipline to do it monthly, you should. The case for handing it over isn't complexity — it's consistency. Reconciliation fails through postponement, and postponement is what happens to any task that has no deadline attached.

Daily

Clear The Queue

Feed transactions matched and coded as they arrive, with queries raised the same day rather than saved for month end.

Weekly

Check The Feeds

Every connected account verified as still delivering. A broken feed found in week one is a non-event; found in month three it's a project.

Monthly

Agree The Balances

Every bank and card account agreed to its statement, differences explained, and the reconciliation position documented.

Ongoing

Resolve Exceptions

Unidentified items investigated and cleared rather than carried forward. Nothing ages quietly into the next period.

If you're behind

Catch-up reconciliation is scoped separately, because the work depends on how far back the divergence goes and how much documentation still exists. We start by finding the last date your records and the bank actually agreed, then work forward from there. Businesses are often further behind than they think — an account that "just needs a quick tidy" frequently turns out to have diverged eighteen months ago.

Reconciliation is part of bookkeeping, not a separate service

We don't sell reconciliation on its own. It's a core part of every Xero bookkeeping package, because reconciling an account without owning the ledger it feeds means being accountable for a number we can't control. If your reconciliation is broken, the fix is a bookkeeping engagement — not a bolt-on.

See our bookkeeping packages, which include bank and card reconciliation for all connected accounts as standard.

What we don't do

We reconcile accounts; we don't hold payment authority on them and can't move money. We don't prepare or file tax returns and don't run payroll — we keep the records clean so your CPA works from a reconciled position. And we're not your auditor: an audit requires an independent firm, and our involvement in maintaining the records is precisely why it can't be us.

Questions
 
Xero reconciliation, answered
Next
 
Inventory Management
 
Not sure when your accounts last actually agreed?
 
A 30-minute review of your Xero file — which accounts reconcile, which don't, what's sitting unresolved, and what it would take to get current.