{"product_id":"small-business-income-and-expense-tracker-52936","title":"Small Business Income and Expense Tracker Spreadsheet UK, Etsy Seller Bookkeeping, Profit and Mileage Log, Google Sheets \u0026 Excel","description":"\u003cp\u003eStop dreading your Self Assessment. Log your sales, costs and mileage as you go and let this calm little spreadsheet do the sums for you, all year round. ♡\u003c\/p\u003e\n\u003cp\u003e★ WHAT'S INCLUDED\u003cbr\u003e\n• Income \u0026amp; Expense Tracker (.xlsx) with 7 tabs: Instructions, Settings, Dashboard, Income, Expenses, Mileage, Monthly Summary\u003cbr\u003e\n• How-To-Use guide (PDF) for Google Sheets, Excel and your phone\u003c\/p\u003e\n\u003cp\u003e★ DETAILS\u003cbr\u003e\n• Set for the UK tax year (6 April to 5 April), months run 6th to 5th so totals line up\u003cbr\u003e\n• Income log with platform dropdown: Etsy, Shopify, TikTok Shop, Amazon, Website, In person, Other. Gross, fees and net\u003cbr\u003e\n• Expenses log with 11 HMRC-style allowable expense groups and a receipt kept Y\/N column (missing receipts turn pink)\u003cbr\u003e\n• Mileage log at 45p then 25p per mile after 10,000 miles, worked out automatically (rates are editable)\u003cbr\u003e\n• Monthly Summary with profit for each month, totals by expense category and income by platform\u003cbr\u003e\n• Dashboard with profit, profit margin, a tax pot guide, VAT threshold watch and four charts\u003cbr\u003e\n• VAT registered or not: a simple Yes\/No switch reminds you how to enter amounts\u003cbr\u003e\n• Soft sage and cream design, built with standard formulas only (no macros)\u003c\/p\u003e\n\u003cp\u003e★ PERFECT FOR\u003cbr\u003e\n• Etsy sellers and handmade businesses\u003cbr\u003e\n• UK sole traders, side hustles and small shops\u003cbr\u003e\n• Crafters, makers, small studios and print-on-demand sellers\u003cbr\u003e\n• Anyone who wants their numbers ready for Self Assessment or their accountant\u003c\/p\u003e\n\u003cp\u003e★ HOW IT WORKS\u003cbr\u003e\n1. Purchase and download the file from your Etsy Purchases page.\u003cbr\u003e\n2. Upload it to Google Drive and open with Google Sheets (or open in Excel \/ Numbers).\u003cbr\u003e\n3. Fill in Settings, then log sales, costs and mileage as you go. The summary and dashboard do the rest.\u003c\/p\u003e\n\u003cp\u003e★ PLEASE NOTE\u003cbr\u003e\n• This is a record-keeping tool, not tax or accounting advice. Please check with an accountant or HMRC if you're unsure.\u003cbr\u003e\n• This is a DIGITAL DOWNLOAD. No physical item will be sent.\u003cbr\u003e\n• For personal use only. Please don't share, resell or redistribute the file.\u003cbr\u003e\n• Works in Google Sheets (free), Microsoft Excel and Apple Numbers. A free Google account is all you need.\u003cbr\u003e\n• Colours may vary slightly between screens and devices.\u003cbr\u003e\n• Due to the nature of digital products there are no returns or refunds, but if anything isn't right please message me and I'll happily help.\u003c\/p\u003e\n\u003cp\u003eThank you for supporting a small UK business ♡ Hello Beautiful Designs\u003c\/p\u003e\n\u003cp\u003eThis spreadsheet was designed by me with the help of AI tools, and the mock-up images were also created with AI.\u003c\/p\u003e","brand":"HBDesignsandStickers","offers":[{"title":"Default Title","offer_id":57639856570743,"sku":"C037","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0558\/9532\/6801\/files\/il_fullxfull.8743033741_ibz0.jpg?v=1792920699","url":"https:\/\/www.hellobeautifuldesigns.co.uk\/products\/small-business-income-and-expense-tracker-52936","provider":"HBDesignsandStickers","version":"1.0","type":"link"}