Skip to the guide
IQ Booksby ReconcileIQ

Reports & closing · Guide 42 of 53

Reading the reports and closing the year

A guided tour of every report in the suite, what each one tells you, when to use which. Plus the year-end checklist and close.

Reports are where the ledger answers questions. The Reports tab holds them all, grouped by purpose. This guide explains each, when you’d use it, and the gotchas to watch for. Then the year-end close workflow ties it all together at period-end.

Statutory reports

Trial balance

Reports → Trial balance. The full chart of accounts with closing balances, organised by type. The debits column equals the credits column; if it does not, something was posted wrongly and is worth looking into.

Use cases: month-end and year-end review, accountant handover, debugging a P&L that looks wrong.

Profit & loss

Reports → P&L. Income minus expenses for a period, account by account. Revenue at the top is sales (turnover). Where the books have them, cost of sales comes off revenue to give gross profit; other operating income (grants, sundry income) joins it and operating expenses come off to give operating profit; interest received, finance costs (interest paid) and tax sit below it, with profit before tax between them. Interest, other income and the corporation tax charge are placed by their role in the chart (or their name), whatever their codes. P&L by month lists all income together as Total income.

It opens on the financial year so far. Type the dates, or use This month, Last month, This quarter, This FY or Last FY. Every row opens the entries behind it. For two periods side by side, use Period comparison; for one project, Project P&L.

What the figures say

Above a single-period P&L, What the figures say puts it in sentences: income and the result against the period before of the same length (a quarter against the quarter before; a period longer than a quarter, such as a year to date, against the same period a year earlier), the gross margin where there is cost of sales (margins are worked out on revenue, the sales at the top of the P&L, not on interest or other income), the biggest changes, costs new this period and costs that stopped, and a single entry that makes most of a cost that rose (a one-off, with the result without it and a link to the entry; a cost posted most months, such as rent, is never one). It is worked out from the same figures by rules, costs nothing, and prints and downloads with the statement. Ask RiQ to explain writes a fuller note from the same figures for 25 credits (nothing is taken if it cannot be written); it is for people who can change the books.

Report pack

Reports → Report pack emails a management pack on the first working day after each month (or each of your financial quarters), from 7am: one PDF built from the books as they stand that morning, with the profit and loss and what the figures say, the balance sheet, cash flow, aged debtors and creditors, and the VAT return for VAT-registered books (choose which). It goes to the members of the books you tick and to any other addresses (your accountant, a director, a lender) once an owner has confirmed them: an admin can add an address, and it waits until an owner opens the page and saves. Members get it on any plan; emailing other addresses comes with a plan that includes invoice email. It is off until you switch it on, costs no credits, and the page shows what each recipient got last time. Download last month’s shows the pack before it goes.

Profit & loss by month

Switch the toggle at the top of the P&L from Single period to By month and the statement pivots into the columnar grid practices live in: one column per calendar month across your chosen window (up to 36 months), a pinned account column on the left, and a period total on the right.

  • Zeros are dimmed to a dot so the shape of the year reads at a glance: a gap in the grid is information.
  • Every account row still drills: click it to open View Transactions filtered to that account.
  • The net profit row runs month by month along the bottom, teal when positive, coral when negative, closed with the accounting double-rule.
  • CSV export and Print work exactly as they do on the single-period statement.

Use cases: spotting the month a cost crept in, seasonality at a glance, management-accounts packs, and the “can you send me the monthly P&L” every accountant asks for.

Balance sheet

Reports → Balance sheet. Snapshot of assets, liabilities and equity at a point in time. Total assets equals liabilities plus equity (the fundamental accounting equation).

Type the date, or use Today or Last FY end. Assets are grouped by each account’s role in the chart: current assets, fixed assets (cost less accumulated depreciation), investments, and anything else under other assets. The groups always add up to total assets.

VAT return

Reports → VAT return. The 9-box HMRC VAT return format for the UK. Pulls from VAT-coded transactions in the period:

  • Box 1: VAT due on sales
  • Box 2: VAT due on EC acquisitions (rare since Brexit; usually zero)
  • Box 3: total VAT due (1+2)
  • Box 4: VAT reclaimed on purchases
  • Box 5: net VAT to pay or reclaim (3-4)
  • Box 6: total sales (excl. VAT)
  • Box 7: total purchases (excl. VAT)
  • Box 8 / Box 9: EC dispatches and acquisitions

