First page of the Business Expense Tracker for Tax DeductionsExcel workbook preview

IRS records and US tax

Business Expense Tracker for Tax Deductions

Business expense spreadsheet for tax deductions: Schedule C line mapping, 50% meals and gift limits, receipt checks from Pub 463 and a dated mileage log.

Excel workbook · 22 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

A business expense spreadsheet for tax deductions keeps every business cost in one place with the information a preparer or the IRS needs: the date, payee, business purpose, the return line it belongs on and proof that it happened. It is usually asked for at year end by the tax preparer, and it is usually rebuilt from bank statements because receipts and purposes were never recorded.

The workbook maps 27 expense categories to the lines of Schedule C, applies the deductible share from IRS Publication 463 (50% for business meals, nothing for entertainment, a per-recipient cap for gifts) and checks each row against the record rules in that publication. A mileage log applies the IRS standard mileage rate for the date of each trip, and a summary totals everything by category and by month.

Who it is for

The sole proprietor or bookkeeper who has to hand the preparer a clean list of deductible expenses with receipts for the year.

What is inside

  • Expenses sheet with 13 worked rows and 20 blank rows, mapped to Schedule C (2026) lines
  • 27 categories with deductible shares: 50% for business meals, 0% for entertainment, a per-recipient cap for gifts
  • Record rule and flag per row from Pub 463: lodging receipts, the USD 75 receipt threshold, missing receipts
  • Mileage log with 8 trips that applies 72.5 or 76 cents per mile by trip date (IRS 2026 rates)
  • Settings sheet with each rate and limit and its IRS source
  • Summary by category, by month and a count of rows that need attention
  • Business use % column for mixed-use items

How to use it

Check the rates on the Settings sheet, then log each expense with a category and its business purpose.

Files

  • XLSXbusiness-expense-tracker-for-tax-deductions.xlsx22 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.

Questions about this template

How much of a business meal can I deduct?

Publication 463 says you can generally deduct 50% of the cost of business meals if you or your employee are present and the food and beverages are not lavish or extravagant. Entertainment is not deductible. The tracker applies the 50% share to the Business meals category.

Do I need a receipt for every business expense?

Publication 463 says documentary evidence such as a receipt is not needed for travel, gift or transportation expenses under USD 75, other than lodging, though you still need a record of the amount, time, place and business purpose. Lodging always needs a receipt. For other expenses, keep the receipt.

Which mileage rate does the tracker use for 2026?

The IRS set the 2026 business standard mileage rate at 72.5 cents a mile for 1 January to 30 June and 76 cents a mile from 1 July to 31 December. The Settings sheet holds both rates and the change date, and each trip uses the rate for its date.