travel expense tracker

Attribution: Prepared by 6DuckLearn. Inspired by Google Workspace with Gemini Prompting Guide 1travel-expense-tracker1 (2travel-expense-tracker25).

When to use this

You need a reusable, structured spreadsheet to track business travel expenses — either to set up before a trip or to help someone else log their costs systematically. This is a Gemini in Sheets step.

What you'll get

A Google Sheets template with properly labelled columns, ready to fill in — covering date, expense category, vendor name, and description. Optionally includes running totals and per-category summaries.

Prompt template

Use this in Gemini in Sheets (open a new Google Sheet, then open the Gemini sidebar):

Create a budget tracker for business travel. It should include columns for: date, expense type (meal, entertainment, transportation), vendor name, and a description.

For a more complete tracker:

Create a business travel expense tracker with columns for: date, expense type (meal, entertainment, transportation, accommodation, other), vendor name, amount (HKD), receipt attached (yes/no), and notes. Add a summary row at the bottom that totals by expense type. Include a header row with column labels.

Customisation tips

• Multi-currency: "Add a currency column and a converted amount column in [HKD / USD / EUR]"
• Per-person tracking: "This is for a team of 3 — add a 'person' column"
• Policy compliance: "Add a column for 'within policy limit (yes/no)' with a note column for exceptions"
• Trip-specific tabs: "Create separate tabs for each day of the trip"
• Auto-calculation: "Add a formula in the total column that sums all amounts" — Gemini can write basic Sheets formulas

Iteration suggestions

After generating the tracker:

1. Populate from itinerary — if you used gemini-business-travel-itinerary, paste the planned meals/activities as pre-filled rows to give an estimated budget before the trip
2. Add approval workflow: "Add a column for manager approval status with values: pending / approved / rejected"
3. Export/share: Share the Sheet with the traveller before the trip so they can log in real-time
4. Post-trip analysis: "Summarise total spend by category from this sheet" — paste the filled data back to Gemini for a spend breakdown

Related skills in this workflow