Can You Use Spreadsheets for Bookkeeping? 2026/27 Guide

Yes, a business can use spreadsheets for bookkeeping, but the spreadsheet must be accurate, secure and suitable for its tax and reporting obligations. A sole trader with simple records may manage well with a structured workbook. A growing company, VAT-registered business or MTD user often needs accounting or bridging software.

When spreadsheets can work well

A spreadsheet can be appropriate where the business has:

• a small number of transactions;
• one bank account and a simple ownership structure;
• few or no employees;
• limited stock or fixed assets;
• no complex VAT schemes or foreign transactions; and
• a competent person maintaining and reviewing the file.

The workbook should still support bank reconciliation, evidence, year-end adjustments and a clear audit trail.

What a bookkeeping spreadsheet should contain

At minimum, record:

• transaction date;
• customer or supplier;
• invoice or receipt reference;
• description and category;
• net amount, VAT rate, VAT and gross amount where applicable;
• payment date and bank account;
• business and private-use split;
• supporting-document location; and
• any correction with an explanation.

Use separate controlled tables for sales, purchases, expenses, bank activity, fixed assets, payroll journals and VAT where relevant.

Spreadsheets and Making Tax Digital

From 6 April 2026, qualifying sole traders and landlords with 2024/25 qualifying income above £50,000 entered MTD for Income Tax. Thresholds extend to more than £30,000 from April 2027 and more than £20,000 from April 2028.

A spreadsheet can be part of an MTD system when it maintains the required digital records and connects to HMRC through compatible bridging or submission software. A standalone workbook cannot submit quarterly updates unless it includes an approved connection.

Data moving between products must preserve the required digital links. Manual retyping or copy-and-paste between separate systems can breach the digital-link rules.

See the full Making Tax Digital bookkeeping guide.

Spreadsheets and VAT

VAT-registered businesses generally keep digital VAT records and submit through MTD-compatible software. A workbook may hold transaction data if:

• required VAT fields are recorded digitally;
• calculations and adjustments are controlled;
• the data connects digitally to compatible filing software; and
• records are retained for the required period.

Special VAT schemes, partial exemption, imports, reverse charges and multi-rate sales increase the risk of formula errors.

Main risks of spreadsheet bookkeeping

Formula and range errors

A formula can omit newly inserted rows, point to the wrong column or be overwritten with a value. Errors may remain invisible until tax, cash flow or accounts are wrong.

No reliable audit trail

Ordinary workbooks do not always show who changed a transaction, when or why. Save controlled versions and protect formula cells.

Duplicate or missing entries

Manual entry can duplicate invoices, omit bank transactions or transpose figures. Regular bank reconciliation is essential.

Weak access and backup controls

Emailing copies creates conflicting versions and exposes financial information. Use restricted cloud storage, multi-factor authentication and tested backups.

Poor scalability

As transaction volumes, staff and tax complexity grow, manual work can cost more than software and provide less reliable management information.

Spreadsheet versus accounting software

Controls for a reliable workbook

• Lock formula and heading cells.
• Use data validation for categories and VAT rates.
• Give every transaction a unique reference.
• Reconcile each bank and card account monthly.
• Compare control totals with returns and accounts.
• Keep a correction log rather than silently overwriting entries.
• Use one controlled master file.
• Restrict access and enable version history.
• Back up automatically and test recovery.
• Ask an accountant to review the design before relying on it.

When to move to software

Consider migrating when the business registers for VAT, hires staff, holds stock, trades internationally, adds users, needs departmental reporting, experiences recurring errors or enters MTD for Income Tax.

Plan the cutover at a month, quarter or year end. Reconcile all balances first and preserve the old workbook and source documents.

Frequently asked questions

Does HMRC require a particular accounting-software brand?

No. Where MTD applies, the product or combination must be compatible and meet digital-record and submission requirements.

Can receipts be stored outside the spreadsheet?

Yes, if the evidence is retained securely and can be linked to the recorded transaction. Digital copies should be legible and complete.

Is Excel automatically MTD compliant?

No. Excel or another spreadsheet requires appropriate records, digital links and compatible bridging or filing software.

Official source

Check HMRC’s Making Tax Digital for Income Tax guidance and current software requirements before choosing a system.