TheIQSuite Issue № 04 · LedgerIQ
LedgerIQ — features

Upload a GL.
Get CFO-grade analysis.

Forty-plus analysis modules from one general ledger export. Trial balance, P&L, balance sheet, cash flow. Liquidity, leverage, return ratios. DuPont, break-even, anomaly detection, revenue forecasting. Branded board pack PDF in seconds. Works with QuickBooks, Xero, Sage, Pandle, NetSuite — any platform that exports a GL.

Universal Enrichment

Any chart of accounts. Auto-classified.

Different platforms structure their charts of accounts differently. QuickBooks doesn't tell you which accounts are current assets versus fixed; Xero's account types don't always line up with proper financial-statement categories; Sage uses its own taxonomy. LedgerIQ's Universal Enrichment system reads any chart and auto-classifies every account into the right financial-statement bucket — so the analysis modules can run no matter where the GL came from.

Auto-classification

Every account in the GL gets categorised: current vs fixed assets, current vs long-term liabilities, equity, revenue, COGS, opex. The full financial-statement taxonomy.

  • Reads QuickBooks, Xero, Sage, Pandle, NetSuite, FreeAgent
  • Falls back to AI classification for unknown account names
  • Correctable: every classification can be overridden

Fiscal year aware

Configure your fiscal year start month. All comparative periods, year-over-year deltas, and trend modules respect it. UK April-start, US January-start, custom — all supported.

Opening balance handling

Opening balances detected and applied properly to balance-sheet rollups. Trial balance reconciles. P&L isolates the period.

The catalogue

Forty-plus modules. Every angle of the books.

Most analytics tools give you a P&L and call it a day. LedgerIQ gives you the full board pack — core statements, ratios, working capital, profitability, trends, forecasting, advanced analysis like DuPont and break-even. Each module is interactive, exportable, and explainable by RiQ.

Core financial statements

Trial Balance
Profit & Loss
Balance Sheet
Cash Flow Statement
Statement of Changes in Equity
Common-size P&L
Common-size Balance Sheet

Ratios & efficiency

Liquidity Ratios
Profitability Ratios
Debt & Leverage
Return Ratios (ROA, ROE)
Working Capital
Cash Conversion Cycle
Receivables & Payables
Inventory Efficiency
Productivity Metrics

Profitability & revenue

Margin Analysis
Profitability Analysis
Revenue Insights
Expense Structure
Expense Correlation
Automated COGS ID

Trends, forecasting, scenarios

Ratio Trends
Key BS Trends
Key P&L Trends
Key Metrics Trend
Seasonality Analysis
Revenue Forecasting
Break-Even Analysis
What-If / CVP

Advanced analysis

DuPont Analysis
Capital Structure Optimisation
Credit Risk & Lending
Tax Efficiency
Anomaly Detection
Financial Health Score
Asset Management
Budget vs Actual
RiQ AI copilot

Ask the books a question. Get an answer.

RiQ runs alongside LedgerIQ. Ask questions in plain English; RiQ navigates to the right module, pulls the relevant numbers, and explains what they mean. It can also drive the dashboard for you — switch views, apply filters, generate reports, export PDFs — by command.

Plain-English commands. Real actions.

RiQ's not a chatbot bolted onto the side. It's wired into the dashboard's command system — when you ask it to "show me Q3 vs Q4 margins", it actually navigates to the margin analysis module and applies the filter. When you ask it to "explain why current ratio dropped", it pulls the underlying account movements and generates a narrative explanation.

  • Navigate to any module by name
  • Apply filters: period, fiscal year, account
  • Generate narrative explainers for any module
  • Build full business reports as Markdown or PDF
  • Suggest follow-up analysis based on what you've looked at
Conversation snippet
› What's my cash conversion cycle and is it improving?
RiQ: Your CCC is 47 days for the trailing 12 months, down from 53 days in the prior year. The improvement is driven by faster receivables collection (DSO down 8 days) partially offset by inventory build (DIO up 3 days). I've opened the Cash Conversion Cycle module — the breakdown chart is there.
› Generate a board summary on liquidity
RiQ: Drafted. Three pages: liquidity ratios with peer benchmarks, working capital trend chart, cash flow forecast for the next quarter. Open the Reporting tab to download as PDF.
Charts & visualisation

Interactive. Branded. Exportable.

Every module renders interactive charts via ApexCharts (migrated from Chart.js in April 2026 for sharper SVG output). Editorial palette, brand-consistent typography, hover tooltips with the underlying numbers. Export any chart as PNG or SVG for slides, or roll the whole dashboard up into a PDF board pack.

ApexCharts SVG

SVG output by default — sharp on retina, smooth resize, works in print. 25 chart types across the 40+ modules: bars, lines, areas, donuts, heatmaps, candlesticks for valuation modules.

Brand-consistent palette

Editorial cream + ink with LedgerIQ teal accents. No clashing rainbow defaults. Charts inherit the design tokens — change one variable, every chart updates.

Image export

Right-click any chart → export as PNG or SVG for your client deck. Resolution-independent SVGs scale cleanly to print. PNGs at 2× density for screens.

