Skip to content
The title slide and first slides of the Business Meal Expense Log template

Business Meal Expense Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Minimal
Difficulty
Beginner
Updated
November 15, 2026

Every slide (5)

Overview

Consultants, sales reps, shop owners and anyone who buys lunch for a client use this log to keep meal records in good order. The Meals tab holds one row per meal: date, venue, guests, headcount, purpose, business reason, food, tip, the share you count and the receipt status. The Guests tab lists the people you met and what came of it. The Dashboard counts meals, sums spending and compares each purpose in a column chart.

Fill in a row on the day of the meal, because memory of who came fades fast. A reason like "Renewal talk with the dental practice" is far more useful than "lunch." Mark a share below 100 percent when part of the bill was personal. Clear the red Missing rows once a month so a year-end search for receipts is never needed.

Useful for

  • Show who attended and why for every meal
  • Separate personal and work parts of one bill
  • Chase down missing itemized receipts early

What's included

  • 4 tabs: Dashboard, Meals, Guests, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Meals: a table
  • Guests: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Meals tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What details should I note for a business meal?

Most tax authorities look for the date, place, cost, the people present and the business reason. This log has a column for each, plus the receipt status. Check current IRS rules for exact wording, since they change.

How do I track meals when I travel?

Pick Travel meal as the purpose and name the trip in the reason, such as the city and client visit. Keep the receipt for each meal. A Missing status keeps the row red until you save it.

Can I deduct the full meal amount?

That depends on current IRS rules and the type of meal, so this sheet does not decide it. Enter the share your tax professional advises in the Share counted column and the business part updates for you.

  • #tax-tracker
  • #business-meal-expense-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…