How to Scan Receipts Into Excel (and Keep Them Organised)

Receipts are small, numerous and easy to lose, yet they are the evidence behind business expenses, tax deductions and reimbursements. Shoeboxes of fading paper become a problem at tax time or in an audit. Scanning receipts into Excel turns that paper into a searchable, sortable record that you can total, categorise and reconcile.

This guide explains how to scan receipts into Excel step by step: capturing good images, extracting data with OCR or by hand, structuring the spreadsheet, categorising, handling tax, matching to bank transactions, storing images and avoiding common mistakes.

Why scan receipts into Excel?

• Evidence: tax authorities generally expect records supporting deductions; a digital archive is easier to keep and search.
• Totals and reports: Excel can sum expenses by category, month, project or person.
• Reimbursement: employees and owners can claim accurately.
• Reconciliation: matching receipts to bank and card lines proves each payment and flags unsupported ones.
• Durability: thermal receipts fade, sometimes within months; images do not.

Whether a scanned copy can replace the paper original depends on your jurisdiction's rules; many tax authorities accept legible electronic copies, but check guidance where you file.

What you need

Item	Options
Capture device	Phone camera with a scanning app, desktop scanner, multifunction printer
Extraction	Manual entry, Excel's data-from-picture feature where available, receipt OCR apps, expense software
Spreadsheet	Excel or Google Sheets
Storage	Cloud folder with consistent naming, or expense software

Step 1: capture receipts promptly and clearly

The best habit is to capture receipts the same day. Practical tips:

• Flat surface, good light: avoid shadows and glare; daylight or even indoor light works best.
• Contrast: place light receipts on a dark background so the app can detect edges.
• Whole receipt: include the merchant name at the top and the total and payment details at the bottom. Photograph long receipts in sections if needed, or use an app that stitches them.
• Focus: tap to focus and hold steady; blurry digits cause errors.
• Both sides if the back contains information such as returns or tax details.
• Use scanning mode: scanning apps crop, straighten and enhance automatically, producing a cleaner image than a regular photo.

For paper backlogs, a sheet-fed document scanner processes stacks quickly; small receipts may need a carrier sleeve.

Step 2: name and store images consistently

Before or during extraction, save each image with a consistent name, for example:

2026-10-04_OfficeSupplyCo_48.75.jpg

Store them in folders by year and month, or by year only with names that sort by date. The image file name or ID goes in the spreadsheet so every row links to its evidence. See how to organise bank statements for folder structures that work equally well for receipts.

Step 3: set up the spreadsheet

Create a table with these columns:

Column	Example	Notes
Receipt ID	R-2026-0412	Unique reference
Date	2026-10-04	Real date format
Merchant	Office Supply Co	Consistent naming
Description	Printer paper, toner	Brief business purpose
Category	Office supplies	From a fixed list
Net amount	40.63	Before tax
Tax amount	8.12	VAT/GST/sales tax as shown
Total	48.75	As on receipt
Currency	GBP	If you spend in several
Payment method	Business card 1234	Card, cash, personal card
Paid by	J. Smith	For reimbursements
Project/client	Client A	If billable
Image file	2026-10-04_OfficeSupplyCo_48.75.jpg	Link or name
Matched to bank line	Yes	Reconciliation status

Tips:

• Format as an Excel Table (Ctrl+T) so formulas and formats extend automatically.
• Data validation for Category, Payment method and Currency, using dropdown lists, keeps values consistent.
• Formula check: add a column =ROUND(F2+G2-H2,2) that should be zero; non-zero flags typos in net, tax or total.
• Hyperlinks: use =HYPERLINK("path/or/url","View") to open the image from the row.

Step 4: extract the data

Option A: manual entry

For a handful of receipts a month, typing is fine. Enter from the image, not memory, and use the check column.

Option B: Excel's picture-to-data feature

Some versions of Excel can insert data from a picture, converting a photo of a table into cells. It works best on tabular content; receipts vary, so results need checking. Availability depends on your Excel version and platform.

Option C: receipt scanning apps

Many apps use OCR and AI to extract merchant, date, total and tax, then export CSV or Excel. Compare:

• Accuracy on your receipts, especially totals and dates.
• Export format and column control.
• Handling of currencies and tax.
• Price per receipt or subscription.
• Data privacy and retention terms.

Background on how this works: what is OCR.

Option D: expense management software

For teams, expense software combines capture, extraction, approval policies, reimbursement and accounting sync. It is more than Excel, but many businesses still export to Excel for analysis.

Checking extracted data

Always verify:

• Total: OCR may pick a subtotal, a tip line or the "change" line instead.
• Date: day/month order varies by country; receipts may show multiple dates.
• Tax: some receipts show several rates; capture each if you reclaim tax.
• Merchant: the legal name may differ from the brand; choose one consistent name.
• Currency: foreign receipts need currency recorded and conversion handled.

