Guides · · Updated

How to Organize Receipts for Your Accountant in Google Sheets

A spreadsheet of receipt rows being handed over in a folder marked with the year

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:

ColumnWhat goes in itWhy
DateThe date on the receiptThe IRS lists the date as one of the details to show.1
VendorWho you paidThe payee.1
CategoryA type from section 3Keeps the year sorted by kind of expense.1
TotalThe amount you paidThe amount.1
What it was forA few words about the item or serviceThe description the IRS lists.1
Receipt photoA link to the saved photoSo 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

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

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.

Download on the App Store Get it on Google Play

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

  1. 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). ↩
  2. 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). ↩
  3. Google. "SUMIF." Google Docs Editors Help. https://support.google.com/docs/answer/3093583 (accessed 2026-11-18). ↩
  4. Google. "Share files from Google Drive." Google Docs Editors Help. https://support.google.com/docs/answer/2494822 (accessed 2026-11-18). ↩
  5. Slipmo. "How it works," "One app for every kind of spending," and FAQ. https://www.slipmo.com/ (accessed 2026-11-18). ↩