Small Business Tax Prep Kit Excel for your small business owners and sole proprietors getting ready for tax season — income log with 1099 tracking, deductible expenses, depreciation, a tax estimate, and a filing…
About this template
Small Business Tax Prep Kit Excel for your small business owners and sole proprietors getting ready for tax season — income log with 1099 tracking, deductible expenses, depreciation, a tax estimate, and a filing checklist. Know what you earned, what you can deduct, and what you still owe — before the filing deadline.
$49
Excel & Google Sheets template — instant download on Etsy
Business Income Log — date, client or payer, income source, 1099 type, whether the 1099 arrived, amount, and notes for every source of business income. Missing 1099s are easy to spot.
Deductible Expense Log — date, item, category, amount, business-use share, and deductible amount for every expense. Meals are capped at 50 percent by formula.
Asset and Depreciation — asset, placed-in-service date, cost basis, method, recovery years, and the first-year depreciation estimate for every business asset. Section 179 items take the full basis in year one.
Tax Estimate and Filing Checklist — net business income, self-employment tax, a federal income tax estimate at a flat planning rate, quarterly payments made, the balance still owed, the effective rate, and a checklist of documents still needed.
Dashboard — gross income, 1099s received and missing, deductible expenses, depreciation, net income, estimated tax, payments, balance due, effective rate, documents still needed, income by payer, expenses by category, and quarterly payments.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Small Business Tax Prep Kit
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 Small Business Tax Prep Kit track?
The Small Business Tax Prep Kit tracks Business Income Log; Deductible Expense Log; Asset and Depreciation; Tax Estimate and Filing Checklist; Dashboard.
What do the example numbers show?
The included example shows: 12 income items; gross business income 71,200; 10 1099s received (63,200); 1 1099 missing, Sun Valley Realty 6,800; 1 cash payment with no 1099, 1,200.
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.