Pick the period and click Run, or use Prepare this period on an open HMRC obligation. Tick the declaration and Submit VAT return to file it with HMRC. Once a period is filed it is locked: anything that would change its VAT is refused, and a correction goes on a later return as a VAT adjustment.

Operational reports

Aged debtors

Reports → Aged debtors. Outstanding customer balances aged into Current / 1-30 / 31-60 / 61-90 / 90+ buckets. Worked out live from the open invoices; the total agrees with Accounts Receivable on the trial balance.

Aged creditors

Reports → Aged creditors. The supplier-side equivalent. What you owe whom and how old it is.

Statements

Reports → Statements. Customer-facing statements of account, ready to email. Drill to a customer for their full statement; one click to email.

Activity reports

Sales by customer

Reports → Sales by customer. Revenue grouped by customer for a period. Sorted by total descending. Useful for concentration analysis and customer-tier review.

Purchases by supplier

Reports → Purchases by supplier. The mirror: spend grouped by supplier. Same shape; useful for negotiation prep and supplier-base review.

Period comparison

Reports → Period comparison. Two periods side-by-side, with absolute and percentage variances by account. Pick any two periods (this month vs. last month, this quarter vs. same quarter last year, etc.).

Cash flow

Reports → Cash flow. The cash movement for the period, decomposed into Operating / Investing / Financing activities. Different from a P&L because it shows what cash actually moved, not what was earned in accruals terms.

Project P&L

Reports → Project P&L. A P&L sliced by project tag. See the projects guide.

Analysis (LedgerIQ)

Reports → Analysis opens LedgerIQ over these books: 44 modules covering ratios, trends, anomaly detection, what-if scenarios and business valuation, built straight from the ledger with nothing to export. Opening a period draws 1,000 credits; opening the same period again within 24 hours, by anyone with access to the books, is free.

Some of LedgerIQ’s figures also appear in IQ Books itself, worked out by the same calculations, at no charge:

  • Dashboard: a 13-week cash outlook, week by week, with the lowest point.
  • Customers and suppliers: how they pay, or how you pay them, on time and in days.
  • Products: days of stock at the rate each item went out over the last twelve months.
  • Projects: margin and unbilled work.
  • Clients (practices): weeks of cash, debtor days and targets off course for each client.
  • RiQ quotes these figures when you ask about cash, who to chase or how a target is doing, and raises a notice when cash is forecast to go below zero within 13 weeks or a scorecard target goes red.

Beside the 44 modules, LedgerIQ on IQ Books books has Your Books, State of the Books at the top of its sidebar: how far the books are written up, what waits in Review, the period-end checks, findings to act on, what RiQ has found (which can be dealt with there), the deadlines ahead with the payment the cash calendar expects, and what changed since the last analysis. Each line opens its fix in IQ Books.

Some modules go deeper on IQ Books books: Tax Efficiency explains what changed on the VAT return against the period before and a year earlier, and what is worth a second look before filing; the Examination Pack tests segregation of duties and bank reconciliation; Credit Risk uses the loan repayments and interest actually in the books.

The answers LedgerIQ asks for (cost of sales, cash, when a liability falls due) are saved on the chart of accounts; see the chart of accounts guide.

Year-end close workflow

Accounting → Year-end close starts with Before you close: a checklist worked out from the books for the year to the close date you pick, every time you open it, so it cannot drift from what is really there. Each item is done, not done or does not apply, and each one not done says why and has a button to the screen where you fix it:

  1. Nothing still in Review. Lines waiting in a bank’s Review drafts are not in the ledger, so the year is short by them.
  2. Prepayments, accruals and deferred income posted up to the year end (Prepayments and accruals).
  3. Depreciation charged on every live asset up to the year end, and the asset register agreeing with the asset accounts (Fixed assets).
  4. Stock counted at the year end, where you keep stock: every product holding stock covered by a stocktake posted within a fortnight of the year end.
  5. No draft invoice or bill dated in the year.
  6. Nothing posted with a future date.
  7. VAT reviewed on purchases posted without VAT, where you are registered. Costs that never carry VAT (wages, pensions, depreciation, interest, insurance, bank charges, rates and the like) are left out.
  8. The opening position ties: the opening balances balance and nothing is posted before them.
  9. Nothing left in suspense or opening balance equity.
  10. Journals set to reverse in the year have reversed (Reverse on), so no accrual meant to come out is carried into next year.

