Home › Templates › Side hustle income tracker

Side Hustle Income Tracker

A free side hustle income tracker for Excel and Google Sheets: log every gig payment with platform fees and the 1099 form you expect, log expenses by Schedule C line and business miles at the 2026 IRS rates, and the Summary tab shows profit by gig and by month, an estimate of self-employment tax, a suggested set-aside and the four 2026 estimated-tax due dates with what you paid.

Download Excel template (.xlsx) 308 KB · no macros · Excel 2016+ and Google Sheets · tax year 2026 · v1.0, 3 Nov 2026

Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no app, no bank connection: you type or paste your payouts yourself.

Preview: the Example tabs, filled with a fictional person's four gigs from 1 Jan to 31 Oct 2026 (a day job with $38,000 of wages, 12% federal and 4.5% state rates typed on Settings).
$29,227.94gross income from 109 payments
$17,436.72net profit after $11,791 of fees, expenses and mileage
$2,463.73estimated self-employment tax
$5,137.53total estimated tax: set aside 19.8% of each payment's net
DateGig / platformClientGrossFeesNetPayment method1099 expectedSet aside
7 Oct 2026Freelance designFitness studio client$300.00$9.00$291.00Payment appNone$57.56
8 Oct 2026Online craft shopMarketplace sales$165.48$16.32$149.16Platform payoutNone$29.51
9 Oct 2026Rideshare drivingRideshare app$365.40$92.50$272.90Platform payoutK$53.98
11 Oct 2026Food deliveryDelivery app$196.56$0.00$196.56Platform payoutNEC$38.88
16 Oct 2026Rideshare drivingRideshare app$303.64$76.46$227.18Platform payoutK$44.94
18 Oct 2026Food deliveryDelivery app$165.90$0.00$165.90Platform payoutNEC$32.82
23 Oct 2026Rideshare drivingRideshare app$195.94$41.32$154.62Platform payoutK$30.59
23 Oct 2026Freelance designBakery client$780.00$0.00$780.00Bank transferNEC$154.29
23 Oct 2026Online craft shopMarketplace sales$250.98$24.44$226.54Platform payoutNone$44.81
30 Oct 2026Rideshare drivingRideshare app$359.91$93.95$265.96Platform payoutK$52.61
Example Summary, 2026: gross income (light bars) and net profit (dark bars) by month. Jan gross $2,355, net profit $1,206; Feb gross $2,312, net profit $1,167; Mar gross $3,569, net profit $2,189; Apr gross $2,656, net profit $1,562; May gross $3,227, net profit $1,877; Jun gross $3,191, net profit $2,137; Jul gross $2,123, net profit $1,148; Aug gross $3,543, net profit $2,488; Sep gross $2,661, net profit $1,440; Oct gross $3,591, net profit $2,224.Gross incomeNet profit$0$1,000$2,000$3,000$4,000JanFebMarAprMayJunJulAugSepOct

Chart: gross income and net profit by month, January to October 2026, from the same file. The workbook draws this as a native chart, plus net profit and set-aside by gig.

What's inside the spreadsheet

TabWhat you typeWhat it calculates
Start hereNothingSteps, the maths, colour key, limits, disclaimer
SettingsTax year, your gigs (up to 10), expected W-2 wages, your federal marginal and state income tax rates, an optional set-aside %, payment methods, expense categoriesHolds the 2026 IRS and SSA figures (each with its source), the four due dates and the Schedule C line for each category
Income logUp to 400 payments: date, gig/platform (dropdown), client, gross, platform fees, payment method, 1099 form expected (NEC / K / None), notesNet received, month, a suggested set-aside per payment, a check on every row
Expenses logUp to 400 expenses: date, gig (optional), category (dropdown), description, amount, business-use %Deductible amount (meals at 50%), Schedule C line, a row check
Mileage logUp to 400 trips: date, gig, business purpose, from/to, milesDeduction at the standard mileage rate, a row check
SummaryOnly what you paid each quarterGross, fees, expenses, mileage and net profit; gross by expected 1099 form; SE tax with the wage base and $400 test; income-tax estimates; set-aside; tables by gig and by month; quarterly suggestions vs paid; a Schedule C view by line; two native charts
Example Settings, Income log, Expenses log, Mileage log, SummaryAlready filled109 payments, 55 expenses and 91 mileage rows for a fictional person, so you can see every formula working

