House Down Payment Tracker
Why Basic Trackers Fall Short
Most people open a spreadsheet, type in a target number, and stop there. That approach ignores actual interest accrual and irregular income. A $400,000 home requires $80,000 at 20% to skip PMI entirely. Starting January 2024 with $650 bi-weekly contributions into a 4.8% high-yield account reaches that mark by March 2027. Add two extra $1,200 deposits from tax refunds in April and the timeline shortens by four months. Track every inflow by date and source so you see the impact immediately instead of guessing at year-end.
Building the Spreadsheet Columns That Matter
Create six columns: Date, Source, Amount, Running Total, Projected Interest, and Adjusted Target. Enter the initial $5,000 seed from a bonus on 15 January. Link the running total to a simple interest formula that compounds monthly using the current APY. Update the Projected Interest cell each time rates change. This structure forces you to confront shortfalls early, such as the $2,300 gap created when overtime ended in June 2024. No vague categories, only precise entries.
Setting Contribution Rules That Stick
Commit to automatic transfers the day after payday. Set the amount at 12% of take-home pay rather than a flat figure that feels arbitrary. When base salary rises from $4,800 to $5,100 monthly in July 2025, the tracker automatically scales the contribution to $612 bi-weekly. Review the rule once per quarter against actual spending data. If restaurant spending exceeds $380 in any month, redirect that exact amount into the house fund the following week. The tracker makes the trade-off visible in real time.
Accounting for Market and Rate Shifts
High-yield savings rates dropped from 5.1% to 4.3% between October 2023 and February 2024. Update the interest column immediately instead of hoping the old rate holds. A 0.8% decline adds roughly $1,900 in extra months to reach $80,000. Counter the drop by moving $15,000 into a 6-month CD ladder at 5.25% while keeping the rest liquid. The tracker records both the transfer date and the new blended yield so progress stays accurate. Never leave outdated assumptions in the model.
Quarterly Reviews and Course Corrections
Every 90 days, compare actual balance against the projected line. A $1,400 shortfall in September 2024 triggered a temporary side-gig that added $475 weekly for eight weeks. Log both the extra income and the resulting acceleration. If closing costs rise from 2.5% to 3.1% of purchase price, increase the target by that exact percentage. The final sentence in every review is always the same: adjust the contribution or timeline before the next quarter begins. Grab the finished template and monthly updates through the LedgerLaunchCo newsletter.
📧 Want more like this?
The free 7-day Subscription Cleanse. Daily emails with cancellation scripts and renegotiation tactics.
Frequently Asked Questions
How much do you need?
Target 20% of the purchase price to eliminate PMI. On a $425,000 home that equals $85,000. Add 2.8% for closing costs, bringing the total to $96,900. Start with current savings of $12,400 on 1 February 2024 and contribute $725 bi-weekly at 4.6% APY. The tracker shows you hit the number by late October 2026 without any rate increases or windfalls. Update the purchase price assumption every six months as listings change.
FHA vs conventional down payments
FHA loans allow 3.5% down, so $14,875 on the same $425,000 home. That lowers the monthly payment by roughly $180 but adds $1,900 in annual mortgage insurance. Conventional at 20% removes PMI after closing. Run both scenarios in the tracker using the actual rate quotes from March 2024. The 20% path saves $34,000 in insurance premiums over seven years even though it requires more upfront cash.
Where to keep savings
Use a high-yield savings account paying at least 4.3% as of February 2024. Keep three months of contributions in checking for liquidity. Move any balance above $25,000 into a 6-month CD ladder. The tracker logs each transfer date and new yield. Avoid money market funds that dipped below 4% last year. Update the interest rate cell the same day the bank announces a change.
First-time buyer programs
State programs in 2024 offered $10,000-$25,000 in down payment assistance with income limits around $92,000 for a household of two. Record the grant as a one-time inflow on the expected closing date. Subtract the amount from your target immediately. Some programs require repayment if you sell within five years, so note that contingency in the tracker notes column. Confirm current limits with your local housing authority before relying on the funds.
Closing cost prep
Budget 2.5% to 3.5% of purchase price. On a $425,000 home that range is $10,625-$14,875. Add a separate column in the tracker for closing costs only. Fund it with 10% of every house savings deposit starting six months before target closing. If inspection reveals $3,200 in repairs, shift that amount from the down payment column and extend the timeline by three weeks rather than raiding emergency reserves.
📊 Want to track this ongoing?
Track subscriptions, budgets, and debt payoff with the LedgerLaunchCo Etsy spreadsheet bundle.