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.
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.
| Date | Gig / platform | Client | Gross | Fees | Net | Payment method | 1099 expected | Set aside |
|---|---|---|---|---|---|---|---|---|
| 7 Oct 2026 | Freelance design | Fitness studio client | $300.00 | $9.00 | $291.00 | Payment app | None | $57.56 |
| 8 Oct 2026 | Online craft shop | Marketplace sales | $165.48 | $16.32 | $149.16 | Platform payout | None | $29.51 |
| 9 Oct 2026 | Rideshare driving | Rideshare app | $365.40 | $92.50 | $272.90 | Platform payout | K | $53.98 |
| 11 Oct 2026 | Food delivery | Delivery app | $196.56 | $0.00 | $196.56 | Platform payout | NEC | $38.88 |
| 16 Oct 2026 | Rideshare driving | Rideshare app | $303.64 | $76.46 | $227.18 | Platform payout | K | $44.94 |
| 18 Oct 2026 | Food delivery | Delivery app | $165.90 | $0.00 | $165.90 | Platform payout | NEC | $32.82 |
| 23 Oct 2026 | Rideshare driving | Rideshare app | $195.94 | $41.32 | $154.62 | Platform payout | K | $30.59 |
| 23 Oct 2026 | Freelance design | Bakery client | $780.00 | $0.00 | $780.00 | Bank transfer | NEC | $154.29 |
| 23 Oct 2026 | Online craft shop | Marketplace sales | $250.98 | $24.44 | $226.54 | Platform payout | None | $44.81 |
| 30 Oct 2026 | Rideshare driving | Rideshare app | $359.91 | $93.95 | $265.96 | Platform payout | K | $52.61 |
What's inside the spreadsheet
| Tab | What you type | What it calculates |
|---|---|---|
| Start here | Nothing | Steps, the maths, colour key, limits, disclaimer |
| Settings | Tax 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 categories | Holds the 2026 IRS and SSA figures (each with its source), the four due dates and the Schedule C line for each category |
| Income log | Up to 400 payments: date, gig/platform (dropdown), client, gross, platform fees, payment method, 1099 form expected (NEC / K / None), notes | Net received, month, a suggested set-aside per payment, a check on every row |
| Expenses log | Up to 400 expenses: date, gig (optional), category (dropdown), description, amount, business-use % | Deductible amount (meals at 50%), Schedule C line, a row check |
| Mileage log | Up to 400 trips: date, gig, business purpose, from/to, miles | Deduction at the standard mileage rate, a row check |
| Summary | Only what you paid each quarter | Gross, 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, Summary | Already filled | 109 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.
| Item | 2026 figure | Source |
|---|---|---|
| Standard mileage rate, business | 72.5 cents a mile for 1 Jan – 30 Jun 2026; 76 cents a mile from 1 Jul 2026 | IR-2025-128 (29 Dec 2025); Announcement 2026-11 (IRB 2026-29, 13 Jul 2026); IRS standard mileage rates |
| Self-employment tax rate | 15.3% = 12.4% Social Security + 2.9% Medicare | IRS: Self-employment tax |
| Amount subject to SE tax | Generally 92.35% of net earnings | IRS Topic 554 |
| SE tax threshold | Net earnings from self-employment of $400 or more | IRS Topic 554 |
| Social Security wage base | $184,500 (wages and SE earnings combined) | SSA contribution and benefit base; IRS |
| Estimated tax due dates | 15 Apr 2026, 15 Jun 2026, 15 Sep 2026, 15 Jan 2027 | 2026 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 200 | IRS 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 2025 | Instructions 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.
- 1099-NEC: a business that paid you at least $2,000 in the year for services. In the example the fitness studio client pays less than that in total, so its rows say None.
- 1099-K: a payment app or marketplace when you pass $20,000 and 200 transactions, or a card processor for any amount. The 1099-K instructions define box 1a as the gross amount "without regard to any adjustments for credits, cash equivalents, discount amounts, fees, refunded amounts, shipping amounts, or any other amounts". That is why the Income log records gross and fees separately: gross ties to the form, and fees are a cost.
- No form: cash, small clients, and most marketplace sellers under the threshold.
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
- 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.
- 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.
- Pick the 1099 form expected: NEC, K or None. Column K shows how much of that payment to move to a tax savings account.
- 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%).
- 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.
- Check the Check column on each log: rows that are not OK are left out of every total, and
B4on each log counts them. - 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).
| Category | Line | Deductible | What goes here |
|---|---|---|---|
| Advertising | Line 8 | 100% | Ads, promoted listings, business cards |
| Parking and tolls | Line 9 | 100% | Business parking and tolls; added on top of the standard mileage rate |
| Commissions and fees | Line 10 | 100% | Fees you pay that are not already in the Income log fee column |
| Contract labor | Line 11 | 100% | Payments to contractors who help you |
| Insurance (not health) | Line 15 | 100% | Business liability, equipment insurance |
| Legal and professional | Line 17 | 100% | Tax preparer, accountant, lawyer |
| Office expense | Line 18 | 100% | Postage, printer ink, small office items |
| Rent: vehicles or equipment | Line 20a | 100% | Rented equipment or machinery |
| Rent: other business property | Line 20b | 100% | Booth fees, studio or storage rent |
| Repairs and maintenance | Line 21 | 100% | Repairs to business equipment (not your car if you use the mileage rate) |
| Supplies | Line 22 | 100% | Materials, packaging, delivery bags |
| Taxes and licenses | Line 23 | 100% | Business license, permits |
| Travel | Line 24a | 100% | Overnight business travel: fares, lodging |
| Meals (50%) | Line 24b | 50% | Business meals; the deduction is 50% in most cases |
| Utilities and phone | Line 25 | 100% | Business share of phone and internet: set business-use % |
| Other: software and subscriptions | Line 27a | 100% | Design software, apps, cloud storage |
| Other: shipping | Line 27a | 100% | Shipping labels for orders |
| Other expenses | Line 27a | 100% | 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.
| Field | Formula |
|---|---|
| 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
| Gig | Gross | Fees | Expenses | Miles | Mileage ded. | Net profit | SE tax (simple) | Set-aside |
|---|---|---|---|---|---|---|---|---|
| Rideshare driving | $11,982.88 | $2,877.33 | $159.56 | 5,852 | $4,320.15 | $4,625.84 | $653.61 | $1,362.95 |
| Food delivery | $4,785.15 | $0.00 | $39.99 | 1,810 | $1,341.40 | $3,403.76 | $480.94 | $1,002.88 |
| Freelance design | $8,830.00 | $48.18 | $336.50 | 203 | $150.22 | $8,295.10 | $1,172.06 | $2,444.06 |
| Online craft shop | $3,629.91 | $330.84 | $1,342.82 | 104 | $77.22 | $1,879.03 | $265.50 | $553.63 |
| Shared costs (no gig) | $0.00 | $0.00 | $767.00 | 0 | $0.00 | -$767.00 | ||
| Total | $29,227.94 | $3,256.35 | $2,645.87 | 7,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
- Net profit: $29,227.94 gross − $3,256.35 fees − $2,645.87 expenses − $5,889.00 mileage = $17,436.72.
- Net earnings from self-employment: $17,436.72 × 92.35% = $16,102.81. That is over $400, so SE tax applies.
- 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.
- Income tax: ($17,436.72 − $1,231.87) × 12% = $1,944.58 federal and × 4.5% = $729.22 state.
- Total estimated tax: $5,137.53, 29.5% of profit or 19.8% of each payment's net.
Quarterly payments
| Payment | Due date | Period ends | Profit to date | Fed. tax to date | Suggested | Paid | Paid − suggested |
|---|---|---|---|---|---|---|---|
| 1st payment | 15 Apr 2026 | 31 Mar 2026 | $4,561.65 | $1,153.27 | $1,153.27 | $1,150.00 | -$3.27 |
| 2nd payment | 15 Jun 2026 | 31 May 2026 | $8,000.00 | $2,022.54 | $869.27 | $900.00 | $27.46 |
| 3rd payment | 15 Sep 2026 | 31 Aug 2026 | $13,773.44 | $3,482.17 | $1,459.63 | $1,400.00 | -$32.17 |
| 4th payment | 15 Jan 2027 | 31 Dec 2026 | $17,436.72 | $4,408.31 | $926.14 | not 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
| Item | Schedule C line | Amount |
|---|---|---|
| Gross receipts (before platform fees) | Line 1 | $29,227.94 |
| Car: business miles x standard rate | Line 9 | $5,889.00 |
| Platform fees (grouped here with commissions and fees) | Line 10 | $3,256.35 |
| Advertising | Line 8 | $95.00 |
| Parking and tolls | Line 9 | $127.06 |
| Legal and professional | Line 17 | $260.00 |
| Office expense | Line 18 | $54.20 |
| Rent: other business property | Line 20b | $85.00 |
| Supplies | Line 22 | $884.89 |
| Taxes and licenses | Line 23 | $75.00 |
| Meals (50%) | Line 24b | $23.40 |
| Utilities and phone | Line 25 | $432.00 |
| Other: software and subscriptions | Line 27a | $258.90 |
| Other: shipping | Line 27a | $350.42 |
| Total expenses (lines 8-27a) | Line 28 | $11,791.22 |
| Net profit | Line 31 | $17,436.72 |
Common mistakes
- Logging net payouts as income. A 1099-K shows gross. Log gross and fees, or your income won't match the form.
- Treating the $400 rule as tax-free income. It is the self-employment tax test, not an income tax exemption.
- Waiting for a 1099. Income is reportable with or without a form; keep your own log.
- Mixing mileage and car costs. With the standard rate, don't also deduct fuel, repairs or insurance for the same car. Do add business parking and tolls.
- Logging miles without a purpose. Write the date, the business purpose and where you drove on every trip, and leave personal driving out.
- Spending the set-aside. Move it to a separate savings account on payday, so the quarterly payment is already there.
Limits
- An estimate for a sole proprietor or single-member LLC filing Schedule C in US dollars, one tax year per file. The income tax part relies on the marginal rate you type.
- Not modelled: the qualified business income deduction, credits, the 0.9% Additional Medicare Tax, depreciation, home office, cost of goods sold, actual car expenses, state-specific rules and penalty safe harbours (90% of this year's tax, or 100% or 110% of last year's).
- W-2 withholding is not counted against the estimate. Raising withholding at your day job is another way to cover side-income tax.
- 400 rows per log and 10 gigs. Due dates are typed values for 2026; check Form 1040-ES before using the file for another year.
- Recalculation was tested in LibreOffice; the file uses only functions that also exist in Excel 2016+ and Google Sheets.
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
- Expense tracker spreadsheetHousehold spending by category
- Budget spreadsheetPlan the month with side income
- Savings goal trackerTrack the tax set-aside fund
- Bill tracker spreadsheetDue dates and a paid checklist
- Capital gains tax calculatorTax on investment sales
- All templatesFree spreadsheets
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.