The tracker covers one tax year for one person filing Schedule C. For household spending use the expense tracker spreadsheet; to plan the month with your side income in it, use the budget spreadsheet; to park the set-aside money toward a target, use the savings goal tracker.

The 2026 numbers the template uses

Every federal figure sits on the Settings tab with its source, so you can check it and change it. Retrieved from IRS.gov and SSA.gov on 3 November 2026.

Item2026 figureSource
Standard mileage rate, business72.5 cents a mile for 1 Jan – 30 Jun 2026; 76 cents a mile from 1 Jul 2026IR-2025-128 (29 Dec 2025); Announcement 2026-11 (IRB 2026-29, 13 Jul 2026); IRS standard mileage rates
Self-employment tax rate15.3% = 12.4% Social Security + 2.9% MedicareIRS: Self-employment tax
Amount subject to SE taxGenerally 92.35% of net earningsIRS Topic 554
SE tax thresholdNet earnings from self-employment of $400 or moreIRS Topic 554
Social Security wage base$184,500 (wages and SE earnings combined)SSA contribution and benefit base; IRS
Estimated tax due dates15 Apr 2026, 15 Jun 2026, 15 Sep 2026, 15 Jan 20272026 Form 1040-ES; periods from Pub. 505 Table 2-1
Form 1099-K (payment apps, marketplaces)Required when payments exceed $20,000 and transactions exceed 200IRS Form 1099-K FAQs; Instructions for Form 1099-K (12/2026)
Form 1099-NEC (clients paying for services)$2,000 or more a year per payer, for payments after 31 Dec 2025Instructions for Forms 1099-MISC and 1099-NEC (12/2026)

The 2026 mileage rate changed mid-year. IRS Announcement 2026-11 raised the business rate to 76 cents a mile because of "recent increases in the price of fuel". It applies to expenses "paid or incurred ... on or after July 1, 2026"; the 72.5-cent rate from Notice 2026-10 still applies before that date. The Mileage log picks the rate from each trip's date, and both rates sit on Settings.

The 1099-K threshold changed in 2025. The IRS says the One, Big, Beautiful Bill "retroactively reinstated the reporting threshold in effect prior to the passage of the American Rescue Plan Act of 2021 (ARPA) so that third party settlement organizations are not required to file Forms 1099-K unless the gross amount of reportable payment transactions to a payee exceeds $20,000 and the number of transactions exceeds 200." (IR-2025-107, 23 Oct 2025). A platform may still send a 1099-K below the threshold, and some states set lower ones.

1099 forms: what to expect, and why it doesn't change what you report

The 1099 form expected column on the Income log lets you match forms in January against your own records. The Summary adds up gross income by expected form: in the example, $11,995.15 with a 1099-NEC expected, $11,982.88 with a 1099-K, and $5,249.91 with no form.

The form is only a paper trail. The IRS Gig Economy Tax Center says: "You must report income earned from the gig economy on a tax return, even if the income is" from part-time, temporary or side work, or not reported on a Form 1099-K, 1099-MISC, 1099-NEC, W-2 or other income statement. The Form 1099-K FAQs put it plainly: "All income, no matter the amount, is taxable unless the tax law says it isn't – even if you don't get a Form 1099-K."

How to use it

  1. Open Settings. Type your gigs (up to 10), your expected W-2 wages for the year, your federal marginal income tax rate (your bracket) and your state rate. Leave the set-aside % blank to let the Summary work it out.
  2. Open Income log. Add each payment or payout: date, gig, client, gross and the fee the platform kept. For a payout where the app only shows the net, use the app's earnings statement to find gross and fees. Type a refund as a negative gross.
  3. Pick the 1099 form expected: NEC, K or None. Column K shows how much of that payment to move to a tax savings account.
  4. Open Expenses log. Add business costs with a category; the Schedule C line fills in. For a shared phone or internet plan, type the business-use % (for example 60%).
  5. Open Mileage log. Log business miles with the date, purpose and where you drove. The deduction uses the rate for the trip date: 72.5 cents before 1 July 2026 and 76 cents from 1 July.
  6. Check the Check column on each log: rows that are not OK are left out of every total, and B4 on each log counts them.
  7. Open Summary. Read your profit and estimated tax, then type each estimated payment you make in the yellow Federal paid and State paid cells.

