Before
Staff copied processor amounts into a spreadsheet, compared currencies and net amounts, and searched for the corresponding journal entry one transaction at a time. When a match was unclear, they prepared the evidence and handed the issue to finance, often moving between the processor, ledger, receipt sheet, and review queue.
How it works
- Retrieve the selected available settlements and the configured ledger rows.
- Compare each settlement against ledger candidates and require one exact match on transaction ID, currency, net amount, and journal reference.
- Verify or create the receipt for an exact match, or reuse or create a finance review card for a discrepancy.
Workflow details
- Batch intake: A finance user starts the workflow on demand, and the automation retrieves a bounded set of available processor transactions together with the configured ledger extract.
- Deterministic reconciliation: Each settlement is checked against ledger rows by transaction ID, requiring exactly one candidate, matching currency, matching net amount, and a non-empty journal reference. Missing, duplicate, currency, amount, or other ambiguous matches are classified for review.
- Verified recording: For an exact match, the workflow checks the receipts sheet and the open exception queue before reusing an existing record or appending the verified transaction, currency, processor net, ledger reference, status, and source.
- Finance handoff: For a discrepancy, it prepares evidence describing the source transaction, completed comparison, unresolved issue, decision required, and recommended next step, then reuses or creates a finance review card.
- Controlled outcome: The workflow returns a processed batch record with the disposition for every selected settlement and does not edit the ledger, post journal adjustments, or move money.
What changed
Every selected settlement now receives an automated disposition before the batch ends: exact matches are verified against the receipts sheet and recorded, while discrepancies are packaged with evidence and delivered through the finance review queue. Human judgment remains only for deciding how to resolve the flagged discrepancy.
Work removed
Copying processor amounts into a spreadsheet, comparing currencies and net amounts, tracing each transaction to a ledger reference, checking for existing exception cards, preparing discrepancy evidence, and manually creating or reusing the receipt or review handoff.
Expected outcome
Every selected settlement receives a disposition; in the demonstrated two-record batch, one exact match produces a verified receipt and one mismatch produces a finance review, with no automatic journal adjustment.



