Home / Templates / Handmade Shop Bookkeeping Bundle
2026 edition · Google Sheets template
Handmade Shop Bookkeeping Bundle
True per-order profit after platform and payment fees, plus inventory, expenses and quarterly tax set-asides for a one-person shop.
Excel · Google Sheets · LibreOffice · one-time $29
Instant digital download — all sales are final, but if anything is genuinely broken we fix it fast or make it right. Email [email protected].
The actual file
Browse it before you buy
Every screenshot below is the real Handmade Shop Bookkeeping Bundle workbook — real headers, real sample numbers, real formulas. Click a tab.
Click a tab — this is the real file, not a mockup. 6 tabs total.
Tab by tab
What's inside
5 tabs shown below, matched to the real column headers in the file.
Orders
Log each sale by platform (Etsy, Shopify, Market, Other) and type in that row's platform Fee % yourself (the sheet notes suggested rates); payment fee applies automatically from the settings block to every row except Market sales, and per-order profit after shipping and materials calculates itself.
Inventory
Materials on hand with unit cost, live stock value, and a REORDER flag once quantity drops to your reorder point.
Expenses
Business costs with a Deductible? flag, so your tax-deductible total is always known.
Tax Set-Aside
Pulls taxable profit by quarter straight from Orders and Expenses, and shows what to park at your chosen set-aside rate.
Dashboard
Sales, fees, order profit, shop expenses, net profit after expenses, overall margin, stock value on hand, and tax parked for the year.
Before you type a thing
It ships filled in — with sample data
Every tab you saw above already has worked example numbers in it, so you can see how Handmade Shop Bookkeeping Bundle behaves before you touch it. Study it, then overwrite it — nothing is "real" until you replace the samples with your own numbers.
Honey cells are yours
Any cell shaded honey is an input — type over the sample value with your own. These are unlocked and unprotected.
Grey cells calculate themselves
Pale grey cells hold formulas and are locked. Leave them alone — totals, dashboards and progress bars update automatically as you fill in the honey cells.
Delivery & format
How you get it
Pay with Stripe, land instantly on a download page with your .xlsx workbook — plus an email backup of the same link, in case you lose the tab.
Open it your way: double-click for Excel or LibreOffice, or upload to Google Drive and choose Open with → Google Sheets.
Updates to this 2026 edition are emailed to you free — no repurchase, ever.
Because this is an instant digital download, all sales are final — but if anything is genuinely broken we fix it fast or make it right. Email [email protected].
Set expectations
What this is not
- Manual data entry — no marketplace sync; you log each sale yourself (copy/paste from your Etsy or Shopify export works fine).
- One shared file — sharing and permissions are handled through your own Google Drive, not a built-in login system.
- No native charts — margin shows as an in-cell color scale and data bar, not a chart object.
- Room for 40 orders, 30 expenses and 20 inventory items — generous for a one-person shop; more than that means extending the SUM/SUMIFS ranges yourself, or duplicating the file per year.
- Tax figures are rough estimates, not tax advice — set-aside rates vary by country, state and income; confirm with a professional.
- US-dollar formatting by default — changeable for any currency via Format → Number.
Getting started
Set up in 4 steps
Set your payment fee and tax rates in the honey cells at the top of Orders.
Log every sale on Orders — platform + payment fees and per-order profit calculate themselves.
Keep Inventory current so you always know stock value and what to reorder.
Expenses feed your deductible total; Tax Set-Aside tells you what to park each quarter for tax.
Good to know
Handmade Shop Bookkeeping Bundle FAQ
What format does it come in?
A single .xlsx workbook. It opens natively in Excel and LibreOffice, and in Google Sheets via "Make a copy".
How do I use it in Google Sheets?
Upload the .xlsx to Google Drive, right-click it, choose Open with → Google Sheets, then File → Make a copy to get your own editable version.
Does it work for Etsy and Shopify?
Yes — pick the platform per row from the dropdown and type in that row's Fee % yourself (the sheet lists suggested rates, e.g. Etsy ~6.5%, Shopify 0%). The payment fee applies automatically to every row except Market sales, which are charged none.
Is the tax set-aside number accurate?
It's a rough estimate — taxable profit by quarter, times a set-aside rate you choose. Rates vary by country, state and total income, so confirm the right number with a tax professional.
Do I get updates?
Yes — every update to the 2026 edition is free. We email the new link when it ships.
What's your refund policy?
Because this is an instant digital download, all sales are final — but if anything is genuinely broken, we fix it fast or make it right. Email [email protected].
Keep reading
Related guides
Already have this one covered? Side Hustle Income Tracker — Every side gig in one sheet — gross vs net per platform, expenses, and a quarterly tax stash.
Instant download · No subscription · Free 2026-edition updates