Self Employed Bookkeeping Spreadsheet UK – Sole Trader Cash Basis Excel Template
Self Employed Bookkeeping Spreadsheet UK – Sole Trader Cash Basis Excel Template
A practical self employed bookkeeping spreadsheet for UK sole traders, freelancers and small business owners who want to record income, expenses, invoices, stock, payroll support and monthly profit in Microsoft Excel.
Designed for simple cash basis bookkeeping, this Excel workbook helps self employed users keep organised records without monthly software subscriptions. Includes a user guide and clear workbook structure for day-to-day bookkeeping.
What is a self employed bookkeeping spreadsheet?
A self employed bookkeeping spreadsheet is an Excel workbook used to record business income, expenses, invoices, payments, stock records and profit summaries. It helps sole traders and self employed individuals keep their business records organised throughout the year.
This workbook is designed for UK self employed users who want a simple but structured bookkeeping system in Excel. It is especially useful for cash basis bookkeeping, where income and expenses are usually recorded when money is received or paid.
The template has been created by a UK-qualified bookkeeping template creator with a City & Guilds UK diploma in manual and computerised Sage Line 50 bookkeeping and accounting.
Who this sole trader bookkeeping spreadsheet is for
This Excel bookkeeping workbook is suitable for self employed individuals and sole traders who want to keep better records without using complicated accounting software.
- Self employed individuals
- Sole traders
- Freelancers
- Side business owners
- Small service businesses
- Users preparing for Self Assessment
- Businesses using cash basis bookkeeping
- Users who prefer Excel over cloud software
Cash basis bookkeeping for self employed users
Cash basis bookkeeping is a simple method where income is recorded when it is received and expenses are recorded when they are paid. Many self employed people prefer this method because it is easier to understand and manage.
This workbook helps users organise cash basis records in Excel by separating income, expenses, invoices, stock records and monthly summaries into a structured bookkeeping flow.
- Record income received
- Record expenses paid
- Track invoices and payments
- Monitor monthly profit
- Keep records ready for review and Self Assessment preparation
What is included in the self employed bookkeeping spreadsheet?
This workbook gives self employed users a practical Excel bookkeeping system for everyday record keeping. It is not just a blank spreadsheet; it is structured to help users record and review their business activity clearly.
- Cash basis bookkeeping workflow
- General entries structure
- Ledger-style tracking
- Profit and loss summary
- Income tracking
- Expense tracking
- Invoice and payment tracking
- Inventory and stock support
- Reorder list support
- Printable purchase order support
- Payslip and employee timesheet support
- Short-term liability tracking
- Amortisation support
- User guide included
- Onboarding checklist included with Premium
- Email guidance included with Premium
What records can you keep in this Excel workbook?
Self employed users need clear records of business income, expenses and supporting information. This workbook is designed to keep those records in one organised Excel file.
Sales and payments
Record business income, customer payments and invoice-related income in a structured way.
Business costs
Track business expenses so you can review costs, monthly profit and yearly totals more easily.
Inventory records
Use the inventory and reorder support to monitor products, stock activity and purchase needs.
Self Employed Bookkeeping Spreadsheet Packages
Choose the package that matches the level of support you need. All options use the self employed cash basis Excel bookkeeping workbook.
Premium
£59.00
Best for self employed users who want the workbook plus onboarding support and guidance.
- Cash basis bookkeeping workbook
- Income and expense tracking
- Invoice and payment tracking
- Inventory and reorder list support
- Printable purchase order support
- Payslip and timesheet support
- Onboarding checklist included
- Email guidance included
Standard Package
£49.00
Best for users who want the full workbook and quick start guidance.
- Same full workbook as Premium
- Cash basis bookkeeping structure
- Income and expense tracking
- Invoice and stock support
- Quick start steps included
- Protected helpers and print areas pre-configured
Template Only
£39.00
Best for confident Excel users who want the workbook immediately and prefer self setup.
- Ready-to-use cash basis workbook
- Income and expense sections
- Invoice and payment tracking
- Inventory support
- User guide included
- Suitable for self setup
Self Employed Bookkeeping Spreadsheet FAQs
Can a sole trader use Excel for bookkeeping?
Yes. A sole trader can use Excel to keep organised records of income, expenses, invoices, payments and business costs, provided the records are clear and complete.
Is this suitable for cash basis bookkeeping?
Yes. This workbook is designed for self employed users and sole traders who want a practical cash basis bookkeeping spreadsheet in Excel.
Does this help with Self Assessment?
The workbook helps organise income and expense records that may be useful when preparing Self Assessment information. It does not replace tax advice or HMRC filing guidance.
Does the workbook include a user guide?
Yes. The workbook comes with a user guide to help users understand the setup and workflow.
Do I need WooCommerce to buy this template?
No. Payments are handled securely through Stripe payment links.
Ask a Question About This Template