Watch the UK Accounting Template Excel in Action

Watch a full walkthrough of our UK accounting template Excel workbook for small to medium businesses. This video demonstrates how the double entry bookkeeping system works, how bookkeeping entries flow through the sheets, and how reports are generated automatically.

The workbook includes structured Excel tables, pivot tables and built-in filters that allow users to sort, filter and review data quickly. Separate sheets are included for reporting, so users can produce useful summaries from the accounts, payroll, invoices, liabilities and stock records.

• Built using Excel tables for structured bookkeeping and tracking
• Pivot tables for useful data analysis and summaries
• Filters to help produce reports quickly
• Separate sheets for reports and summaries
• Clear workflow from data entry to bookkeeping reports

What is included in this UK accounting template Excel workbook?

Our UK accounting template Excel workbook is a complete double entry bookkeeping system for small and medium businesses that want a clear and structured way to keep accounts in Microsoft Excel. It is built for UK bookkeeping and can be used for both VAT registered and non VAT registered businesses depending on the version and setup.

The workbook is designed so that transactions entered in the main data entry areas flow through automatically into the bookkeeping reports. This means the spreadsheet is not just a simple cashbook. It is a connected Excel accounting workbook that supports real bookkeeping workflows.

• Double entry bookkeeping in Excel
• Automatic ledger and trial balance updates
• Profit and loss and balance sheet reporting
• VAT tracking for VAT registered businesses
• Payroll tools including timesheets, PAYE, NI and payslip support
• Invoice and payment tracking for customers and suppliers
• Accounts payable and accounts receivable summaries ready for posting
• Inventory, stock movement and stock value support
• Short term liabilities and payment monitoring
• Asset depreciation schedule with posting dates, tracking and summary values ready for posting
• Structured sheets with protected formulas and guided data entry

Double Entry Excel Accounting Template for UK Business

The main workbook is a double entry accounting template in Excel for UK businesses that want control over their records. Instead of relying on software subscriptions, users can work in a structured workbook where bookkeeping entries are posted and the core reports update automatically.

Transactions are entered into the main bookkeeping entry sheet and then flow into the ledger, trial balance, profit and loss account and balance sheet. This creates a practical bookkeeping workbook for businesses that want an Excel accounting system with proper double entry logic rather than a basic one page spreadsheet.

The workbook is suitable for businesses that need to record sales, purchases, expenses, liabilities, stock transactions, payroll-related entries and VAT entries. It is particularly useful for owners who want visibility over how bookkeeping entries affect reports.

• GENERALENTRIES for bookkeeping postings
• LEDGER updated automatically from the entries
• TRIAL BALANCE for checking balances
• P&L and BALANCE SHEET driven from the bookkeeping data
• Clear account structure and posting flow for UK businesses

VAT Registered and Non VAT Registered Bookkeeping in Excel

One of the main strengths of this UK accounting template Excel workbook is that it supports both VAT registered and non VAT registered bookkeeping. For VAT registered businesses, the workbook supports output VAT, input VAT, VAT liability tracking and VAT-related bookkeeping postings. For non VAT registered businesses, the bookkeeping remains simpler while still keeping proper accounting records.

Businesses that are VAT registered can use the workbook to monitor invoice values, VAT values and gross totals, while maintaining clear double entry accounting. This helps business owners see both the operational side and the bookkeeping side in one place.

This makes the workbook useful both as a UK VAT bookkeeping spreadsheet and as a non VAT bookkeeping spreadsheet depending on the needs of the business.

Payroll, Payslips and Wages Tracking

The workbook also includes payroll support through the employee timesheet and payroll-related sheets. It can handle employee hours, daily rate workers, hourly rate workers and monthly salary workers depending on how the timesheet and payroll setup is used.

Payroll data can be summarised into weekly or monthly pay periods and used to calculate gross pay, PAYE tax, employee National Insurance, pension and other deductions. That payroll information can then be used for payslips and for posting payroll-related double entry journals into the bookkeeping records.

This makes the workbook more than just a bookkeeping spreadsheet. It becomes a connected Excel payroll and accounting workbook for UK businesses that need wages tracking as part of their bookkeeping process.

• Employee time tracking
• Gross wages calculations
• PAYE and employee NI calculations
• Pension and deduction support
• Payslip support for weekly and monthly payroll
• Payroll summaries ready for bookkeeping posting

Inventory, Invoices, Accounts Receivable and Accounts Payable Tracking

The workbook also supports practical day-to-day business administration. It includes stock and inventory related features, invoice payment tracking and payment logging. This allows users to connect their bookkeeping with real business operations.

Inventory IDs, item categories, item descriptions, prices, purchase prices and SKU data can be stored and used to support stock tracking and reporting. Stock movement sheets can be used to show stock in and stock out activity, while inventory summary sheets can show live stock balances and stock values.

For customer invoices and supplier invoices, the workbook includes invoice payment tracking so that users can record invoices and then log payments separately. The payment tracking structure can be used to monitor balances due, overdue invoices, payments received, payments made, customer receivables and supplier payables. Summary reports can then be used to review accounts receivable and accounts payable with due dates, posting dates and outstanding balances ready for bookkeeping posting.

• Customer invoice payment tracking
• Supplier invoice payment tracking
• Outstanding balance monitoring
• Overdue payment visibility
• Inventory and stock movement support
• Useful for bookkeeping, stock control and cashflow monitoring

Accounts Payable, Accounts Receivable and Asset Depreciation Reports Ready for Posting

