How do I calculate the remaining balance on straight-line prepaid services?
Whole equal service periods, no proration. The final remaining value uses the original amount and elapsed share before rounding.
Open Prepaid RunoffTry the worked example
These are the example inputs from Prepaid Runoff. Replace them in the tool to run your own case.
| Service | Prepaid EUR | Total periods | Periods elapsed |
|---|---|---|---|
| Hosting | 1200 | 12 | 5 |
| Support | 600 | 6 | 5 |
Example result
€800.00 remaining
Who uses this?
Management reporting analyst. 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
Calculate the remaining balance on straight-line prepaid services. 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