{"product_id":"sinking-funds-savings-tracker","title":"Sinking Funds Savings Tracker Spreadsheet","description":"\u003cp\u003eThis sinking funds tracker gives every known cost its own fund and works out what to set aside each month to meet it on time. It is for anyone tired of Christmas, the car service and the insurance renewal all landing at once.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eNothing on the dashboard is typed. Show all funds or pick one, and the cards, bars and timeline follow.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSet aside: the money in the funds against what they need\u003c\/li\u003e\n\u003cli\u003eEvery fund, with set aside and still to find\u003c\/li\u003e\n\u003cli\u003eA month needed: what each fund needs each month from here, against your plan\u003c\/li\u003e\n\u003cli\u003eComing up: the next bills due, what is set aside and whether each is on track\u003c\/li\u003e\n\u003cli\u003eWhen it is needed: the next twelve months, with a dot in the month each bill is due\u003c\/li\u003e\n\u003cli\u003ePut in each month, with the current month highlighted, and the running total against the target\u003c\/li\u003e\n\u003cli\u003eNext bill due: the next irregular bill, its date and its amount\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA fund per known cost\u003c\/h2\u003e\u003cp\u003eGive each fund a target and a date, and the monthly amount is calculated. A bill calendar sits next to it, so nothing arrives as a surprise. Every figure on the dashboard is calculated from the tabs behind it. Nothing is typed into a summary, so the front page can never disagree with the rows it came from.\u003c\/p\u003e\u003ch2\u003eConnected tabs\u003c\/h2\u003e\u003cp\u003eEvery tab reads the same transaction list, so nothing is entered twice. Beyond the funds, it is a complete annual budget and savings planner:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eMoney in, money out:\u003c\/strong\u003e 2,000 transaction rows, income by pay cycle, recurring bills, a bill calendar, and accounts with balances\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTwelve months:\u003c\/strong\u003e January through December, budget against actual, variance colored, start in any month, and an annual summary\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBuild wealth:\u003c\/strong\u003e the 50\/30\/20 split, debt payoff, sinking funds, savings goals and net worth\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYou get real spreadsheet files, not a PDF with a link in it: Excel and Google Sheets, each filled in and each blank and ready for yours. The filled copy is the file in the photos, so you can see how it behaves before you type anything.\u003c\/p\u003e\u003cp\u003eIt is a budget template you can start in any month, with the bill calendar and sinking funds doing the forward planning.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The files are for personal use on your own devices; please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to the Google Sheets versions (filled and blank).\u003c\/p\u003e\u003ch3\u003eHow is the monthly amount for each fund worked out?\u003c\/h3\u003e\u003cp\u003eFrom the target and the date the bill is due: what is still to find is spread over the months left, and compared with what you plan to put in.\u003c\/p\u003e\u003ch3\u003eCan I see which bills are coming up?\u003c\/h3\u003e\u003cp\u003eYes. The dashboard lists the bills due next and whether each is on track, and the timeline marks the month each bill falls due over the next twelve months.\u003c\/p\u003e\u003ch3\u003eCan I look at one fund on its own?\u003c\/h3\u003e\u003cp\u003eYes. Pick a single fund on the dashboard and the cards, bars and timeline switch to that fund.\u003c\/p\u003e\u003ch3\u003eIs it only for sinking funds?\u003c\/h3\u003e\u003cp\u003eNo. The same file includes a full monthly budget, savings goals, debt payoff and net worth, all reading one transaction list.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597862830174,"sku":"OPX-052","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/sinking-funds-savings-tracker-01.jpg?v=1790832223","url":"https:\/\/opxviashop.com\/products\/sinking-funds-savings-tracker","provider":"OPXVIA","version":"1.0","type":"link"}