Money basics

A receipt tracking template for Google Sheets, with photo links

Build a simple Google Sheets receipt log with photo links, categories and monthly totals, and learn what a scanner app can and cannot do for the sheet.

Editorial illustration for A receipt tracking template for Google Sheets, with photo links

The simplest receipt template in Google Sheets is one tab with six columns: date, shop, category, amount, payment mode and a link to the photo of the bill. Photograph each receipt with your phone, drop it into a Drive folder, paste the link into the row, and let two formulas do the monthly totals. A scanner app only helps with the photo step; the sheet is what makes the receipts useful.

The six columns to set up

Open a new sheet, name the first tab Receipts and put these headers in row 1.

ColumnHeaderWhat goes in it
ADateThe bill date, typed as 14/11/2026 so Sheets reads it as a date
BShopShort name such as Apna Kirana or Medico Pharmacy
CCategoryPick from a dropdown: Food, Health, Home, Travel, Other
DAmountTotal in rupees, numbers only, no symbol
EPaid byUPI, Card, Cash
FPhotoLink to the image in your Drive folder

For the dropdown, select C2:C500, open Data, then Data validation, and add a dropdown from a list of items. A fixed list stops you ending up with Food, food and Foods as three different categories, which would quietly break your totals.

Create one Drive folder called Receipts 2026-27 and keep every photo there. Name each file with the date and shop, for example 2026-11-14 apna-kirana, so the folder sorts itself. Then right-click the file, copy the link, and paste it in column F. If you want a clickable label, use a helper column and fill it down:

  • =HYPERLINK(F2, "View bill") turns the pasted link into a tappable label.
  • =IF(F2="", "No photo", "Photo saved") in another column shows which rows still lack a bill.
  • Keep the folder sharing set to private. A link that anyone can open is not what you want for bills that show your address or phone number.

Which formulas give me monthly totals?

Put a month start date in a cell such as I1 (say 01/11/2026) and the next month start in I2 (01/12/2026). Then total one category for that month with:

=SUMIFS($D$2:$D$500, $C$2:$C$500, "Food", $A$2:$A$500, ">="&$I$1, $A$2:$A$500, "<"&$I$2)

The first range is what gets added; the pairs after it are the conditions. Change the word Food to a cell reference such as K2 and you can copy the formula down a list of categories. For a grand total of the month, drop the category pair and keep the two date conditions.

A worked example with made-up numbers

Say November has five bills: kirana 640, pharmacy 385, auto fare 120, a restaurant 1,150 and another kirana trip 910. Marked Food, Health, Travel, Food and Food, the Food total is 640 + 1,150 + 910 = 2,700. Health is 385 and Travel is 120, so the sheet should show 3,205 for the month. If your grand total disagrees with a manual addition, a date typed as text is the usual culprit; Sheets left-aligns such cells, so look for them.

What does a scanner app add, and where does it stop?

A scanner app gives you a flatter, brighter image than a casual photo and may crop the edges. Most will not fill your sheet for you, and any that reads amounts will need checking, because thermal-paper bills fade and misread digits. Treat scanned text as a suggestion and type the total yourself. Before installing one, check whether it asks for contacts or location it does not need, and whether you can export or delete your files.

When does a sheet stop being enough?

A sheet works for a few dozen bills a month. It gets heavy when you also want to bring in card and bank statements, keep every receipt attached to the matching payment, or see reports without rebuilding formulas. SpendixAI is one option for that stage: you upload statements, review the rows, and receipts are kept with their transactions. It does not read SMS or connect to your bank.

A short weekly routine

  1. Every Sunday, empty your phone gallery of bills into the Drive folder.
  2. Add one row per bill, filling the link as you go.
  3. Check that the month total matches the sum of the rows you can see.
  4. Fix any blank category cells before the week closes.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports