Reports & closing · Guide 44 of 53
Deeper analysis with LedgerIQ
LedgerIQ turns your IQ Books ledger into 44 analytics modules (statements, ratios, trends and forecasts), unlocked for a flat 1,000 credits per analysis period. This guide shows you how to open it, scope a period, and export the single-sheet general ledger for a year-end handoff.
LedgerIQ is ReconcileIQ’s analytics dashboard: 44 modules covering the core statements, liquidity and profitability ratios, trends and forecasts. It reads straight from your posted IQ Books ledger, so you never re-key anything. Each analysis period you open unlocks for a flat 1,000 credits, disclosed on the unlock panel before anything is charged.
Open LedgerIQ On Your Books
LedgerIQ lives inside IQ Books’ reporting area and analyses whatever is on your ledger right now.
- Post some transactions first. Every chart is built from your posted ledger, so a brand-new organisation with nothing confirmed will show empty panels. Confirm a few bank lines or issue an invoice, then come back.
- Go to
Reports → Analysis. - Choose the period. Pick this financial year, last year, the last 12 months or everything, or type your own dates. Activity before the period carries in as opening balances. The panel shows the cost before anything is charged, then IQ Books hands your ledger for that period into LedgerIQ.
- Explore the modules. Profit & loss, balance sheet, cash flow, working capital, ratio trends and forecasts each open in their own panel. Ask RiQ inside LedgerIQ to explain any figure or chart.
What LedgerIQ Reads (And What It Doesn’t)
The dashboard reflects your books exactly, which means it deliberately leaves some things out:
- Only posted entries count. Draft bank lines, unissued invoices and bills, quotes and OCR captures are inert until you confirm or issue them, so they will not appear in any figure yet.
- Corrections net out. When you correct a posted entry, IQ Books reverses the original and posts a fresh one. LedgerIQ shows only the corrected position, not the reversal trail.
- Your year-end close is left in the picture. The automatic journal that zeroes your income and expense accounts at year-end is excluded from the analytics feed, so your profit and loss still shows real trading activity rather than a flat zero.
Export Your General Ledger
When you want to hand the whole year to your accountant, feed it into PrepIQ for year-end working papers, or run it through standalone LedgerIQ, export the single-sheet general ledger.
- Open
Reports → General Ledger. Choose the export. - Scope the period. Set a from and to date, or leave it open to include every posted entry.
- Decide on the year-end close. For a normal download, keep everything. For a year-end handoff to your accountant or PrepIQ, choose to leave out the year-end close entries so they see the full gross figures and work out the statutory adjustments themselves.
- Download the workbook. You get one clean worksheet, grouped into a block per account, with one row per journal line.
Each entry is labelled with a Type worked out from its bank line: a single bank line paid in reads as Money In, a single bank line paid out reads as Money Out, and anything else (a manual journal, a multi-bank entry) reads as Adjustment. This is a transaction-level ledger, not a trial balance — LedgerIQ and PrepIQ need the underlying lines, not a summary. The export also reports total debits, total credits and a balanced flag so you can confirm nothing is missing.
Ask RiQ To Open It
You do not have to hunt through the menus. Hold the Space bar (or tap the RiQ mic button) and say “open LedgerIQ” or “show me the financial analysis” — RiQ maps ‘analysis’, ‘analytics’ and ‘financial analysis’ to Reports → Analysis and takes you straight there.
Common Questions
Does running LedgerIQ cost me credits? Yes, a flat 1,000 credits per analysis period you open, shown on the unlock panel before anything is charged. Opening the same period again within 24 hours is free for anyone in these books, even from another browser, and the single-sheet GL export is always free. AI explanations inside the analysis are included in the unlock.
A draft invoice is missing from the numbers — why? Drafts and quotes never touch the ledger. Issue the invoice (or confirm the bank line) and it will appear on your next refresh.
My profit hasn’t zeroed even though I’ve closed the year. That is intentional: the year-end close journal is held out of the analytics feed and the general-ledger export by default, so your income and costs keep showing for the period you are analysing.