Notion Templates
Notion Templates/
All Templates
All Templates/
🧾
Recurring Payment Tracker
🧾

Recurring Payment Tracker

Master Tag
Finance
Created
Mar 31, 2021 10:04 PM
How It Works
https://www.redgregory.com/notion/2021/4/1/recurring-payments-in-notion-monthly-quarterly-yearly
Usage
Web Tags
Database
Formula
Alternatives
💸
Subscription Cleanse
Cover
Subscriptions & Purchases
Subscriptions & Purchases
Original Payment
Name
Recurring
Amount
Next Payment Date
Feb 28, 2019
Website
Monthly
$67.00
Jan 15, 2019
N. Machine
Quarterly
$35.00
Oct 31, 2020
Coffee Sub
Yearly
$120.00

Last Payment

if(prop("Recurring") == "Monthly", dateAdd(prop("Original Payment"), dateBetween(now(), prop("Original Payment"), "months"), "months"), if(prop("Recurring") == "Quarterly", dateAdd(prop("Original Payment"), dateBetween(now(), prop("Original Payment"), "quarters"), "quarters"), if(prop("Recurring") == "Yearly", dateAdd(prop("Original Payment"), dateBetween(now(), prop("Original Payment"), "years"), "years"), now())))

Next Payment

if(prop("Recurring") == "Monthly", dateAdd(prop("Original Payment"), dateBetween(now(), prop("Original Payment"), "months") + 1, "months"), if(prop("Recurring") == "Quarterly", dateAdd(prop("Original Payment"), dateBetween(now(), prop("Original Payment"), "quarters") + 1, "quarters"), if(prop("Recurring") == "Yearly", dateAdd(prop("Original Payment"), dateBetween(now(), prop("Original Payment"), "years") + 1, "years"), prop("Original Payment"))))