{"product_id":"single-income-household-budget","title":"Single Income Household Budget Spreadsheet","description":"\u003cp\u003eThis single income budget shows how far one salary reaches when it is holding up a whole household. It is a family budget for one-earner homes, including stay at home parent households, that want the risk in numbers.\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\u003eA cover ratio for every month\u003c\/h2\u003e\u003cp\u003eIncome divided by essentials, worked out each month and color-coded, so you can see at a glance which months the one wage covers comfortably and which it does not. In the demo it never drops below 1.49x, and the tab says so.\u003c\/p\u003e\u003ch2\u003eIf the income stopped\u003c\/h2\u003e\u003cp\u003eThe question that keeps one income budget households awake: if the pay stopped on Friday, how long would everything else keep running? In the demo it is 5.4 months as things stand, 6.4 if optional spending goes, and 8.6 if savings pause too. Investments are counted at half, because selling in a hurry costs money.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eOne Income: monthly cover ratio against essentials, color-coded\u003c\/li\u003e\n\u003cli\u003eWhat you could reach if the income stopped, and how fast\u003c\/li\u003e\n\u003cli\u003eCutting back buys time: three scenarios, months of runway each\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003e28 connected tabs\u003c\/h2\u003e\u003cp\u003eUnderneath sits a complete household budget. Everything reads from one transaction list, so nothing is typed twice and there are no pivot tables to refresh.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e2,000 transactions and 40 categories, all renameable\u003c\/li\u003e\n\u003cli\u003eEvery figure calculated: budgets, variances, totals and percentages\u003c\/li\u003e\n\u003cli\u003eOver-budget and overdue amounts color themselves\u003c\/li\u003e\n\u003cli\u003eDrop-down lists that grow as you add accounts and categories\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers, not pictures\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eIt answers the emergency fund question directly: how many months your savings and accounts would carry the household on one income or none.\u003c\/p\u003e\u003cp\u003eYou get a filled-in copy as well as a blank one: a full demo year you can click through, and a blank ready for your own money, in Excel and Google Sheets. It uses no dynamic arrays, no macros and no add-ins, so it behaves the same in every supported version, and the Google Sheets version is a real workbook, not a PDF with a link in it.\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, no subscription and no bank connection\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 Start Here tab walks you through setup in a few minutes. The files are for your own household; 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 or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. You get Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make Google Sheets copies with a free Google account.\u003c\/p\u003e\u003ch3\u003eWhat is the cover ratio?\u003c\/h3\u003e\u003cp\u003eYour income divided by your essential spending for each month. Above 1 means the one income covers the essentials that month.\u003c\/p\u003e\u003ch3\u003eHow does it work out months of runway?\u003c\/h3\u003e\u003cp\u003eIt adds up what you could reach if the income stopped, counting investments at half, and divides by your spending under three scenarios.\u003c\/p\u003e\u003ch3\u003eCan I rename the categories?\u003c\/h3\u003e\u003cp\u003eYes. All 40 categories are renameable, and drop-downs grow as you add accounts and categories.\u003c\/p\u003e\u003ch3\u003eDoes it connect to my bank?\u003c\/h3\u003e\u003cp\u003eNo. There is no bank connection, no add-ins and no macros. You enter or paste your transactions.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597863977054,"sku":"OPX-067","price":25.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/single-income-household-budget-01.jpg?v=1790832308","url":"https:\/\/opxviashop.com\/products\/single-income-household-budget","provider":"OPXVIA","version":"1.0","type":"link"}