Use Google Sheets AI to Track Tour Business Expenses

What This Does

Google Sheets' AI features help you set up a professional expense tracker for your tour business — with automatic category totals, tax-ready summaries, and formula suggestions — without needing to know spreadsheet formulas. One afternoon of setup saves hours at tax time every year.

Before You Start

• You have a Google account and access to Google Sheets (sheets.google.com — free)
• You have a rough sense of your business expense categories (equipment, insurance, platform fees, marketing, transportation)
• You're willing to spend 15 minutes now to save 8+ hours at tax time

Steps

1. Open Google Sheets and start a new spreadsheet

Go to sheets.google.com and click + Blank. Name it "Tour Business Expenses [Year]."

2. Use "Help me create" to generate your tracker structure

Click on an empty cell, then look for the Explore button (bottom right corner of the screen, looks like a sparkle/star icon). Alternatively, type your goal in the search bar that appears in the Explore panel: "Create an expense tracker for a self-employed tour guide with categories for equipment, insurance, platform fees, marketing, and professional development."

The AI suggests a table structure — accept it or use the suggestion as a starting point.

3. Set up your columns manually if needed

If you prefer to build it yourself, create these columns in Row 1:

• A: Date
• B: Description
• C: Category (Equipment / Insurance / Platform Fees / Marketing / Transportation / Professional Development / Other)
• D: Amount
• E: Paid By (Cash / Card / PayPal)
• F: Receipt? (Yes/No)

4. Add a category totals section

Click on a cell below your expense rows. Click the Explore panel (bottom right sparkle). Ask: "Create a formula to sum all expenses in column D where column C equals 'Platform Fees'." It generates a SUMIF formula. Repeat for each category.

5. Add a year-to-date total

In a prominent cell, use the formula Google Sheets suggests when you start typing: =SUM( and select your entire D column. This is your running total for the year.

6. Log expenses weekly, not at year end

Set a reminder on your phone for Sunday evenings: 10 minutes to log that week's receipts. Booking platform invoices, microphone battery replacements, printing costs — all go in. Weekly logging takes 5 minutes. Year-end catch-up takes 8 hours.

Real Example

Scenario: You're a self-employed ghost tour guide in Savannah preparing for April tax filing.

Categories you track:

• Platform fees: Viator/GetYourGuide commissions (downloaded from their dashboards monthly)
• Insurance: NFTGA liability insurance premium
• Equipment: New wireless microphone, audio receiver batteries
• Marketing: Canva Pro subscription, printed business cards
• Professional development: History books, online tour guide courses

At tax time: Your Google Sheet totals each category. You hand these numbers to your accountant or enter them in TurboTax's self-employment section. Zero scrambling.

Tips

• Download your monthly FareHarbor or Peek Pro revenue/commission reports as CSVs and paste them directly into a "Platform Income" tab — the Explore AI can help you build a formula to sum monthly totals
• Take photos of every physical receipt immediately and store them in a Google Drive folder named "Receipts [Year]" — link to these photos in your spreadsheet's notes column
• If Google Sheets' AI formula suggestions don't appear, try typing your goal into the Explore search bar (bottom right of any spreadsheet) — it's the same AI in a different interface

Tool interfaces change — if a button has moved, look for similar AI/magic/smart options in the same menu area.