{"product_id":"50-30-20-budget-spreadsheet","title":"50\/30\/20 Budget Dashboard Spreadsheet","description":"\u003cp\u003eThis 50 30 20 budget spreadsheet checks one simple rule every month: half your take-home pay on needs, 30% on wants and 20% on savings. You log each transaction once, and the workbook tells you whether you kept to the rule and where you drifted.\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\u003eA single dropdown switches the page between a month and the full year. Nothing on it is typed; it fills itself from your entries.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eTake-home pay for the period, and how many months kept to the rule\u003c\/li\u003e\n\u003cli\u003eNeeds, wants and savings, each as a share of take-home against its 50, 30 or 20% target\u003c\/li\u003e\n\u003cli\u003eThe rule by month: needs, wants and savings each month, with the targets drawn in\u003c\/li\u003e\n\u003cli\u003eTwelve monthly verdict tiles: on the rule, save more, or overspent\u003c\/li\u003e\n\u003cli\u003eWants to trim: the biggest wants in the period, the first place to cut\u003c\/li\u003e\n\u003cli\u003eLeft over: what was neither spent nor saved, with a twelve-month mini chart\u003c\/li\u003e\n\u003cli\u003eIn dollars: what the rule allows against what actually went out\u003c\/li\u003e\n\u003cli\u003eThree rings showing how many points you are over or under each target\u003c\/li\u003e\n\u003cli\u003eCash flow: income and spending by month, with a running total left over\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThe Rule Tracker\u003c\/h2\u003e\u003cp\u003eThe Rule Tracker turns the budget rule into a plain verdict for each month: on the rule, saving too little, or overspending. It works from your own numbers, so the judgment is about your actual month, not an estimate.\u003c\/p\u003e\u003ch2\u003eTwenty-nine connected tabs\u003c\/h2\u003e\u003cp\u003eEvery tab reads from one transaction list. Nothing is typed twice and there are no pivot tables to refresh, so your monthly budget and the year view always match.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e2,000 transaction rows and 40 categories, all renameable\u003c\/li\u003e\n\u003cli\u003eBudgets, variances, totals and percentages calculated for you\u003c\/li\u003e\n\u003cli\u003eOver-budget and overdue amounts change color on their own\u003c\/li\u003e\n\u003cli\u003eDropdown lists that grow as you add accounts and categories\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your numbers, so it doubles as an expense tracker and a savings tracker\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eFilled in, light and dark\u003c\/h2\u003e\u003cp\u003eEach download has a full demo year to click through and a blank copy for your own money, in Excel and in Google Sheets. Both come in a light edition and a dark edition, with every tab restyled and the same formulas underneath.\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 needed.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no bank connection\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example, and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (light and dark, 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 as soon as payment clears. The template is for personal use on your own devices; please do not share or resell the files. 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 Google Sheets or only Excel?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel workbooks run in Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eHow does it tell me if I kept to the 50\/30\/20 rule?\u003c\/h3\u003e\u003cp\u003eThe Rule Tracker gives each month a verdict, on the rule, saving too little or overspending, and the dashboard shows needs, wants and savings against their 50, 30 and 20% targets.\u003c\/p\u003e\u003ch3\u003eWhich categories count as needs and which as wants?\u003c\/h3\u003e\u003cp\u003eYou decide. All 40 categories can be renamed, and the workbook groups your spending so the rule is checked against your own numbers.\u003c\/p\u003e\u003ch3\u003eWhere should I cut back first?\u003c\/h3\u003e\u003cp\u003eThe dashboard lists your biggest wants for the period under Wants to trim, which is the first place to look.\u003c\/p\u003e\u003ch3\u003eAre the light and dark editions the same workbook?\u003c\/h3\u003e\u003cp\u003eYes, apart from the look. Same tabs, same formulas, and both are included.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597859913822,"sku":"OPX-010","price":27.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/50-30-20-budget-spreadsheet-01.jpg?v=1790831980","url":"https:\/\/opxviashop.com\/products\/50-30-20-budget-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}