{"product_id":"emergency-fund-savings-tracker","title":"Emergency Fund Savings Tracker Spreadsheet","description":"\u003cp\u003eThis emergency fund tracker shows how many months of essentials your savings would cover, and when the fund will be full at your current pace. It is for anyone building the fund that stops a bad month turning into a bad year.\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. Pick the full year or any month and the page shows the fund at the end of it.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eIn the fund: the balance, with a mini chart of every month end\u003c\/li\u003e\n\u003cli\u003eMonths of cover: how long the fund would pay your essentials, against your target\u003c\/li\u003e\n\u003cli\u003eThe fund month by month, against the target line\u003c\/li\u003e\n\u003cli\u003ePut in and taken out, and the emergencies it paid for each month\u003c\/li\u003e\n\u003cli\u003eFull by: the month the fund reaches your target at the pace so far\u003c\/li\u003e\n\u003cli\u003eMilestones at one month, three months, your target and six months, reached or expected\u003c\/li\u003e\n\u003cli\u003eA month of essentials, with every share as a percentage\u003c\/li\u003e\n\u003cli\u003eWhat the fund paid for: the latest withdrawals with date and amount\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA target with a date\u003c\/h2\u003e\u003cp\u003eSet a savings goal and a date, and the monthly amount it takes to hit it is calculated for you. Sinking funds sit alongside, so the emergency fund stops being the thing you raid for the car service. 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\u003eTen connected tabs\u003c\/h2\u003e\u003cp\u003eEvery tab reads the same transaction list, so nothing is entered twice. It works as a full budget spreadsheet as well as a savings tracker:\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\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\u003eCan I use this in Google Sheets or Excel?\u003c\/h3\u003e\u003cp\u003eBoth. 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 does it work out months of cover?\u003c\/h3\u003e\u003cp\u003eIt divides the fund balance by what a month of essentials costs you, and shows the result against the target you set.\u003c\/p\u003e\u003ch3\u003eWill it tell me when the fund will be full?\u003c\/h3\u003e\u003cp\u003eYes. The dashboard shows the month the fund reaches your target at the pace so far, with milestones at one month, three months, your target and six months.\u003c\/p\u003e\u003ch3\u003eCan I track other savings too?\u003c\/h3\u003e\u003cp\u003eYes. Sinking funds and savings goals sit in the same file, so planned costs are saved for separately from the emergency fund.\u003c\/p\u003e\u003ch3\u003eDo I need Microsoft 365?\u003c\/h3\u003e\u003cp\u003eNo. It runs on Excel 2016, 2019, 2021 or 365 and on LibreOffice, with no add-ins or macros.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597862797406,"sku":"OPX-051","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/emergency-fund-savings-tracker-01.jpg?v=1790832217","url":"https:\/\/opxviashop.com\/products\/emergency-fund-savings-tracker","provider":"OPXVIA","version":"1.0","type":"link"}