Free tool
Free familybudget tracker.
Ten minutes a week. Log what you spend, pick the month, and see every category against the budget you set, with what is left before the month ends.
- Price
- Free
- Format
- On this page, always current
- Built by
- Salman Feroz, CPA, CMA and team
- Code word
- BUDGET

What is inside
5 parts, one workbook
Inputs are marked in colour. Everything else calculates. The first sheet is a one-page guide.
- 01Setup: income and your budget for each categoryIncluded
- 02Spending log for up to 600 entriesIncluded
- 03This month: budget, actual and what is leftIncluded
- 04Needs, wants and savings against a target you setIncluded
- 05Full year by category with a trend chartIncluded
Who it is for
Family budget tracker: who gets the most from it
What comes in, what goes out and what is left, month by month.
Built by The Accounting Doc team in Pickering, Ontario, from the working files we use with clients.
- Two-income households that earn well and still wonder where it goes
- Families saving for a home, an RESP or a year off
- Canadians abroad running a household in two currencies
Get the family budget tracker
Tell us who you are and the full template opens on this page, straight away and every time you come back. Free. We also send you the new tools as they come out.
- Setup: income and your budget for each category
- Spending log for up to 600 entries
- This month: budget, actual and what is left
- Needs, wants and savings against a target you set
The template, on the page
View it here, copy the structure into your own sheet. The template stays on this page so it is always the current version; inputs are the shaded cells, everything else calculates.
Leave your email to open the full template
Free. The view opens straight away and stays open on this device.
Open the template| The Accounting Doc | ||
|---|---|---|
| One place for what comes in, what goes out and what is left, month by month. Built for busy households: ten minutes a week keeps it current. | ||
| How to use it | ||
| Step 1 | Open Setup. Type your household income and your own monthly budget for each category. | |
| Step 2 | Open Transactions. Add each thing you spend: date, what it was, category and amount. Once a week is enough. | |
| Step 3 | Open This month. Pick the month at the top to see budget against actual for every category. | |
| Step 4 | Open Needs wants savings to see how the month split, and Year for the full picture. | |
| Colour key | ||
| Yellow cells | You type here. Sample entries are already in: type over them or delete them. | |
| White and grey cells | These calculate on their own. Leave them alone. | |
| What is in this workbook | ||
| Setup | Income, categories and your monthly budget for each. | |
| Transactions | Your spending log. Up to 600 entries. | |
| This month | Budget, actual and what is left, by category. | |
| Needs wants savings | How the month split against a target you set. | |
| Year | Every category, every month, with a trend chart. | |
| Built by The Accounting Doc, Pickering, Ontario. accountingdoc.ca. A working tool, not tax, legal or financial advice. Want the numbers kept for you? Ask for a fixed price quote at accountingdoc.ca. |
Setup
Type over the yellow cells. Add your own categories in the blank rows.
| Category | Type | Monthly budget | Income source | Monthly amount | |
|---|---|---|---|---|---|
| Mortgage or rent | Need | 2800 | Salary 1, take-home | 6200 | |
| Property tax and condo fees | Need | 450 | Salary 2, take-home | 4900 | |
| Utilities and internet | Need | 380 | Canada Child Benefit | 0 | |
| Groceries | Need | 1200 | Other income | 0 | |
| Car payment and insurance | Need | 750 | |||
| Fuel and transit | Need | 320 | |||
| Childcare and school | Need | 900 | Total monthly income | (calculates) | |
| Health and dental | Need | 150 | Income less total budget | (calculates) | |
| Phone plans | Need | 160 | |||
| Insurance, life and home | Need | 210 | Sample figures only. Use take-home pay, after tax. | ||
| Restaurants and takeout | Want | 350 | |||
| Entertainment and subscriptions | Want | 120 | |||
| Kids activities and sports | Want | 300 | |||
| Clothing | Want | 200 | |||
| Travel and holidays | Want | 400 | |||
| Gifts and giving | Want | 150 | |||
| Emergency fund | Savings | 500 | |||
| RRSP, TFSA and RESP | Savings | 1200 | |||
| Extra debt payments | Savings | 300 | |||
| Total budget | (calculates) |
Date
| 2026-11-01 00:00:00 | Mortgage | Mortgage or rent | 2800 | Joint | (calculates) | (calculates) | |
|---|---|---|---|---|---|---|---|
| 2026-11-02 00:00:00 | Weekly shop | Groceries | 286.4 | Card | (calculates) | (calculates) | |
| 2026-11-03 00:00:00 | Hydro and gas | Utilities and internet | 212.75 | Joint | (calculates) | (calculates) | |
| 2026-11-05 00:00:00 | Fill up | Fuel and transit | 74.2 | Card | (calculates) | (calculates) | |
| 2026-11-06 00:00:00 | Hockey registration | Kids activities and sports | 310 | Card | (calculates) | (calculates) | |
| 2026-11-07 00:00:00 | Pizza night | Restaurants and takeout | 68.5 | Card | (calculates) | (calculates) | |
| 2026-11-09 00:00:00 | Weekly shop | Groceries | 301.15 | Card | (calculates) | (calculates) | |
| 2026-11-10 00:00:00 | RESP contribution | RRSP, TFSA and RESP | 400 | Joint | (calculates) | (calculates) | |
| 2026-11-12 00:00:00 | Daycare | Childcare and school | 900 | Joint | (calculates) | (calculates) | |
| 2026-11-14 00:00:00 | Streaming | Entertainment and subscriptions | 38.97 | Card | (calculates) | (calculates) | |
| 2026-10-03 00:00:00 | Weekly shop | Groceries | 1180 | Card | (calculates) | (calculates) | |
| 2026-10-01 00:00:00 | Mortgage | Mortgage or rent | 2800 | Joint | (calculates) | (calculates) | |
| 2026-10-18 00:00:00 | Thanksgiving trip | Travel and holidays | 620 | Card | (calculates) | (calculates) | |
| (calculates) | (calculates) | ||||||
| (calculates) | (calculates) | ||||||
| (calculates) | (calculates) | ||||||
| (calculates) | (calculates) | ||||||
| (calculates) | (calculates) | ||||||
| (calculates) | (calculates) | ||||||
| (calculates) | (calculates) | ||||||
| (calculates) | (calculates) |
This month
Pick the month in the yellow cell. Type the first day of the month.
| Month to view | 2026-11-01 00:00:00 | ||||
|---|---|---|---|---|---|
| Category | Type | Budget | Actual | Left | Used |
| Total | (calculates) | (calculates) | (calculates) | (calculates) | |
| Income this month | (calculates) | ||||
| Spent and saved so far | (calculates) | ||||
| Not yet assigned | (calculates) | ||||
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
Needs, wants, savings
Uses the month chosen on This month. The target split is yours to change: 50, 30 and 20 is a common starting point, not a rule.
| Type | Target share | Target amount | Actual | Difference |
|---|---|---|---|---|
| Need | 0.5 | (calculates) | (calculates) | (calculates) |
| Want | 0.3 | (calculates) | (calculates) | (calculates) |
| Savings | 0.2 | (calculates) | (calculates) | (calculates) |
| Total | (calculates) | (calculates) | (calculates) | (calculates) |
Year
Type the year in the yellow cell.
| Year | 2026 | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Category | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
| Total | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
| (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) | (calculates) |
Family budget tracker: your questions
Is the family budget tracker really free?
Yes. Leave your email and the full template opens on the page straight away, and stays open on this device. No card, no trial.
What do I need to open it?
Nothing. It opens on this page as sheets you can read; the shaded cells are the inputs and the rest calculates. Copy the structure into your own spreadsheet, or ask us to keep it filled in for you.
Will you email me afterwards?
You get the template, then a short series of practical emails for Canadian business owners. Unsubscribe in one click.
Can you set it up for my business?
Yes. That is what the monthly plans are for: we keep the numbers current so the template is filled in for you. Ask for a fixed price quote.
Rather have us keep the numbers?
Two questions, then where to reply. You hear from us within one working day with an indicative range and the plan that fits. The exact price is confirmed in writing before any work starts.
We never ask for confidential documents on this form. Secure upload happens after onboarding.
- WhatsAppMessage us from your phone
- Book a callPick a time that suits you
- Call +1 647 283 1515Office hours, Eastern time
- Emailsalman@accountingdoc.ca
We never ask for confidential documents in chat.
We use one analytics cookie to see which pages help people. Privacy