How to scan receipts into a spreadsheet

Every business has a shoebox, a glove compartment, or a camera roll stuffed with receipts that someone meant to deal with later. Later arrives at tax time, all at once, with faded ink. Scanning receipts into a spreadsheet as you go turns that yearly panic into a tidy table you can sort, search, and hand to your accountant. Here is the whole process, from photo to CSV.

Why a spreadsheet beats the shoebox

A photo of a receipt proves you bought something. A row in a spreadsheet tells you what it cost, when, and which job it belonged to. You can total a month of fuel in seconds, filter every expense for one client, and spot the purchase you forgot to claim. Your accountant will also charge you less when the records arrive as clean data instead of a bag of paper. Sorting beats squinting, every time.

The fields worth capturing

Vendor. The shop or supplier name, spelled the way it appears on the receipt.
Date. The purchase date, not the day you finally scanned it.
Line items. What you actually bought. "Office supplies" is weak. "Printer paper, ink cartridge" holds up when someone asks.
Tax. The tax amount on its own line of data. You may be able to claim it back, and you can only claim what you can point to.
Total. The full amount paid, matching the receipt to the cent.
Optional but smart: a category (fuel, meals, materials) and the client or job the expense belongs to. Future you says thanks.

Photo tips so scans read cleanly the first time

Flatten the receipt. Smooth out folds and curls. Hold the corners down or weigh one edge with your mug.
Use plain light. Bright, even light works best. Harsh shadows across the numbers confuse any reader, human or software.
Fill the frame. Get close enough that the receipt takes up most of the photo, and keep the edges visible.
Shoot straight down. Angled shots stretch the text and blur the far end.
One receipt per photo. A pile shot saves ten seconds now and costs ten minutes later.
Scan it the same day. Thermal paper fades fast, and a receipt in a hot car can go blank in weeks.

The two-minute review before you export

Scanning software is quick, and quick work deserves a fast check before the numbers land in your books. Compare the table against the photo, row by row. Check the total first, because a misread digit usually shows up there. Then scan the date (March 3 loves to become March 8), the tax amount, and any line item priced over $100. Fix mistakes in the table, not in the spreadsheet later, so your export stays the single clean copy. Two minutes here saves a confusing afternoon in April.

Getting the CSV into Excel or Google Sheets

Export your receipts as a CSV file. Then bring it into your spreadsheet in about a minute:

Google Sheets: Open a blank sheet. Click File, then Import, then Upload, and pick your CSV. Choose "Replace spreadsheet" or "Insert new sheet", set the separator to comma, and click Import data. Your receipts land as proper rows and columns.
Excel on desktop: Open a blank workbook. Go to the Data tab, click From Text/CSV, pick your file, and press Load. Excel reads the headers and types for you.
Excel the simple way: Double-click the CSV and it opens as a spreadsheet. Fine for a quick look, but save it as an .xlsx file before you add formulas or formatting, or they will vanish when you close it.
After importing: Freeze the top row (View, then Freeze in Sheets) so headers stay put, widen the vendor column, and save a backup copy before you start sorting.

The easier way

The scanning, typing, and checking is the part that piles up until tax season. Receipt Scanner reads your receipt photos and pulls out the vendor, date, line items, tax, and total into a clean table you can download. Snap the receipt, give the table a quick once-over, and get on with your day.