Spreadsheets

Link receipt photos to expense rows with HYPERLINK in Sheets

Use the HYPERLINK formula in Google Sheets to link Drive receipt photos to expense rows, with a date_merchant_amount file name that is easy to search.

Editorial illustration for Link receipt photos to expense rows with HYPERLINK in Sheets

In Google Sheets, =HYPERLINK(url, "view") turns a cell into a clickable link, so each expense row can open its receipt photo in Drive with one tap. Keep all receipts in one Drive folder, paste each file's link into a column, and let a formula show a short label instead of a long address.

The real work is not the formula, it is the habit: a predictable file name so you can find a receipt in seconds when a refund or warranty question comes up months later.

How do I set up the Drive folder and the sheet?

  1. Create one Drive folder, for example Receipts 2026-27, matching the April to March year.
  2. Make columns in your sheet: A Date, B Merchant, C Category, D Amount, E File name, F Receipt link, G Receipt.
  3. Upload each photo or PDF into the folder. On a phone, scanning from the Drive app gives a tidy PDF.
  4. Right-click the file, choose Share, then Copy link. Paste it into column F.
  5. In G2 enter the formula below and fill it down.

The formula: =IF(F2="","missing",HYPERLINK(F2,"view")). Anything with a link shows a clickable view label, and rows without a link say missing, so gaps stand out.

What file name makes receipts easy to find?

Use date, merchant and amount, in that order, joined by underscores: 2026-11-08_Grocer_1250. Starting with the year-month-day form means files sort in date order by themselves. Let the sheet build the name so you never type it twice. In E2:

  • =TEXT(A2,"yyyy-mm-dd")&"_"&SUBSTITUTE(B2," ","")&"_"&D2

Rename the photo to exactly what E2 shows before uploading. When you later search Drive for the date or merchant, the file comes up straight away. The link itself cannot be predicted from the name, because Drive gives each file its own address, so the paste step stays manual.

A few hypothetical rows show how it reads once it is running:

DateMerchantAmount (₹)File name to use
2026-11-08Grocer1,2502026-11-08_Grocer_1250
2026-11-09Pharmacy6402026-11-09_Pharmacy_640
2026-11-12Fuel2,0002026-11-12_Fuel_2000

If two receipts from the same merchant land on the same day for the same amount, add a letter at the end, such as _a and _b, so the names stay unique.

This is worth a minute. A Drive link opens only for people who have access. If the folder is private, the link works for you and for anyone you have added. If you send the sheet to a family member or an accountant, add them to the folder as well, otherwise they will see a request-access page. Think about what a receipt shows: card digits, phone numbers, addresses. Keep the folder restricted and share with named people only.

How do I find rows with no receipt?

A simple count keeps you honest at month end. This counts rows that have an amount but no link:

  • =COUNTIFS($D$2:$D$500,">0",$F$2:$F$500,"")

Add conditional formatting on column G with the custom formula =AND($D2>0,$F2="") to colour those rows. Before you submit a claim to an employer, or when you want a warranty record, filter by that colour and finish the gaps.

Keep the receipt folder for as long as you might need the paperwork: a warranty period, a return window or an employer reimbursement. How long to keep records for income tax purposes is a question for your CA, and the answer is not the same for everyone.

What if the spreadsheet starts to feel heavy?

Links break if a file is moved to another folder you have not shared, and a large sheet with hundreds of links gets slow to scan. SpendixAI keeps receipts with their transactions instead, so a link column is no longer needed. Until then, the HYPERLINK method above works fine for a few hundred rows.

Quick checklist

  • One folder per financial year.
  • File names built by formula, not typed.
  • Link column filled the same day.
  • Folder sharing reviewed once a quarter.
SPENDIXAI JOURNAL

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

Explore your reports