Skip to content

Monthly expense tracker

List what you spend each month and see it added up by category against your limit.

Monthly expense tracker template, first page

Fill it in and preview

Monthly expense tracker

A spreadsheet to record what you spend in a month. List each payment with its date and category, then read the Summary sheet: the total, the amount in each category, its share of the total and how much of your limit is left. Download it as Excel, OpenDocument, PDF or CSV.

Expenses

Monthly expense tracker

Add one row for every payment. The Summary sheet adds them up by category.

Name Leila Rahimi

Month March 2027

Monthly limit 1,800.00

Date What it was for Category Amount
2027-03-01 Rent Housing 760.00
2027-03-03 Supermarket Food 84.20
2027-03-05 Monthly transport pass Transport 49.00
2027-03-08 Pharmacy Health 18.50
2027-03-12 Cinema and dinner Leisure 62.00
2027-03-15 Electricity Bills 71.30
2027-03-19 Supermarket Food 96.75
2027-03-24 Birthday gift Other 35.00

Summary

Summary by category

Category Spent Share of total
Housing 760.00 64.6%
Food 180.95 15.4%
Transport 49.00 4.2%
Health 18.50 1.6%
Leisure 62.00 5.3%
Bills 71.30 6.1%
Other 35.00 3.0%
In the categories 1,176.75 100.0%
Without a listed category 0.00
Total spent 1,176.75
Monthly limit 1,800.00
Left to spend 623.25
Share of the limit used 65.4%
Number of payments 8
Biggest payment 760.00

Open this spreadsheet in nerixA preview of the first rows with sample figures. Open it in nerix to fill in your own and change any cell.

Templates are a careful starting point, not legal advice. Where the law matters, check what applies where you are.

Money and payments

What this template is for

A monthly expense tracker spreadsheet: list every payment with its date and category and see the totals, shares and what is left of your limit. Free.

It is free to fill in online, needs no account, and downloads as a Word document or a PDF. See all Money and payments templates All free Excel and spreadsheet templates

Money and payments

What you fill in

The form asks for 4 details. The document fills itself in as you type.

  • Your name

    For example: Leila Rahimi

  • Month

    For example: March 2027

  • Monthly limitoptional

    The most you want to spend this month. Leave empty for no limit.

    For example: 1800

  • Payments

    One row for each payment. Category: Housing, Food, Transport, Health, Leisure, Bills or Other.

Money and payments

What is inside

The parts of this document, in order.

  1. 1A spreadsheet to record what you spend in a month. List each payment with its date and category, then read the Summar...

Templates

How it works

  1. 01

    Open

    Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.

  2. 02

    Change

    Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.

  3. 03

    Download

    Save it as an Excel file, an OpenDocument sheet, a PDF or CSV.

Make it yours with AI

Open it in the chat and ask for changes: shorter, firmer, another situation, another language.

Adapt it with nerix

Money and payments

Questions people ask

What details does this template ask for?

The form asks for 4 details, starting with Your name, Month, Payments. 1 more are optional.

Can I download this template as Word or PDF?

Yes. Open it in nerix and the finished spreadsheet downloads as Excel, OpenDocument, PDF or CSV. It is free and the page only shows sample figures.

Is what I type sent anywhere?

No. What you type stays in your browser while you fill in the document. It only goes to nerix if you choose to open the template in the chat.

What should I check before I use this template?

The tracker adds up what you enter, so a missing payment is a missing amount. Give every row one of the listed categories to see it in the summary.

Are these invoice and payment templates free?

Yes. Each one is free to fill in and download as Word or PDF, with no account.

What must an invoice include?

Your details, the customer's details, an invoice number and date, a description of what was sold, the amount and how to pay. Tax rules differ by country, so add what your local rules require.

How polite should a payment reminder be?

Start friendly and factual, with the invoice number, amount and due date. Only move to firmer wording if the first reminder is ignored.

Can I use these for a business in any country?

Yes. The templates assume no country, and you enter your own currency, tax details and payment instructions.