UK Sole Trader Bookkeeping & Self Assessment Spreadsheet
★ Finally, bookkeeping that actually makes sense — and it's built around UK tax. ★Running yourself ragged with shoeboxes of receipts and a tax return you're dreading? This simple, done-for-you spreadsheet keeps your whole year in one place and estimates your Self Assessment tax bill automatically — no accounting jargon, no complicated software.Built by a UK accountancy professional. Designed for sole traders, freelancers, Etsy sellers, tradespeople and side-hustlers.WHAT'S INSIDE (6 tabs)✔ START HERE — a plain-English 4-step guide, so you're set up in minutes✔ Income Log — record every payment; the month fills in automatically✔ Expense Log — categorise costs with HMRC-aligned dropdowns✔ Mileage Log — auto-calculates your claim (45p/25p per mile)✔ Self Assessment Summary — your profit + estimated Income Tax & Class 4 NIC, live✔ Categories — easy dropdown lists you can editWHY YOU'LL LOVE IT• UK-specific — real HMRC expense categories and 2025/26 tax bands (most templates are US!)• Automatic tax estimate — see what to set aside as you go, no nasty January surprise• Editable rate cells — update the figures each April and reuse it every year• Colour-coded — blue = type here, black = automatic. Impossible to break the formulas• Works in Microsoft Excel AND Google Sheets (free) — just upload and goINSTANT DIGITAL DOWNLOADYou'll get one .xlsx file immediately after purchase. No physical item is shipped. To use in Google Sheets (free): File → Import → Upload, then "Replace spreadsheet".PLEASE NOTEThis is a bookkeeping tool and tax estimate, not personalised tax advice. The estimate assumes self-employment is your only taxable income. Always confirm figures with HMRC or a qualified accountant before filing. Due to the digital nature of this product, no refunds can be offered once downloaded — but message me with any questions, and I'll help.Thank you for supporting a small business! ♥
Get it → biztoolkitstudio.gumroad.com