# travel expense tracker
## Metadata

- Canonical URL: https://6ducklearn.com/skills/travel-expense-tracker/
- Markdown URL: https://6ducklearn.com/skills/travel-expense-tracker/index.md
- Product: skills
- Category: productivity
- Tags: curated, gemini, google-workspace, admin, travel, sheets, expenses
- Updated: 2026-07-14T03:00:00.357428+00:00
## Summary
Build a business travel expense tracker in Google Sheets — with columns for date, type, vendor, and description
## Content
> **Attribution:** Prepared by 6DuckLearn. Inspired by [Google Workspace with Gemini Prompting Guide 1travel-expense-tracker1 (2travel-expense-tracker25)](https://workspace.google.com).

## 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

| Step | Skill | What it does |
|------|-------|--------------|
| 1 | `gemini-business-travel-itinerary` | Create the hotel-centric day-by-day itinerary |
| 2 → You are here | `gemini-travel-expense-tracker` | Build a matching expense tracker in Sheets |

## Related Skills

- [business travel itinerary](https://6ducklearn.com/skills/business-travel-itinerary/index.md): Create a structured business travel itinerary for an executive — hotel-proximate dining, entertainment, and logistics in table format
- [gemini admin agenda travel planner](https://6ducklearn.com/skills/gemini-admin-agenda-travel-planner/index.md): [DEPRECATED — split into 6 focused skills] See: gemini-team-offsite-agenda, gemini-team-icebreaker-activities, gemini-agenda-table-reformat, gemini-strategic-context-enrichment, gemini-business-travel-itinerary, gemini-travel-expense-tracker
- [agenda table reformat](https://6ducklearn.com/skills/agenda-table-reformat/index.md): Reformat a text agenda into a clean structured table, inserting icebreakers into each day slot
- [strategic context enrichment](https://6ducklearn.com/skills/strategic-context-enrichment/index.md): Enrich agenda sessions with content from @tagged strategy or vision documents using Gemini in Docs
- [team icebreaker activities](https://6ducklearn.com/skills/team-icebreaker-activities/index.md): Generate icebreaker activity ideas for team workshops and offsites — tailored to group size, time limits, and desired outcomes
- [team offsite agenda](https://6ducklearn.com/skills/team-offsite-agenda/index.md): Plan a structured multi-day team offsite agenda — day-by-day activities balancing team bonding and strategic work