Pay2Value › Free expense tracker template

Free expense tracker template (Google Sheets & Excel)

A simple spreadsheet to track your spending in ringgit. It adds up each month and each category for you, and has one extra column most templates don't: "Would you buy it again?"

⬇ Download the template (.xlsx)

Free. No sign-up. 2 sheets: Spending and Summary.

What's inside

  • Spending sheet: Date, What, Category, Amount (RM), Paid with, Would you buy it again? Category and Yes/No are drop-down lists.
  • Summary sheet: total spent, money on things you'd buy again, money you regret, and totals for every category and every month of the year.
  • Categories: Food, Drinks, Transport, Shopping, Fun, Bills, Subscriptions, Health, Gifts, Other.

How to use it in Google Sheets

1

Download the file above.

2

Open Google Sheets → File → Import → Upload, and choose the file. (In Excel, just open it.)

3

Add one row for each thing you buy. Fill the last column a few days later, when you know if it was worth it.

4

Check the Summary sheet at the end of the month. Change the year in cell B1 if you need to.

Tired of filling in a spreadsheet?

Most people stop after a week or two. Pay2Value does the same thing on your phone: it logs TNG, ShopeePay, MAE and bank payments for you, and asks "Would you buy it again?" at the right time.

▶ Get it on Google Play

Questions

Is the template free?

Yes, it is free to download and use.

Does it work in Google Sheets?

Yes. Import the .xlsx file in Google Sheets (File → Import). The formulas and drop-down lists keep working.

Why a "Would you buy it again?" column?

Totals show how much you spent, not whether it was worth it. Marking Yes or No a few days later shows how much went to things you regret.