Skip to content
Menu

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 · Founder & CEO, Equali4 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.

  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 reconciliation run automatically

    Equali reconciles your payments, payouts and fees against your orders in real time, matching 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 reconciled, 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.

Written by the team that builds the reconciliation engine behind it.

More from Equali

One source of truth for every payment

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