FintrekIncome and expense tracker: free template and a simple routine
Updated 28 October 2026
An income and expense tracker answers three questions: how much came in, how much went out, and what is left. Here is what to put in it, a free template that already has it all, and a routine that keeps it honest.
What an income and expense tracker is
It is a list of every money movement with a monthly total on top. Unlike a budget, it does not start with a plan — it starts with what actually happened. Most people need a month or two of honest tracking before a budget makes sense at all.
The columns you need
- Date — when the money moved.
- Description — a few words you will recognise later (“taxi to airport”, “salary”).
- Type — income or expense. Transfers between your own accounts are neither — keep them out of the totals.
- Category — for expenses: housing, groceries, eating out, transport, utilities, health, fun, other.
- Amount and currency — in the currency you actually paid or received.
- Amount in your main currency — calculated, so totals can be added up across currencies.
See the month at a glance
On a separate summary sheet: total income, total expenses, the difference, and spending by category. The formula behind each number is a simple SUMIFS: the sum of the “main currency” column where the month matches and the type is “Expense” (and, for a category, where the category matches). Add the share of income you kept — it is the single most motivating number in personal finance.
Free template: everything above, ready
The free Fintrek budget template has a transactions sheet with exactly these columns, drop-downs for type, category and currency, your own exchange rates, and a monthly summary with charts. It opens in Excel, Google Sheets and Numbers — no sign-up.
A 10-minute weekly routine
- Add anything from the week you have not recorded yet — cash first, it is the easiest to forget.
- Check the two or three biggest categories against last month.
- Pick one small change for next week. One, not five.
Once a month, look at income minus expenses. If it is positive and growing, the tracker is doing its job.
When the spreadsheet becomes a chore
Manual entry is where most trackers stop. If that happens, let the entry part be done for you: tell the Fintrek bot in Telegram “groceries 450 lira” or “salary 2000 dollars”, confirm, and it is recorded in the right currency. Any time, the bot sends you this same template filled with all your records — income, expenses, exchanges and debts — so your spreadsheet stays yours.
Questions
What is the difference between an expense tracker and a budget?
An expense tracker records what happened; a budget is a plan for what should happen. Track first for a month, then use the numbers to set your budget.
Is there a free income and expense tracker for Google Sheets?
Yes. The Fintrek budget template opens in Google Sheets (File → Import) and Excel. It is free and needs no sign-up.
How do I track monthly expenses in Excel?
Keep one row per transaction with a date, type, category and amount, then add up each month with SUMIFS by month and type — the template does this for you.
Should transfers between my accounts be income or expense?
Neither. Moving money between your own accounts or exchanging currency does not change how much you have — keep these separate from income and expenses.