How to track recurring expenses without formulas
This post is about the philosophy. For the step-by-step setup, read How to track recurring bills without a spreadsheet.
Recurring expenses — rent, salary, subscriptions, utilities — are the most predictable part of your finances. They're also the part that spreadsheets handle worst, requiring manual re-entry every month with no forecasting capability built in.
The spreadsheet problem with recurring items
A spreadsheet doesn't know that your rent is due on the 1st every month. You have to tell it — by manually entering it again, every single month. Miss it once, and your monthly total is wrong. Miss it twice, and your year-over-year comparison is misleading. There's also no forward view: the spreadsheet only shows what you've entered, never what's coming.
What a recurring bill tracker needs to do:
The formula-free method
The key insight is that recurring expenses don't require calculation — they require registration. You register them once in a system that understands time and recurrence, and the system handles everything else.
In FinTrack, this works in three steps:
Register each recurring item
Add the name, amount, type (income or expense), and due day. For salary: Income, £4,200, Day 1. For rent: Expense, £1,200, Day 5. Takes about 2 minutes total for a typical household.
The Financial Timeline does the rest
FinTrack automatically places each item in the current month's timeline. Items show as "Today," "Tomorrow," or "In X days" — a live view of what's coming, without any formulas or manual intervention.
Safe to Spend updates automatically
Every time an item is added, marked paid, or passed its due date, your Safe to Spend and Projected Month-End recalculate. The numbers are always current without any action from you.
What you get that spreadsheets can't provide
Zero monthly re-entry
Items registered once appear automatically every month.
Forward visibility
You see what's due before it leaves your account.
Safe to Spend
Current balance minus all unpaid upcoming expenses — the number you actually need.
Projected Month-End
What your balance will be on the 31st if everything goes as expected.
Set up your recurring items once
Free to start. Takes 2 minutes to set up. No formulas, no monthly re-entry, no bank connection.
Start FinTrack Free