How to Organize Receipts for Your Accountant in Google Sheets
Short answer: the IRS does not make you use a particular system. It says any system works if it clearly shows your income and expenses.1 For a year-end handoff, a single Google Sheet with one row per receipt does that well, as long as each row answers the questions an accountant will ask: who was paid, how much, when, what it was for, and where the receipt is.1
If your receipts live in a shoebox, a camera roll and an email inbox, the cleanup at year-end is the expensive part. This post shows a layout you can start today, based on what IRS guidance says records should show. It is general information, not tax advice; your accountant decides what is deductible and how it is reported.
1. The IRS asks for clarity, not a format
The IRS page on business records says you can use any system suited to your business, as long as it clearly shows income and expenses.1 Publication 583 says the same thing: the law generally does not require a specific type of record, and your records must be available for IRS inspection at all times.2 Electronic systems are allowed, and the same requirements that apply to paper records apply to them.1
What this means for you: the choice of tool is yours. What matters is that anyone who opens the file, you or your accountant, can see what was paid and why without guessing.
2. What each row should show
For supporting documents such as sales slips, paid bills, invoices and receipts, the IRS says they should show the payee, the amount, proof of payment, the date, and a description of the item or service.1 Turn those into columns:
| Column | What goes in it | Why |
|---|---|---|
| Date | The date on the receipt | The IRS lists the date as one of the details to show.1 |
| Vendor | Who you paid | The payee.1 |
| Category | A type from section 3 | Keeps the year sorted by kind of expense.1 |
| Total | The amount you paid | The amount.1 |
| What it was for | A few words about the item or service | The description the IRS lists.1 |
| Receipt photo | A link to the saved photo | So the proof is one click from the row. |
The first five follow the IRS list of details and its advice to sort by type of expense. The last column is a practical suggestion, not an IRS requirement: it saves your accountant from asking you to dig out the original.
If your receipts are still photos on your phone, how to scan receipts into Google Sheets on iPhone covers three ways to get them into these columns. For a trip with receipts in more than one currency, see how to track travel expenses in multiple currencies.
3. Sort by year and by type
The IRS suggests keeping supporting documents in an orderly way, for example organized by year and by type of income or expense.1 In a sheet, that means one tab (or one file) per tax year, and a Category column that uses a short, fixed list. The IRS record categories that apply to spending are a good starting point (it also lists gross receipts and employment taxes):1
- Purchases: items bought for resale.
- Expenses: business costs other than purchases.
- Travel, gift and transportation: these expenses must be substantiated; the IRS points to Publication 463 for the details.1
- Assets: property used in the business, such as machinery or furniture. The IRS asks you to keep records of the cost, use and disposal.1
Use the same wording every time, so one filter or one formula catches every row of a kind. If a receipt does not fit, write "Ask accountant" in the Category column instead of guessing, and decide together later. For a longer category list based on the expense lines of Schedule C, see Schedule C expense categories for freelancers.
4. A bank statement shows you paid, not what you bought
It is tempting to hand over bank statements and call it done. Publication 583 says that if you lack a canceled check, certain account statements can prove payment when they show the check number, amount, payee and posting date, or the equivalent details for electronic transfers and credit cards. It also says that proof of payment alone does not establish a deduction, so you should keep the supporting documents too, such as invoices.2
What this means for you: the statement and the receipt do different jobs. Keep both, and let the sheet link each row to the receipt.
5. Before you hand it over: a checklist
- Sort by date, then look for gaps: a month with no rows is worth a second look.
- Fill the blanks. Every row should have a vendor, a total and a category, even if the category is "Ask accountant".
- Total each category. With Category in column D and Total in column C,
=SUMIF(D:D, "Expenses", C:C)adds up every row whose category is Expenses.3 Repeat it for each category and compare the result to your records. - Share the right way. In Google Drive you can share a file with a specific person and choose Viewer, Commenter or Editor. A Viewer can open the file but not comment or edit; a Commenter can comment but not edit.4 Commenter is a reasonable choice if your accountant only needs to ask questions.
- Keep the paper originals until your electronic system is proven. Publication 583 says original paper records may be destroyed only after the electronic system has been tested and procedures ensure it keeps meeting the requirements.2 How long to keep records is covered in what to keep from your receipts when you are self-employed.
Where Slipmo fits
The slow part of this system is typing: one row per receipt, all year. Slipmo is a phone app that does that step. You photograph a receipt, and it reads the vendor, date and total and adds them as a new row in a Google Sheet you already keep, matching your sheet's own column headers, such as Date, Vendor, Category and Total.5 AI fills in the fields for you to check before the row is added.5 If you want, it can also keep a copy of each receipt photo in your own Google Drive, linked from its row, which is the "Receipt photo" column from section 2.5 It only gets access to the files you choose, and it is free for 3 scans a day, up to 10 a month.5
You still decide the category and the business reason, and your accountant decides what the numbers mean for your return. Slipmo's part is narrower: it takes the typing out of "one row per receipt".
More from Slipmo: Scanning receipts into Google Sheets on an iPhone and Tracking travel expenses in several currencies, all in the guides. To see how it works, visit the Slipmo home page.
Google Sheets and Google Drive are trademarks of Google LLC. Slipmo is not affiliated with or endorsed by Google. This article is general information about IRS guidance as published on IRS.gov and is not tax or legal advice.
References
- Internal Revenue Service. "What kind of records should I keep." IRS.gov, Small Businesses & Self-Employed (page last reviewed 2026-08-03). https://www.irs.gov/businesses/small-businesses-self-employed/what-kind-of-records-should-i-keep (accessed 2026-11-18). ↩
- Internal Revenue Service. Publication 583, Starting a Business and Keeping Records (rev. 12/2024), "Recordkeeping": why keep records, electronic records, supporting documents. https://www.irs.gov/publications/p583 (accessed 2026-11-18). ↩
- Google. "SUMIF." Google Docs Editors Help. https://support.google.com/docs/answer/3093583 (accessed 2026-11-18). ↩
- Google. "Share files from Google Drive." Google Docs Editors Help. https://support.google.com/docs/answer/2494822 (accessed 2026-11-18). ↩
- Slipmo. "How it works," "One app for every kind of spending," and FAQ. https://www.slipmo.com/ (accessed 2026-11-18). ↩