Etsy & Handmade Bookkeeping Spreadsheet: monthly profit & loss tracker (Excel + Google Sheets)

Know your real profit every month, without logging every single Etsy order.

Etsy already adds up your sales, fees, ads and refunds each month. This tracker takes those six totals from your monthly statement, adds your craft fair, wholesale and website sales and every business expense, and builds your profit & loss for you.

WHAT'S INSIDE

• Dashboard: revenue, costs, profit, margin, tax set-aside and Etsy's share of your Etsy sales, for the whole year.
• Monthly profit & loss, January to December, with every cost category.
• Charts: revenue vs profit by month, and costs by category (Etsy fees, ads and shipping labels included).
• Etsy Monthly: six numbers a month from Shop Manager > Finances > Monthly statements. Takes two minutes.
• Other Sales: 400 rows for markets, wholesale, commissions and your own website.
• Expenses: 600 rows, 14 editable categories, and a red flag for any expense without a saved receipt.
• Tax set-aside: choose a percentage and see how much to put aside each month, based on your profit so far this year.
• Checks: flags rows that need fixing (missing date or amount, text instead of a number, unknown category), rows from another year, and missing receipts.
• Works in any currency. One file per year: save a copy, clear it and set the new year.

WHY IT'S EASY TO USE

• Works in Excel and Google Sheets. One-time price, no subscription, no account.
• A filled-in example and a Start Here tab, so you copy the setup instead of starting from a blank sheet.
• Free updates: your download page always has the latest version.

HOW YOU GET IT

1. After checkout you get a short PDF with your personal download page and your license key (the key is also on your order page).
2. Download the file at sheetsandsums.com/download/bookkeeping-tracker with the email you bought with and your key. You always get the newest version, and future updates are free: same page, same key.
3. Open the .xlsx file in Excel (2016 or newer) or LibreOffice (free, also on Mac). Apple Numbers isn't supported. Google Sheets: drive.google.com > New > File upload, then open it with Google Sheets.
4. Fill in the yellow cells. Everything else calculates on its own.

GOOD TO KNOW

• Instant digital download. Nothing is shipped.
• No subscription, no macros, no account needed.
• In Excel and LibreOffice, formulas are locked so they can't break by accident (no password). Google Sheets doesn't keep the locks.
• Every rate and assumption sits in an editable cell, so you can update it yourself when something changes.
• Stuck? The Start Here tab answers most questions. Otherwise email hello@sheetsandsums.com; we usually reply within 2 working days.
• Doesn't open or doesn't work as described? Email us and we'll fix it or refund you.

KNOW YOUR WHOLE YEAR

Pair it with the Etsy Fee & Profit Calculator 2026, or get both in the Etsy Seller Bundle and save 21%.

Not tax, legal or accounting advice. For use in your own business; please don't resell or share the file.