Inline drill-down
Every total in a HISAB 360 report is alive. Drill down in Excel by double-clicking a number — a revenue line in your P&L, a balance on the Balance Sheet, a customer's overdue amount in an aging report — and the transactions behind it unfold right below, neatly indented. Double-click again and they tuck away. No pivot tables to build, no source tabs to hunt through: the breakdown is one click deep and re-runs live, so it's always current.
Start free trialA total on its own hides the story. HISAB 360 makes it a doorway. When you drill down in Excel, the individual rows that add up to a figure appear directly beneath it, indented, without leaving the report or opening another sheet. It's the fastest way to answer "what's actually in this number?" during a review, a board pack, or a month-end close — and it works on the reports HISAB builds for you, not just PivotTables.
People reach for grouping rows in Excel to get expand-and-collapse behaviour, but native grouping only hides rows that are already on the sheet, and you build the outline by hand. HISAB 360's drill-down is smarter: it knows which detail sits behind each total and fetches it on demand, so you get genuinely expandable rows in Excel without setting up a single outline level. Double-click to expand, double-click to collapse — that's the whole interface.
A drillable total can re-query your live ERP connection, so double-clicking a figure pulls the current transactions behind it straight from QuickBooks Online, Xero, Zoho Books, Odoo or the rest of your stack — not a stale export. It turns a static drill-down report in Excel into a live window onto your books, with the same governed, read-only-by-default access HISAB uses everywhere else.
Drill-down is designed around real finance work: expand a category total in a P&L to see the invoices in it, a fixed-asset line on the Balance Sheet to see the additions, or an aging bucket to see which customers are late. Because HISAB builds the report and knows the source, every total it produces can be made drillable — the "why" behind any number is always one double-click away.
When a total expands, the rows below it shift down safely and every other total stays drillable; rows you added by hand are protected when you collapse. Drill settings save with the workbook and reopen intact, so a reviewer opening the file can trace any total back to its transactions. It's the traceability of a pivot table with none of the setup — and it survives the handoff.
In a report built by HISAB 360, just double-click any total. The transactions behind that number expand inline, indented directly under it. Double-click again to collapse them. There are no pivot tables to configure and no source tabs to hunt through — the detail is one click away and re-runs live.
Yes. HISAB 360 makes any total in a report expandable: double-click to reveal the underlying rows, double-click to hide them again. Unlike Excel's manual row grouping, you don't set up outline levels by hand — HISAB knows which detail sits behind each total and pulls it on demand.
Grouping rows in Excel just hides and shows rows that are already on the sheet, and you build the outline manually. HISAB 360's drill-down fetches the actual detail behind a total on demand — from the raw data or live from your accounting system — and expands it in place. It always reflects current data, and it protects your layout when it expands.
Yes. A drillable total can re-query your ERP connection — QuickBooks Online, Xero, Zoho Books, Odoo or FreshBooks — so double-clicking a figure pulls the current transactions behind it straight from the source, not a stale snapshot.
Yes. Each drill re-runs its query the moment you expand it, so the breakdown always reflects your latest data. Drill settings also save with the workbook, so anyone who reopens the file can trace a total back to its transactions.
Want to build the reports first? See how HISAB works inside Excel, combines files with AI Power Query, and reads & writes your ERP.
Free 15-day trial — every feature plus 50 HISAB AI credits. Five-minute install. No credit card.
Start free trial