Etsy Shop Accounting Spreadsheet | Seller Bookkeeping, Tax Deductions, Profit and Loss & Expense Tracker (Google Sheets + Excel)

Seller's description

A complete Etsy seller bookkeeping spreadsheet with monthly and annual dashboards. Track income and expenses, see your profit, chase unpaid invoices and get a tax summary - in Google Sheets or Excel.

Platform fees quietly eat 20-30% of a handmade sale. This separates fees from materials so you can see what you actually keep on every order.

12 tabs, every formula already written and locked. No subscription. No sign-up. One payment and the files are yours to keep.


WHAT'S INCLUDED

- Bookkeeping-Template.xlsx - the 12-tab workbook, works offline in Excel
- Google-Sheets-Setup.pdf - import it into your own Google Drive in three clicks
- READ-ME-FIRST.pdf - the setup steps and what every tab does

There is no shared link to expire. You import the file into your own Google Drive, so the spreadsheet is yours and cannot break.


SET UP IN FIVE MINUTES, NO VIDEO NEEDED

Seven plain-English setup steps are built into the first tab. No tutorial to sit through, nothing to install and no account to make with me.


THE 12 TABS

- Annual Dashboard - income, expenses, net profit, money owed, tax set-aside, miles, your best month, a profit-goal ring and charts of where the money comes from and goes
- Monthly Dashboard - pick any month from a dropdown: profit, change vs last month, progress to your monthly goal and every category
- Quarterly - pick Q1 to Q4 for totals, the months inside it and the tax to put aside for quarterly payments
- Income - date, customer, invoice number, category, amount, paid yes/no
- Expenses - date, paid to, category, amount, receipt link; business or personal fills itself in from the category
- Mileage - from, to and miles; the deduction is worked out with your own rate
- Unpaid Invoices - every unpaid invoice, oldest first, flagged at 30 and 60 days
- Top Customers - ranked by what they paid this year, with invoices and amounts still owed
- Monthly Summary - income, expenses, profit, margin, unpaid and miles for every month
- Tax Summary - totals by category, deductible amounts, mileage deduction and a suggested tax set-aside
- Settings - business name, financial year, currency symbol, mileage rate, tax %, profit goal and your categories
- Start Here - the seven setup steps


BUILT PROPERLY, NOT THROWN TOGETHER

- Your financial year can start in any month, and every tab follows it
- Any currency: set your symbol once on Settings
- Every formula is locked so it cannot be broken by accident
- Categories are dropdowns already set up for Etsy sellers, and you can rename them
- Owner draw and personal spending are kept out of profit and tax
- Room for 1,000 income rows, 1,000 expenses and 500 trips a year


WHO IT'S FOR

Etsy, Shopify and online shop owners who want to know their real profit after fees.


WHAT YOU NEED

Microsoft Excel 2010 or newer (Windows or Mac), or a free Google account for Google Sheets. Nothing else. The Excel file works with no internet connection.


INSTANT DOWNLOAD

Nothing is posted to you. Your files are ready the moment your order goes through - find them under You, then Purchases and reviews, then Download Files.


REFUNDS

Because the files are delivered instantly and cannot be returned, all sales are final. But if a file will not open, will not calculate, or is not what was described, message me and I will fix it or refund you. I would always rather solve the problem than leave you with something you cannot use.


PLEASE NOTE

This is a spreadsheet, not tax advice. The tax summary adds up your categories so you have clean figures to give your accountant. It does not file anything for you.

The images show the spreadsheet filled with sample data. Your copy arrives with five example rows per tab that you clear before you start.

Your purchase is for your own business use. Please do not resell or redistribute the files.


I reply to every message within 24 hours.