Apollo's Templates
HomeBusinessExpense Report TemplatesGoogle Sheets
Straight to your Drive

11 Google Sheets Expense Report Templates

Every expense sheet in the library as a make-a-copy Google Sheets link — the version for people whose receipts arrive when they're nowhere near a desk. One click puts a private copy in your Drive with the totals, category dropdowns, and reimbursement math verified working after conversion. Log the expense from your phone while the receipt is still in your hand; the arithmetic keeps itself.

The Sheets fleet

Eleven templates, one click each.

Standard expense report sheet with date, description, category, and amount columns, a cash-advance line, and approval signatures

Expense Report — the standard

One row per expense with the category dropdown; subtotal, advance, and reimbursement compute in your Drive.
Travel expense report with day rows and columns for airfare, lodging, meals, and mileage totaling by category

Travel — day-by-category grid

Fill the day rows from your phone as the trip happens — the sheet dates them from your trip dates.
Monthly expense report with 31 dated rows and a category summary block that totals the month

Monthly — with category summary

The SUMIF category breakdown updates live — share one copy with the bookkeeper and both see the same totals.
Expense tracker with a running spending log, payment-method column, and self-keeping category and monthly summary blocks

Tracker — running log

The phone-first sheet: log spending as it happens; category and month totals keep themselves.
Mileage log with odometer start and end readings, computed miles, and reimbursement at the IRS standard rate

Mileage Log — IRS rate math

Log trips from the driver's seat; odometer readings become miles and reimbursement automatically.
Compact expense reimbursement form listing out-of-pocket purchases with receipt checkboxes and an approval block

Reimbursement Form — compact

Fill it in Sheets, download as PDF, and email the request with receipts attached.
Petty cash log with money-in and money-out columns, a running balance, and an over-short reconciliation block

Petty Cash — running balance

Log the box from any device — the balance and the over/short check live in your Drive.
Annual expense summary grid with twelve month columns by category and quarter and year totals

Annual — 12-month grid

The year grid as a shareable Sheet — hand your preparer a link instead of a binder.
Credit card expense report matching statement lines with business and personal columns and a reconciliation total

Credit Card — statement check

Reconcile the statement from anywhere; the difference line reads $0.00 when you're done.
Simple four-column expense sheet with date, description, category, and amount rows and a single total

Simple — four columns, one total

The shortest sheet in the library, editable from a phone in about thirty seconds.
Nonprofit expense report tagging each expense to a program or fund with a by-program summary

Nonprofit — by program or fund

Share one copy with the treasurer; program totals and volunteer mileage compute live.
The copy flow

Three clicks, start to spreadsheet.

  1. Click “Open in Google Sheets” on any card — Google shows the template with a Make a copy button.
  2. Copy it — the new sheet lands in your Drive, private to you, formulas and dropdowns intact.
  3. Rename it for the period (“August expenses”) and share it with your approver when it’s ready.
The desktop twin
Excel Expense Templates
The same ten sheets as .xlsx downloads — no Google account involved.
Open →
Log miles from the car
Mileage Log
The Sheets copy is the natural glovebox — odometer in, reimbursement out.
Open →
Documents, not calculators
Google Docs Expense Templates
When the report needs to be a branded, printable document rather than a spreadsheet.
Open →

Frequently asked questions

What happens when I click “Open in Google Sheets”?
Google shows a “Make a copy” page for the template; click the button and a full copy — formulas, dropdowns, formatting — lands in your own Drive, named and editable like any spreadsheet you created. Nothing is shared back to us: the master is read-only to you, your copy is private to you, and we can't see it. You'll need to be signed in to a Google account, which is Google's requirement for copying, not ours.
Do the formulas and dropdowns really survive the conversion?
Yes — verified, not assumed. Our build process uploads sample-filled copies of each sheet and reads the computed results back out of Google Sheets: the standard report's subtotal-minus-advance, the travel sheet's day and category totals, the monthly SUMIF breakdown, the mileage rate multiplication. All of it matches the Excel originals to the penny. The category dropdowns convert to native Sheets data validation and keep working too.
Why use the Sheets version instead of the Excel download?
Phones, mostly. Expenses happen away from desks — the taxi receipt, the parking garage, the client lunch — and a Sheets copy is editable from the Google Sheets app wherever the receipt is handed to you. Sharing is the other reason: give the bookkeeper view access to your copy and month-end becomes a link, not an attachment. If your books live in Excel on one machine, the .xlsx is the same sheet without the account requirement.
Can I share one sheet with my whole team?
Share copies deliberately: the clean pattern is one copy per person per period (“Kim — August expenses”), shared to the approver with edit or comment access. A single communal sheet that everyone types into becomes an attribution puzzle — whose lunch was row 14? For a team, make the monthly sheet your per-person standard and have the bookkeeper collect the links in a folder. Drive's version history then serves as your audit trail for free.
Updated through September 2026