Build a Receipt Drawer You Can Search
When an expensive appliance breaks, the last thing you want to do is sift through 14,000 unread emails to find the warranty. Here is how to use an AI assistant to build a private, easily searchable index of your most important household purchases in 30 minutes.

The washing machine is making a sound you’d normally associate with a helicopter taking off from the laundry. You definitely remember buying it on sale, but your inbox remembers every sale email ever sent by every shop in the country. Meanwhile, the physical receipt drawer in your kitchen is a graveyard of faded thermal paper and expired supermarket coupons.
When something expensive breaks, you need the proof of purchase immediately. Give yourself 30 minutes this weekend to build a digital receipt drawer you can search straight from your phone. You only need to index five items to make the entire exercise worthwhile.
The Finish Line
A private, dedicated folder of original documents and a small spreadsheet index that takes you from “broken washing machine” to the right warranty evidence in under a minute. No new apps to download, and no need to give a third-party service access to your emails.
- Time: 30 minutes (10 minutes gathering, 5 minutes prompting, 10 minutes filling, 5 minutes testing).
- Cost: Free.
- Prerequisites: Your smartphone, a standard AI chat tool (like ChatGPT, Claude, or Google Gemini), and a basic spreadsheet app (like Google Sheets, Apple Numbers, or Microsoft Excel).
1. Pick the five things you’d hate to replace
Do not attempt to digitise every single receipt you own. Perfection is the enemy of a finished index. Start with the laptop, the e-bike, the washing machine, the heat pump, and whatever cost enough to make you stare hard at the checkout screen before tapping your card. Include a recent expensive repair if it matters more than another gadget.
Find a receipt, order confirmation, or invoice for each of your five items. If you can’t find one in two minutes, mark it as missing in your head and move on. A partially finished index beats having a second chaotic inbox to search.
New Zealand’s official Consumer Protection guide to keeping receipts suggests retaining proof of purchase, warranties, signed contracts, and instruction manuals. These are the documents that matter if something goes wrong and you need a repair, replacement, or refund. They recommend writing down specific details: when you bought it, the retailer's details, how much you paid, and your payment method.
Create a new folder in your preferred cloud storage (iCloud Drive, Google Drive, or OneDrive) and name it Receipt Drawer. If you only have a paper receipt, Consumer Protection advises taking a photo of it and filing it away on your phone. Save these originals in your new folder. Use descriptive, highly searchable filenames, such as washing-machine_receipt_2025.pdf or ebike-invoice-workshop.jpg.
2. Have AI design the drawer (but don't let it look inside)
Why use an AI assistant for a simple spreadsheet? Because formatting headers, deciding on column widths, and figuring out what information to track is tedious enough that most of us just abandon the project. An AI can generate a clean, copyable template in seconds.
However, you must not feed your actual receipts, serial numbers, or home address into a chatbot. The Office of the Privacy Commissioner's guidance on generative AI strongly cautions against entering confidential or personal data into these tools. Generative AI models are trained on vast amounts of information, and there is a real risk that your personal information could be retained or disclosed by the provider to train future models. The Privacy Commissioner suggests an elegant alternative: strip your input data of any information that enables re-identification.
We will do exactly that by giving the AI dummy data. Open your AI assistant and paste this exact prompt:
Design a simple spreadsheet index for five expensive things I own. I am going to copy and paste this into a spreadsheet, so format the output purely as a Markdown table. Do not add any conversational filler.
Use these completely fake examples to fill the first three rows: Laptop from Store A, bought 12 May 2024 for $1200; Washing machine from Store B, receipt missing; Bike repair from Workshop C, invoice saved, cost $400.
Include a header row and columns for: Item, Retailer, Purchase Date, Amount Paid, Payment Method, Proof of Purchase (Filename or Link), and Notes. Leave unknown dates or amounts blank. Do not infer warranty coverage or add extra columns.
3. The Template Output
Your AI assistant will generate a clean text table. Because the Privacy Commissioner also warns that AI tools can produce "confident errors of fact or logic," review the columns to make sure it hasn't hallucinated a bizarre column like "Depreciation Value."
Illustrative Output:
| Item | Retailer | Purchase Date | Amount Paid | Payment Method | Proof of Purchase (Filename/Link) | Notes |
|---|---|---|---|---|---|---|
| Laptop | Store A | 12 May 2024 | $1200 | |||
| Washing machine | Store B | Missing | ||||
| Bike repair | Workshop C | $400 | Invoice saved |
4. Build and fill the actual drawer
Copy the AI's table. Open a fresh spreadsheet on your phone or laptop and paste the table in. If your spreadsheet app puts all the text into a single cell, use the “Paste Special” option and select “Values only,” or try pasting it into a plain text editor first to strip any weird formatting.
Delete the fake rows containing “Store A” and “Store B.” Now, take 10 minutes to fill in the real information for your five chosen items. When you get to the Proof of Purchase column, you have two choices:
- The Link Method: If your spreadsheet and folder are in the same cloud ecosystem (like Google Sheets and Google Drive), right-click the file in your drive, copy the link, and paste it into the spreadsheet cell.
- The Filename Method: If you are saving files locally to your phone, simply type the exact filename (e.g.,
heat-pump-invoice.pdf) into the cell. This way, you can just highlight the text, hit your phone's search bar, and the file will appear instantly.
Keep serial numbers and specific model numbers in the “Notes” column. If you update your contents insurance, this single spreadsheet now contains everything your insurer requires for high-value items.
5. Run the broken-washing-machine test
Close your folder. Close the spreadsheet app. Clear your mind.
Now, pretend your washing machine has just died. Pick up your phone and time yourself. Open your new index spreadsheet. Search for “washing machine.” Check the purchase date to see if you are likely still covered by the warranty, then use the filename or link to open the actual receipt.
Zoom in on the receipt. Check that the seller, the date, and the amount paid are legible. If it is a photo of a thermal receipt taken in terrible kitchen lighting, and you can't read the total, delete it and take a better photo. Stop the timer. If you did this in under 60 seconds, your new system works.
6. Common failures and easy recovery
Even the best household systems occasionally hit a snag. Here is how to keep your index functioning smoothly over time.
- The receipt has already faded to blank white: Thermal paper is notoriously fragile. If the receipt is completely blank, your best recovery option is to log into your internet banking, search the rough date and amount, and screenshot the transaction as your proof of purchase. Next time, take a photo the day the item enters your house.
- Your partner needs access: If you share household administration, do not turn on "anyone with the link can view" access. This is a security risk for a document detailing the most expensive things in your home. Share the folder and spreadsheet explicitly with their specific email address.
- You are tempted to add 50 more items: Stop. The biggest failure point of home inventory systems is administrative burnout. Pin the spreadsheet so it stays at the top of your app. When you buy your next major item (item number six), just open the sheet and add one row. Maintenance takes 30 seconds, provided you don't turn it into a massive weekend chore.
AI disclosure: AI systems assisted with research and writing. Gemini independently peer-reviewed and approved this article before publication. Images, where present, are illustrative AI-generated photographs.