Three checks are judgement rather than arithmetic: VAT on purchases, stock and the asset register. When one is right as it stands (the purchases really carry no VAT, say), use Mark reviewed and say why in a few words; it then counts as done for that year, shows who marked it and when, and Undo puts it back. The other checks have a right answer in the books, so they are done by fixing what they point at.

The checklist warns; it never stops you closing. When you close with items not finished, the confirmation says how many. From 30 days before your financial year end (change it in Settings, Automation) until the year is closed, What RiQ found shows the same list as a notice, so the work starts before the year end rather than after it; its Open Year-end close opens this page on that year.

Closing then works out the closing journal (Preview shows it: the profit or loss for the year moved to retained earnings) and locks the period: nothing dated on or before the close date can be posted afterwards. The close itself can be dated today at the latest, as a lock in Settings can. For a later date, the coming year end say, Preview shows that year’s checklist, Mark reviewed included, and no closing journal: A period can be locked up to today, not after it. FX revaluation and any final adjustments are journals you post before closing.

Audit log

Settings → Audit log is your forensic record: every change to every record, with who did what and when. Filter by entity type, user, date. Useful when something looks wrong and you need to retrace.

Related guides

The Ten VAT Codes And When To Use Each

Every line you code carries a VAT code. The code decides how much VAT IQ Books works out and which box of the return the figure lands in, so it is worth knowing the whole set. Five codes cover everyday trading:

  • ST — Standard rate (20%). The default for most goods and services you buy or sell.
  • RR — Reduced rate (5%). Domestic fuel and power, children’s car seats, certain energy-saving materials and similar reduced-rate supplies.
  • ZR — Zero-rated (0%). Taxable but charged at nothing — most food, books and newspapers, children’s clothing, public transport, prescription medicines. It still appears on the return, which is what separates it from exempt.
  • EX — Exempt. Supplies that carry no VAT and sit outside the taxable base — insurance, finance and credit, education, postage, some property. Use this rather than zero-rated when the supply is genuinely exempt.
  • NV — No VAT / outside the scope. For anything that is not a VAT supply at all — wages and PAYE, dividends and drawings, transfers between your own accounts.

The remaining codes are the reverse-charge family. On these the document shows no VAT of its own — only the net amount — because you and the other party each self-account for the VAT as equal and opposite entries on your returns. Do not expect to see VAT sitting on a reverse-charge invoice:

  • RC & RCS — Reverse charge on services. Used when you buy services from, or sell services to, a business in another country.
  • PVA — Postponed VAT accounting on imported goods. You account for the import VAT on your return instead of paying it at the border.
  • DRC & DRR — Domestic reverse charge for construction (CIS). Applies to qualifying construction work between VAT-registered contractors and subcontractors: one side for what you pay, one for what you invoice.

One quirk to expect: VAT codes only attach to income, expense and asset accounts. If you put a VAT code on a balance-sheet control account — a liability, equity or suspense code — IQ Books quietly changes it to No VAT with a zero amount. That is deliberate, not a fault.

Reading The Nine-Box VAT Return

Open the VAT return under Reports, set the period start and end, and IQ Books builds the nine boxes for you from the transactions you have posted. You never type a figure in — the boxes are recalculated from the ledger every single time, so they always reflect the current state of the books. Here is what each box tells you:

  • Box 1 — VAT you charged on sales (output tax).
  • Box 2 — VAT due on EU acquisitions. Always shows £0 in IQ Books.
  • Box 3 — total VAT due. Box 1 plus box 2 — and because box 2 is always zero, box 3 equals box 1.
  • Box 4 — VAT you are reclaiming on purchases (input tax).
  • Box 5 — the net figure. Box 3 minus box 4. A positive number is what you owe HMRC; if box 4 is the larger, you are due a refund.
  • Box 6 — total sales, net of VAT.
  • Box 7 — total purchases, net of VAT.
  • Boxes 8 & 9 — EU goods supplied and acquired. Both always show £0.

