Reconciles

Xero auto reconcile and what to use when payouts and batches will not match

Xero auto reconcile means the bank feed, bank rules and suggested matches that tick off statement lines for you. It works when each bank line is one invoice or one bill. It stops when one payout covers many invoices, when fees are netted, or when one customer payment settles several bills. For those lines you need a matching tool beside Xero. Reconciles starts at $888 a year and reads exported files, so no connection to your Xero organisation is needed.

Two finance leads weighing two close software proposals pinned side by side on a wall

What Xero auto reconcile covers and where it stops

Xero imports bank feed lines and proposes a match for each one from the amount, date and reference. A bank rule can code recurring lines, such as a subscription or a bank fee, without you touching them. Xero describes the tools in Xero Central, and our Xero reconciliation page shows how a whole month is matched at once.

That covers the clean lines, usually the majority. The remainder is what eats the afternoon, and it comes in three shapes.

  • Processor payouts. Stripe, PayPal, Square and Shopify pay out net of fees and refunds, in one deposit that maps to many sales.
  • Combined customer payments. One ACH or one check settles six invoices, or a customer short pays and the credit note is missing.
  • Timing. A deposit made on the 30th clears on the 2nd, so it sits unreconciled across the month end.

Xero can combine several transactions into one match by hand, and that is the right tool for a few. At 40 or 400 lines a month the work is finding which invoices are inside which deposit, not clicking the match button.

The ways to reconcile Xero compared

OptionBest forWhat it doesWhere it stopsTypical price
Xero bank feed, rules and suggested matches Simple one to one lines Proposes matches, codes recurring lines Does not explain a payout or split a combined payment Included with Xero
Manual find and match in Xero A handful of combined lines a month You pick the transactions that make up one bank line Slow past a few dozen lines, no fee explanation Staff time
Posting tool such as [A2X](/blog/a2x-pricing) Amazon, Shopify and similar sellers Posts clean settlement summaries to Xero Does not prove each payout landed in the bank From $29 a month per channel
Matching tool such as Reconciles Teams with processor batches and remittances Matches bank, payout and invoice lines, lists exceptions, exports journal entries Does not record transactions or post live $888 to $5,988 a year
Bookkeeper or spreadsheet Under a few dozen lines a month Manual checking Does not scale, errors slip through Time

Third party prices come from their public pages at the time of writing, so confirm before you buy. For the wider shortlist see the roundup of the best bank reconciliation software.

One Stripe payout in Xero, matched to invoices and fees

Say $3,962.18 arrives in the bank on the 14th. In Xero you have 21 paid invoices totaling $4,085.00 for the week. The $122.82 difference is Stripe fees of $118.62 and a $4.20 refund on one invoice.

Xero shows the $3,962.18 bank line and suggests nothing, because no single invoice has that amount. You open Find and Match, tick 21 invoices, and still have a $122.82 gap to code by hand. A matching tool starts from the Stripe payout report instead. It adds the 21 invoices, applies the fee and the refund, lands on $3,962.18 and marks the deposit as one to many with the gap explained. If one invoice had been paid twice the total would be $4,235.00 and the match would fall out as an exception with the duplicate named. See the Stripe payout reconciliation page for the file layout.

How Reconciles works with Xero

Reconciles reads your bank statement, your processor payout reports and a Xero export such as the account transactions report or the invoice list, all as CSV or XLSX. It matches them, shows each match with a reason and a confidence score, and sends what it cannot tie to an exceptions queue. On Growth and Scale you export journal entries to import back into Xero.

Practices that close Xero files for many clients can use the same flow per client, see reconciliation software for accounting firms. A private medical practice is a typical small case. Its clinicians use clinical software such as Prescriber at the point of care, while the bookkeeper in Xero faces daily card batches from patient payments.

See pricing

How to decide whether Xero auto reconcile is enough

1. Count the lines that do not match one to one. If almost every bank line is one invoice, the bank feed and rules are enough.

2. List the processors. Past two or three, one tool that matches them all beats a subscription per channel.

3. Decide whether the pain is posting or proof. Posting tools create entries. Matching tools prove the cash arrived.

4. Time one month. Upload last month's statement and payout reports and see how many lines tie out on their own before you pay.

Xero auto reconcile questions

Does Xero reconcile bank transactions automatically?

Partly. Xero imports bank feed lines, suggests matches by amount, date and reference, and bank rules code recurring lines for you. You still approve the matches. Lines that combine several invoices, or a payout net of fees, usually need a manual find and match or a tool that splits them.

Why will Xero not auto reconcile my Stripe payout?

Stripe pays out the total of many charges minus fees and refunds, so the deposit equals no single invoice and Xero has nothing to suggest. You reconcile it by combining the invoices and coding the fee difference, or by matching the Stripe payout report to the invoices first, as Reconciles does.

What is the best Xero reconciliation software?

It depends on the gap. Xero's own tools suit one to one lines. A posting tool such as A2X fits marketplace sellers who need clean settlement journals. A matching tool such as Reconciles fits teams with payout batches, split remittances or several clients, from $888 a year.

Can reconciliation software work with Xero without a connector?

Yes. Export the bank statement and a Xero report such as account transactions as CSV or XLSX and upload both. Reconciles reads columns by content, matches the lines and exports journal entries you can import into Xero.

How much does Xero reconciliation software cost?

Reconciles publishes its plans. Starter is $888 a year billed yearly for 3,000 matched transactions a month, Growth is $2,388 a year for 20,000 a month, and Scale is $5,988 a year for 100,000 a month. Monthly billing is $149, $399 and $999.

See how much of last month ties out on its own

Upload a bank statement and a Xero export. In a few minutes you will see which deposits matched and which are short.