Reporting & exports

Board-ready PDFs. One click.

Pick the modules you want, hit export, get a branded PDF board pack. Cover page, table of contents, executive summary auto-generated by RiQ, then each chosen module rendered with its chart and supporting commentary. Excel exports for the underlying data; chart PNG/SVG for slide decks.

PDF board packs

Branded cover, exec summary by RiQ, chosen modules rendered as pages with charts and narrative. Print-ready or share as PDF.

  • Editable header / footer with your firm's branding
  • Table of contents auto-generated
  • Page-level commentary from RiQ
  • Charts at print-quality SVG

Excel exports

The underlying numbers, not just images. P&L, balance sheet, ratio tables, trends — every module's data exportable to .xlsx for your own modelling.

  • Multi-tab workbook per export
  • Formulas preserved for ratio tables
  • Period columns side-by-side for comparatives

Chart images

Any chart, any module, downloadable as PNG (2× resolution) or SVG (vector). Drop straight into a slide deck or client report.

  • PNG for emails & quick decks
  • SVG for print & pixel-perfect resize
  • Brand colours preserved
Platform compatibility

Any platform that exports a GL.

LedgerIQ is platform-agnostic. Drop in a GL export from QuickBooks, Xero, Sage, Pandle, FreeAgent, NetSuite — or a generic CSV/XLSX from anywhere. The Universal Enrichment system reads the structure and runs every module. No connector setup required.

QuickBooks
Online
Xero
All editions
Sage
Business Cloud / 50
Pandle
UK
FreeAgent
UK
NetSuite
+ generic CSV
Under the hood

Client-side. Always.

LedgerIQ runs entirely in your browser. The GL export is read locally; no upload to a server, no data ever leaves the device. The whole engine — parser, enrichment, modules, charts, PDF generator — is JavaScript running client-side.

Browser-based, no upload

The GL file is parsed in JavaScript. Nothing is sent to a server. You can run LedgerIQ on the most sensitive client books with confidence the data stays local.

Sub-second module render

Every module re-computes when you change period, fiscal year, or comparison. The whole dashboard recalculates in under a second for typical SMB GLs.

ApexCharts SVG renderer

Migrated from Chart.js in April 2026 for sharper output and better print quality. Chart factory enforces brand consistency; legacy modules render through an adapter shim.

40+
Analysis modules
25
Chart types
0
Server uploads of your GL
6+
Platforms supported natively
Security & privacy

The most private analysis tool you'll use.

Because the engine is client-side, the GL never leaves your browser. The most sensitive client data — every transaction, every balance, every customer — stays on your device. We don't see it because we don't have it.

Client-side processing

The whole GL parser, enrichment system, and analysis engine runs in your browser. No server upload. Cuts the risk surface to zero.

Optional save / share

Save state to your account if you want to come back later. Otherwise, close the tab and the GL is gone. Your call.

GDPR by design

Data minimisation isn't a policy here — it's the architecture. We can't share what we don't have.

FAQ

The honest answers.

Does LedgerIQ work without integration into my accounting platform?

Yes. Export the general ledger from your platform — QuickBooks, Xero, Sage, NetSuite, anything that exports a GL — and drop it into LedgerIQ. No OAuth setup, no connector. Most users work this way.

Trial balance, or actual GL?

Actual GL. A trial balance alone is a snapshot — it can produce a balance sheet but it can't drive transaction-level analysis like anomaly detection, expense correlation, or seasonality. LedgerIQ uses the GL because that's where the interesting analysis lives.

Why client-side processing?

Two reasons. The first is privacy: your most sensitive client data never leaves your browser. The second is speed: there's no upload latency, no server queue, no waiting. Hit upload and the dashboard renders in under a second.

What about multi-entity / consolidations?

Per-entity analysis is fully supported — switch between entity GLs in the dashboard. Cross-entity consolidation is on the roadmap but not yet shipped. For now, run each entity separately and compare.

How does it handle different fiscal years?

Configurable. Set your fiscal year start month per dataset; all comparatives, period analysis, and trend modules respect it. UK April-start, US January-start, custom — all work.

Can I export the analysis to share with a client?

Yes — three ways. PDF board pack with selected modules, branded cover, RiQ-generated commentary. Excel workbook with the underlying numbers across multiple tabs. Or individual chart images (PNG / SVG) for dropping into a deck.

Does it work for US clients?

Fully. The Universal Enrichment system handles US chart-of-account conventions, January fiscal year start, US-specific account types. Tax efficiency, credit risk, lending analysis modules are jurisdiction-aware.

How does the RiQ AI copilot work?

RiQ is the same AI assistant that runs across the IQ Suite — wired into LedgerIQ's command system so it can navigate modules, apply filters, generate explainers, and build board reports on command. Plain-English questions in, dashboard actions and narrative answers out.

Is there a free tier?

Yes. Starter is free with 5,000 credits a month — enough to run the dashboard regularly. See pricing.

Before the analysis

The other two products in the suite.

Forty modules. One upload.

From raw GL to board pack in under a minute. Free to start, no card required.