Upgrade From Spreadsheets: Automated iXBRL & FRS 102

Key takeaway

A substantial number of UK accounting practices still prepare limited company accounts in Excel or similar spreadsheets — a workflow that was adequate when the main output was a Word-processed PDF sent to the client and Companies House. The modern accounts production environment has moved on: iXBRL tagging for HMRC is mandatory, FRS 102 has been revised, and clients expect faster turnaround and digital access. Spreadsheet-based accounts production does not scale, does not generate iXBRL-tagged outputs automatically, and does not connect to the bookkeeping and tax data that exists in the practice’s digital systems. BrightAccountsProduction provides a dedicated accounts production workflow — from trial balance import to iXBRL submission — that replaces the spreadsheet approach without requiring practices to overhaul their entire setup.

The spreadsheet persists in accounts production because it is flexible, familiar, and carries no additional licence cost. A practice that has been preparing accounts in Excel for fifteen years has templates that work, staff who know them, and a reasonable question: why change something that is already working?

The answer is not that spreadsheets have stopped working — it is that the environment around them has changed in ways that spreadsheet-based accounts production cannot easily accommodate. This post sets out what those changes are and what specialist accounts production software adds to the workflow.

What Has Changed in the Accounts Production Environment

iXBRL is mandatory for HMRC submissions. Since April 2011 for larger companies and April 2012 for the majority of companies filing CT600 returns, company accounts submitted to HMRC alongside the CT600 must be in iXBRL (inline eXtensible Business Reporting Language) format — a tagged digital version of the accounts that allows HMRC’s systems to extract and process the data automatically.

Spreadsheets do not produce iXBRL output. A practice preparing accounts in Excel faces one of two options: use bridging software that attempts to tag the spreadsheet-generated accounts (a time-consuming, error-prone process), or produce accounts in accounts production software that generates iXBRL natively. For practices still bridging, the overhead of the iXBRL tagging process is the single most powerful argument for switching to dedicated software.

FRS 102 has been revised. The revised FRS 102, effective for accounting periods beginning on or after 1 January 2026, introduces a new lease accounting model and updated revenue recognition requirements. Implementing these changes correctly in a spreadsheet-based accounts workflow requires manual updates to templates, manual calculation of right-of-use assets and lease liabilities, and manual construction of the new disclosures. In dedicated accounts production software, the revised standard is built into updated templates and calculation workings.

Clients expect digital access and faster turnaround. Client expectations have shifted. Practices competing for the same client base as technology-forward competitors are expected to provide draft accounts quickly, in digital format, with the ability to collaborate on queries and revisions without physical document exchange. Spreadsheet-based workflows can deliver this, but they typically require more manual effort to do so than dedicated accounts production software.

Data is increasingly available in digital form. The trial balance for a client using cloud bookkeeping (BrightBooks, Xero, QuickBooks) is available digitally. A practice with a direct connection between the bookkeeping platform and accounts production software can import the trial balance with a few clicks, rather than re-entering it from a paper printout or exporting and reformatting a CSV. The manual re-entry that spreadsheet-based accounts production requires is both a time cost and an accuracy risk.

What BrightAccountsProduction Adds to the Workflow

Trial balance import. BrightAccountsProduction supports trial balance import from leading bookkeeping platforms including BrightBooks, as well as CSV import for trial balances from other sources. For practices where the client’s bookkeeping is maintained digitally, this eliminates the manual re-entry of the trial balance — which for a set of accounts with 80 nominal codes represents meaningful time saved, and meaningful error risk removed.

Automated iXBRL generation. Accounts prepared in BrightAccountsProduction are automatically tagged in iXBRL format as a standard output of the accounts production process. The practice does not need to separately tag a completed accounts document — the iXBRL is produced alongside the accounts, ready for submission to HMRC with the CT600. For practices currently bridging spreadsheet accounts to iXBRL, eliminating this step is the most immediate time saving.

FRS-compliant accounts templates. BrightAccountsProduction provides accounts templates for FRS 102 (full standard and Section 1A for small companies), FRS 105 (micro-entities), and FRS 101 (reduced disclosure framework). The templates are updated when the relevant standards change — including the 2026 revised FRS 102. Practices do not need to maintain and update their own templates when the accounting standard changes; the updated template is available in the software.

Integrated working papers. For practices using MyWorkpapers (Bright’s cloud working papers platform), BrightAccountsProduction connects to the working papers for each set of accounts. Review points, queries, and sign-off actions in MyWorkpapers are linked to the accounts preparation process, providing an audit trail of the preparation and review workflow.

