Payment reconciliation

Free Prepaid Service Balance Calculator

A prepaid service balance tracks received money that has not yet been applied to approved charges. Reconcile its movement over a period without treating a requested top-up or future work estimate as money available.

Preparing your calculator with today’s date…

Calculation notes

How the result is calculated

Available advance = verified opening balance + confirmed top-up. Sum the three approved applications. Remaining advance = max(0, available − applied); excess application = max(0, applied − available). This is an operational money reconciliation, not revenue recognition, a wallet, a credit-note calculation or a refund decision.

Formulas and examples reviewed October 2, 2026. Illustrative figures; no tax or contractual determination.

A funded period with a remaining advance

USD 2,000 opening plus USD 500 confirmed top-up gives USD 2,500 available. Applications USD 1,200 and USD 800 leave USD 500 unapplied.

A request is not a receipt

USD 500 opening, no received top-up and USD 700 proposed application exceeds available funds by USD 200. A requested USD 300 top-up does not remove that shortfall until confirmed.

Questions about this calculation

Does the remaining advance expire or get refunded?

The calculator decides neither. Use the actual agreement and supported document process; keep any expiry or refund decision separate from this arithmetic.

Can I deduct the advance twice?

No. Tie each application to an invoice or charge reference and check prior applications before reducing a balance. This calculator does not know your existing ledger.

How to use it

1

Enter the verified opening unapplied advance and confirmed top-up.

2

Enter approved applications to identified charges.

3

Review remaining funds or excess application against the ledger.

Related workflows

Move from the quick answer into the rest of the invoice system.