Small Business Bookkeeping Spreadsheet
Small Business Bookkeeping Spreadsheet, Income Expense Tracker, Tax Set-Aside (2027)
Checkout happens on Etsy (secure, Etsy buyer protection). Files appear in your Etsy account under Purchases the moment payment clears.
For the freelancer or seller whose records are a shoebox and a bank statement, usually noticed the week before quarterly taxes are due. The Small Business Bookkeeping Spreadsheet is an Excel workbook that also opens in Google Sheets, with seven tabs and 1,250 ready rows with category and payment dropdowns. As you log, it works out monthly profit, how much to hold back for taxes and where you stand against the four IRS estimated-tax deadlines, which you can edit. An 8-page fillable PDF guide covers setup, a weekly routine and year-end.
On the first day, complete the Setup tab and enter this month's income and expenses from the bank statement; the dashboard populates as you go. Back-filling the year can happen gradually. Skip it if you have employees, inventory or an accountant who wants software exports; this is single-entry bookkeeping for a US sole proprietor or side business. It does not give tax or accounting advice.
- Format: Excel workbook (.xlsx) that opens in Google Sheets or Excel, plus a fillable PDF guide in US Letter and A4
- Workbook: 7 tabs, 1,250 log rows, category and payment dropdowns, automatic totals
- Guide: 8 pages, 184 fillable fields
- Google Sheets / Excel workbook with 7 tabs: Start Here, Setup, Income, Expenses, Mileage, Dashboard, Tax Summary
- 1,250 ready rows (400 income, 600 expense, 250 mileage) with category and payment dropdowns
- Dashboard: profit by month, suggested tax set-aside, the 4 IRS estimated-tax periods with editable due dates
What You Get
- Google Sheets / Excel workbook with 7 tabs: Start Here, Setup, Income, Expenses, Mileage, Dashboard, Tax Summary
- 1,250 ready rows (400 income, 600 expense, 250 mileage) with category and payment dropdowns
- Dashboard: profit by month, suggested tax set-aside, the 4 IRS estimated-tax periods with editable due dates
- Expense business-use %, deductible amount and 'other year' dates kept out of the totals automatically
- Year-end tax summary by category for your tax preparer
- 8-page fillable guide: setup, weekly routine, records, tax-period worksheet, year-end checklist
- Your copy starts blank and ready for your numbers; listing images show sample data
Who It's For
Freelancers, sole proprietors, Etsy and online sellers, side hustlers and small service businesses in the US. Not tax, legal or accounting advice.
How It Works
- Check out on Etsy. Your files are ready instantly: Etsy > You > Purchases and reviews > Download files.
- Open the PDF in Adobe Acrobat Reader, Apple Preview, Xodo, Chrome or Edge. Click any box, type, and save your copy.
- Print the pages you want, as many times as you need (US Letter or A4), or keep it digital.
- Spreadsheet: open the .xlsx in Excel, or in Google Sheets with File > Import > Upload. Type your numbers into the input cells; totals calculate automatically.
The Details
- Format: Excel workbook (.xlsx) that opens in Google Sheets or Excel, plus a fillable PDF guide in US Letter and A4
- Workbook: 7 tabs, 1,250 log rows, category and payment dropdowns, automatic totals
- Guide: 8 pages, 184 fillable fields
- Works with: Google Sheets (free), Microsoft Excel. Guide: Acrobat Reader, Preview, Xodo, Chrome, Edge
- Files in your download (3): Small-Business-Bookkeeping-2027-SHEETS.xlsx; Small-Business-Bookkeeping-Guide-FILLABLE.pdf; Small-Business-Bookkeeping-Guide-FILLABLE-A4.pdf
Good To Know
- This is a digital download. Nothing is shipped.
- Screen and printer colors vary a little; print a test page first.
- Personal use: print and fill as many copies as you need for yourself or your household. Please do not resell, share or redistribute the files.
- Design created with AI assistance under the creative direction of the seller.
- Not tax, legal or accounting advice. The set-aside is a savings estimate, not a tax calculation; ask a tax professional what applies to you.
