Payment reconciliation software links money received or paid with the invoices, bills and other records it settles. It helps finance explain the payment and keep outstanding balances current.
The difficult cases rarely look like a neat one-to-one match. A customer pays several invoices together, a processor deducts fees or a supplier refunds an amount without the original reference. Earlier review helps preserve context, while the software still needs the evidence to allocate the money correctly.
How is payment reconciliation different from bank reconciliation?
Payment reconciliation explains what a particular movement settles. Bank reconciliation checks the bank activity and balance against the cash records in the ledger.
The processes overlap, but completing one does not necessarily complete the other. A bank receipt can sit in an unapplied cash account while finance investigates which customer invoice it belongs to.
Use the bank reconciliation guide to evaluate statement completeness and the period review alongside payment allocation.
What should happen with partial and combined payments?
Consider an illustrative customer with invoices for €600 and €400. The customer sends €900. Finance needs to establish the intended allocation using the remittance or other evidence; the software should not infer a €100 write-off merely because the amounts are close.
If the customer intended to settle the first invoice and part of the second, the ledger should show €100 still due on the second invoice. The team should be able to trace the allocation and change it under the appropriate controls if better evidence arrives.
Test the reverse case too: several receipts settling one invoice. The remaining balance and collection status should reflect the allocations made so far.
How should the system treat fees and currency differences?
A processor payout may combine several receipts and deduct fees, refunds or reserves. Matching the net bank amount directly to an invoice can lose that detail.
Ask the vendor to show the gross receipts, deductions and resulting payout, with a trace to the processor evidence. For foreign currency transactions, inspect the original amount, settlement amount and exchange treatment separately.
The multi-currency accounting guide explains the currency questions to include. Fee and exchange accounts should follow an approved policy, rather than serving as a place to hide unexplained differences.
What should remain in the exception queue?
Keep an ambiguous receipt visible until someone has enough evidence to allocate it. Assign an owner, record the investigation and review items by age and value.
Test reversals and returned payments. If a settlement fails later, finance needs to understand the effect on the open invoice and any collection activity. A status update should preserve the earlier history.
How does Light connect payments with the ledger?
Light's bill payment software connects supplier payments with bills, and its subscription management product includes incoming payment matching. Evaluate each direction against the accounts, payment methods and exceptions you actually use.
For the buying test, include a partial payment, a net payout and a returned payment. Follow each one into the ledger and then into the outstanding balance view.
Measure the age of unapplied cash, correction rate and investigation time. The accounts receivable guide shows why current allocations matter for collections as well as accounting.
