Gig Worker Income and Expense Excel - Free Template

1. Start on Transactions and enter each gig payment or expense on its own row. Use the date, platform or client, type, category, and amount fields exactly as shown.
2. Record mileage, hours, and rate whenever the job uses your car or paid time. A week of 4 delivery shifts at 120 miles each already gives you 480 miles to compare against your fuel and maintenance costs.
3. Mark Receipt Status and Tax Deductible? as you go. Do not leave those to year-end, because a $55 fuel fill-up is easy to lose once it disappears into a card statement.
4. Review the Summary Dashboard after each payout or at week-end. Check whether gross income, fees, and net amount match what your platform paid you.
5. Use Expense Categories to keep coding consistent. If one month you call something Fuel and the next month Gas, your totals will drift and your SUM summaries will be less reliable.
6. Follow the Instructions tab whenever you hand the file to a spouse, assistant, or bookkeeper. That keeps entry consistent even if somebody else fills in the workbook.

This workbook fits the person who gets paid in pieces: a rideshare driver with 40 trips this week, a delivery courier with $1,250 of app payouts, or a handyman who invoices three clients and buys supplies on the road. It also fits the sole proprietor who files Schedule C and wants a clean count of income, fuel, supplies, and platform fees before quarter-end.

Image 1: The Transactions Tab

Image 1 shows why this format works in real life. You can enter one row for a 5.5-hour Uber shift in Austin, another for a DoorDash weekend run in Denver, and another for a $55.40 fuel fill-up, then see the business pattern instead of a pile of card swipes.

When The Dashboard Helps Most

The Summary Dashboard matters when you are trying to answer a simple question: did the week actually make money after fees, gas, and supplies? If a driver grosses $2,400 in a month and spends $410 on fuel, $120 on platform fees, and $85 on supplies, the dashboard shows the real margin instead of the headline payout.

Why The Category Sheet Matters

The Expense Categories tab keeps you from creating six spellings of the same cost. That matters when you hand the file to a bookkeeper at an LLC, a spouse helping with records, or a contractor who wants the year clean before filing season.

The IRS expects you to keep records that support income and deductions, and that means dates, amounts, business purpose, and proof of payment. In practice, a mileage row with the date, city, state, and miles driven is stronger than a bank statement alone, because the statement never tells you why the trip was business.

Keep The Data Long Enough

For federal recordkeeping, the usual retention period is 3 years, and it can stretch to 7 years in some cases. If you are preparing Form 1040 with Schedule C and Schedule SE, you want the workbook to survive long enough to back up the return, not just until the next phone upgrade.

Income, Fees, And Tax Forms

Platforms that pay contractors often report income on 1099-NEC when payments reach $600 or more. If you earn $18,000 from app work and $1,200 in fees are withheld by the platform, you still need the gross income number, because the deduction trail is separate from the payment trail.

Mileage And Self-Employment Tax

For gig workers, mileage logs are not a nice-to-have. If you drive 8,000 business miles and use the IRS standard mileage method, even a 1-mile error per day can change your deduction by hundreds of dollars over a year, which then changes your estimated taxes on Form 1040-ES.

The most expensive mistake is mixing personal spending into business records and then trying to sort it out at tax time. A $32.15 delivery bag, a $85 phone bill with 75% business use, and a $55.40 fuel purchase all belong in different buckets, and if you miss that separation you understate your deduction or create a messy audit trail.

Bad Mileage Math

A mileage log with only a monthly total and no contemporaneous detail is weak when the return gets questioned. If you claim 9,600 business miles and later cannot show the date, route, or business purpose, you can lose a deduction worth thousands of dollars at the standard mileage rate.

Fee Blind Spots And Net Confusion

Another common failure is booking only the net payout and ignoring the platform fee. If your app shows $1,000 gross income, $120 in service fees, and a $40 adjustment, entering only the bank deposit makes your revenue look smaller and your business expense totals incomplete.

Quarterly Tax Surprises

Gig workers often get hit by underpayment penalties because they wait until April to think about tax. If you owe self-employment tax of 15.3% plus federal income tax on top of that, a $2,500 quarterly profit can leave you short by several hundred dollars if you never set aside cash.

The way to keep this sheet alive is to tie it to a fixed event, not to motivation. The best trigger is payout day or Sunday night, because that is when the trips, fees, and receipts are still fresh.

Three Habits That Keep The Data Clean

• Enter transactions as soon as the shift ends, so a $18.50 rate or a $3.20 fee does not get forgotten in two days.
• Use the same category names every time, because one consistent list makes SUMIF totals usable at month-end.
• Review the dashboard before each estimated-tax deadline on April 15, June 15, September 15, and January 15.

When The Spreadsheet Is Too Small

If you are managing several drivers, hundreds of transactions per month, or payroll plus contractor payments, this workbook starts to act like a holding tank rather than a system. At that point, move to QuickBooks or a dedicated bookkeeping app so you can stop re-keying data and start reconciling it.