This UK accounting template Excel workbook does not just help with bookkeeping entry. It also includes summary reports that help you prepare accurate accounting postings. That means users can move from day-to-day record keeping into structured bookkeeping journals more easily.

The workbook includes support for accounts payable summary reporting, accounts receivable summary reporting, and asset depreciation tracking. These reports are useful for businesses that want Excel bookkeeping spreadsheets that do more than simple data entry.

Accounts receivable summary report

Customer invoices can be logged and then matched against payments received. This creates an accounts receivable summary that helps track invoice balances, amounts received, outstanding amounts, overdue balances and posting dates. It is useful for businesses that want a clear receivables report in Excel and want to monitor who still owes money and when payment is due.

• Customer invoice tracking
• Payments received matched against invoices
• Outstanding balances and overdue amounts
• Posting dates and due dates visible for review
• Useful for receivables control and bookkeeping posting

Accounts payable summary report

Supplier invoices can also be tracked in the workbook. This creates an accounts payable summary showing supplier names, invoice dates, due dates, posting dates, payments made and outstanding balances. This is useful for businesses that want to manage creditors, supplier liabilities and payment timing within an Excel bookkeeping workbook.

• Supplier invoice tracking
• Payments made matched against supplier invoices
• Outstanding creditor balances
• Due dates, payment due reporting and posting dates
• Useful for accounts payable control and liability monitoring

Asset depreciation schedule ready for posting

The workbook also supports asset depreciation tracking in Excel. Fixed assets can be recorded with purchase date, cost, useful life, residual value, monthly depreciation, accumulated depreciation, remaining periods and last depreciation date. This helps businesses keep track of asset value reduction and prepare depreciation entries properly.

The depreciation section is designed to support posting-ready summaries with period tracking. This means users can see which assets are active, which posting dates apply, how many depreciation postings remain, and what the monthly depreciation expense is for the period.

• Asset register and depreciation schedule
• Straight line depreciation calculations
• Monthly depreciation expense ready for posting
• Accumulated depreciation and net book value tracking
• Posting dates, remaining periods and last depreciation date

These features make the workbook useful not only as a UK bookkeeping spreadsheet, but also as a practical Excel accounting system for businesses that need payable reports, receivable reports and depreciation schedules alongside the main accounts.

Hairdresser and Salon Bookkeeping Template in Excel

Our double entry accounting workbook is also available in an adjusted version for hairdresser and salon businesses. This is useful for salons, barbers, beauty businesses and chair rental setups that need more tailored record keeping.

The hairdresser bookkeeping template is based on the same strong bookkeeping logic but is adjusted for salon operations. Depending on the setup, this can include tracking related to bookings, services, stock, employee activity and salon-specific business workflows. It is useful for businesses that want an Excel salon bookkeeping spreadsheet rather than a generic accounting file.

If you run a salon and want a hairdresser accounting spreadsheet, salon bookkeeping template or Excel salon accounts template, this version is designed to be more relevant to your day-to-day work.

Buy Hairdresser Bookkeeping Template

Self Employed Cash Basis Bookkeeping and UK Calculators

In addition to our double entry accounting workbook for businesses, we also provide bookkeeping spreadsheet workbooks for self employed users. These are especially useful for cash basis bookkeeping, simpler income and expense tracking, and preparing for Self Assessment.

Our self employed bookkeeping spreadsheets are designed for users who want a practical Excel workbook for cash basis bookkeeping without overcomplicating the process. This makes them useful for sole traders, freelancers and self employed people who want a straightforward bookkeeping spreadsheet they can understand and control.

We also provide useful UK calculators on our website, including a Self Assessment tax return calculator UK and a take home pay calculator UK. These tools are useful for self employed people, workers and business owners who want quick estimates while planning their income and tax position.

• UK Self Assessment Tax Return Calculator
• UK Take Home Pay Calculator – Hourly, Weekly and Monthly

These tools support visitors who are looking for a UK self assessment calculator, self employed tax estimate calculator, take home pay calculator, wages calculator UK, self employed bookkeeping workbook and cash basis bookkeeping spreadsheet.

Who this Excel accounting template is for

This UK accounting template Excel workbook is useful for business owners who want structured bookkeeping without relying entirely on cloud software. It is particularly suited to people who want to understand their numbers, keep control over their records and use practical spreadsheet-based systems.

• Small UK businesses
• Medium sized businesses needing spreadsheet-based bookkeeping
• VAT registered businesses
• Non VAT registered businesses
• Salon and hairdresser businesses
• Businesses with stock and inventory
• Businesses that want payroll support within Excel
• Self employed users who want cash basis bookkeeping tools
• Owners who want clear bookkeeping workbooks and accounting templates

Buy the UK Excel accounting template

If you need a UK accounting template Excel workbook with double entry bookkeeping, VAT support, payroll support, stock tracking, accounts payable and receivable summaries, invoice payment tracking and asset depreciation tracking, this workbook is built to give you a practical bookkeeping system in Excel.

Buy Double Entry Accounting Workbook Template

Related pages on our website

• Take Home Pay Calculator UK
• Self Assessment Tax Return Calculator UK

If you are looking for an Excel accounting template UK, UK bookkeeping spreadsheet, double entry bookkeeping Excel template, VAT bookkeeping spreadsheet, hairdresser bookkeeping template, salon bookkeeping spreadsheet, self employed cash basis bookkeeping workbook, self assessment calculator UK or take home pay calculator UK, explore the tools and templates available across our website.