Debt payoff spreadsheet

Record an identifier, data date, noted balance and any movements you want to keep. In a simple subtraction, 1000 minus a movement of 100 gives 900 only when the example has no other charges or adjustments.

Ready to print 1 printable

View preview

Currency

US dollar ($)
Pound sterling (£)

Recording example

Record an identifier, data date, noted balance and any movements you want to keep. In a simple subtraction, 1000 minus a movement of 100 gives 900 only when the example has no other charges or adjustments.

Check the data

Do not infer interest or closing dates from a subtraction when those details are unspecified. The sheet organizes records; it does not choose a repayment order or recommend financial products or decisions.

Check formulas and units

Test the sheet with two or three simple amounts and check the total manually. Distinguish input cells from calculated cells. Do not add amounts from different currencies or periods as though they were equivalent; the template organizes the data you enter.