Skip to content

Free templates · no email, no sign-up

Sinking Funds Tracker (Free Excel, Google Sheets & PDF)

A free sinking funds tracker: list each cost you know is coming, its goal and the month it's due, and the sheet works out what to set aside each month. Log deposits as you go; balance and % funded update. Excel and Google Sheets .xlsx plus a printable PDF, no email.

In the example, six funds (car registration and repairs, holidays and gifts, home insurance, medical and dental, back to school and pet care) need $425 a month in total. A $900 car fund due in December is $75 a month; a $600 insurance bill due in June is $100 a month.

  • Free printable sinking funds tracker (PDF preview)

    Sinking funds tracker

    Up to 15 funds: goal + due month = what to save each month, with 12 months of deposits, balance and % funded.

  • Free printable zero-based budget template (PDF preview)

    Zero-based budget template

    Income, 30 categories tagged need / want / save, planned vs actual, and a 'Left to budget' line that says when every dollar has a job.

The .xlsx opens in Excel, Apple Numbers and LibreOffice. For Google Sheets: drive.google.com → New → File upload → open the file → File → Save as Google Sheets. Type in the cream cells; totals update by themselves.

How sinking funds work

A sinking fund is money set aside a little at a time for a cost with a date: the yearly car insurance, holiday gifts, a vacation, property tax. Divide the goal (minus what you've already saved) by the months until it's due, and save that every month. When the bill arrives, the money is there, and it never lands on a credit card.

Keep the money in one high-yield savings account and let the tracker say how much belongs to each fund, or use separate savings 'buckets' if your bank offers them. Add the monthly total as one line in your budget.

  • Yearly bills: car registration, insurance, memberships, property tax, software renewals.
  • Irregular but certain: car repairs, medical and dental, pet care, home maintenance.
  • Seasonal: holidays and gifts, back to school, summer camp, vacations.

Work out the monthly amount

The sinking fund calculator does the same math for one goal, and the yearly expenses calculator helps find the costs to plan for. For the gift fund, the holiday budget calculator splits the total by person. If you'd rather have it all connected, the paid 2027 Budget Planner Spreadsheet Pack (below) links twelve dated months, sinking funds, debt payoff and a bill calendar into one workbook; the free files here stay free either way.

Plan the new year

More of the 2027 budget pack

Frequently asked questions

What is a sinking fund?

Money you save a little each month for a known future cost, such as insurance, gifts or car repairs, so the bill is paid in cash when it comes.

How do I calculate how much to put in a sinking fund?

(Goal − already saved) ÷ months until it's due. A $900 cost due in December, starting in January, is $75 a month.

What's the difference between a sinking fund and an emergency fund?

A sinking fund is for costs you know are coming. An emergency fund is for the ones you can't predict, like a job loss. Keep them separate.

How many sinking funds should I have?

As many as you have predictable non-monthly costs; most households have 5 to 10. The tracker holds up to 15.

Is there a sinking funds tracker for Google Sheets?

Yes: download the free .xlsx, upload it to Google Drive and choose File → Save as Google Sheets.