Expense categories and Schedule C lines

The categories follow the expense lines in the Instructions for Schedule C (Form 1040), so the Summary's Schedule C view can be copied into tax software line by line. Meals use a 50% deductible share because the instructions say "In most cases, the percentage is 50%." Rename or add categories on Settings (up to 20).

CategoryLineDeductibleWhat goes here
AdvertisingLine 8100%Ads, promoted listings, business cards
Parking and tollsLine 9100%Business parking and tolls; added on top of the standard mileage rate
Commissions and feesLine 10100%Fees you pay that are not already in the Income log fee column
Contract laborLine 11100%Payments to contractors who help you
Insurance (not health)Line 15100%Business liability, equipment insurance
Legal and professionalLine 17100%Tax preparer, accountant, lawyer
Office expenseLine 18100%Postage, printer ink, small office items
Rent: vehicles or equipmentLine 20a100%Rented equipment or machinery
Rent: other business propertyLine 20b100%Booth fees, studio or storage rent
Repairs and maintenanceLine 21100%Repairs to business equipment (not your car if you use the mileage rate)
SuppliesLine 22100%Materials, packaging, delivery bags
Taxes and licensesLine 23100%Business license, permits
TravelLine 24a100%Overnight business travel: fares, lodging
Meals (50%)Line 24b50%Business meals; the deduction is 50% in most cases
Utilities and phoneLine 25100%Business share of phone and internet: set business-use %
Other: software and subscriptionsLine 27a100%Design software, apps, cloud storage
Other: shippingLine 27a100%Shipping labels for orders
Other expensesLine 27a100%Anything else ordinary and necessary for the gig

There is no "car repairs" or "fuel" category on purpose. The Schedule C instructions say that with the standard mileage rate you "Do not deduct depreciation, rent or lease payments, or your actual operating expenses", but you do add parking fees and tolls. Platform fees from the Income log are grouped with line 10 (commissions and fees) in the Schedule C view; a tax preparer may place them differently.

The formulas, explained

Exact formulas from the blank tabs (row 8 on the logs). On the Income log, D is gross, E fees, L the row check. On the Summary, B16 is net profit, E9 net earnings from self-employment and E13 the SE tax. The Settings references hold the rates shown above.

FieldFormula
Income log: net received (F8)=IF(D8="","",N(D8)-N(E8))
Income log: set aside from this payment (K8)=IF(L8<>"OK","",MAX(0,F8)*IF(Settings!$B$17<>"",Settings!$B$17,Summary!$E$20))
Expenses log: deductible (G8)=IF(K8<>"OK","",E8*IF(F8="",1,F8)*INDEX(Settings!$C$41:$C$60,MATCH(C8,Settings!$A$41:$A$60,0)))
Mileage log: deduction at the rate for the trip date (F8)=IF(I8<>"OK","",E8*IF(A8>=Settings!$B$13,Settings!$B$12,Settings!$B$11))
Summary: gross income (B9)=SUMIFS('Income log'!$D$8:$D$407,'Income log'!$L$8:$L$407,"OK")
Summary: mileage deduction (B14)=SUMIFS('Mileage log'!$F$8:$F$407,'Mileage log'!$I$8:$I$407,"OK")
Summary: net profit (B16)=B9-B15
Summary: net earnings from SE (E9)=MAX(0,B16)*Settings!$B$6
Summary: Social Security part (E11)=IF(E9<Settings!$B$10,0,MIN(E9,MAX(0,Settings!$B$9-N(Settings!$B$14)))*Settings!$B$7)
Summary: Medicare part (E12)=IF(E9<Settings!$B$10,0,E9*Settings!$B$8)
Summary: federal income tax estimate (E15)=MAX(0,B16-E14)*N(Settings!$B$15)
Summary: set-aside % of each payment (E20)=IF(Settings!$B$17<>"",Settings!$B$17,IF(N(B11)<=0,0,E17/B11))
Summary: gig net profit (G28)=IF(A28="","",B28-C28-D28-F28)
Summary: 1st quarter profit to period end (D61)=SUMIFS('Income log'!$D$8:$D$407,'Income log'!$L$8:$L$407,"OK",'Income log'!$A$8:$A$407,"<="&C61)-SUMIFS('Income log'!$E$8:$E$407,'Income log'!$L$8:$L$407,"OK",'Income log'!$A$8:$A$407,"<="&C61)-SUMIFS('Expenses log'!$G$8:$G$407,'Expenses log'!$K$8:$K$407,"OK",'Expenses log'!$A$8:$A$407,"<="&C61)-SUMIFS('Mileage log'!$F$8:$F$407,'Mileage log'!$I$8:$I$407,"OK",'Mileage log'!$A$8:$A$407,"<="&C61)
Summary: suggested 2nd payment (F62)=MAX(0,E62-SUM(F$61:F61))

