Payment reconciliation
Payment reconciliation that runs every day.
Orders, processor settlements and bank deposits matched, with exceptions sent to a short queue.
Orders412 · $38,410.20
Settlements409 · $38,120.70
Bank deposit$37,006.14
3 exceptions · fees and a refund explain the restIn the queue
Three-way match
Order, settlement and deposit, line by line.
Each order is tied to the settlement that paid it and the deposit it landed in.
- Order total$186.00Store
- Settled by processor$186.00Batch 0915-2
- In bank deposit$180.42After processing cost
Order 20931Matched
Exceptions
What doesn't match gets a reason.
Unsettled orders, short deposits and refunds are listed with their likely cause.
- Order 20877 marked paid, never settled$92.40Check capture
- Refund issued, order still shows paid$64.00Update order
- ACH return R01 on order 20790$118.00Retry allowed
Bank files
Return and change files read automatically.
Returns and account corrections from your bank update orders and customer records.
- 626 ••••6789 RETURNED DEBIT$118.00
- 799 R01 INSUFFICIENT FUNDS
- 621 ••••4410 NOTIFICATION OF CHANGE
- 798 C01 NEW ACCOUNT ••••4471
2 records postedOrders and customers updated
Questions
Asked on most calls.
- What is payment reconciliation?
- Matching each order to the settlement that paid it and the deposit it landed in.
- How often does it run?
- Daily, or as often as your processor and bank publish new data.
- Which systems does it read?
- Your store or ERP, your processors and your bank files. Scoped on the call.
- What is the reconciliation process?
- Reconciliation automation pulls orders, settlements and deposits, matches them, and queues what does not match.
- What does billing reconciliation mean?
- Checking that every invoice or charge you billed was collected and deposited.
- What does a build cost?
- Every build is custom, so it is scoped and quoted on the call.
Payment reconciliation
Show us where the numbers drift.
Thirty minutes with the people who build it.
