This is a reconciliation worksheet for a known receipt against a single billing reference. Never enter bank details.
Reconciliation / Receivables operations clerk
Payment Application
Apply a received amount against open principal and separate any unapplied balance.
01 / Inputs
Working sheet
Edit any cell to recalculate. Use anonymous references. Data stays in this browser tab and clears when you reload.
| Reference | Open EUR | Receipt EUR | Row |
|---|
02 / Review
Decision sheet
| Reference | Applied | Still open | Unapplied |
|---|---|---|---|
| INV-14 | €75.00 | €0.00 | €15.00 |
| INV-18 | €80.00 | €40.00 | €0.00 |
Discuss an anonymised receivables review
€99 one-time pilot after scope agreement for an ageing report and editable deck.
The free tool runs independently on your device.