Updated:
Small Business Bookkeeping Spreadsheet
Know your real profit per order and per month. Your orders count your inventory down, platform and payment fees come off each order, and the profit & loss fills itself in — with a quarterly tab that shows what to set aside for tax at your own rate.
Preview
What's inside
- How_To_Guide.pdf
- Small_Business_Bookkeeping_Blank.xlsx
- Small_Business_Bookkeeping_Example.xlsx
WHAT BUYERS OF SMALL BUSINESS SPREADSHEETS ASKED FOR — INCLUDED
- A quarterly tax set-aside tab
- No passwords and nothing locked
- No #N/A or broken formulas on empty rows — every tab recalculated and checked before upload
- Inventory linked to orders: sold and in stock update by themselves, red when it is time to reorder
- Fees per order from your own platform percentages
WHAT YOU GET
Tabs: Start Here · Profit & Loss · Settings · Inventory · Orders · Money In & Out · Quarterly Tax · Pricing Calculator
- Small_Business_Bookkeeping_Blank.xlsx — start here
- How_To_Guide.pdf — step by step with pictures
HOW IT WORKS
- Settings: your fee percentages and tax set-aside %
- Inventory: products, cost, price, stock, reorder level
- Orders: one row per order — fees, cost of goods and profit calculate
- Money in & out: supplies, ads, software, wholesale, fairs
- Read profit per month and the amount to set aside per quarter
- Pricing calculator: materials + packaging + your time + shipping → the price for your target margin
FORMAT
- .xlsx spreadsheet — opens in Microsoft Excel (desktop, web, Mac), Google Sheets (upload the file to Google Drive and open it with Google Sheets) and LibreOffice Calc.
- Nothing is locked: no sheet passwords, no macros. Light-blue cells are for typing, white cells calculate.
The quarterly tab multiplies your profit by the rate you choose; it does not calculate tax law. Your tax office or accountant knows the rate and dates that apply to you.
Need more than this one? ReadyStack Pass opens all 544 files and 493 full versions — $29/month or $199/year. See the Pass →
A template you fill in yourself — not legal or tax advice.