Skip to content

How to automate payment reconciliation

A four-step guide to moving from manual, spreadsheet-based payment reconciliation to an automated process that matches every payout to its orders and posts the journal entries for you.

Martin Burn
Martin BurnFounder & CEO, Equali · Former Payments Product Director
4 min read

Manual payment reconciliation is one of the most time-consuming jobs in a finance team: opening provider statements, working out which payout covers which orders, chasing the fees and refunds that do not add up, and keying the result into the accounting system by hand. Automating it removes the repetitive work and leaves your team with only the exceptions that genuinely need judgement.

Here is how to move from a manual process to an automated one with Equali, in four steps and with no development work.

Reconcile your specific platforms

Whether you are connecting Shopify to Xero for multi-rate tax splits, matching Stripe payouts to Xero without manual bank feed adjustments, or unraveling complex Amazon seller settlements, Equali provides automated daily settlement sync directly into your general ledger.

  1. Connect your data sources and accounting system

    Connect your sales channels, payment providers and accounting system through the guided setup. Equali pulls order and payout data by API where available, or by SFTP and file upload for bespoke formats, with no development work on your side.

  2. Let automated matching run in real time

    Equali matches your payments, payouts and fees against your orders in real time, agreeing every settlement to the transactions that make it up across all your connected sources in one standard format.

  3. Review only the exceptions

    Matched items need no attention. Equali surfaces only the discrepancies, each with a break reason, so your team resolves the handful that need a human rather than checking every line.

  4. Post categorised journal entries

    Once verified, Equali posts categorised journal entries straight to your accounting system, traceable from the payout back through the fees and refunds to the individual order and the cash in your bank account.

Martin Burn

Written by Martin Burn

Founder & CEO, Equali · Former Payments Product Director

Building the high-volume reconciliation and journal posting engine behind Equali. Grounded in real-world CASS 15 safeguarding, multi-PSP settlement matching, and accounting automation.

About our platform →

Related reading

View all articles →
Strategy6 min read

Build vs buy: automated reconciliations

Should you build automated reconciliations in-house or buy an off-the-shelf specialist product? The factors to weigh, from opportunity cost and complexity to maintenance.

Martin BurnMartin Burn · 23 July 2026
Read article
Strategy5 min read

Reconciliation models: pros and cons

The reconciliation models finance teams use, from fully manual spreadsheets to a purpose-built platform, and the trade-offs of each depending on the scale and complexity of your payments.

Martin BurnMartin Burn · 23 July 2026
Read article

Stop chasing reconciliations in spreadsheets

Connect your channels and providers, and let Equali reconcile, categorise and post every transaction. Start free, or see it on your own data.

Equali

Book a demo

Pick a time and tell us what you'd like to cover. All times shown in your local timezone (hosted from London).

Loading times…