Companies House and HMRC filing. BrightAccountsProduction generates the full accounts for Companies House (filleted accounts for small companies) and the iXBRL-tagged accounts for HMRC submission alongside the CT600. Both outputs are produced from the same accounts preparation — there is no separate process for preparing the Companies House version versus the HMRC version.

Data flow from BrightTax. For practices using BrightTax for CT600 preparation, accounts figures from BrightAccountsProduction are available in BrightTax without re-entry — the profit figure, capital allowances, and balance sheet data flow from the accounts production to the tax computation. This connection reduces the duplication of effort that occurs when accounts and tax are prepared in separate, unconnected systems.

What the Switch Looks Like in Practice

Practices moving from spreadsheet accounts production to BrightAccountsProduction typically go through the following transition:

Template setup. The accounts templates in BrightAccountsProduction need to be configured for the practice’s style preferences — header information, groupings, and any specific disclosure text that is standard across the client base. This is a one-time setup activity, not a recurring overhead.

Staff familiarisation. Staff who have prepared accounts in spreadsheets for years are typically faster than expected at learning dedicated accounts production software — because the workflow is more structured and the software handles the iXBRL and formatting steps that were previously manual. Expect the first three to five sets of accounts in the new software to take longer than usual; by the tenth set, speed should be at or above the spreadsheet baseline.

Parallel running. For the first batch of accounts prepared in BrightAccountsProduction, running the accounts preparation in both the old spreadsheet and the new software, then comparing outputs, validates the configuration and builds confidence before the practice relies on the new software for submission.

Integration with existing systems. For practices already using BrightBooks or BrightTax, the integration between those systems and BrightAccountsProduction means the workflow improvement compounds — trial balance imports from BrightBooks, and figures flowing to BrightTax, reduce the total effort across the accounts-to-tax workflow, not just within accounts production itself.

Frequently Asked Questions

Do I need specialist accounts production software, or can I continue with spreadsheets?

The practical answer depends primarily on whether your current spreadsheet workflow produces iXBRL-tagged output for HMRC submissions, or whether you are using bridging software to add the iXBRL tagging step. If you are bridging, specialist accounts production software that generates iXBRL natively will save significant time. If you are not filing any CT600-accompanied accounts (for example, a practice that only handles sole traders and partnerships), the iXBRL requirement does not apply. For any practice preparing limited company accounts, dedicated software is the more efficient long-term approach.

How does BrightAccountsProduction handle the revised FRS 102 from 2026?

BrightAccountsProduction has been updated for the revised FRS 102, effective for accounting periods beginning on or after 1 January 2026. The updated templates include the new disclosures for right-of-use assets and lease liabilities, and the software supports the calculation workings for lease accounting under the revised standard — including the interest charge on the lease liability and the right-of-use asset depreciation. Comparative restatement for the transition year is also supported.

How long does it take to prepare a set of accounts in BrightAccountsProduction compared to a spreadsheet?

For a straightforward FRS 102 Section 1A set of accounts for a small limited company, with a trial balance imported digitally, experienced BrightAccountsProduction users typically report preparation times of one to two hours for the accounts production stage — comparable to a well-structured spreadsheet workflow. The difference is in the iXBRL output (automatic rather than a separate bridging step) and the accuracy of the FRS-compliant templates. For practices currently spending significant time on the iXBRL tagging step, the time saving is material.

Can BrightAccountsProduction work with bookkeeping data from platforms other than BrightBooks?

Yes. BrightAccountsProduction supports trial balance import from major bookkeeping platforms via CSV as well as through direct integrations. Practices with clients on Xero, QuickBooks, or other platforms can export the trial balance in CSV format and import it into BrightAccountsProduction, avoiding manual re-entry. The direct integration with BrightBooks provides the most seamless data flow for clients on the Bright platform.

Is BrightAccountsProduction suitable for sole trader and partnership accounts as well as limited companies? BrightAccountsProduction is primarily designed for the preparation of statutory accounts for limited companies and other entities with formal accounts preparation obligations. For sole trader and partnership tax returns, BrightTax handles the self-assessment and partnership returns, which typically do not require the same formal accounts format as limited company statutory accounts.

BrightAccountsProduction provides dedicated accounts production with iXBRL generation, FRS-compliant templates, trial balance import, and direct data flow to BrightTax — replacing the manual overhead of spreadsheet-based accounts workflows. Find out more about BrightAccountsProduction or speak to your account manager.

This content may have been developed with the assistance of AI tools. Content is reviewed by a member of the Bright team before publication. Guidance on legislation can be obtained from your industry body.