To check the evidence behind a figure and file it away:

  1. Set the period. Choose the period start and end dates for the quarter (or month) you are reporting.
  2. Review the nine boxes. Sense-check box 5 against what you expect to pay or reclaim.
  3. Drill into a box. Click a box to open its per-box detail — the actual list of transactions that make up the total — and from there into any individual entry if something looks wrong.
  4. Export it. Save the return to Excel or PDF for your records.
  5. Reprint a filed period. Once a period has been submitted to HMRC through Making Tax Digital, the PDF prints as a stamped receipt carrying the submission reference and processing date.

If you correct a transaction after posting it, IQ Books records the fix as a reversal of the original plus a fresh entry. Both the reversed original and its reversal are left out of the VAT figures automatically, so a correction never double-counts on the return.

Setting Your Year-End And Locking A Period

Two settings under Settings then Organisation govern which dates are open for posting, and both are worth setting deliberately rather than leaving on their defaults.

The financial year-end is a month and a day — for example month 3, day 31 for 31 March. It defaults to 31 March if you leave it. There is no calendar cross-check, so take care not to save an impossible combination such as 31 in a short month; enter a date that genuinely exists.

The period lock is a ‘locked until’ date that freezes everything on or before it. Use it to protect a finished quarter or a filed VAT period from accidental change:

  1. Open Settings then Organisation. Only an owner or admin can change these.
  2. Set the ‘locked until’ date. Everything dated on or before it becomes read-only.
  3. Save. From now on any attempt to add, edit, confirm, void or delete an entry on or before that date is refused, with a message pointing you back to Settings then Organisation to unlock.

The lock is inclusive of its own date. To reopen a locked stretch, clear the date (or move it earlier) and save. One deliberate exception: opening balances can still be posted onto a locked date, because a migration onto IQ Books sets the lock exactly at the opening-balance date.

Preparing For And Troubleshooting The Year-End Close

The year-end close sweeps your profit-and-loss accounts into retained earnings and locks the year behind it. A few things need to be in place first, and a handful of messages tell you when they are not.

Before you close, make sure you have a retained-earnings account. The close moves the year’s profit or loss into an Equity account carrying the retained-earnings role. If none exists, the close will not run — create that Equity account first (or point the close at one explicitly).

Preview freely; commit carefully. Anyone with an owner, admin or bookkeeper role can run the preview, which is read-only and safe to repeat as often as you like. It shows the revenue total, the expense total and the net profit or loss that will move to retained earnings. Only an owner or admin can commit the close.

If the close refuses to run, it is almost always one of these:

  • “Books are already locked up to X — pick a later close date.” You have already locked or closed up to that point. Choose a date after the existing lock.
  • “Nothing to close.” There is no posted income or expense up to the date you chose. Check that the year’s invoices and bank lines are actually issued and confirmed, not sitting as drafts.
  • No retained-earnings account. Create the Equity account described above, then try again.

The whole operation is all-or-nothing: if the closing entry cannot post for any reason, the period lock is left where it was, so you never end up half-closed.

One important point for planning. The close adds up your profit from the very start of the books up to the close date — it is cumulative, not a single-year slice. In practice: close each year once, in date order, and let the period lock hold each finished year shut. Avoid picking a close date that reaches back over a year you have already closed. After a successful close, the closing entries are kept out of your profit-and-loss views so your income and expense accounts do not appear artificially zeroed; it is the period lock, not a blank screen, that tells you the year is done.

IQ Books by ReconcileIQ

Your books, kept by themselves.

IQ Books is the AI-native UK ledger that does the bookkeeping for you. Bank transactions arrive coded, receipts and bills file themselves from a photo or an email, and the books are reconciled to the statement. RiQ does it, you sign it off. The ledger is free.