Evidence-first money workflow · Personal Money
Debt Snowball Payment Reconciler
Reconcile a planned debt snowball schedule with actual monthly payments, ending balances, missing rows, extra payments, and focus-debt shifts.
- 1Prepare
- 2Analyze
- 3Review and export
Prepare the evidence
Paste the documented CSV schema or choose a local CSV file. Nothing is sent to Nirmion.
Review the analysis
Summary metrics lead back to the rows that support them.
Method and interpretation
How to use Debt Snowball Payment Reconciler
Use this reconciler after one or more months of following a smallest-balance-first payoff schedule. A planner can show what should happen, but statement timing, changed minimums, skipped payments, new charges, and deliberate exceptions can move the real balances away from that path. This workflow keeps the planned schedule and actual evidence separate so the difference can be reviewed without silently rewriting history.
Prepare the input
The plan CSV needs month, debt, opening balance, APR, minimum, planned payment, and planned ending balance. The actual CSV needs the same month and debt labels plus actual payment and actual ending balance. Use one row per debt and month, one currency, and YYYY-MM months. Set a tolerance for small statement-rounding differences. Debt names are normalized for case and spacing but should otherwise remain stable.
Check the worked example
The worked example follows Card A before Card B because Card A has the smaller opening balance. October matches. In November, Card A receives less than planned while Card B receives extra, so the evidence shows both a below-plan row and a shifted focus. The result does not call that choice wrong; it shows exactly where the snowball schedule changed.
Read the evidence
Start with matched coverage, then inspect below-plan or missing rows. The focus column identifies the smallest positive opening balance for each month. A focus shift appears when another debt receives extra payment while the expected focus receives no extra above its minimum. Ending-balance deviation reveals whether payments alone explain progress; a higher actual balance can also indicate interest, fees, or purchases omitted from the plan.
Calculation method
Rows match by normalized month and debt. Payment difference = actual payment − planned payment. Balance difference = actual ending balance − planned ending balance. Values within the selected tolerance are treated as matched. Monthly snowball focus sorts positive opening balances from smallest to largest, then uses APR and debt name only as stable tie breaks.
Review Tiller’s documented snowball and payment-tracking workflow
Questions this workflow helps answer
Use these questions to confirm that this tool matches the task you need to complete.
- How can I reconcile a debt snowball spreadsheet against actual monthly payments?
- Which missed or extra payments changed my smallest-balance payoff plan?
- Why does my actual ending balance differ from the planned debt snowball balance?
Limits and decision boundary
This tool audits an existing schedule; it does not calculate interest from transactions, verify due dates, infer new charges, or move payments. A lower actual ending balance may include credits or adjustments rather than an extra payment. Promotional terms, delinquency, hardship plans, and secured debts can justify a different priority.
Common mistake
Do not paste current balances into every planned month. Use the original schedule as the plan and statement-supported values as actuals, otherwise the reconciliation will appear matched because the plan was overwritten.
Your pasted values and selected CSV files are processed in this browser tab. This workflow does not connect to a bank, save a budget, or provide financial, tax, legal, or investment advice.
Questions about this workflow
Does a focus shift mean I used the wrong strategy?
No. It means actual extra payment did not follow the smallest-balance focus shown by the plan. Review due dates, fees, promotions, and intentional decisions before changing anything.
Why can payment match while ending balance differs?
The plan may have used different interest, fees, purchases, credits, or posting dates. Use the statement reconciler and interest audit to investigate the balance bridge.
Can I reconcile more than one year?
Yes, within the 5,000-row input limit. Stable debt names and one row per debt and month are required.