Savings Tracker Spreadsheet (Sinking Funds)

Please read this page to complete your Savings Tracker Spreadsheet (Sinking Funds) quickly & easily.

Introduction

Welcome! Your budget has a built-in guide that you can use instead of these instructions. In the top-right corner of every page you’ll find an INFO (i) cell:

  1. Hover the mouse over the INFO (i) to read a guide to the page.
  2. Fill in only the cells that are HIGHLIGHTED for you.
  3. For useful tips Read Notes to cells that have a black corner.

NOTE: We recommend using your budget at 75% zoom (see the dropdown at the top).

How To Complete Your Budget (Tab by Tab):

BUDGET SETTINGS

NOTE: This spreadsheet includes a BONUS Spending Breakdown on the Transaction tab. If you want to see your full spending breakdown, complete all steps below (Steps 1, 2 & 3). If you intend to use ONLY the Savings Tracker, then complete only Steps 1 & 3.

  1. Choose your currency & year (left-hand side).
  2. In the tables ‘INCOME & EXPENSES CATEGORIES’ enter types of your Income, Expenses, Bills, Savings, Subscriptions & Debt into the HIGHLIGHTED cells (for ideas check out the Notes in the first cell of every column).
  3. In the table ‘SAVINGS (SINKING FUNDS)’ the column ‘Savings Fund’ is autofilled from the tables on the left. For each fund enter your Goal (amount), Start (initial capital), Monthly (monthly payments) into the HIGHLIGHTED cells.

Go to Transactions >>

TRANSACTIONS

  1. Enter every transaction as it comes. Fields to complete are: Date, Amount & Income/Spending (highlighted). The rest is autofilled for you.
  2. To enter Date you can double-click the cell to choose from the calendar OR enter it manually in any format.
  3. To enter the type of Income/Spending, click the arrow and choose from the dropdown. You can also start typing for options to pop up.

Continue to Savings >>

SAVINGS

This tab will be fully autofilled for you as you complete the Monthly Budget tab and the Transactions tab throughout the year.

THAT’S IT!

Using The Tracker For Next Periods:

TRANSACTIONS

  1. Clear all entries (date, amount & income/spending only) to use it again. Clear ONLY the highlighted cells with your entries.
  2. To bulk clear cells, select the first cell >> holding ‘Shift’ + ‘Command’ >> click ‘Down Arrow’ >> hit ‘Delete’.

SAVINGS

Update your details on the Settings tab, if required. Add more savings types, if any.


Follow Us On Socials

Pay SecureWe support the following payment methods.

Select your currency