Step 5: categorise consistently

Use a fixed list of categories aligned with your chart of accounts or tax form. Common examples:

• Advertising and marketing
• Meals (often with special tax rules)
• Travel
• Vehicle and fuel
• Office supplies
• Software and subscriptions
• Professional fees
• Equipment
• Telephone and internet
• Training

Record a business purpose for meals, travel and entertainment, since tax rules often require it. For deeper guidance see how to categorise business expenses.

Step 6: match receipts to bank and card transactions

A receipt proves what was bought; the bank or card statement proves payment. Matching both:

1. Export or convert bank and card statements to Excel. StatementPilot converts statement PDFs with the bank statement to Excel converter and the credit card statement converter.
2. Add a matching key: date plus amount usually works.
3. Use XLOOKUP or COUNTIFS to find each receipt's matching transaction.
4. Mark matched rows on both sheets.
5. Review leftovers:
   • Transactions with no receipt: find the receipt, get a duplicate invoice from the merchant, or document the expense.
   • Receipts with no transaction: cash purchases, personal card spending to reimburse, or duplicates.

Example formula on the receipts sheet, assuming the bank sheet has dates in column A and amounts in column C:

=IF(COUNTIFS(Bank!A:A,B2,Bank!C:C,-H2)>0,"Matched","Check")

Allow for dates differing by a day or two between purchase and posting; a tolerance window using COUNTIFS with date ranges handles that.

Worked example

In October, a sole trader has 42 business card transactions and 39 receipts. Matching finds 37 pairs. Two receipts were paid in cash. Five card transactions lack receipts: three are online subscriptions whose invoices are downloadable from the vendor portals, one is a parking charge with an emailed receipt, and one is a personal purchase made on the business card by mistake, which is recorded as a drawing. After follow-up, every business transaction is supported.

Step 7: summarise and report

Once data is clean, a PivotTable gives totals by category and month. Useful views:

• Expenses by category per month.
• Tax reclaimable per quarter.
• Reimbursements due per person.
• Billable expenses by client or project.

Check totals against the bank and card statements and your accounting system.

Choosing a capture method by volume

Monthly receipts	Suggested approach
Under 20	Phone scanning app plus manual entry into Excel
20 to 100	Receipt OCR app exporting CSV, checked and pasted into the workbook
100 to 500	Expense software with approvals, exporting to Excel for analysis
Over 500 or many employees	Expense management integrated with accounting and corporate cards

The right point to move from Excel to dedicated software is usually when approvals, reimbursements and policy enforcement, rather than typing, become the bottleneck.

Reimbursements for employees and owners

When people pay for business expenses personally, the receipt log becomes the basis for reimbursement:

1. Each person submits receipts with a business purpose.
2. Someone other than the claimant reviews and approves the claim against policy.
3. Approved amounts are totalled per person with SUMIFS on the "Paid by" column.
4. Reimbursements are paid by bank transfer and recorded as matched to the claim.
5. The receipts remain linked to the expense in the books.

Keep personal card statements out of business records; only the receipts and reimbursement payments are needed. For owners of small companies, consistent reimbursement records also make it much clearer which costs belong to the business.

Using receipts for sales tax and VAT

If you reclaim VAT, GST or similar taxes, the receipt usually needs to meet specific requirements, such as showing the supplier's tax registration number and the tax amount; simplified receipts below certain thresholds may be allowed. Requirements vary by country, so check your tax authority's rules. In the spreadsheet, record tax separately by rate, and flag receipts that do not meet the requirements so you do not reclaim tax on them in error.

Handling special cases

Long receipts

Capture in sections or use stitching; record only the total and tax, unless line detail matters.

Faded receipts

Scan immediately; adjust contrast in the scanning app; if illegible, obtain a duplicate from the merchant or rely on supporting records such as card statements plus a note.

Foreign currency

Record the original currency and amount, the converted amount and the rate source. Card statements show the converted amount actually charged, including fees.

Split business and personal purchases

Record only the business portion, noting the split, or record the full amount and the personal portion separately.

Digital receipts

Emailed and in-app receipts can be saved as PDF into the same folder structure, with the same naming.

Refunds and returns

Record refunds as negative rows linked to the original receipt, and match them to the credit on the card or bank statement.

Building a monthly receipt routine

A simple routine prevents backlogs. A workable monthly cycle for a freelancer or small business:

Daily or after each purchase (one minute)

• Photograph the receipt with the scanning app.
• Save digital receipts from email into the receipts folder.
• Put the paper receipt in a single tray or envelope for the month.

Weekly (fifteen minutes)

