← All prebuilt solutions
Practice Tools

Trial Balance to Accounts Mapper

Paste a trial balance from any software – get statutory accounts figures under FRS 102 Section 1A or FRS 105

£20

Secure checkout. Your download link is sent as soon as payment clears.

Trial Balance to Accounts Mapper

Overview

Turning a trial balance into statutory accounts means mapping every account to the right heading, posting year-end adjustments, and then building a profit and loss account, balance sheet and notes in the format the Companies Act requires – for this year and last year. This workbook does that in one place. Paste up to 500 lines from any software, check the suggested mapping, post your journals, and the statements, notes figures and lead schedules build themselves. Switch between FRS 102 Section 1A (small companies) and FRS 105 (micro-entities) with one drop-down.

Price
£20
Who it’s for
Practice Tools
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

TB Import

The pasted trial balance with balances, suggested mapping, final heading and status. What you do: paste your TB; override headings where needed.

TB Import
Mapping Rules

Step 2

Mapping Rules

The statutory headings, code ranges and keywords used for suggestions. What you do: edit code ranges and keywords to match your chart of accounts.

Step 3

Journals

Corporation tax estimate, journal lines, checks and the reversals list. What you do: enter your journals.

Journals
Final TB

Step 4

Final TB

Every account after journals and tax, with its statutory line. What you do: nothing to enter.

Who it is for

Made for people like you

  • Example – text
  • Accountants and bookkeepers – A consistent, checked route from any client's TB to accounts figures, with an audit trail of every journal.
  • Company directors preparing their own accounts – Statutory-format figures you can use to complete your accounts software or check your accountant's draft.
  • Finance teams – Year-end lead schedules and a final TB to support the accounts file.
  • WATCH OUT – This workbook produces figures, not a filing. Accounts filed at Companies House and with the company tax return must be in iXBRL – use your accounts production or filing software for that.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter the company name, registration number and year end, choose the framework, and tell the workbook how your TB is laid out (debit and credit columns or one signed column, and which way round the signs are).
  2. TB Import – Export the trial balance from your software for this year and last year. Paste codes, names and balances into the yellow columns (Paste Special > Values).
  3. Check the mapping – Every line shows a suggested heading and how it was chosen. Fix anything red (Unmapped or Suspense) and look at anything amber (Check sign). Pick a heading in the override column to change a suggestion.
  4. Journals – Enter year-end adjustments – accruals, prepayments, depreciation, stock, dividends – one line per account. Each journal must balance. Enter disallowable expenses and capital allowances for the corporation tax estimate.
  5. Review the results – Look at the Dashboard checks, then the Profit and Loss, Balance Sheet, Notes and Lead Schedules sheets.
  6. Notes inputs – Enter fixed asset disposals, share details and directors' advances on the Notes sheet.

Key features

  • Paste up to 500 lines from any bookkeeping software – debit and credit columns or a single signed balance – with last year's figures alongside.
  • Every account mapped to a statutory heading by code range and keyword, with your own override, plus alerts for unmapped, suspense and odd-signed balances.
  • Year-end journals (accruals, prepayments, depreciation, stock, dividends) with balancing checks and a reversals list, plus an automatic corporation tax estimate.
  • Final trial balance, lead schedules with drill-down, statutory P&L and balance sheet for this year and last year, and figures for the notes.
  • Switch between FRS 102 Section 1A and the FRS 105 micro-entity formats in one click. Produces figures – not an iXBRL filing.

What’s included

  • Dashboard – Results and checks
  • Settings – Company, year end, TB layout, framework
  • TB Import – Paste your trial balance
  • Mapping Rules – Headings, code ranges and keywords
  • Journals – Year-end adjustments and tax
  • Final TB – After journals, with statutory lines
  • Lead Schedules – By heading, with drill-down
  • Profit and Loss – Statutory format
  • Balance Sheet – Statutory format
  • Notes – Figures for the notes
  • Tax Rates – Corporation tax rates
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions