Xero's Auto Bank Reconciliation and Your Shopify Payouts

Xero's automatic bank reconciliation, powered by its JAX assistant, is still in beta, but it is already doing real work. Xero said in August that it had automatically reconciled "more than 100 million transactions". This month its latest improvements were covered in an Insightful Accountant round-up on 16 October.

For an e-commerce brand, the obvious question is what this means for processor payouts. Shopify Payments, Stripe, PayPal and Afterpay deposits are the lines that take the longest to reconcile. This guide explains what the feature does, what a reconciled payout line actually proves, and how to review JAX's work before you sign off the month.

What the feature does

Xero's product page describes four ways JAX can reconcile a bank statement line:

• Rule: one of your own bank rules is applied.
• Match: the line is matched to a record that already exists in Xero, such as an invoice payment.
• Memory: JAX follows how you have reconciled similar transactions before.
• Prediction: JAX follows how other Xero users have reconciled similar transactions.

Xero says JAX "only automatically reconciles when it's highly confident". When it is less sure, it suggests a match and leaves the line for you. According to Xero's launch post, automation has to be turned on separately for each bank account you want JAX to reconcile. The product page says it is available in Australia on the Grow plan and above, with an optional add-on for Ignite. Xero has said its goal is for JAX to "reconcile more than 80% of your bank statement lines in real time". That is a goal, not a measured result.

Auto-reconciled lines appear on a Reconciled page in each bank account. The August update added the method used on each line and filtering, and it lets you change the account code and tax rate on a line without removing the reconciliation. The same post says Xero is still working on "more complex use cases", and gives a single payment covering several invoices as an example.

Reconciled is not the same as correct

A reconciled bank line proves one thing: the amount in Xero agrees with the amount on the bank statement. It does not prove that the amount was coded to the right accounts.

That difference matters most for payouts, because a payout is a net figure. Take one Shopify Payments payout:

Say JAX reconciles the $5,269.00 line with Memory or Prediction, coding it to Sales with GST on Income, because that is how similar deposits have been coded before. The bank account now agrees with the statement to the cent, and the line moves to the Reconciled page. But the ledger shows sales of $5,269.00 instead of $5,500.00 in sales and $110.00 in refunds. The $121.00 of fees does not appear anywhere.

If the fees carry GST at the standard rate, the net GST in this example comes out at $479.00 either way: $500.00 on the orders, less $10.00 on the refund and $11.00 on the fees, is the same as one-eleventh of the deposit. That is easy to misread as a sign the coding is fine. It is not fine. Gross sales are understated by $231.00, the fee expense is missing, refunds are invisible, and the sales and purchase totals you report are wrong even though the net is right. If any fee, refund or adjustment is treated differently for GST, the net will not survive either.

None of this is a fault in the feature. JAX reconciles bank lines, and the bank line here really is $5,269.00. The breakdown into orders, refunds and fees lives in the processor's payout report, not in the bank feed. An AI tool can only work with what it is given, so whatever produces your payout entries has to read that report.

Where payout lines should land

The pattern used in our Stripe and Afterpay guides still holds:

1. Sales, refunds, fees and other adjustments are booked to a processor clearing account from the payout report, one entry per payout.
2. The bank deposit is coded to that same clearing account.
3. Once every payout is booked, the clearing account holds only money that is genuinely in transit, and you can list what that is.

With this structure, the bank deposit only needs one decision: which clearing account it goes to. That is the kind of line automatic reconciliation should get right, and you can make it predictable. A bank rule that sends each processor's deposits to its own clearing account means the line is reconciled by Rule, using logic you wrote and can read, instead of by Memory or Prediction.

How to review JAX's work at month-end

If automation is on for the operating account that receives your payouts, add these checks to the close:

1. Filter the Reconciled page to auto-reconciled lines. Xero's August update added filtering for this. Look at every processor deposit.
2. Check the method on each payout line. For Shopify, Stripe, PayPal and Afterpay deposits, you want Rule or Match. A payout reconciled by Memory or Prediction deserves a second look, however sensible its coding seems.
3. Check the account, not just the amount. Any payout coded straight to Sales, or to a general suspense account, has skipped the decomposition. Recode it to the clearing account. The August update lets you do that from the Reconciled page without unreconciling.
4. Check the tax rate. Deposits into a clearing account are normally coded with no GST, because GST is handled in the payout entry. A deposit coded with GST on Income is a warning sign. Your accountant should confirm which tax code they want on these lines.
5. Reconcile the clearing account itself. A fully reconciled bank account tells you nothing about whether each clearing account is at zero or holds only explainable items in transit. That is a separate check, and it is the one that proves the payouts were booked correctly.

It is also worth choosing which accounts to automate. Because the setting is per account, you can leave it off for the account where payouts land until your bank rules are in place, and turn it on for a card or expenses account first.

What this means for your close

Automatic bank reconciliation will take a large share of routine matching off the books, and the method label and in-row editing make it easier to review than a black box. For an e-commerce brand, the hard part of the close was never clicking reconcile on a deposit. It was proving what each deposit was made of. Get that right in the clearing account and JAX has an easy, checkable decision to make on each bank line. Skip it, and a payout can be fully reconciled and still wrong.

That decomposition step is what Vert is built for. It splits each payout into sales, fees, refunds, chargebacks, reserves and GST, proves the parts sum back to the deposit, and drafts a balanced entry for your approval in Xero. If you want to see it on your own payouts, you can join the pilot.