• Extract data from the week's images into the spreadsheet.
• Check totals, dates and tax against the images.
• Assign categories and business purposes while you still remember them.
• Note any receipts you know are missing.

Monthly (thirty to sixty minutes)

• Download or convert the month's bank and card statements.
• Run the matching formulas and review unmatched items.
• Chase missing receipts from suppliers or online accounts.
• Record reimbursements due and personal items charged to business cards.
• Build the monthly summary and check it against your accounting system.
• Back up the spreadsheet and image folder.

Quarterly and year-end

• Total reclaimable tax for returns where applicable.
• Review categories for consistency.
• Archive the period's files in read-only form.
• Pass a clean file to your accountant along with the matched statements.

The monthly step fits naturally into a broader close; see the month-end close checklist.

Designing the workbook

A workbook with several sheets keeps things tidy:

Sheet	Purpose
Receipts	One row per receipt, as described above
Bank	Converted bank statement transactions
Card	Converted card statement transactions
Lists	Categories, payment methods, currencies and people for dropdowns
Summary	PivotTables and charts
Notes	Explanations of unusual items, rates used and decisions

Use the same date format and sign convention on the Bank and Card sheets. A common approach is negative numbers for money out, which is why the matching formula compares against the negative receipt total. Freeze the header row, turn on filters and avoid merged cells, which break sorting and formulas.

Useful formulas

• Month column: =TEXT(B2,"yyyy-mm") for grouping.
• Missing receipt flag on the Bank sheet: =IF(COUNTIFS(Receipts!B:B,A2,Receipts!H:H,-C2)=0,"No receipt","").
• Duplicate check: =COUNTIFS(B:B,B2,C:C,C2,H:H,H2)>1 flags rows with the same date, merchant and total.
• Category total: =SUMIFS(H:H,E:E,"Travel").

Privacy and security of receipt data

Receipts can reveal card digits, addresses, travel patterns and purchases. Store images in an access-controlled folder, avoid sharing full workbooks unnecessarily, and check the data handling terms of any app that processes receipts in the cloud. Delete images you no longer need once retention periods end.

Common mistakes

1. Waiting until year-end: receipts fade or get lost.
2. Inconsistent merchant names: makes analysis and matching harder.
3. Text dates and numbers: imported values left as text break formulas.
4. No image reference: the spreadsheet loses its evidence.
5. Double-counting: recording an expense from both the receipt and the invoice.
6. Ignoring tax detail: losing reclaimable tax or misstating it.
7. No backup: a single laptop folder is a single point of failure.

How long to keep receipts

Retention requirements vary. In many countries, tax records must be kept for several years after the relevant tax year, and longer in some situations. Check your tax authority's guidance, and see how long to keep bank statements for a broader discussion of retention periods.

Excel vs dedicated software

	Excel	Receipt/expense software
Cost	Usually already owned	Subscription
Setup	You design it	Ready-made
Capture	Separate app	Integrated
Extraction	Manual or separate OCR	Built-in
Approvals	Manual	Built-in
Accounting sync	Import manually	Often direct
Flexibility	High	Moderate
Best for	Freelancers, small volumes, analysis	Teams, higher volume

Frequently asked questions

Can Excel scan receipts directly?

Some versions of Excel can convert a picture of a table into cells, but receipts vary in layout, so results need checking. Most people use a scanning or receipt app to extract data and then import the CSV or Excel file.

What is the best way to photograph receipts?

Use a scanning app on a flat, dark background with even light, capture the whole receipt including merchant and total, and check the image is sharp before discarding the paper.

Are scanned receipts accepted by tax authorities?

Many tax authorities accept legible electronic copies of receipts, but rules vary by country and situation. Check the official guidance where you file before discarding paper originals.

How do I match receipts to my bank statement?

Convert the statement to Excel, then match receipts by date and amount using COUNTIFS or XLOOKUP, allowing a few days' tolerance for posting. Review unmatched items on both sides.

What columns should a receipt spreadsheet have?

At least a unique ID, date, merchant, description, category, net amount, tax, total, payment method and image reference, plus a matched status for reconciliation.

How often should I scan receipts?

Ideally the same day you receive them, with a weekly session to extract and check data. Daily capture prevents fading and loss; weekly extraction keeps the work small and lets you remember the business purpose.

Should I keep the paper receipts after scanning?

That depends on your tax authority's rules and your own risk tolerance. Many people keep paper originals for a period, such as until the relevant tax return is filed and reviewed, before discarding them, but check official guidance first.

Summary

Scanning receipts into Excel works when you capture promptly, store images consistently, extract data carefully, categorise from a fixed list and match every receipt to the bank or card line that paid it. The result is a complete, searchable expense record ready for tax time and audits.

Try StatementPilot to convert bank and card statements into Excel so matching receipts takes minutes instead of hours.