Setting Up Your Subscription Tracker
Start with the currency symbol. Change it once on the List tab and it propagates across every sheet, so you never touch currency formatting again.
Each subscription needs a due day, not a full date. Enter “15” for Netflix once and the calendar finds the 15th whether you are looking at January or July, without you re-entering anything when the month rolls over.
Categories are the other field worth filling in properly. Tag each line as streaming and media, shopping, or whatever buckets match your spending, and the template rolls up totals per category on its own.
How Billing Cycles Drive Automatic Renewal Calculations
Five billing cycles are supported: monthly, annual, one-time, quarterly, and biannual. Picking one sets off two calculations at once, and both matter for different reasons.
The first converts your entered cost into monthly and annual equivalents. Enter $100 as an annual charge and you see what it costs per month; enter $9.99 monthly and you see the yearly figure. Annual plans hide their real weight until you see that monthly number next to your other charges.
The second runs off the start date. Put in when you signed up or when the current term began, and the template projects the next renewal by applying the cycle to that date: monthly subscriptions land on the same date each month, annual ones on the anniversary, quarterly every three months. Uncheck the renewal box for a service you canceled and it drops out of the calendar without deleting the history.
Reading Your Spending Dashboards
Three dashboards do the aggregation. The first works one subscription at a time: select Netflix and you get spend to date, per month, and per year for that line alone, which is the view that tells you whether a service earns its keep.
The second collapses everything into two numbers, total monthly and total yearly across all subscriptions. That is your full subscription load in one place.
The third groups by category. Choose streaming and media and you get the combined monthly, yearly, and to-date spend across Netflix, Spotify, and anything else tagged that way. Category drift is the thing this catches: a single $10 addition slips past you, but a category sitting at $80 per month does not.
All three recalculate the moment you change a renewal date or a billing cycle, with no manual refresh step.
Using the Calendar to Stay Ahead of Renewal Due Dates
The calendar tab pulls due dates from your subscription list and is otherwise read-only. Three settings accept input: displayed month, displayed year, and start of week. Change any of them and every due date refreshes.
Color coding carries the urgency. Overdue bills are marked distinctly, bills due today show bold, and bills due soon appear without the bold weight. A glance tells you which renewals need attention before the end of the week.
Archiving is a matter of preference. Keep a single calendar tab and uncheck boxes as you pay through the month, or duplicate the tab and rename each copy (“January Calendar,” “February Calendar”) to keep a dated record of what was paid and when. The duplicate approach costs you thirty seconds a month and gives you a year of history you can actually look back at.
Example: Tracking Netflix, Prime, Spotify, and Gym Renewals
Mixing billing cycles is where the aggregation earns its place. Netflix runs $20 monthly on the 15th, Amazon Prime is $100 annually on August 1st, Spotify is $9.99 monthly on the 20th, and a gym membership costs $150 quarterly, renewing March 1st, June 1st, September 1st, and December 1st.
The dashboard turns that into a monthly average of roughly $88: $20 plus $8.33 from Prime plus $9.99 plus $50 from the gym. The annual total lands near $1,180. All four services show up on the calendar with their due dates, and switching Spotify from monthly to annual recalculates both the monthly average and the yearly total on the spot.
Why This Matters for Your Dzing Safe-to-Spend Number
Dzing works out safe-to-spend from your planned operations: recurring income, subscriptions, bills, and one-off expenses. Every renewal is money already committed, so it comes off what is genuinely available this month.
The tracker does the arithmetic, and Dzing does the consequence. Once you have the monthly cost and renewal date for each service, enter them as planned operations and your safe-to-spend number stops pretending that $88 is still yours to spend.
The category view is worth checking before you add anything new. Streaming at $80 a month plus a $15 addition is a number you can weigh against your safe-to-spend before you commit, rather than noticing it three statements later.
Making the Next Renewal a Non-Event
Doing this by hand means holding four renewal dates in your head, then guessing what is left in your account after the ones you forgot. The spreadsheet gets you the totals, but it does not know about your rent, your salary date, or the money you set aside last week.
The better version: you open your phone, see one number, and know that every subscription renewal between now and payday is already deducted from it. Dzing computes that safe-to-spend figure from a transparent formula and shows you the full breakdown, with planned operations covering recurring salary, subscriptions, bills, and one-off expenses across multiple accounts and currencies. Budgets and savings goals feed into the same calculation, and spending history shows where it went.
Dzing does not sync with your bank. Every entry is manual by design, and it never moves real money. That trade is the point: you type in the renewal, and in exchange the number you see is one you understand line by line.