DIY Accounting Spreadsheets

Excel bookkeeping and accounting software for UK small businesses

Payroll & PAYE

DIY Accounting Small Business Accounting Software UK

DIY Accounting small business accounting software for the UK is a set of free Excel spreadsheets for sole traders and limited companies. Each workbook turns a list of sales and a list of purchases into a monthly profit and loss account, VAT returns and, for a sole trader, an Excel copy of the self assessment return. It suits a business that is VAT registered and one that is not. The Basic Sole Trader, Self Employed and Company Accounts packages are free to download, and donations fund them.

Accounting Software Strengths

Accounting Software easy to use by non accountants requiring no previous accounting knowledge and is basically a list of sales and a list of purchases on preset excel spreadsheets. Each workbook is arranged as 12 monthly spreadsheets with preset columns and uses an entry code letter to analyse both sales and expenditure.

Cash and bank spreadsheets are included as optional extras for those businesses that require them with a built in automated bank reconciliation. The sheet is designed to be completed by copying the figures from the bank statement into the bank spreadsheet and the bank reconciliation is achieved by also entering the statement total which is automatically checked against the entries made.

Monthly profit and loss account also includes a financial health check based upon an automated tax forecast to enable businesses to monitor their financial performance. By entering drawings the package then compares the net profit made with the likely tax liability plus the drawings.

Quarterly vat returns are generated for vat registered business and is also suitable for non vat registered business. To produce a vat return clients simply go to the vat file and select the quarter end date from a drop down menu and the figures for the vat return are automatically generated.

The vat calculations can be disabled by non vat registered small businesses by simply changing the standard vat rate from standard rate (20%, GOV.UK: VAT rates) to zero making the accounting software suitable for both vat registered and non vat registered businesses.

The accounting package includes a stand alone sales invoice generator which requires invoices generated to be manually input into the sales sheet.

The fixed asset schedule is preset with the capital allowance tax rates to automatically calculate capital allowances when fixed assets are entered. Depreciation is also automatically calculated with preset percentages that can be changed as required.

A major benefit of using this small business bookkeeping software is the templates are arranged in such a way to automatically generate an excel copy of the self employed tax return. The excel self assessment tax return is arranged in the same layout as the official HMRC form with the same box numbers making it easy to copy the figures from one to the other for submission.

Accounting Software Weaknesses

The Self-employed accounting software UK is based upon single entry bookkeeping transactions and does not produce a balance sheet which is an optional requirement for self employed and therefore not a problem for the vast majority of businesses. DIY Accounting actually recommend clients who are self employed and wish to produce a balance sheet to use their Limited Company accounts package which does produce a balance sheet being based not on single entry bookkeeping but on double entry bookkeeping principles. The small business accounting software is suitable for a single tax year, and packages are available for tax years 2020 to 2021 up to 2026 to 2027. It does not cater for accounting periods other than April to April. There are benefits in anyone self employed adopting the standard April to April financial year as this avoids tax allowances from two separate years being a feature of the accounts. When used by small businesses using the cash accounting system the bookkeeping entries to the sales and purchase accounting spreadsheets must be entered according to the dates money is paid or received rather than the dates invoices were issued. At the end of the financial year any invoices not yet entered require to be listed to adjust the final profit and loss account figures. This a major disadvantage if using the vat cash accounting scheme rather than the Accounting Software being reviewed.

For a Limited Company

A limited company uses the Company Accounts spreadsheets. They list sales, purchases, bank and credit card entries, and a trial balance in the financial accounts file posts the double entry automatically, with an audit check. The package produces a monthly profit and loss account, a balance sheet and the statutory notes for the final company accounts. It also calculates capital allowances and the corporation tax liability, and a bank statement balance box checks each bank sheet. Opening debtors and creditors from the previous year go in as lists. The package is free to download.

Free to Download

The packages cost nothing to download. A voluntary donation funds their upkeep. The software can save many businesses the need to employ an accountant, which can save hundreds of pounds in professional fees.

Other Features

The product has a stock control feature to monitor any stock losses. The small business accounting software contains a wages interface that fully integrates the DIY Accounting Payroll Software when those files are saved into the same folder as the accounting software files. Being written on excel spreadsheets all transactions are visible and capable of being changed by for example overwriting any errors as opposed to a database system that requires new transactions to be entered to reverse previous entries. The sales and purchase spreadsheets include columns for entering CIS tax deductions and payments and the certificate numbers. The CIS tax being then automatically entered on the self employed tax return. As the small business accounting software is written on excel spreadsheets then it is essential that users have Excel 2007 or later installed to use the program. The accounting software also works fine with an open source spreadsheet package such as LibreOffice Calc.

Conclusion: Free and Easy to Use

Free, easy to use and needs no bookkeeping skills or previous accounting experience. It produces automated accounts and, for a sole trader, an Excel copy of the self employed tax return.

Editor's note (2025/26): Since April 2022, all VAT-registered businesses must submit VAT returns digitally through Making Tax Digital (MTD). Manual submission via the HMRC website is no longer available. DIY Accounting provides an MTD VAT submission service at submit.diyaccounting.co.uk. A free day pass gives you 3 VAT returns to try it. After that, the Resident VAT bundle costs £9.99 a year or £0.99 a month.

Tax reference: Self Assessment for the self-employed - Source: GOV.UK: self assessment tax returns; VAT standard rate: GOV.UK: VAT rates (applicable tax year 2026/27)

File with HMRC and Companies House

DIY Accounting Submit is HMRC recognised. It files VAT returns, and company accounts and confirmation statements to Companies House. £9.99 a year (£0.99 a month), with a free day pass to try it.

File with DIY Accounting Submit