How do I apply a received amount against open principal and separate any unapplied balance?
This is a reconciliation worksheet for a known receipt against a single billing reference. Never enter bank details.
Open Payment ApplicationTry the worked example
These are the example inputs from Payment Application. Replace them in the tool to run your own case.
| Reference | Open EUR | Receipt EUR |
|---|---|---|
| INV-14 | 75 | 90 |
| INV-18 | 120 | 80 |
Example result
€15.00 unapplied
Who uses this?
Receivables operations clerk. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
Apply a received amount against open principal and separate any unapplied balance. The business case pairs prepared back-office work with a person responsible for exceptions. Benchcraft designed this tool’s inputs, decision rule and example for this office task.
Original video