How to Create a Professional Expense Report for Your Accountant

Accountants charge by the hour. The more organized your expense records are when you hand them over, the less time your accountant spends deciphering and organizing them — and the lower your bill. A well-prepared expense report can easily save you $200–$500 in accounting fees at tax time.

Here’s exactly what accountants need, what common mistakes cost you money, and how to prepare expense records that a professional can use without reformatting.

What accountants actually need

A good expense report for an accountant contains the following information for each expense:

Column	Why it matters
Date	Ties the expense to the correct tax year and period
Merchant / Supplier	Identifies who was paid; needed for any CRA review
Category	Determines which line item it goes on in your return (T2125 or T2)
Net Amount (before tax)	The deductible expense amount; separating it from tax is essential for GST/HST filers
Tax 1 Name & Amount	GST/HST or TPS — used to calculate Input Tax Credits
Tax 2 Name & Amount	PST/TVQ where applicable
Total	Cross-check against bank/credit card statement
Payment Method	Helps reconcile against bank statements
Notes	Business purpose, especially for meals and travel

The most important column: separating net from tax

Many people hand their accountant a single “total amount” column. This creates extra work if you’re registered for GST/HST, because your accountant needs to back-calculate the net and tax amounts to prepare your GST return and calculate your Input Tax Credits.

The simplest thing you can do to make your accountant’s job easier: always record the net amount (before tax) and the tax amount(s) in separate columns. This information is printed on every receipt — you just need to capture it.

Categories: use consistent labels

Whatever categories you use, be consistent. Mixing “Meals”, “Dining”, “Restaurant”, and “Client Meal” for the same type of expense creates extra work. Pick a category list at the start of the year and stick to it.

Recommended categories aligned with CRA’s T2125:

Advertising
Meals & Entertainment (note: 50% deductible)
Office Supplies
Professional Services
Rent
Transportation & Travel
Utilities
Other

When you use receipts2excel.ca, the Excel output includes a built-in dropdown with these categories. You can assign each expense in the spreadsheet before sending it to your accountant.

Formatting that accountants can actually use

An accountant-friendly expense spreadsheet:

One row per transaction — not one row per category totals
Clear column headers in row 1 — no merged cells in the header
Dates in a consistent format — YYYY-MM-DD or DD/MM/YYYY, not mixed
Numbers as numbers — don’t type “$45.00” as text; let Excel format it
No totals mixed into the data rows — put summary totals on a separate sheet
Currency consistent — note any foreign currency transactions with the exchange rate

Avoid: colour-coded rows to indicate categories (colours don’t survive export), merged cells anywhere in the data, notes embedded in cells alongside numbers.

Provide the receipts too

The spreadsheet organizes the data. The receipts are the supporting documentation. Ideally provide both:

The Excel expense report
A folder of receipt images (digital photos or PDFs), numbered or named to match the Receipt Ref column in your spreadsheet

If you’re submitting electronically (email or a shared drive), organize receipt images by month or category.

Notes column: often overlooked, sometimes critical

For most routine expenses (office supplies, a software subscription), a notes column isn’t necessary. But for certain categories, it’s essential:

Meals and entertainment: Note who attended and the business purpose (“Client dinner — pitch meeting with Acme Corp”)
Travel: Note the business purpose of the trip
Ambiguous purchases: Home office equipment, tools that could be personal or business, etc.

The CRA expects you to be able to explain the business purpose of claimed expenses. A brief note in your spreadsheet is the simplest way to capture this at the time of the purchase, before you forget.

Common mistakes that increase your accounting bill

Handing over raw receipts in a folder with no spreadsheet — your accountant then has to manually enter each one
Inconsistent date formats — your accountant spends time normalizing them
Mixing currencies without noting exchange rates
Only recording totals (no net/tax split) when you’re a GST/HST registrant
Blurry or incomplete receipt photos that your accountant can’t read
Sending partial records — missing a full quarter forces your accountant to reconcile gaps

When to hand off your expense report

Most accountants appreciate receiving annual expense reports in January or February, before the tax-season rush. If you file quarterly GST/HST returns, you may want to provide a quarterly summary as well. Ask your accountant what format and timing works best for them — some prefer monthly batches, others prefer one annual package.

Putting it all together

A good expense report takes 10–15 minutes to create per month if you’ve been capturing receipts consistently. At year end, it’s a matter of compiling the monthly summaries and handing them over.

If you have a backlog of receipt photos to process, receipts2excel.ca can help: upload your photos, and the tool extracts all the relevant data (date, merchant, net amount, tax lines, payment method) into a formatted, two-sheet Excel file. Add your expense categories, attach your receipt images, and you have a package your accountant can use immediately — without reformatting.