A personal finance dashboard that forecasts your money to the day

Most personal-finance apps are rear-view mirrors. They tell you, in loving detail, what you already spent — far too late to change anything. I wanted the opposite: something that looks forward. A dashboard that watches how I actually spend and answers the only two questions that keep anyone up at night — will I make it to the end of the year, and if I keep spending like this, what day do I hit zero?

So I built a Personal Finance Dashboard that quietly runs on a small computer in my home.

How it knows what you spent — without you lifting a finger

Here's the clever part. Every time you spend money — a card swipe, a transfer, a bill paid — your bank fires off an email about it. Those notifications pile up in Gmail, and most people never read them. This system does.

Sitting inside a humble Google Sheet is a Google Apps Script that reads through those transaction emails in your inbox, one by one. It pulls out the details that matter — how much, to whom, and when — works out what kind of spending it was, and writes each one as a tidy row in the spreadsheet. It runs on its own schedule, so the sheet keeps filling itself in as your day goes on. No receipts to keep, no columns to type, nothing to remember.

That spreadsheet becomes a single, always-current ledger of your financial life. And the dashboard? It simply reads off that sheet. Gmail delivers the raw transactions, the script does the gathering and sorting, the spreadsheet holds the truth, and the dashboard does the thinking. By the time you open the page, the work is already done — you just look.

It understands what you spend

Every transaction is grouped automatically — food, transport, bills, shopping, and so on — and from that, the dashboard works out how fast money actually leaves your account. Crucially, it follows your typical day, not your worst one: a single big purchase like a flight or an annual bill won't panic the numbers and throw the whole picture off. What you're left with is an honest, steadily-updating read on your real habits — no willpower, no envelopes, no guilt.

A report you can actually read

Financial dashboards love to drown you in dense tables and angry red figures. The Report page is built like a magazine spread instead: generous spacing, clean typography, clear category breakdowns, and this-month-versus-last comparisons you grasp at a glance. The point was never more data — it was understanding. One page, and you simply know how the month is going.

Your year, predicted to the day

This is where it stops being a tracker and becomes something genuinely useful. The dashboard projects your balance forward, day by day, all the way to the end of the year — and hands you the answers that actually matter:

• What you'll have left at the end of the month and the end of the year, if nothing changes.
• The exact day you'd run out at your current pace — not a vague "you're spending too much," but a date on the calendar.
• The tightest moment ahead, so a cash crunch never sneaks up on you.

Seeing a date instead of a warning changes how you behave. It's the difference between "I should spend less" and "I have until the 14th."

It knows what's coming in, too

A forecast is only as good as its income side, so the dashboard takes future income seriously: regular pay, the occasional bonus, individual paychecks you're expecting. It folds all of it into the projection — which means it can tell you not just whether you'll finish the year comfortably, but which months will be tight, and roughly how much you'd need to set aside to glide through to year-end without a scare.

Plan the future — including the fun parts

The part I use most is planning ahead. Thinking about a trip? Drop it in as a future expense and the dashboard redraws on the spot: how much it dents your year-end balance, how much sooner you'd hit empty, whether your cushion survives it. You get to make the call before you book — with the consequences laid out — instead of finding them in next month's statement. Budgeting stops being a chore you do afterwards and becomes a quick what-if you run beforehand.

Yours, and only yours

For something that knows this much about your money, where it lives matters. It runs on hardware I own, and your numbers never get handed to a third-party app to mine or sell. It watches your money so you don't have to — and it answers to no one but you.

---

Forecasting isn't fortune-telling. It's just taking the patterns already sitting in your spending seriously enough to extend the line forward — and having the nerve to put a date on it. If you'd want a dashboard like this keeping an eye on your own money, that's exactly the kind of system I build. Get in touch.