Receipts in a spreadsheet work best with a Drive folder for each month, a consistent file name, and a link column in the sheet that opens the file. That holds up for a few dozen receipts a month. It starts failing when uploads are missed, files cannot be searched by amount, or the person holding the phone is not the person holding the sheet.
How should you organise the folders?
Use the Indian financial year as the top level, because that is how bills, warranties and your CA will think about them. One folder per month inside it keeps each folder short enough to scan.
- Receipts 2026-27
- Receipts 2026-27 / 04 Apr
- Receipts 2026-27 / 05 May
- Receipts 2026-27 / Warranty and big purchases
A separate folder for warranty items, such as a washing machine or phone, is worth it. You will look for those bills two years later, long after the monthly folders stop mattering.
What file naming scheme works?
Name the file the way you would search for it: date first, merchant, what it was, amount. For example 2026-04-12 Croma laptop bag 1499. Starting with the date in year-month-day order keeps files sorted by time, and including the amount means the Drive search box can find a bill from a number on your bank statement. Rename the photo straight after you take it, because a file named IMG_4821 is nearly useless in six months.
How do you link a receipt to a sheet row?
- Add a column called Receipt next to Amount.
- Upload the photo or PDF to the right month folder.
- Right-click the file and copy its link, then paste it into the Receipt cell for that expense. In Excel and Google Sheets you can also press Ctrl+K on a cell to insert a link and show text such as View.
- If you keep the link in one column and want a clickable label in another, use =HYPERLINK(H2,"View") where H2 holds the link.
Links to files that stay inside the same cloud drive generally keep working if you move the file within that drive, but links to a file on your computer's own folder break when the folder moves. Test one link after you reorganise.
Where does this method fall over?
- Missed uploads. A receipt arrives on WhatsApp or email, you mean to file it later, and later never comes.
- Two steps for one expense. You must record the row and then also file the receipt, and nothing connects them if one half is forgotten.
- Weak search. You can search file names, but you cannot ask for every receipt in a category, or every one above a certain amount, without extra formulas.
- Sharing risk. A folder shared with a family member for convenience can stay open long after it should be closed.
- Paper receipts. Thermal paper fades, so photograph a till slip the same day.
To find expenses that have no receipt, count rows above a limit you set and with an empty link cell. If amounts are in column D and links in column H: =COUNTIFS($D$2:$D$500,">=500",$H$2:$H$500,""). A number above zero tells you how many bills to chase. To show which ones, add a helper column with =IF(AND(D2>=500,H2=""),"Need receipt","") and filter on it.
How does this compare with attaching a receipt in an app?
In an app, the receipt belongs to the transaction itself, so the question of whether a link is current does not arise and there is no separate folder to maintain. SpendixAI keeps receipts with their transactions, so opening an expense shows the bill beside it. That removes the double step, though you still need to take the photo. It will not recover bills you never captured, and the sheet-and-Drive method can be perfectly fine if your volumes are small.
A monthly receipt check
- Run the missing-receipt formula for the month.
- Chase or photograph the big ones first.
- Move warranty bills into their own folder.
- Check that each folder's sharing setting is still what you intended.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