Self-employment tax follows the 2026 Form 1040-ES self-employment tax worksheet: net profit × 92.35%; Medicare part = that × 2.9%; Social Security part = the smaller of that amount and ($184,500 − your W-2 wages), × 12.4%. If net earnings are under $400, SE tax is zero. Half of SE tax is deductible for income tax, so the income-tax estimate uses (profit − half of SE tax) × your rate.

Set-aside. Total estimated tax ÷ net received gives the share of each payment's net to set aside. Type your own % on Settings to override it. By gig and by month, the suggested set-aside is profit × (total estimated tax ÷ net profit).

Quarterly suggestion, pay as you earn. For each period end (31 Mar, 31 May, 31 Aug, 31 Dec), the Summary takes profit earned up to that date, works out SE tax plus federal income tax on it, and subtracts what was suggested earlier. Uneven months, common in gig work, get uneven payments instead of four equal ones.

Worked example from the sample data

The fictional person drives for a rideshare app, delivers food on weekends, does freelance design and runs an online craft shop. They also have a day job, so they typed $38,000 of W-2 wages, a 12% federal rate and a 4.5% state rate on Settings.

Profit by gig, January to October 2026

GigGrossFeesExpensesMilesMileage ded.Net profitSE tax (simple)Set-aside
Rideshare driving$11,982.88$2,877.33$159.565,852$4,320.15$4,625.84$653.61$1,362.95
Food delivery$4,785.15$0.00$39.991,810$1,341.40$3,403.76$480.94$1,002.88
Freelance design$8,830.00$48.18$336.50203$150.22$8,295.10$1,172.06$2,444.06
Online craft shop$3,629.91$330.84$1,342.82104$77.22$1,879.03$265.50$553.63
Shared costs (no gig)$0.00$0.00$767.000$0.00-$767.00
Total$29,227.94$3,256.35$2,645.877,969$5,889.00$17,436.72$2,572.10$5,363.52

Rideshare has the highest gross ($11,982.88) but keeps only $4,625.84 after $2,877.33 of platform fees and a $4,320.15 mileage deduction for 5,852 miles (72.5 cents a mile to 30 June, 76 cents from 1 July). Freelance design earns less gross ($8,830.00) and keeps $8,295.10, the most of any gig. The craft shop's supplies, shipping and ads take $1,342.82 of its $3,629.91. The phone plan, business license and tax preparer fee ($767.00 in total) are shared costs with no gig.

From profit to estimated tax

  1. Net profit: $29,227.94 gross − $3,256.35 fees − $2,645.87 expenses − $5,889.00 mileage = $17,436.72.
  2. Net earnings from self-employment: $17,436.72 × 92.35% = $16,102.81. That is over $400, so SE tax applies.
  3. Social Security part: wages of $38,000 leave $146,500 of the $184,500 wage base, more than $16,102.81, so $16,102.81 × 12.4% = $1,996.75. Medicare part: × 2.9% = $466.98. SE tax = $2,463.73.
  4. Income tax: ($17,436.72 − $1,231.87) × 12% = $1,944.58 federal and × 4.5% = $729.22 state.
  5. Total estimated tax: $5,137.53, 29.5% of profit or 19.8% of each payment's net.

Quarterly payments

