Template

Download

Produce year end financial accounts and iXBRL format accounts for your micro-entity company with our template.

Involving the minimum accounting items required by Companies House and HM Revenue & Customs, the template offers a simple, money saving solution.

Your limited company will qualify as a micro-entity if, for the year, it does not exceed two of these thresholds:

  • Turnover threshold: £632,000
  • Balance sheet assets threshold: £316,000
  • Employees threshold: 10 on average

Note that companies within group accounts or charities cannot take advantage of this minimum accounting format.

To use the template you must have Microsoft Excel installed and use Windows operating system.

Download and save a copy of the template to your computer. Register as a new user either from the template, or by using the button below.

Once registered, you can choose to generate the year end accounts or convert the accounts to iXBRL format, all at the click of a button. The accounts are delivered direct to your computer in an instant, so you won't have to worry about emails with attachments going astray.

View the accounts in your web browser, print the Balance Sheet for Companies House, or attach the iXBRL format accounts to the Company Tax Return for HMRC.

The iXBRL service costs £20 per conversion, and you can buy conversion credits using the button below.

Register
Buy
FAQ's
Password must be 8 characters or more
Current credits :
Buy more conversions
1. What type of company can use your accounts template?

The template can be used by companies that are classed as micro-entities. A micro-entity is a company that meets two or more qualifying conditions in the reporting year. The qualifying conditions are that turnover does not exceed £632,000, Balance sheet assets do not exceed £316,000 and the number of employees does not exceed 10.

2. What if my company fails to meet the qualifying conditions?

If the company cannot meet qualifying conditions in the reporting year, it can still claim to be a micro-entity if it met those conditions in the immediately prior year. If the company cannot meet the qualifying conditions for two consecutive years, it will not be a micro-entity for these purposes.

3. What types of small company are excluded?

Charitable companies, companies included within group accounts and certain other companies are excluded from being micro-entities. Also excluded are limited liability partnerships.

4. Who can use the web service?

Anyone with knowledge of preparing company accounts will be able to use the service, not just accountancy professionals.

5. How does it work?

User enters accounts data for the company into a template created in Microsoft Excel. The template is a free download. User can then generate the statutory accounts or convert the accounts to iXBRL format by the click of a button. The accounts are electronically delivered to the user's computer and can then be saved locally. Delivery time will depend on the quality of user's internet connection and the number of other users accessing the system at the time. Email is not required in delivering the accounts.

6. What iXBRL tags are applied to the accounts data?

All data items in the accounts that require tagging for iXBRL are automatically tagged. Any data entered into a template cell which is pertinent to that cell will create a valid tag for that data. Where there is no obvious candidate cell for a particular data item, use of 'Other' item cells will normally be accepted by HMRC. The current template uses the UK gaap taxonomy, which applies for reporting years starting before 1 January 2016. Future updates to the template will use the new FRS taxonomy applicable to periods starting on or after that date.

7. How do I submit the iXBRL accounts to HMRC?

The iXBRL accounts file can be included as an attachment to the CT600 Company Tax Return, using either the HMRC online filing portal or proprietary Tax Return filing software.

8. Is the service recognised by HMRC?

Yes, HMRC officially recognise Brankin Software Limited as a conversion software application provider.

9. How much does it cost?

There is unlimited free use of the service to create the statutory accounts. The price to convert the accounts to iXBRL is £20.00 for a single iXBRL conversion credit, £45.00 for 3 for conversion credits or £80.00 for 6 for conversion credits. Credits can be purchased using PayPal.

10. Do I need any special software?

To use the service the pre-requisites are an up to date web browser and recent version of Microsoft Excel installed, on the Windows operating system. No other special software is required.

11. How do I print accounts without the browser headers and footers?

To print the statutory accounts without the web browser headers and footers, in the browser go to File > Page Setup, or in Chrome Print > Options. Set all headers and footers to "Empty" or "None".

12. How do I print the accounts in Microsoft Edge?

Use printer settings Paper size: A4, Margins: Normal, Scale: Shrink to Fit, Headers and footers: Off. To print as a PDF, click the top-right 3 dots symbol on the Edge browser and select Open with Internet Explorer. The accounts are displayed in IE, from where you can print using your PDF printer.

Ask