{"product_id":"bill-tracker-calendar-spreadsheet","title":"Bill Tracker and Calendar Spreadsheet","description":"\u003cp\u003eThis bill tracker spreadsheet shows every bill you owe on a day-by-day calendar, so a payment never catches you off guard. List your bills once, log what goes out, and you can see what is paid, what is due and what is late for any month of the 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\u003eChoose the full year or a single month and the cards and calendar follow. Nothing on the dashboard is typed; it fills itself from what you enter.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eBills due and paid: what was due, what went out and how many bills were paid\u003c\/li\u003e\n\u003cli\u003eThe bill calendar: the month day by day, marked paid, due, late or missed\u003c\/li\u003e\n\u003cli\u003eThe year at a glance: twelve months of bills and how each month went\u003c\/li\u003e\n\u003cli\u003eAutopay or by hand: what leaves on its own and what you pay yourself\u003c\/li\u003e\n\u003cli\u003eBills by category: where the bill money goes, with every share as a percentage\u003c\/li\u003e\n\u003cli\u003eNext bill: its day, its amount and whether it is on autopay\u003c\/li\u003e\n\u003cli\u003eThe next 14 days: every bill coming up, with the days left until it is due\u003c\/li\u003e\n\u003cli\u003eYour biggest monthly bills\u003c\/li\u003e\n\u003cli\u003eHow much each account needs to hold to cover the bills that come out of it\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA bill calendar for all twelve months\u003c\/h2\u003e\u003cp\u003eThe calendar is built from your bill list and runs day by day across the whole year. Change a due day once and the calendar moves itself, so this due date tracker stays right without any rework. It covers monthly bills on autopay and anything you pay by hand.\u003c\/p\u003e\u003ch2\u003eTwenty-one connected tabs\u003c\/h2\u003e\u003cp\u003eEverything reads from one transaction list, so nothing is typed twice and there are no pivot tables to refresh. It is a bill payment tracker and a budget spreadsheet in one, with every category feeding the same totals.\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 own numbers, not pictures\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA filled-in copy to learn from\u003c\/h2\u003e\u003cp\u003eAlongside the blank workbook you get a full demo year you can click through, so you can see every tab working before you enter your own money. Both come in Excel and in Google Sheets.\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\u003eThe Excel workbook, filled with a worked example\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for your own numbers\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with 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 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\u003eCan I use it in Google Sheets instead of Excel?\u003c\/h3\u003e\u003cp\u003eYes. The Excel workbook runs 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\u003eWhat happens if a bill's due date changes?\u003c\/h3\u003e\u003cp\u003eChange the due day once in your bill list and the calendar moves the bill for every month by itself.\u003c\/p\u003e\u003ch3\u003eCan I tell autopay bills apart from ones I pay myself?\u003c\/h3\u003e\u003cp\u003eYes. The dashboard splits what goes out on its own from what you pay by hand, and the next-bill card says whether it is on autopay.\u003c\/p\u003e\u003ch3\u003eWill it show me which bills are coming up?\u003c\/h3\u003e\u003cp\u003eYes. The dashboard lists every bill due in the next 14 days with the days left, and the calendar marks each day as paid, due, late or missed.\u003c\/p\u003e\u003ch3\u003eDoes it connect to my bank account?\u003c\/h3\u003e\u003cp\u003eNo. You log what goes out and the workbook does the rest. There is no bank connection, no add-in and no subscription.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597859946590,"sku":"OPX-011","price":25.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/bill-tracker-calendar-spreadsheet-01.jpg?v=1790831986","url":"https:\/\/opxviashop.com\/products\/bill-tracker-calendar-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}