PaymentDue datePeriod endsProfit to dateFed. tax to dateSuggestedPaidPaid − suggested
1st payment15 Apr 202631 Mar 2026$4,561.65$1,153.27$1,153.27$1,150.00-$3.27
2nd payment15 Jun 202631 May 2026$8,000.00$2,022.54$869.27$900.00$27.46
3rd payment15 Sep 202631 Aug 2026$13,773.44$3,482.17$1,459.63$1,400.00-$32.17
4th payment15 Jan 202731 Dec 2026$17,436.72$4,408.31$926.14not yet-$958.31

The first payment came in $3.27 under the suggestion; the second more than made up for it. By 15 September the person is $32.17 behind, and the 15 January 2027 payment is still open, with $1,107.53 of the year's estimate not yet covered by payments. These are federal figures; the state columns in the file work the same way.

Schedule C view

ItemSchedule C lineAmount
Gross receipts (before platform fees)Line 1$29,227.94
Car: business miles x standard rateLine 9$5,889.00
Platform fees (grouped here with commissions and fees)Line 10$3,256.35
AdvertisingLine 8$95.00
Parking and tollsLine 9$127.06
Legal and professionalLine 17$260.00
Office expenseLine 18$54.20
Rent: other business propertyLine 20b$85.00
SuppliesLine 22$884.89
Taxes and licensesLine 23$75.00
Meals (50%)Line 24b$23.40
Utilities and phoneLine 25$432.00
Other: software and subscriptionsLine 27a$258.90
Other: shippingLine 27a$350.42
Total expenses (lines 8-27a)Line 28$11,791.22
Net profitLine 31$17,436.72

Common mistakes

Limits

FAQ

How much should I set aside for taxes from a side hustle?

There is no single percentage. The amount depends on your profit, your other income and your state. The template works it out: self-employment tax (15.3% of 92.35% of profit, with the Social Security part capped by the 2026 wage base of $184,500 minus your wages) plus your own federal and state rates on the profit. In the fictional example that comes to $5,137.53 on $17,436.72 of profit, or 29.5%, which is 19.8% of each payment's net. Treat it as an estimate, not tax advice.

Do I have to pay tax on side hustle income under $400?

The $400 figure is the self-employment tax test: IRS Topic 554 says you usually must pay self-employment tax if you had net earnings from self-employment of $400 or more. It is not a tax-free allowance. The IRS Gig Economy Tax Center says you must report gig income on a tax return even if it comes from part-time or side work or is not reported on a Form 1099. Income tax can still apply below $400.

Will I get a Form 1099-K for 2026?

Only if a payment app or online marketplace has to file one, or chooses to. The IRS says third party settlement organizations are not required to file Form 1099-K unless payments to you exceed $20,000 and the number of transactions exceeds 200. A platform may still send one below that, card payments have no threshold, and your state may have a lower one. Either way, the IRS says all income is taxable even if you don't get a Form 1099-K.

What is the 1099-NEC threshold for 2026?

For payments made after December 31, 2025, the IRS threshold for reporting nonemployee compensation on Form 1099-NEC is $2,000 a year per payer, up from $600, and it may be adjusted for inflation from 2027. A client who paid you less than that usually will not send one, but the income is still reportable.

When are 2026 quarterly estimated taxes due?

The 2026 Form 1040-ES lists April 15, 2026, June 15, 2026, September 15, 2026 and January 15, 2027. You don't have to make the January payment if you file your 2026 return by February 1, 2027 and pay the full balance with it. The Summary tab shows a suggested amount for each date and tracks what you paid.

Can I deduct mileage for gig work?

Yes, if you are self-employed: IRS Topic 510 lists the self-employed among those who can deduct car expenses, with the standard mileage rate or actual costs. For 2026 the IRS business rate is 72.5 cents a mile for January to June and 76 cents a mile from July 1, after Announcement 2026-11 revised it because of higher fuel prices. The Schedule C instructions say parking fees and tolls are added on top. This template uses the standard rate for each trip's date, so do not also log fuel or car repairs as expenses.

Related tools and templates

Educational template only, not tax, legal or financial advice. Tax figures are estimates; your actual tax depends on your whole return. Example data is fictional: the gigs, clients, amounts, rates and payments are made up to show the formulas. Federal figures are for tax year 2026 from IRS.gov and SSA.gov, retrieved 3 November 2026; check the linked pages or a tax professional before you file or pay.