{"product_id":"small-business-bookkeeping-spreadsheet-light-dark","title":"Small Business Bookkeeping Spreadsheet (Light + Dark)","description":"\u003cp\u003eDid you actually make money this month, after Etsy fees, materials and shipping? This simple bookkeeping spreadsheet answers that for a one-person Etsy, handmade or small online shop, without accounting software. Light and dark versions are both included.\u003c\/p\u003e\u003cp\u003eYou fill in Setup once, then add to two lists as you go: Sales (one row per order) and Expenses (one row per cost). The Dashboard, the Profit \u0026amp; Loss and every total fill themselves. Each thing is typed once. No locked cells.\u003c\/p\u003e\u003ch3\u003eWHAT YOU GET · 5 FILES\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eSmall-Business-Bookkeeping.xlsx: your blank file (light), with Etsy's US fee rates and common expense categories already filled in\u003c\/li\u003e\n\u003cli\u003eSmall-Business-Bookkeeping-Dark.xlsx: the same blank file in dark mode\u003c\/li\u003e\n\u003cli\u003eSmall-Business-Bookkeeping-EXAMPLE.xlsx and Small-Business-Bookkeeping-Dark-EXAMPLE.xlsx: the same file filled with a made-up candle and soap shop, so you can click around first\u003c\/li\u003e\n\u003cli\u003eSmall-Business-Bookkeeping-Quick-Start-Guide.pdf (4 pages): which file to open, the 3 steps, 7 simple rules with example rows, questions and answers, and your Google Sheets \"Make a copy\" links (light and dark)\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003e9 TABS\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eStart Here: three steps and short tips, with links to every tab\u003c\/li\u003e\n\u003cli\u003eSetup: business name, year and currency symbol; up to 8 sales channels (Etsy, Shopify, markets, wholesale…) with their own fee rates; Etsy's US fees in editable cells; money accounts; up to 20 expense categories with a monthly budget each; an optional mileage rate\u003c\/li\u003e\n\u003cli\u003eDashboard: pick a month and see sales, fees, expenses, net profit, profit margin, orders, average order and sales tax collected; profit by channel; your top expenses against their budget, in red when over; a 12-month chart of sales, fees \u0026amp; expenses and net profit\u003c\/li\u003e\n\u003cli\u003eSales: one row per order with date, channel, order number, item, quantity, item total, shipping charged, discount, sales tax, platform fees, payment fees, ads fees, shipping label and refund. Fees, net and month fill themselves. 1,000 rows ready.\u003c\/li\u003e\n\u003cli\u003eExpenses: one row per cost with date, category, vendor, what, amount, account and a Receipt ✔. 500 rows ready.\u003c\/li\u003e\n\u003cli\u003eProfit \u0026amp; Loss: the whole year month by month: sales, discounts, refunds, fees by type, shipping labels, every expense category and net profit, with year totals and running totals\u003c\/li\u003e\n\u003cli\u003ePrice Check: type a price and your costs to see Etsy's fees, your profit per sale and your margin, plus a break-even price and a price for the margin you want\u003c\/li\u003e\n\u003cli\u003eMileage (optional): one row per business trip; the value uses your rate per mile\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003ePlus a Lists tab that fills the drop-downs by itself (no need to touch).\u003c\/p\u003e\u003ch3\u003eWHY IT'S SIMPLE\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eType each order once. The same row feeds the Dashboard, the Profit \u0026amp; Loss, profit by channel and the chart.\u003c\/li\u003e\n\u003cli\u003eSales tax is kept apart. It is never counted as your income.\u003c\/li\u003e\n\u003cli\u003eNo time to look up every fee? Leave the fee cells empty and the sheet estimates them from your rates in Setup. Type the real fees from your Etsy statement whenever you like.\u003c\/li\u003e\n\u003cli\u003eRefunds go on the same order row, so the month of the sale stays right.\u003c\/li\u003e\n\u003cli\u003eEach expense category has its own monthly budget and turns red when you go over.\u003c\/li\u003e\n\u003cli\u003ePrice Check helps you price a new item before you list it.\u003c\/li\u003e\n\u003cli\u003eNothing is locked. No passwords, no macros. Click any grey cell to see its formula.\u003c\/li\u003e\n\u003cli\u003eNo video needed. The Start Here tab and the 4-page guide cover everything.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eLIGHT AND DARK\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eBoth versions are in this download, with the same tabs and the same formulas. Pick the one you like.\u003c\/li\u003e\n\u003cli\u003eLight: a soft cream page. Type in the white boxes with a thin border.\u003c\/li\u003e\n\u003cli\u003eDark: every tab is dark, the chart too. Type in the boxes with a thin border. Made for the screen: printing a dark tab uses a lot of ink.\u003c\/li\u003e\n\u003cli\u003eIn both, grey cells fill themselves.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eFROM THE EXAMPLE FILE\u003c\/h3\u003e\u003cp\u003eMade-up numbers, an example only. A small candle and soap shop with 121 orders on Etsy, Shopify and one market weekend, and 81 costs from January to October 2026. In October: 781.35 in sales, 71.62 in fees, 487.99 in expenses and 221.74 net profit, while materials went over their budget (240.00 against 180.00), so that row turns red. Your numbers will be different.\u003c\/p\u003e\u003ch3\u003eHOW IT WORKS\u003c\/h3\u003e\u003col\u003e\n\u003cli\u003eAfter checkout, click the download button on your order confirmation page. The same download link is also in your order confirmation email.\u003c\/li\u003e\n\u003cli\u003eOpen the quick-start guide. Use a Google Sheets link to make your own copy (light or dark), or open a blank .xlsx in Excel.\u003c\/li\u003e\n\u003cli\u003eSetup, about 5 minutes: your channels, your fee rates and your expense categories.\u003c\/li\u003e\n\u003cli\u003eAdd sales and costs as you go: one row per order, one row per cost.\u003c\/li\u003e\n\u003cli\u003eOnce a month, pick the month on the Dashboard and see what you really kept.\u003c\/li\u003e\n\u003c\/ol\u003e\u003ch3\u003eCOMPATIBILITY\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eGoogle Sheets: use the \"Make a copy\" links in the guide (a free Google account is needed)\u003c\/li\u003e\n\u003cli\u003eExcel 2016 or newer on Windows (tested in Excel 2021)\u003c\/li\u003e\n\u003cli\u003eOn a Mac? Use the Google Sheets copy\u003c\/li\u003e\n\u003cli\u003eSet it up on a computer. On a phone or tablet, open your copy in the free Google Sheets app to add entries and check it on the go. Phone web browsers show a read-only view.\u003c\/li\u003e\n\u003cli\u003eNot for Apple Numbers.\u003c\/li\u003e\n\u003cli\u003eEtsy's fee rates are for US shops and can be changed in Setup. Any currency: pick or type your currency symbol. It's a label only; nothing is converted.\u003c\/li\u003e\n\u003cli\u003eRows ready: 1,000 orders, 500 costs, 300 trips, 8 channels, 20 expense categories. Copy the last row down for more.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eGOOD TO KNOW\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eDigital download. No physical item will be shipped.\u003c\/li\u003e\n\u003cli\u003eFor personal use only: use it for your own shop. You may gift one copy to one person. Please don't share, resell or redistribute the files or the Google Sheets links beyond that.\u003c\/li\u003e\n\u003cli\u003eNot tax advice. This spreadsheet is for your records; talk to a tax professional about your taxes, sales tax and deductions.\u003c\/li\u003e\n\u003cli\u003eEnglish only.\u003c\/li\u003e\n\u003cli\u003eColors may look slightly different on different screens.\u003c\/li\u003e\n\u003cli\u003eADHD-friendly by design: short steps, one place to type each thing, nothing hidden behind passwords.\u003c\/li\u003e\n\u003cli\u003eDesigned with the help of AI tools, then checked by hand.\u003c\/li\u003e\n\u003cli\u003eQuestions? Email us at lysansan24@gmail.com and we'll help.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eMORE FROM OUR SHOP\u003c\/h3\u003e\u003cp\u003eWant a budget for your home money too? See our \u003ca href=\"\/products\/simple-monthly-budget-spreadsheet\"\u003eSimple Budget Spreadsheet\u003c\/a\u003e, in light or dark mode. Busy season? Our \u003ca href=\"\/products\/task-project-tracker-spreadsheet-light-dark\"\u003eTask \u0026amp; Project Tracker\u003c\/a\u003e keeps every to-do in one list, and our \u003ca href=\"\/products\/holiday-budget-gift-tracker-spreadsheet-light-dark\"\u003eHoliday Budget \u0026amp; Gift Tracker\u003c\/a\u003e plans every gift.\u003c\/p\u003e","brand":"Holeless Digital","offers":[{"title":"Default Title","offer_id":59056201629960,"sku":"S-SMALLBIZ","price":22.09,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1060\/7329\/3064\/files\/11-small-business-bookkeeping.jpg?v=1791684882","url":"https:\/\/holelesshome.com\/products\/small-business-bookkeeping-spreadsheet-light-dark","provider":"Holeless Digital","version":"1.0","type":"link"}