Rechnungskalender & Abo-Tracker
Jede Rechnung und jedes Abo in einem druckbaren Monatskalender, mit Fälligkeits-Warnungen, Jahresübersicht und einer Kündigungsliste, die zeigt, was du sparen würdest
Sofort-Download · Lizenz für private Nutzung · lebenslange Updates
Mit PayPal oder Karte bezahlen
- 8 Blätter
- Formate: .xlsx (Excel 2016+, Google Sheets) + PDF guide
- ZIP: 123 KB
Richte es ein, nutze es mindestens eine Woche — und wenn es wirklich nicht zu dir passt, schreib uns innerhalb von 14 Tagen mit einem Screenshot deiner Einrichtung, und du bekommst den vollen Betrag zurück.
Die Produktdetails sind derzeit auf Englisch.
Type a bill in once — amount, due day, how often it repeats and the next date it is due — and the tracker does the rest. It works out the monthly equivalent (a 720 semi-annual insurance bill is 120 a month), the annual cost, how many days you have left and whether the bill is Paid this period, Due soon, Overdue or Scheduled. Sixty bills fit, at any of six frequencies: weekly, biweekly, monthly, quarterly, semi-annual and annual.
The Calendar tab draws a real month grid — pick the month and the week start in Settings and it redraws itself, with the total due and the number of bills on each day, today highlighted, and a month total, daily average and busiest day underneath. It is built to print, so it can live on the fridge.
The Subscriptions tab is where the money hides. List up to 50 services, mark whether you actually used each one in the last 30 days, and decide Keep, Cancel or Undecided. The Dashboard adds up the annual cost of everything you never open and exactly what cancelling your "Cancel" list would save you in a year — plus free-trial dates that count down before they turn into a paid subscription.
The Payment Log gives you twelve months of tick boxes with the value paid and what is still outstanding this month, and the Annual Overview spreads every bill across the year so the expensive months stop being a surprise. Built for Excel 2016+ and Google Sheets with classic, compatible formulas only — no macros, nothing locked. Sample data for a real household is filled in so nothing looks empty on first open.
Das bekommst du
- 8 sheets: Start Here, Settings, Dashboard, Bills, Calendar, Subscriptions, Payment Log, Annual Overview
- 60 bills × 6 frequencies (weekly, biweekly, monthly, quarterly, semi-annual, annual) with automatic monthly and annual cost
- Printable month calendar that redraws for any month and either week start, with the amount and number of bills on each day
- Status per bill — Paid this period, Due soon, Overdue, Scheduled — from your reminder days and last-paid date
- 50 subscriptions with used-in-the-last-30-days flag, Keep / Cancel / Undecided decisions and the yearly saving from cancelling
- Free-trial end dates with a countdown alert before they turn into a paid subscription
- Dashboard with 12 KPIs (monthly bills, monthly and annual subscriptions, potential saving, due in 7 days, overdue, autopay %, unused services, live trials) and 4 charts
- 12-month payment log with counts, value paid, value still outstanding and a flag for every bill you have not ticked
- Annual Overview: every bill across all 12 months with running totals and a built-in check that the year adds up
- Works in Excel 2016+ and Google Sheets · no macros · instant download (.xlsx + PDF guide)
Jede Seite ansehen
Klick auf eine Seite, um sie zu vergrößern.
Was drin ist
Fragen
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive, open it and choose File → Save as Google Sheets. Every formula, dropdown, chart and conditional format is Sheets-compatible. A short PDF walks you through it.
Can I print the calendar?
Yes — the Calendar tab is set up to print on one landscape page with the working columns kept off the printable area, so you get a clean month grid. Change the month in Settings and print the next one.
How does it handle bills that are not monthly?
Pick the frequency and the tracker converts it: weekly × 52 ÷ 12, biweekly × 26 ÷ 12, quarterly ÷ 3, semi-annual ÷ 6, annual ÷ 12. The calendar puts weekly bills on every matching weekday, biweekly bills every fourteen days from the next due date, and everything else on its due day in the months it actually falls due.
Do the due-date alerts update by themselves?
Yes. Days until due and the statuses are based on today's date, so they are correct every time you open the file. You choose how many days of warning each bill gets.
What do I do after I pay a bill?
Put the date in "last paid" and move the next due date forward one cycle. The status changes to "Paid this period" straight away, and you can tick the month on the Payment Log.
Can I change the currency and the categories?
Yes. The currency symbol, the 12 categories and the 8 payment accounts all live on the Settings sheet and can be renamed — every dropdown and chart follows.
Is anything locked or macro-based?
No. No macros, no protected sheets, no external links. Blue-on-yellow cells are inputs; black cells are formulas.
Bewertungen
Noch keine Bewertungen — dieses Produkt ist neu. Jede Bewertung hier stammt aus einem bestätigten Kauf.
Lizenz für die private Nutzung in einem Haushalt. Kein Weiterverkauf, keine Weitergabe. Lieferung als ZIP-Download sofort nach der Zahlung. Es wird nichts Physisches verschickt.
