Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceBudgeting & Expense ManagementDaily Expense Tracker

SpreadsheetBudgeting & Expense ManagementFree

Daily Expense Tracker

Log every purchase in seconds and see this month’s spending by category, daily average and month-end forecast.

Shown with sample data

Colour

Daily Expense Tracker

Log every purchase in seconds and see this month’s spending by category, daily average and month-end forecast.

Spent this month
$652.89
Daily average
$36.27
Wants share
35%
Spending you could choose to cut
Biggest purchase
$95
Purchases this month
14
Budget for the month
$1,260
Projected month-end
$1,088
Categories trending over
1
Spending by category this month
  • Groceries$254.70
  • Shopping$95
  • Transport$92.30
  • Entertainment$83.99
  • Dining out$51.50
  • Bills$35
  • Personal care$28
  • Health$12.40
Share of spending by category
  • Groceries$254.7039%
  • Shopping$9515%
  • Transport$92.3014%
  • Entertainment$83.9913%
  • Dining out$51.508%
  • Bills$355%
  • Other$40.406%

How to use it

  1. 1Type the month you want to review on Settings as yyyy-mm (for example 2026-11).
  2. 2Add each purchase on the Expenses sheet the same day, with category, payment method and Need or Want.
  3. 3Set a monthly budget per category on the Monthly budget sheet.
  4. 4Watch Projected month-end: a category marked Trending over will overshoot if you keep the current pace.
  5. 5At month end, change the month on Settings and keep logging; past months stay in the log.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

You cannot cut what you have not measured. Log each purchase with its category and whether it was a need or a want; the tracker totals the month you choose, compares each category with its budget, projects where you will finish at today’s pace and shows how much of your spending is discretionary.

Who it’s for

  • Finding out where your money actually goes
  • A 30-day spending challenge
  • Building the numbers for your first budget

What’s included

  • Expenses sheet: One row per purchase.
  • Monthly budget sheet: Budget, spending and forecast for the month on Settings.
  • Settings sheet: The month the summaries show.

How to use it

  1. 1Type the month you want to review on Settings as yyyy-mm (for example 2026-11).
  2. 2Add each purchase on the Expenses sheet the same day, with category, payment method and Need or Want.
  3. 3Set a monthly budget per category on the Monthly budget sheet.
  4. 4Watch Projected month-end: a category marked Trending over will overshoot if you keep the current pace.
  5. 5At month end, change the month on Settings and keep logging; past months stay in the log.

Tips

  • Log purchases straight away, even small ones. Forgotten coffees and app purchases are usually the surprise.
  • Track for a full month before cutting anything. One week rarely shows the real pattern.
  • Look at the Want share before deciding what to cut: it shows how much of your spending is truly flexible.

Questions

What is the best way to track daily expenses?

Record each purchase the moment you make it, with a category, and review weekly. A simple log you keep is better than a detailed one you abandon after a week.

Should I include bills paid by direct debit?

Yes if you want a full picture of monthly spending. If you only want to watch day-to-day spending, leave fixed bills out and track them in a bill tracker instead.

How is the month-end projection worked out?

Spending so far is divided by the days elapsed and multiplied by the days in the month. It assumes your pace stays the same, so it is most useful from the second week on.

Related searchesdaily expense trackerexpense tracker spreadsheettrack daily spendingspending logpersonal expense trackerwhere does my money go

Details

Format
Spreadsheet
Category
Budgeting & Expense Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBudgeting & Expense ManagementFree

Daily Expense Tracker

Log every purchase in seconds and see this month’s spending by category, daily average and month-end forecast.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Budgeting & Expense Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More budgeting & expense management templates

View all
Household Monthly Budget3 sheets

Income received

$4,550

Spent so far

$2,947

Left to spend

$373

Spending by category
$1,450
$518.55
$400
$300
$250
Rent / mortgageGroceriesEmergency fundExtra debt paymentRetirement
SpreadsheetBudgeting & Expense Management

Household Monthly Budget

Plan by category, log spending, and see planned vs actual, what is left and your 50/30/20 split update live.

10 min setupPreview
50/30/20 Budget3 sheets

Total planned

$3,992

Left unallocated

$308

Planned spending by group
63%
  • Needs
  • Savings
  • Wants
SpreadsheetBudgeting & Expense Management

50/30/20 Budget

Split take-home pay into needs, wants and savings, and see how your real spending compares with the rule.

10 min setupPreview
Zero-Based Budget4 sheets

Income this month

$4,980

Left to assign

$0

Spent so far

$3,645

Income by group
63%
  • Essentials
  • Debt
  • Savings
  • Lifestyle
SpreadsheetBudgeting & Expense Management

Zero-Based Budget

Give every dollar a job: assign income until "left to assign" is zero, then track spending against each line.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