Adding Money Calculator with Running Totals
Check the sum of the amounts that are due or already paid.
Everyday money
Arrears Balance Calculator: Amounts Due and Paid
Add obligations that are already due and subtract the payments or credits against them. Use one reconciliation date; interest, penalties and legal allocation rules are not calculated automatically.
Your numbers
How the calculation works
An arrears reconciliation compares amounts already due with payments and credits against those obligations. It provides an auditable arithmetic balance for a date you choose, without deciding whether a disputed charge is valid or automatically adding late-payment costs.
Outstanding balance = total obligations due − payments − credits.
Choose the cut-off and scope
Decide which account, agreement and reconciliation date the lists cover. Both sides must refer to the same obligations and currency.
Reconcile supporting records
Check invoices or instalments against receipts, statements and agreed credits. Remove duplicates and keep a separate note of disputed or unallocated items.
Compare the two totals
The calculator sums obligations, sums payments and credits, then subtracts the latter from the former. These separate totals help locate a difference when comparing another statement.
Worked example: Partial payment
Sample inputs demonstrate the method. They are not a forecast or product offer.
The first example has three €500 obligations, totalling €1,500. Payments of €500 and €250 total €750. Subtracting the payments leaves €750 outstanding. The result does not identify which instalment remains unpaid because no payment-allocation rule is supplied.
- Amounts due
- 500 500 500
- Payments and credits
- 500 250
Expected result
- Outstanding balance
- €750.00
Worked example: Credit balance
Sample inputs demonstrate the method. They are not a forecast or product offer.
- Amounts due
- 100
- Payments and credits
- 120
Expected result
- Outstanding balance
- -€20.00
Understanding your result
A positive outstanding balance means entered obligations exceed entered payments and credits. It does not by itself establish a legal entitlement, the age of each unpaid item or how a creditor should allocate payments.
A zero balance reconciles the entered lists. A negative balance is a credit under this arithmetic, not negative arrears; review whether it represents an advance payment, an omitted obligation or an actual overpayment.
Questions you might have
What does this arrears calculator include?
Reconcile overdue obligations against payments and credits, keeping interest or penalty estimates separate.
Which assumptions should I check?
Include only amounts that are due by your chosen reconciliation date. No interest, penalty, legal entitlement or allocation rule is inferred.
Choosing the right inputs
- Amounts due
- Enter one obligation per line that is due by your reconciliation date. Exclude future instalments unless the purpose is deliberately to reconcile a different, clearly defined balance.
- Payments and credits
- Enter payments and applicable credits once each, as positive amounts. Use zero when none exist; the calculator subtracts this list from the obligations.
Common mistakes to avoid
- Do not enter payments as negative figures: they are already subtracted by the calculation.
- Do not silently include estimated interest or penalties among contractual obligations. Establish and document any such charge separately.
Assumptions to check
- Include only amounts that are due by your chosen reconciliation date. No interest, penalty, legal entitlement or allocation rule is inferred.
Sources and method
Read our calculation and testing approach.