Notion Masterclass: Build an Expense Tracker from Scratch

A recurring expense tracker built in Notion can eliminate the annual “surprise charge” problem by turning every subscription or recurring bill into a structured record with an automatically calculated next renewal date. The payoff is practical: during weekly planning, users can look ahead at upcoming renewals (via Notion Calendar) and cancel items before charges hit—avoiding refunds or wasted spend.

The build starts from a blank Notion page and creates a full-width “Expense Tracker” dashboard backed by a single underlying database. That database holds the raw details of each expense—how much it costs, when it was last charged, whether it renews monthly or yearly, and where it’s paid from (e.g., specific cards or accounts). It also tracks operational context: category (such as Dev, Marketing, or Website), an owner (who decides whether to keep or cancel), a “used by” list for teams who rely on the tool, a direct link to the billing dashboard, and notes. A status field marks items as active, maybe cancel, or canceled, with an optional cancellation date for recordkeeping.

Two formula properties make the system work. First, “Monthly cost” converts yearly costs into an equivalent monthly outlay by dividing the annual figure by 12 when the recurrence interval is yearly. Second, “Renewal date” calculates the next upcoming renewal relative to today using the charge date plus the recurrence interval (with logic to ensure that if today is the renewal day, the tracker shows today rather than pushing it forward). This turns manual subscription management into a live schedule.

To make the tracker actionable, the database is connected to Notion Calendar. A key requirement is adding a calendar view directly to the source database (not just a linked database view), then using the formula “Renewal date” as the calendar driver. Once connected, upcoming renewals appear on the calendar in week and month views, letting users decide whether to keep or cancel before the charge date.

On the dashboard, multiple linked views provide different ways to review the same underlying data: an “Active expenses” recurrence list sorted by next renewal date, an alphabetical view, a cost-ranked view (monthly cost descending), a calendar layout view showing future renewals, and a grouped categories view that collapses sections by category. A separate “Cancellations” section uses filtered views to show canceled and “maybe cancel” items, sorted by cancellation date or renewal date depending on the status. Together, these views give both forward-looking planning (what’s coming) and retrospective clarity (what was canceled and when). The result is a reusable template that can support business subscriptions or personal budgeting items like streaming services and recurring apps.