Content Creator Income and Tax Tracker Excel for creators — income streams and rates per hour, project profit by platform, gear inventory, a monthly P and L dashboard, and a tax set-aside planning estimate. Know what…
About this template
Content Creator Income and Tax Tracker Excel for creators — income streams and rates per hour, project profit by platform, gear inventory, a monthly P and L dashboard, and a tax set-aside planning estimate. Know what every hour of creating actually earns — and what to set aside before tax time.
$49
Excel & Google Sheets template — instant download on Etsy
Income Streams and Rates — average hours per piece, production cost and editor or contractor cost per piece, cost per hour, realized revenue per hour, and margin in dollars and percent for every content type. Change a cost and every project profit updates by formula.
Projects Log — date, project, platform, content type, hours worked, realized revenue per hour, revenue, cost per hour pulled from the rates sheet, profit per project, and margin. Log long-form, shorts, sponsored work, brand deals, and live streams in one place.
Gear and Supplies — supply, unit, quantity on hand, reorder point, cost per unit, and stock value. Anything at or below its reorder point is flagged LOW STOCK so you buy it before the next shoot.
Monthly P and L — revenue, production and editor cost, software and subscriptions, studio or rent share, and other expenses by month, Jan-Dec, with net profit and margin. Revenue and project cost are formulas from the Projects sheet.
Dashboard — total revenue, projects, hours, average project value, gross and net profit and margin, best content type by margin per hour and by margin percent, best-selling content type, best project and best platform, costs by category, low stock count, and a tax set-aside planning estimate of 25 percent of net profit.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Content Creator Income and Tax Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Content Creator Income and Tax Tracker track?
The Content Creator Income and Tax Tracker tracks Income Streams and Rates; Projects Log; Gear and Supplies; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: Total revenue 5,414 from 20 projects and 96 hours; average project value 270.70.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.