How to Build a Weekly Earnings Spreadsheet (Step-by-Step)

1/6/2025

Earnings Comparison

Many gig workers rely on spreadsheets to track weekly progress.
This guide walks you through building a professional spreadsheet for daily earnings, vendor totals, and week-to-week comparisons.

What You'll Learn

  • How to structure columns
  • Formulas for daily and weekly totals
  • Adding vendor-specific breakdowns
  • Optional charts and visuals
  • Tips for automating calculations

We also show how Gig automatically creates spreadsheets so you don’t have to do the manual work.

Step 1: Structure Your Columns

Start by creating a spreadsheet layout with the essentials:

  • Date
  • Platform (DoorDash, UberEats, Instacart, etc.)
  • Gross earnings
  • Mileage
  • Tips
  • Total hours worked

This creates a clean foundation for all upcoming formulas.

Step 2: Add Formulas for Daily Totals

Use spreadsheet formulas to calculate:

  • Daily gross total
  • Daily net total (after expenses)
  • Earnings per hour
  • Earnings per mile

These formulas help you understand whether a specific day was profitable.

Step 3: Include Vendor-Specific Breakdowns

Create separate sections or tabs to track:

  • Total weekly earnings per platform
  • Average order value
  • Platform efficiency (earnings per hour)
  • Percentage contribution to total income

This lets you easily compare DoorDash vs. UberEats vs. Instacart.

Step 4: Add Optional Charts and Visuals

Charts can help identify patterns:

  • Weekly earnings bars
  • Vendor comparison pie charts
  • Daily mileage trends
  • Hourly profitability

These visuals make long-term tracking easier and more intuitive.

Step 5: Automate Your Calculations

Automation saves time and eliminates mistakes.
You can automate:

  • Weekly totals
  • Vendor contributions
  • Mileage summaries
  • Tax-deductible expense calculations

Tools like Gig already create automated spreadsheets so you can skip the setup entirely (some Gig automated tools are still in alpha stages and may not be available to public).

Building a weekly earnings spreadsheet is one of the simplest ways to track your real profit — and it only takes a few minutes once you know the structure.