Software & SaaS
How a balance layer reconciles payment ledgers
This guide explains the working logic behind reconciling ledgers across several payment accounts, using one marketplace example. It is useful for founders and finance leads deciding what to build, buy or document first.
01
Step one: define the accounts and the truth
Start by listing every account that holds or reports money: the bank account, the payment processor balance, a seller wallet and the internal ledger. Then decide which source is authoritative for each fact. In a marketplace, the processor may be authoritative for card settlements, while the internal ledger is authoritative for what each seller is owed. Write this down as a short table. Without it, a mismatch becomes an argument rather than a task, and any software layer will simply reproduce the confusion in a faster and more expensive way.
02
Step two: normalize entries and match them
Next, convert each source into a common entry format with date, amount, currency, reference and account. A seller sells goods for 100, the processor deducts a 3 fee and settles 97 two days later. The internal ledger should show sale, fee and payout as three linked entries, not one number. Matching rules then pair entries by reference first, then by amount and date window. Anything unmatched goes to a review queue. Keep rules visible and ordered so a finance reviewer can see why two records were joined and change a rule safely.
03
Step three: review exceptions and keep a trail
Finally, decide who handles each kind of exception and what evidence they record. Timing differences might wait a set number of days, while amount differences go to a named person. Each resolution should store the reason, the reviewer and the adjusting entry, never overwriting the original record. At period end, the layer compares total ledger balance with total external balance and reports the remaining difference. If the example marketplace shows a gap of 3, the trail should lead straight to the unrecorded fee, making the correction quick and auditable.