MILabs
Integrations

Payments reconciliation with WooCommerce

How payments reconciliation works with WooCommerce orders and gateway payouts, with unmatched entries sent to a person for review.

Updated 2026-04-06

Payments reconciliation with WooCommerce

A WooCommerce store records each sale as an order, but the money that reaches the bank arrives later and in different shapes. A gateway may pay out a day's takings minus fees, hold back a refund, or combine several orders into one transfer. For a store owner, the gap between those records is where short payments and doubled entries hide. This build reads order data through the WooCommerce REST API and receives order changes through webhooks, so matching starts from the records the shop already keeps. Payout lines from the payment gateway are then paired with orders by amount, date and reference. Anything that does not pair cleanly goes to a review queue that the bookkeeper works through. Xero can hold confirmed matches as ledger entries, and Make or n8n can carry the steps between the store and the ledger. MILabs, a Sydney agency, designs the rules with the team and delivers the work remotely.

How it works

  1. Map each payment gateway's payout lines to the WooCommerce order, refund and fee fields they relate to.

  2. Connect the store through the REST API and webhooks so new orders and refunds reach the matching run.

  3. Apply matching rules on amount, date and order reference, and mark short payments, duplicates and partial refunds.

  4. Send unresolved entries to a review queue for the bookkeeper, and keep the final decision with a person.

  5. Post confirmed matches to Xero, then check the first closing period against the bookkeeper's own reconciliation.

good questions, straight answers

Frequently asked questions

Do I need a developer to connect a payments reconciliation to WooCommerce?
Usually, yes, for the initial connection. The store's REST API keys and webhook settings have to be created and tested, and the hosting and installed plugins affect how the connection behaves. After that, the day-to-day work is in the matching rules and the review queue, which the bookkeeper can understand without writing code. MILabs covers that connection work within the build.
How does a payments reconciliation stay in step with WooCommerce?
It stays in step through the events the store already produces. Webhooks tell the matching run when orders or customers change, so it does not depend on a fixed export being downloaded each day. Gateway payout data arrives on the schedule the provider uses, and the run compares the two sets each time it runs. Unmatched items wait in the queue until someone resolves them.
How do I know a payments reconciliation works with WooCommerce?
You can check it against your own records. Before the team relies on the matches, run the build over a period that the bookkeeper has already reconciled by hand, then compare the matched and flagged entries with that result. Short payments, duplicates and partial refunds should appear where the bookkeeper found them. Any difference becomes a rule change or a noted exception.
Can I start with part of a payments reconciliation on WooCommerce?
Yes. A sensible starting point is the review queue alone, fed by order data from the store and payout lines exported from the gateway, so the team sees open items before any ledger posting is automated. Once the matches look reliable, posting confirmed matches to the ledger can be added. Marketplace payouts that bundle several orders can wait for a later stage, since they need more rules than a single-order match.
How does MILabs test a payments reconciliation against WooCommerce?
MILabs compares the build's output with records the business has already checked. The team takes a period of orders and gateway payouts that the bookkeeper has reconciled, runs the matching rules over the same data, and reviews every difference. Each rule is kept only if it reproduces the known result, and any case that the rules get wrong is added to the review queue rather than forced into a match.
let's make something happen

Custom development: how we can help

Choose how you want to work on this with MILabs. Both options start with an enquiry.

Discovery is free, no obligation from the first chat.

Let us build it for you

We build it and look after it.

Build it yourself, we'll help

You build it with our direction, teaching and a weekly check-in.