{"product_id":"sole-trader-books","title":"Sole Trader Books","description":"\u003cp\u003eA bookkeeping spreadsheet for sole traders, freelancers and online sellers, for Excel and Google Sheets — log income, expenses, mileage and working-from-home, and see your year sorted into four quarters with MTD-style quarterly summaries. Optionally paste a privacy-safe summary into the AI assistant you already use.\u003c\/p\u003e\n\u003cp\u003eBuilt for sole traders, side hustlers and makers selling on Etsy, Shopify, Vinted, eBay, their own website or at craft fairs. Built-in references follow UK rules (April–March tax year, SA103 expense boxes); pick £, $, € or no symbol on the Start Here tab. It changes the symbol only and never converts amounts.\u003c\/p\u003e\n\u003ch3\u003ePreview — see how it works\u003c\/h3\u003e\n\u003cp\u003eSee how it works before you buy — open the \u003ca href=\"https:\/\/docs.google.com\/spreadsheets\/d\/18oLR22OLNHJwWdHr8lFQh7-Y9v-PDw0aNc3HtvNz5wE\/edit?usp=sharing\" target=\"_blank\" rel=\"noopener\"\u003eread-only example\u003c\/a\u003e (Fernhill Paper Co. sample data). Viewers can’t edit; make a copy or use the Blank after purchase.\u003c\/p\u003e\n\u003ch3\u003eWhat's included\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBlank workbook ready for your own figures\u003c\/li\u003e\n  \u003cli\u003eFilled example workbook (fictional business and figures) so you can see how it works\u003c\/li\u003e\n  \u003cli\u003eREADME (PDF) with setup steps for Excel, Excel for the web, Google Sheets and LibreOffice\u003c\/li\u003e\n  \u003cli\u003eAsk AI tab: builds a paste-ready summary of your year rounded to the nearest 10, with no customer names or bank details\u003c\/li\u003e\n  \u003cli\u003eAI Prompt Pack (PDF) with 12 ready-made prompts, including Fix-my-sheet\u003c\/li\u003e\n  \u003cli\u003ePrivacy and AI Safety Card (PDF)\u003c\/li\u003e\n  \u003cli\u003eAssistant Setup text, an optional Claude Skill, and an optional Power Users guide for Gemini in Sheets \/ Copilot in Excel (may need a paid plan)\u003c\/li\u003e\n  \u003cli\u003eLicence file\u003c\/li\u003e\n  \u003cli\u003ePreview images of the main tabs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eTwelve tabs: Start Here, Setup, Dashboard, Ask AI, Income Log, Expense Log, CSV Import, Mileage Log, Use of Home, Quarterly Summary, SA103 Mapping, and Tax Year Close.\u003c\/p\u003e\n\u003ch3\u003eAsk AI (optional)\u003c\/h3\u003e\n\u003cp\u003eThe Ask AI tab uses ordinary spreadsheet formulas only — nothing is sent anywhere from the file. Copy a prompt and paste it into \u003cstrong\u003eyour own\u003c\/strong\u003e ChatGPT, Claude, Gemini, Copilot or similar. There is no hosted Avella AI and no Custom GPT included. Read the Privacy card before you paste anything. AI replies can be wrong; the assistant is an organising helper, not a tax adviser or accountant, and its replies are not tax advice. The sheet is always the source of truth.\u003c\/p\u003e\n\u003ch3\u003eWhat you can do\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIncome Log (1,000 rows) for sales, payouts, refunds and platform fees\u003c\/li\u003e\n  \u003cli\u003eExpense Log (1,000 rows) with categories, business % for mixed-use costs and a receipt tick\u003c\/li\u003e\n  \u003cli\u003eCSV Import to speed up logging from a platform statement or bank CSV\u003c\/li\u003e\n  \u003cli\u003eMileage Log at an editable rate per mile, and Use of Home by flat rate or share of bills\u003c\/li\u003e\n  \u003cli\u003eMTD-style quarterly summaries and year-to-date totals by expense box\u003c\/li\u003e\n  \u003cli\u003eExpenses grouped under SA103S \/ SA103F self-employment boxes, plus a trading allowance comparison (an organising check only, not a recommendation)\u003c\/li\u003e\n  \u003cli\u003eDashboard with turnover, expenses, a profit estimate and data checks; end-of-year checklist and key UK dates\u003c\/li\u003e\n  \u003cli\u003eNo macros, no scripts and no external connections\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eWhat you need\u003c\/h3\u003e\n\u003cp\u003eExcel 2016 or later, free Excel for the web, a free Google account for Google Sheets, or free LibreOffice Calc. An AI assistant is optional and is your own account if you use one. Not designed for limited companies, partnerships or VAT returns.\u003c\/p\u003e\n\u003ch3\u003eImportant\u003c\/h3\u003e\n\u003cp\u003eThis spreadsheet is an organisation and record-keeping tool. It is not tax, accountancy, legal or financial advice. It is not HMRC software, it does not file anything with HMRC and it does not work out your tax bill. If Making Tax Digital for Income Tax applies to you, you will need compatible software to send quarterly updates; this workbook keeps MTD-style quarterly summaries so your figures are organised and ready to check. Check current rules on GOV.UK (www.gov.uk\/self-assessment-tax-returns), get free guidance from MoneyHelper (www.moneyhelper.org.uk), and speak to an accountant or tax adviser about your own situation. Example figures are fictional.\u003c\/p\u003e\n\u003ch3\u003eDigital download\u003c\/h3\u003e\n\u003cp\u003eThis is a digital product, delivered instantly after payment. Nothing is posted. At checkout you confirm that you want immediate access to your digital download and that you understand you lose your 14-day right to cancel once the download starts. If a file is faulty or isn't as described, email \u003ca href=\"mailto:hello@avellasmart.com\"\u003ehello@avellasmart.com\u003c\/a\u003e and we'll put it right. Your legal rights are not affected. See our \u003ca href=\"\/policies\/refund-policy\"\u003eRefund policy\u003c\/a\u003e.\u003c\/p\u003e\n\n\u003cp\u003eSupport: \u003ca href=\"mailto:hello@avellasmart.com\"\u003ehello@avellasmart.com\u003c\/a\u003e\u003c\/p\u003e\n","brand":"Avella Smart","offers":[{"title":"Default Title","offer_id":64168760049994,"sku":"AS-STB-V1.1","price":14.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0892\/8185\/5818\/files\/avella-sole-trader-books-cover-square-v2.0.jpg?v=1793902609","url":"https:\/\/avellasmart.com\/products\/sole-trader-books","provider":"Avella Smart","version":"1.0","type":"link"}