InkSheet Studio
Freelancer 1099 Income and Tax System Spreadsheet | Invoice Tracker, Expenses, Mileage, Tax Estimate
Freelancer 1099 Income and Tax System Spreadsheet | Invoice Tracker, Expenses, Mileage, Tax Estimate
Couldn't load pickup availability
INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.
Tax season is coming and your income lives in four apps, two inboxes and a shoebox. Which clients still owe you? What did you actually deduct this year? And the question that keeps freelancers up at night — how much of this money is really the tax office's?
Most freelancer spreadsheets stop at an invoice list. This one runs the books: every invoice tracks its balance and PAID / PARTIAL / OPEN status by itself, expenses carry their deductible share (fully business, half, or personal), mileage converts to deduction dollars at your rate, and your estimated tax figures itself — for the period and split by quarter for estimated payments. In the sample season inside, $9,800 invoiced becomes $6,180 collected with $3,620 still owed across five invoices — and the sheet already knows the estimated tax on what landed. A bank balance never tells you that. The sheet does.
Transparency note: this spreadsheet was designed with AI assistance, then hand-built, formula-checked and finished by our shop.
THE 5 TABS
• Start Here — Instructions & Dashboard — quick-start instructions, your settings, and a live dashboard where every number is a formula pulling from the other tabs
• Income Log — One row per invoice — balances and payment status figure themselves.
• Expenses Log — Every cost with its deductible share — the deductible dollars figure themselves.
• Mileage Log — Business trips in miles — and in deduction dollars, at your rate.
• Tax Estimate — Taxable income and estimated tax — figured from the three logs, split by quarter.
HOW THE TAX ESTIMATE IS FIGURED
Taxable Income (est.) = Collected Income − Deductible Expenses − Mileage Deduction. Estimated Tax = Taxable Income × your rate (Start Here — the sample starts at 24%). Two honest simplifications: it counts income when it is PAID (cash basis, the way most freelancers file), and invoices dated in an earlier quarter land in their own quarter row below, not in this period's collected total. This is a planning estimate, not tax advice — your accountant owns the real return.
HOW DEDUCTIBLE SHARES WORK
Each expense carries a Deductible %: 1 for fully business costs, a fraction for shared costs like a home office or internet, 0 for personal. Deductible $ = Amount × Deductible %. It is the simplest honest way to keep mixed expenses straight without a second sheet.
THE SAMPLE DATA
It comes loaded with one fictional season (Alex Rivera, brand designer — 12 invoices, 12 expenses, 8 trips) so you can watch every formula work before you delete the samples and type your own: a September invoice that lands in its own tax quarter, home-office rent counted at a 30% deductible share, and 158.9 miles of client trips already turned into their deduction. Formulas are pre-filled down the columns — 40 income rows, 30 expense rows and 24 mileage rows, ready to go.
REQUIREMENTS: a free Google account for the Google Sheets version (the link is inside delivery.pdf), or Microsoft Excel for the .xlsx file delivered with this listing. Nothing to install. Note: the tax figures are planning estimates at the rate you set — not tax advice; your accountant owns the real return.
This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.
Share
