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

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

Eight templates, one click each.

Expense Report — the standard preview
Expense Report — the standard
One row per expense with the category dropdown; subtotal, advance, and reimbursement compute in your Drive.
Travel — day-by-category grid preview
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 — with category summary preview
Monthly — with category summary
The SUMIF category breakdown updates live — share one copy with the bookkeeper and both see the same totals.
Mileage Log — IRS rate math preview
Mileage Log — IRS rate math
Log trips from the driver's seat; odometer readings become miles and reimbursement automatically.
Reimbursement Form — compact preview
Reimbursement Form — compact
Fill it in Sheets, download as PDF, and email the request with receipts attached.
Petty Cash — running balance preview
Petty Cash — running balance
Log the box from any device — the balance and the over/short check live in your Drive.
Annual — 12-month grid preview
Annual — 12-month grid
The year grid as a shareable Sheet — hand your preparer a link instead of a binder.
Credit Card — statement check preview
Credit Card — statement check
Reconcile the statement from anywhere; the difference line reads $0.00 when you're done.
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 eight 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
Month-end sharing
Monthly Expense Report
The per-person monthly standard with the live category summary.
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 August 2026