Setup & configuration · Guide 03 of 53
Designing your chart of accounts
Your chart of accounts is the spine of every report. IQ Books anchors system behaviour to account roles, not codes, so understanding roles is the difference between books that just work and books that fight you.
Every line of every journal in IQ Books posts to an account in the chart. The wizard pre-loads a profile suited to your entity type, but you will almost certainly want to add, rename or archive accounts as your business takes shape. This guide explains the model.
Where to find it
Accounting → Categories shows your chart of accounts grouped by type (Asset, Liability, Equity, Revenue, Expense, Suspense), with sub-types within each. From here you can:
- Add a new account.
- Edit an account’s working label, code and default VAT treatment, and the answers LedgerIQ uses about it.
- Archive a custom account that you no longer need, then restore it if it becomes relevant again.
- See the role assigned to each system-anchored account.
Code, name, type, sub-type, role
An account has five fields you care about:
- Code. A short identifier like
2200or4001. Used by people who think in codes, ignored by IQ Books for system behaviour. - Name. Free-text, shown everywhere a category appears.
- Type. One of Asset, Liability, Equity, Revenue, Expense, Suspense. Determines whether the account appears on the P&L or balance sheet, and the natural debit/credit direction.
- Role. The system-behavioural anchor. Most accounts have no role (they are ordinary categories). A handful must exist with specific roles for the engine to function:
bank_control,accounts_receivable,accounts_payable,vat_control,retained_earnings,suspense,opening_balance_suspense.
Why role matters more than code
When IQ Books needs to post to (say) Accounts Receivable as part of a sales-invoice journal, it does not look for an account code — it looks for an account in your chart with role = accounts_receivable. This means you can rename, recode or restructure your AR account however you like, and the engine still finds it. Conversely, if you accidentally clear the role, the engine will refuse to post (and tell you which role is missing).
You will see the role of an account in the Categories list and in its edit panel. The role and type are deliberately read-only: changing either could silently reclassify old transactions or break automatic posting. You can still rename or recode the account without disturbing its accounting identity.
What the COA profiles give you
The wizard profiles install the following:
- All required system-role accounts (AR, AP, VAT control, retained earnings, suspense, opening-balance suspense) pre-tagged with the right role.
- A reasonable starter set of revenue and expense categories for the entity type. Limited company comes with Sales, Cost of sales, Wages, Rent, Utilities, etc. Property business comes with Rent received, Letting expenses, Mortgage interest, Repairs.
- Common balance-sheet accounts like Cash and equivalents, Stock, Equipment, Accruals, Prepayments, Director’s loan account, Share capital.
Adding accounts that match your business
- Click Add category in the top-right of the Categories workspace.
- Pick the type — this decides whether it lands on the P&L or balance sheet.
- Give it a code that fits your numbering convention, and a name.
- Save. Custom accounts have no protected system role.
- The new category is immediately available in dropdowns across invoices, bills, manual journals and bank rules.
Archiving
If you stop using a custom account, choose Archive on its row rather than deleting it. IQ Books first checks that the account has a zero ledger balance and is not still wired into a bank account, bank rule, draft document, unconfirmed bank draft, active stock item, fixed asset, recurring template or child account. This makes archive a deliberate retirement, not a way to strand future postings.
Archived accounts:
- Don’t appear in dropdowns when you are coding new transactions.
- Still show their historical postings on reports.
- Can be shown with Show archived and returned with Restore.
There is no destructive delete in the Categories workspace. Archive and restore are both written to the organisation audit log.
LedgerIQ’s answers about an account
When LedgerIQ analyses these books it needs a few answers the ledger does not record: which expenses are cost of sales, how much of a cost rises and falls with sales, whether an asset counts as cash, and whether a liability falls due within a year or is borrowing. It asks when it opens and saves each answer on the account, so it is asked once for the organisation, not once per analysis.
A row with saved answers shows them under the account’s name, for example LedgerIQ: cost of sales. Choose Edit on the row to change them under How LedgerIQ reads this account. Not answered clears an answer, and LedgerIQ then goes by the account’s posting role or asks again.
These answers change what LedgerIQ reports (gross margin, break-even, the cash calendar, gearing) and nothing else. They never change how the books post, and never change the account’s role. The same people who can post to the books can change them, and each change is written to the audit log. An analysis already open is told, and offers to refresh.
Related guides
Why IQ Books Sometimes Changes Your VAT Code
If you pick a VAT code on a line and IQ Books quietly resets it to Non-VATable with zero VAT, that is deliberate, not a fault. VAT can only ride on accounts that represent something you buy, sell or own — in other words expense, revenue and asset accounts. The instant a line points at a liability, equity or suspense account, IQ Books clamps the code to Non-VATable and forces the VAT amount to nil.
That is why coding a bank loan repayment, a VAT control movement, a director’s loan or a payment into the suspense account never carries VAT: there is no supply of goods or services behind those accounts, so there is nothing to reclaim or charge. The same rule runs on every screen that posts to the ledger — confirming a bank line, saving a manual journal, issuing a sales invoice or a purchase bill — so the behaviour is identical wherever you code.
The practical lesson for chart-of-accounts design: if you want VAT to flow on a particular kind of transaction, make sure it lands on an account whose type is expense, revenue or asset. Parking a VATable cost on a balance-sheet account by mistake is the usual reason a line shows no VAT when you expected it to.
Turning On Payroll Accounts
IQ Books does not seed payroll accounts by default, because most sole traders and freelancers have no employees. When you take staff on, switch the account set on rather than hand-building it.
- Open Settings, then the Organisation tab. Only an owner or admin can change this.
- Enable the payroll accounts toggle. IQ Books adds a curated set in one go: 225 PAYE & NIC, 226 Net Wages Control and 230 Pension Liability on the liabilities side, plus 550 Wages & Salaries, 555 Employer NI Contributions and 560 Pension Contributions on the expenses side.
- Post your monthly wages journal against them. Enter it by hand as an adjustment, or import it from your payroll software. A typical month with gross pay of £4,000, employer NI of £400 and employer pension of £120 posts as: debit 550 Wages & Salaries £4,000, debit 555 Employer NI £400, debit 560 Pension Contributions £120; credit 225 PAYE & NIC £1,320 (PAYE, employee NI and employer NI due to HMRC), credit 230 Pension Liability £280 and credit 226 Net Wages Control £2,920 (the take-home due to staff). Debits and credits both come to £4,520.
- Clear the control accounts as you pay. Paying staff clears 226, paying HMRC clears 225 and paying the pension provider clears 230 — each as a simple money-out against the bank.
Be clear about the limits: this toggle only provisions the accounts. IQ Books does not calculate PAYE or National Insurance, does not produce payslips and does not file RTI or an FPS with HMRC — you work those out in dedicated payroll software and enter the resulting journal here. Turning the toggle back off later simply hides these accounts from the pickers; it never deletes them, so any historic wage journals still resolve correctly.
Special-Purpose Accounts You Did Not Create
Alongside the accounts you set up, IQ Books maintains a handful of working accounts. Knowing what each is for saves a lot of head-scratching when one shows a balance.
- Suspense (999). Anything IQ Books cannot confidently categorise lands here. A balance in Suspense is expected behaviour, not an error — treat it as your ‘to sort’ tray. Clear it by recoding the underlying transactions to their proper accounts, at which point the suspense balance falls back to zero.
- Bank control accounts (100–199). Every bank account you add is backed by its own asset account in this range. If you do not name a code when adding a bank account, IQ Books reuses a spare one or takes the next free code here. One ledger account can back only one bank account, so you cannot point two banks at the same code.
- Conversion accounts (9998 for sales, 9997 for purchases). These appear when you migrate from Xero, QuickBooks or Sage. They temporarily hold the brought-forward debtor and creditor totals while your outstanding invoices and bills are re-created behind the control accounts. They net to zero once everything ties up; any small residue is reported to you honestly rather than swept out of sight.
- Retained earnings. Year-end close will not run unless an equity account carries the retained earnings role — that is where the year’s profit is swept. This is the clearest illustration of why role matters more than the number in front of it: IQ Books looks for the role, not for a particular code.
Mapping Your Accounts To The Statutory Formats
When you produce statutory accounts, every account has to line up with a standard caption in the chosen framework. IQ Books supports FRS 105 (micro-entity) and FRS 102 Section 1A (small company). Most of the mapping is done for you; the job is to check it and fix the odd account the software could not place.
- Let the auto-map run first. IQ Books matches your accounts to the statutory captions based on their type and role, so a well-designed chart maps almost entirely on its own.
- Override the ones it gets wrong. Set a per-account caption where you disagree with the automatic choice — useful for accounts unique to your trade.
- Resolve every non-zero unmapped account. Tagging is blocked while any account with a balance has no caption, so anything left over must be given one before you can finish.
Tagging is also blocked if the balance sheet does not balance or the company registration number is missing, so tidy those first. One honest caveat: the statutory accounts are read-only and never post anything back to your ledger, and IQ Books tags the figures and lets you download the iXBRL file — it does not submit the accounts to Companies House for you. A printed subtotal can also sit a pound away from the raw underlying total, because each line is rounded to whole pounds before the subtotals are added up.
Common Questions About Adding Accounts
The main flow for adding an account is covered above; these are the details people trip over.
- Who is allowed to add one? Owners, admins and bookkeepers. A member with view-only access cannot create accounts.
- Are there limits on the code and name? The code can be up to 20 characters and the name up to 255. The type must be one of the six recognised kinds — Asset, Liability, Equity, Revenue, Expense or Suspense — or the account is rejected.
- Does it force the code into the right range? No. The 100s, 200s, 500s and so on are conventions the built-in templates follow, not rules the software enforces on a manual add. You could put a new expense at code 150, but keeping to the usual ranges keeps your reports readable and predictable.
- Is there a record of what I added? Yes. A manually created account is flagged as user-created (rather than one of the system defaults) and the addition is written to the audit trail.
- How do I remove one I no longer need? Archive it rather than deleting it — see the Archiving section above. Archiving keeps historic journals intact while removing the account from the pickers going forward.