Mortgage Tracker Spreadsheet: Payments and Balance
Compare entered mortgage payments and rate changes with your original repayment plan.
Your mortgage plan
Your mortgage progress
Example inputsEnter valid tracking details to compare the balances.
- -$1,007
- $497,389
- $498,396
- $1,000
- 2 payments ahead
- $0
Balance progress
Recent progress rows
| Record | Amount |
|---|---|
| 1 Feb 2026 | |
| Planned payment | $2,997.75 |
| Entered payment | $2,997.75 |
| Planned balance | $499,550.20 |
| Tracked balance | $499,550.20 |
| 15 Feb 2026 | |
| Planned payment | $0.00 |
| Entered payment | $1,000.00 |
| Planned balance | $500,699.85 |
| Tracked balance | $499,699.85 |
| 1 Mar 2026 | |
| Planned payment | $2,997.75 |
| Entered payment | $2,997.75 |
| Planned balance | $498,851.75 |
| Tracked balance | $497,849.45 |
| 1 Apr 2026 | |
| Planned payment | $2,997.75 |
| Entered payment | $2,997.75 |
| Planned balance | $498,396.09 |
| Tracked balance | $497,388.69 |
Set a Clear Starting Balance
This mortgage tracker spreadsheet compares your entered payment record with a repayment plan and exports both to a CSV file. Start from a lender statement balance after any interest charged that day.
Enter the statement date, starting rate and remaining term. Keep the original required payment and its frequency as the plan, then choose the date of your loan review.
The first planned payment falls one full payment period after the starting date. Monthly dates keep the original day where possible, with shorter months using their last day. Fortnightly and weekly dates advance by 14 and seven days.
Interest accrues daily on the posted balance using the annual rate divided by 365. The model posts accumulated interest on each planned payment date before applying that day’s payments.
CommBank explains its daily interest calculation using a 365-day divisor and monthly interest periods. This tracker uses your selected payment dates for interest posting, so weekly and fortnightly models can differ from a lender’s monthly charges.
The comparison includes accrued interest through the review date. Fees, redraw and offset balances are excluded. An interest posting date or opening accrued interest that differs from the model can also explain a statement difference.
Record Actual Payments and Rate Changes
Enter each payment with its effective date to build the tracked balance. The original plan stays separate, so an extra or missed payment changes only the entered track.
Use one record per line with an ISO date, a comma and an amount without a dollar sign or thousands separators. For example, 2026-02-15,1000 records a $1,000 payment. Leave payment records empty to model no payments during the period.
Enter every payment after the starting date and on or before the review date. Two payments on the same day remain separate in the transaction export and are added together in the progress table.
Record a changed annual rate with its effective date in Rate changes, such as 2026-03-01,6.25. A rate change applies from that date, while the original plan keeps its starting rate.
Payments reduce the posted balance immediately. Any pending interest stays separate until its posting date, unless a payment clears the remaining debt. Cash above that debt appears as unapplied cash in the export.
The tracker accepts up to 1,000 payments and 100 rate changes over ten years within the remaining plan term. An invalid record stops the comparison and identifies its row. Nothing connects to a bank account or saves automatically.
Read and Export the Difference
A negative balance difference means the tracked debt is lower than the original plan at the same review date. A positive difference means more debt remains in the model.
The example starts with $500,000 at 6%, with a $2,997.75 monthly plan over 30 years. Three planned payments plus an entered $1,000 extra payment leave a tracked balance of $497,389, compared with $498,396 planned.
The balance difference is -$1,007 after whole-dollar rounding. The extra payment accounts for $1,000, with the remaining difference coming from lower interest after that payment.
The chart compares planned and tracked balances from the starting date through the review date. Both lines share the displayed high-to-low range, with a dashed white plan and a solid teal entered track.
Balance-equivalent progress compares both review balances with the original schedule’s closing balances. The example is two scheduled payments ahead on that measure. It measures balance progress in whole scheduled payments, so it does not predict a new payoff date or change the lender’s payment obligations.
If the planned payment cannot reduce the original balance, the progress figure says Plan balance grows. The payment and balance differences remain available. Balance cleared means the entered payments clear the modelled debt and accrued interest.
Download the CSV before leaving the page. It contains the original inputs, dated transactions and rate changes, plus every progress row with planned and entered payments. Dates stay in ISO format and amounts stay as plain numbers for spreadsheet calculations.
Reconcile each exported payment date and amount with the lender statement, then compare the opening balance and interest posting dates. Keep any fees or redraw separate when explaining the remaining difference. The local record is a review worksheet, not the lender’s account.