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:
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.
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.
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.
Charitable companies, companies included within group accounts and certain other companies are excluded from being micro-entities. Also excluded are limited liability partnerships.
Anyone with knowledge of preparing company accounts will be able to use the service, not just accountancy professionals.
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.
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.
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.
Yes, HMRC officially recognise Brankin Software Limited as a conversion software application provider.
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.
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.
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".
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.