{"product_id":"bill-tracker-bill-calendar-spreadsheet-light-dark","title":"Bill Tracker \u0026 Bill Calendar Spreadsheet (Light + Dark)","description":"\u003cp\u003eDid I pay that? When is it due? What is coming up this week? This simple bill tracker answers all three. List each bill once, log a payment when you pay, and see every bill on a calendar: paid, due soon or overdue. Light and dark versions are both included.\u003c\/p\u003e\u003cp\u003eYou type each bill one time: the name, the amount, how often and the first due date. The sheet repeats it for the whole year by itself. When you pay, add one row with the date, the bill and the amount; it finds the due date on its own. Bills on autopay count as paid on their due date, so there is nothing to log for them. No locked cells.\u003c\/p\u003e\u003ch3\u003eWHAT YOU GET · 5 FILES\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eBill-Tracker.xlsx: your blank tracker (light), with common bill categories and accounts already filled in\u003c\/li\u003e\n\u003cli\u003eBill-Tracker-Dark.xlsx: the same blank file in dark mode\u003c\/li\u003e\n\u003cli\u003eBill-Tracker-EXAMPLE.xlsx and Bill-Tracker-Dark-EXAMPLE.xlsx: the same file filled with a made-up household, so you can click around first\u003c\/li\u003e\n\u003cli\u003eBill-Tracker-Quick-Start-Guide.pdf (4 pages): which file to open, the 3 steps, 7 simple rules with example rows, questions and answers, and your Google Sheets \"Make a copy\" links (light and dark)\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003e8 TABS\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eStart Here: three steps and short tips, with links to every tab\u003c\/li\u003e\n\u003cli\u003eSetup: the year and your currency symbol, how many days count as \"due soon\", a late window, whether autopay counts as paid, the accounts you pay from and your bill categories\u003c\/li\u003e\n\u003cli\u003eDashboard: pick a month and see what is due, what is paid and what is still to pay; what is overdue right now; the next 7 and 14 days; autopay vs manual; the next bill to pay; a 12-month chart of due vs paid; a month-by-month record; totals by category and by account\u003c\/li\u003e\n\u003cli\u003eCalendar: pick a month and see every bill on its due date. ✔ paid, ⚠ overdue, ● due soon, and today in red.\u003c\/li\u003e\n\u003cli\u003eBills: one row per bill with category, amount (or tick Varies), how often, first due date, autopay, pay from, an optional last due date and a website or note. Next due date, status, times this year, year total and overdue count fill themselves. 100 rows ready.\u003c\/li\u003e\n\u003cli\u003ePayments: one row per payment with the date paid, the bill, the amount, an optional due date, a confirmation number and a note. It shows the due date the payment counts for and whether it was on time. 600 rows ready.\u003c\/li\u003e\n\u003cli\u003eYear View: every due date of the year in date order, with the amount, what was paid, the date you paid and its status. Up to 1,000 due dates a year.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003ePlus a Lists tab that fills the drop-downs by itself (no need to touch).\u003c\/p\u003e\u003ch3\u003e7 WAYS A BILL CAN REPEAT\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eMonthly\u003c\/li\u003e\n\u003cli\u003eEvery 2 weeks\u003c\/li\u003e\n\u003cli\u003eWeekly\u003c\/li\u003e\n\u003cli\u003eQuarterly\u003c\/li\u003e\n\u003cli\u003eEvery 6 months\u003c\/li\u003e\n\u003cli\u003eYearly\u003c\/li\u003e\n\u003cli\u003eOne-time\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eType the first due date and the bill repeats on the same day of the month (or the same weekday) for the whole year. A bill that ends? Type its last due date.\u003c\/p\u003e\u003ch3\u003eWHY IT'S SIMPLE\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eOne place to type each thing: bills once, payments as you go.\u003c\/li\u003e\n\u003cli\u003ePaid a few days late? It still counts for the due date you missed, and shows how many days late.\u003c\/li\u003e\n\u003cli\u003eBills that change every month (electric, credit card): type a guess and tick Varies. What you pay replaces the guess.\u003c\/li\u003e\n\u003cli\u003eAutopay bills mark themselves as paid on their due date. Prefer to log them? One switch in Setup.\u003c\/li\u003e\n\u003cli\u003eOverdue bills turn red on the Dashboard, the Calendar and the Year View, so nothing slips by.\u003c\/li\u003e\n\u003cli\u003eNothing is locked. No passwords, no macros. Click any grey cell to see its formula.\u003c\/li\u003e\n\u003cli\u003eNo video needed. The Start Here tab and the 4-page guide cover everything.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eLIGHT AND DARK\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eBoth versions are in this listing, with the same tabs and the same formulas. Pick the one you like.\u003c\/li\u003e\n\u003cli\u003eLight: a soft cream page. Type in the white boxes with a thin border.\u003c\/li\u003e\n\u003cli\u003eDark: every tab is dark, the chart too. Type in the boxes with a thin border. Made for the screen: printing a dark tab uses a lot of ink.\u003c\/li\u003e\n\u003cli\u003eIn both, grey cells fill themselves.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eFROM THE EXAMPLE FILE\u003c\/h3\u003e\u003cp\u003eMade-up numbers, an example only. A household with 18 bills, from rent and daycare to a weekly dog walker and a one-time dentist bill, with payments from January to October 2026. On October 20, 9 of the 17 due dates in October are paid, 2 bills are overdue, and the next bill to pay is due tomorrow. Your numbers will be different.\u003c\/p\u003e\u003ch3\u003eHOW IT WORKS\u003c\/h3\u003e\u003col\u003e\n\u003cli\u003eAfter checkout, click the download button on your order confirmation page. The same download link is also in your order confirmation email.\u003c\/li\u003e\n\u003cli\u003eOpen the quick-start guide. Use a Google Sheets link to make your own copy (light or dark), or open a blank .xlsx in Excel.\u003c\/li\u003e\n\u003cli\u003eList your bills, about 5 minutes: name, amount, how often, first due date.\u003c\/li\u003e\n\u003cli\u003eWhen you pay a bill, add one row in Payments.\u003c\/li\u003e\n\u003cli\u003eCheck the Dashboard and the Calendar any time: what is paid, what is due soon, what is overdue.\u003c\/li\u003e\n\u003c\/ol\u003e\u003ch3\u003eCOMPATIBILITY\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eGoogle Sheets: use the \"Make a copy\" links in the guide (a free Google account is needed)\u003c\/li\u003e\n\u003cli\u003eExcel 2016 or newer on Windows (tested in Excel 2021)\u003c\/li\u003e\n\u003cli\u003eOn a Mac? Use the Google Sheets copy\u003c\/li\u003e\n\u003cli\u003eSet it up on a computer. On a phone or tablet, open your copy in the free Google Sheets app to add entries and check it on the go. Phone web browsers show a read-only view.\u003c\/li\u003e\n\u003cli\u003eNot for Apple Numbers.\u003c\/li\u003e\n\u003cli\u003eAny currency: pick or type your currency symbol. It's a label only; nothing is converted.\u003c\/li\u003e\n\u003cli\u003eReady for 100 bills, 600 payments and 1,000 due dates a year. Copy the last row down for more.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eGOOD TO KNOW\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eDigital download. No physical item will be shipped.\u003c\/li\u003e\n\u003cli\u003eFor personal use only. You may gift one copy to one person. Please don't share, resell or redistribute the files or the Google Sheets links beyond that.\u003c\/li\u003e\n\u003cli\u003eA reminder and a record only: it does not pay your bills, does not connect to your bank and does not send emails.\u003c\/li\u003e\n\u003cli\u003eEnglish only.\u003c\/li\u003e\n\u003cli\u003eColors may look slightly different on different screens.\u003c\/li\u003e\n\u003cli\u003eADHD-friendly by design: short steps, one place to type each thing, nothing hidden behind passwords.\u003c\/li\u003e\n\u003cli\u003eDesigned with the help of AI tools, then checked by hand.\u003c\/li\u003e\n\u003cli\u003eQuestions? Email us at lysansan24@gmail.com and we'll help.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eMORE FROM OUR SHOP\u003c\/h3\u003e\u003cp\u003eWant to plan where the money goes too? See our Simple Budget Spreadsheet for a monthly budget, our Paycheck Budget Spreadsheet to plan each paycheck, or our Debt Payoff Planner to pay off cards and loans faster.\u003c\/p\u003e","brand":"Holeless Digital","offers":[{"title":"Default Title","offer_id":59061635088648,"sku":"S-BILLS","price":8.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1060\/7329\/3064\/files\/11-bill-tracker.jpg?v=1791692675","url":"https:\/\/holelesshome.com\/products\/bill-tracker-bill-calendar-spreadsheet-light-dark","provider":"Holeless Digital","version":"1.0","type":"link"}