Skip to content
  • There are no suggestions because the search field is empty.

Xero Reconciliation Troubleshooting Guide Overview

This guide covers what to do if your bank transactions have stopped auto-reconciling correctly in Xero, or if the "Find & Match" suggestions aren't matching the way you'd expect. It also covers the correct way to undo an incorrect reconciliation without breaking the link back to your disbursement in Pencil.

Why can the auto-reconciliation suddenly "break"

The Pencil <> Xero's bank reconciliation algorithm is self-learning: once it has learned how to match a transaction, it does so instantly and accurately going forward.

The problem: if a transaction gets manually reconciled (instead of letting Xero auto-match it, or it gets matched incorrectly), the algorithm gets "confused" and starts suggesting wrong matches for the transactions after it. This is the most common cause when things "used to work fine" and now nothing matches.

A tell-tale sign: if you notice that apart from a few transactions, the rest aren't reconciling correctly anymore — that usually means something was reconciled manually somewhere upstream, and it's worth checking using the steps below.

2. Standard "Match" workflow (for an unmatched transaction)

When a transaction shows under Reconcile but doesn't auto-match:

  1. Go to the Reconcile tab in Xero, find the unmatched line.
  2. Click Match (not Create — Create generates a brand-new transaction instead of linking to the existing one).
  3. Click Find & Match / the search option inside the match panel.


  4. Search by the amount (or part of the invoice/reference number if amount search doesn't surface it).
  5. Tick the checkbox next to the correct matching transaction.
  6. The grey Reconcile button at the bottom turns green — click it.

Tip: if you only see a checkbox and "OK" option but it's not turning green, double check you've actually clicked Find first — it's easy to click Match, not see an obvious match, and stop instead of using the search/find step inside the match screen.

3. When the transaction still doesn't show up in Find & Match

If searching by amount returns nothing:

  1. Try clearing the search and toggling Show spent items as well as received.
  2. Double-check the date/year filter — it's easy to be a page off and land in the wrong year/month.
  3. Try searching by the last few digits of the invoice/reference number instead of amount.
  4. If it's still not appearing, the disbursement may not have synced from Pencil into Xero at all:
    • In Pencil Admin, go to Disbursements, find the transaction, and click Resync.
    • Go back to Xero, refresh, and re-check Reconcile / Find & Match.
4. Checking whether a transaction was manually reconciled

To confirm whether a transaction has been manually (and incorrectly) reconciled:

  1. In Xero, go to Account Transactions.
  2. Click Search to bring up the filter fields, and search by amount or date.
  3. Look at the Status column — anything that shows as reconciled when you weren't expecting it to be is a candidate for being manually/incorrectly reconciled.

5. Undoing an incorrect reconciliation — two different paths, two different fixes

This is the part that's easy to get wrong, because the fix depends on where you undo it.

Path A — Undoing from Account Transactions ("Remove and Redo")

Use this when the entry was a journal-type entry pushed from Pencil (not a straightforward bank statement line).

  1. Go to Account Transactions.
  2. Click Search and filter by amount, date, or status to find the incorrectly reconciled item.
  3. Tick the checkbox for that specific transaction (not just any line) — see the screenshot above.
  4. Click Remove and Redo.
  5. The item now drops back into the Reconcile queue (you'll see the "to reconcile" count go up by one).

⚠️ Critical extra step: Removing and redoing from Account Transactions does not automatically re-link back to Pencil. After doing this, you'll also need to:

Step 6. Go to Pencil Admin → Disbursements → Disbursements List, find that same disbursement, and click Resync.

Step 7. Only after the resync will it correctly reappear and be ready to reconcile/match again in Xero.

Path B — Undoing from Bank Statements ("Restore")

Use this when you're undoing the reconciliation from the bank statement line itself.

  1. Go to Bank Statements.
  2. Tick the checkbox next to the reconciled transaction.
  3. Click Restore.



  4. Go back to Reconcile — the auto-reconciliation suggestion will reappear on its own.

✅ No separate Pencil resync needed in this path — restoring from Bank Statements keeps the link intact and Xero's auto-match picks it back up.

Summary rule of thumb

Where you undo it What happens Extra step required?
Account Transactions → Remove and Redo Breaks the link back to Pencil's disbursement Yes — resync the disbursement in Pencil Admin
Bank Statements → Restore Keeps the link intact No — auto-reconcile reappears in Xero automatically
6. Suggested troubleshooting flow
  1. Note down the specific transactions that aren't matching (exact amounts/dates/invoice numbers help a lot here).
  2. Check Account Transactions for those amounts/dates to see if anything shows an unexpected reconciled status.
  3. If something was manually reconciled incorrectly:
    • Identify whether it needs to be undone via Account Transactions or Bank Statements (see table above).
    • Apply the correct fix and the corresponding follow-up step.
  4. Confirm the corrected item now appears correctly in Reconcile, then follow the standard Match → Find → Reconcile flow above for any remaining unmatched items.
  5. If a disbursement seems to be missing entirely from Xero, check Pencil Admin → Disbursements and resync it.