Content Creator Bookkeeping Spreadsheet 2026, Influencer Tax Tracker, Brand Deal Tracker, UGC Income Expense Log | Excel & Google Sheets

Content creator bookkeeping spreadsheet 2026: payouts, brand deals, gifted products, gear and software by Schedule C line, 1099 check, quarterly set-aside.

WHAT YOU GET (instant digital download)
- Income (1,000 rows): ad revenue and creator programs, sponsorships, UGC, affiliates, memberships and fan tips, digital products, merch (with sales tax) and products received for content, by source, with platform or agency fees withheld
- Brand Deals (200 rows): brand, deliverables, contract amount, agency %, net to you, content due and posted dates, invoice date and terms, payment due, paid date and status (paid, invoiced, overdue, not invoiced), with a 1099-NEC note at $2,000
- Gifted Products: date, brand, item, fair market value, content required, kept or returned, likely treatment (IRS Topic 420, bartering) and a check against the Income tab
- Expenses and Categories: 34 creator categories mapped to the 2025 Schedule C (camera, lenses and computers line 13, small gear and props 22, editing software and music 27b, editors 11, ads 8, merch inventory 4, meals at 50%); wardrobe kept off Schedule C by default
- 1099 Check: each platform, brand and agency vs. the 1099-NEC, 1099-MISC or 1099-K you receive ($2,000 for 2026 NEC/MISC payments; 1099-K over $20,000 and 200 transactions)
- Monthly P&L, Schedule C, Quarterly and Mileage: profit by month with a chart; lines 1-31; SE tax estimate and set-aside; 2026 Form 1040-ES dates; shoots and errands at the 2026 mileage rate by date
- Creator Tips tab and PDF guide: every income stream, gifted products, gear and depreciation, agencies, wardrobe

HOW IT WORKS
1. Download the files from your Etsy purchase page right after checkout.
2. Open the .xlsx in Excel, or upload it to Google Drive and open with Google Sheets. No macros, nothing to install.
3. Start on the "Start here" tab, then type in the yellow cells. Grey cells are formulas and recalculate for you. Each workbook comes in two copies: one with sample rows marked "Sample — delete" so you can see how it works, and one blank.

DETAILS
Products received in exchange for content are generally income at fair market value (IRS Topic 420). Gear can be depreciated or, at $2,500 or less per item, expensed under the de minimis safe harbor if elected: the workbook records it on line 13 for your preparer to decide. Two copies: Example (a sample creator studio marked "Sample — delete") and blank.

Important: the workbook does not calculate depreciation, international withholding or state sales tax returns, or prepare a return. The set-aside is a rough estimate. Schedule C line numbers follow the 2025 form.

Last reviewed Oct. 23, 2026. Uses 2026 IRS figures (mileage rates, SE tax, Form 1099 thresholds, Form 1040-ES due dates) with sources listed in the workbook.

General information, not tax, legal or accounting advice. MFA is not affiliated with the IRS or any platform, brand or agency.

Want your creator income organized or your return prepared? MFA works with creators and influencers. Visit mfa-advisory.com or call (347) 205-4468.

This is a digital product: no physical item will be shipped. Because files are delivered instantly, all sales are final. If a file won't open, message us and we'll fix it.