Subscription Payments Reconciliation Agent
Reconciles each card and direct-debit payout to the subscription billing ledger.
- Industry
- IT Company
- Department
- Finance
- Team
- Accounting Operations
- Kind
- Investigator
- Approver
- Accounting Manager
- Code
- FIN-17
It reconciles every payout from the card and direct-debit payment processors to the SaaS subscription payments the billing system recorded for that payout's window, explaining each difference as fees, refunds, chargebacks, FX, failed retries or timing. It proposes the clearing entries and escalates any payout it cannot reconcile. **The problem it solves:** Why a processor payout differs from the subscription payments recorded: which lines are unmatched and whether fees, refunds, chargebacks, FX or timing explain them.
How it works
6 steps, and a person signs off before step 6.
- 01Looks it up
Finds the record the request is about in the subscription billing system: the payments, refunds and chargebacks recorded in the payout window, with the processor's payout report..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Works it through
Weighs competing explanations against the evidence and shows which one holds up.
- 05Asks a person
Hands the work to Accounting Manager with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the accounting system's general ledger: it posts the approved clearing entries and marks the payout reconciled. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The payments reconciliation procedure: processors and payout schedules, fee schedules, chargeback and refund handling, FX conversion rules and posting limits.
Reads from
the subscription billing system: the payments, refunds and chargebacks recorded in the payout window, with the processor's payout report.
Acts in
the accounting system's general ledger: it posts the approved clearing entries and marks the payout reconciled.
Hands back
An object with payout_id, matched_count, differences (a list with invoice_ref, amount, cause and evidence), proposed_entries (a list), remaining_difference and reconciled (true or false).
Asks a person when
A payout cannot be reconciled within 2 USD, fees exceed 500 USD, or chargebacks exceed 5.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Variance tolerance (USD) | 2 | Payout differences up to this are accepted. |
| Cut-off grace (minutes) | 15 | Payments this close to the window edge may belong to the next payout. |
| Post fees below (USD) | 500 | Processor fees below this are posted without a person. |
| Chargebacks a month that alert | 5 | More chargebacks than this in a month alert the approver. |
| Escalate unreconciled payouts after (hours) | 24 | A payout still unreconciled after this is escalated. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Match each payout line to a billing record by invoice reference, then by amount and account.
- Explain differences as fee, refund, chargeback, FX, failed retry or timing within 15 minutes of cut-off.
- Accept a remaining difference of up to 2 USD.
- Post processor fees below 500 USD; larger ones go to the Accounting Manager.
- Alert on more than 5 chargebacks a month and escalate payouts unreconciled after 24 hours.
See the Subscription Payments Reconciliation Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.