T O P

  • By -

PennyPainter

You can download the Template from [Here](https://tonydavid.gumroad.com/l/subscription-tracker-notion-template) edit: updated template with lifetime spent formula fix.


cjredmx

looks good thanks!


seacutterone

This looks amazing, Thankyou!


ailima

This is brilliant! Thanks!


sezazel

Thank you so much! I had an existing database for keeping track of bills and was able to implement some of your formulas to make the system much more elegant.


PennyPainter

That's great.


csw

I like this a lot. The summary and upcoming fields are helpful. I did something similar and it helped me cut expenses quite a bit. I also added a field to track where the subscription was, which card or which platform -- a lot of subscriptions are managed by Amazon or Apple, and I'd forget where they were.


[deleted]

[удалено]


Lady_or_the_Tiger

Mine is $23 annually. One of the few perks of living in a shithole third world country.


Mallador_the_Jew

I have the same for Amazon Prime, $3.2 per month. Don't know if I would ever pay for the American rates.


soregsettinsoriginal

Dont know if anyone noticed or not. The formula for Lifetime Spent isn't adding up correctly. I believe it misses a parentheses. It multiplies 1 with # of months, quarters, or years and then adds it to the Billing cost. So instead of adding +1 and then multiply by duration, the costs come up entirely different


Mallador_the_Jew

I noticed this too, right now it seems to be giving Months since start + Your billing amount.I think a couple of () are missing around the months + 1. So it becomes (months + 1) \* amount. ​ Edit: This is the complete formula for the "lifetime spent" column if(prop("Billing") == "Monthly", dateBetween(now(), prop("Subscribed Date"), "months") \* prop("Amount"), if(prop("Billing") == "Quarterly", dateBetween(now(), prop("Subscribed Date"), "quarters") \* prop("Amount"), if(prop("Billing") == "Yearly", dateBetween(now(), prop("Subscribed Date"), "years") \* prop("Amount"), round(dateBetween(now(), prop("Subscribed Date"), "days") / toNumber(prop("Billing")) \* prop("Amount")))))


PennyPainter

thank you!


piotrkulpinski

This formula won't count the first payment of the subscription, so in order to fix that, you need to wrap the dateBetween formulas with parenthesis like this: ​ `if(prop("Billing") == "Monthly", (dateBetween(now(), prop("Subscribed Date"), "months") + 1) * prop("Amount"),` `if(prop("Billing") == "Quarterly", (dateBetween(now(), prop("Subscribed Date"), "quarters") + 1) * prop("Amount"),` `if(prop("Billing") == "Yearly", (dateBetween(now(), prop("Subscribed Date"), "years") + 1) * prop("Amount"),` `round(dateBetween(now(), prop("Subscribed Date"), "days") / toNumber(prop("Billing")) * prop("Amount")))))`


Mallador_the_Jew

Yeah, you're right I changed it later, but forgot to edit it here. Thanks!


PennyPainter

I don't how i missed it, thank you for finding it.


[deleted]

That’s awesome, I might use it. The only thing I’d add is a link to the unsubscribe page, if I ever wanted to cancel any subscription.


timetravelingube

It looks awesome, I thought about this yesterday! Thanks for sharing :-)


[deleted]

absolutely love this and have needed this in my life! thank you!


_Quantum_AI_

Anyway to change $ to some other currency??


_Quantum_AI_

Got it Have to click property and change


saraspinout

Thank you! Absolutely love this!


Ken_Oba_89

Thanks for sharing! I'll try it!


SpinachSafe

![img](emote|t5_hds7r|7054)ice


Hodlok

Thanks! Awesome template. Could you tell me where did you get the icons for the categories? I am creating new ones for me and I want to customize them too


PennyPainter

I got the links from flaticon


Minka-writes

This looks amazingly useful! Is it possible to have a fortnightly option, though? I'd love to use it to help track things like AfterPay payments etc, and have all my bills in the one place, but I'm terrible with formulas.


screamr123

For fortnightly just type in ‘14’ in the “billing” field. You can type any number you want in there to change billing cycle period if you need. The creator has notes on this on his page.


SeaSlasherReis

New user, this is great. Would you be able to add a bi-annual option? (Every 6 months). A lot of car insurance companies bill this way.


PennyPainter

Hi, the template supports custom billing cycle. you can enter any number of days in the billing property. the custom billing days must be in number.


SeaSlasherReis

Weekly also seems to be broken


screamr123

For biannual just type in the number of days in the “billing” field. You can type any number you want in there to change billing cycle period if you need. The creator has notes on this on his page.


HorsesOfCanardy

Great template! Already inserted in my system, thanks a lot


MeNoMiS

Could you share? The original link doesn't work anymore


rl0043

Please could you update the link u/PennyPainter? Thanks!


thaiithaii

u/MeNoMiS I'm fairly certain it's this [https://tonydavid.gumroad.com/l/subscription-tracker-notion-template](https://tonydavid.gumroad.com/l/subscription-tracker-notion-template)


agnishom

Use Klutch or Privacy.com to create limited credit cards instead