What the IRS says about substantiating travel and meals
IRS Publication 463 describes what to record for travel. In its Table 5-1, the amount is the cost of each separate expense for travel, lodging and meals; the time is the dates you left and returned and the number of days spent on business; the place is the destination or area of travel; and the business purpose is the purpose of the expense or the business benefit gained or expected.
It says you can keep this proof in an account book, diary, log, statement of expense, trip sheets or similar record, and keep documentary evidence to support each element. It says written records are generally required and that a computer-prepared record counts as adequate. For documentary evidence, it says you generally need receipts, canceled checks or bills, with an exception for an expense other than lodging that is less than $75.
This is general information, not tax, legal or financial advice. Substantiation and deduction rules have conditions and change over time, so read the linked IRS publication and ask a qualified tax professional about your situation.
Why a statement line is only part of the picture
Publication 463 says a canceled check by itself does not prove a business expense without other evidence showing a business purpose, and that a canceled check together with the payee bill ordinarily establishes the cost. A card or bank line similarly shows the merchant, date and amount, but says nothing about who you met or why you travelled.
For a business meal, the publication says a restaurant receipt must show the restaurant name and location, the number of people served, and the date and amount. A statement line carries only some of those details.
The publication also says that, generally, you can deduct only 50% of the unreimbursed cost of your meals, including on business travel. Check the current publication for how that applies to you.
Adding the missing details in a spreadsheet
Once statements are converted, each charge is a row. Add columns for the elements the publication describes, and fill them from your calendar, receipts or notes. A synthetic example:
Date Description Amount Trip / Purpose People Receipt
05/04/2026 Example Airlines -420.00 Denver client visit 1 Yes
05/05/2026 Example Hotel Denver -310.00 Denver client visit 1 Yes
05/05/2026 Example Bistro -64.50 Client lunch - proposal 2 Yes
05/06/2026 Example Rail Co -38.00 Denver client visit 1 No (under 75)A pivot table can total the spend per trip, and a filter on the Receipt column shows which rows still need a document. The "under 75" note reflects the exception for expenses other than lodging that Publication 463 describes, but the other elements of the expense still need to be recorded.
Because meals are treated differently from other travel costs in the publication, a separate Category column for meals makes it easier to total them on their own.
Keep the originals
A spreadsheet is a working summary, and a record you build after the fact is only as good as its source. We are not claiming it satisfies any substantiation requirement. Publication 463 has a section on timely kept records and on proving business purpose, so read it and keep the receipts and notes. PDFtoRow can convert statement PDFs to Excel or CSV as a starting point for the log.
Convert Bank Statement PDFs Cleanly with PDFtoRow
Tired of fixing broken columns, corrupted dates, and numbers stored as text? PDFtoRow extracts transaction tables directly from digital PDF vector layers, preserving check numbers and outputting true numeric amounts. Statements up to 5 pages are free once per email every 24 hours. Check the 10-row preview before you download.
Frequently Asked Questions
According to Publication 463 (Table 5-1), the cost of each separate expense, the dates you left and returned and the days spent on business, the destination, and the business purpose or benefit.
Publication 463 says a canceled check by itself does not prove a business expense without other evidence showing a business purpose. A canceled check with the payee bill ordinarily establishes the cost.
The publication says you generally need documentary evidence such as receipts, canceled checks or bills, with an exception for an expense other than lodging that is less than $75. You still need to record the other elements.
Primary Evidence & Official References
- Publication 463, Travel, Gift, and Car Expenses — irs.gov (Verified 2026-10-29). Official source documentation →