How do I speed up month-end close reporting with iDBQuery?
Turn each recurring close question, such as accruals, flux analysis and account variances, into a saved iDBQuery report that queries your ledger live. Ask 'Explain the month-over-month change in every P&L line over 5%' and it returns cited variances in seconds instead of a manual spreadsheet chase.
Month-end close is a checklist of recurring questions, accruals, account variances, flux commentary, that teams usually answer by rebuilding spreadsheets each period. iDBQuery makes each one a saved, self-refreshing report: - Connect your ledger or accounting source. - Ask each close question once, for example 'Explain the month-over-month change in every P&L line greater than 5%.' - iDBQuery computes the variances against live data and returns a cited flux table you can drop into commentary.
A worked example: a controller saves reports for 'unusual journal entries this period,' 'accounts with no activity that normally have some,' and 'top 10 expense variances.' Next month, reopening them re-runs against the closed period automatically, with no rebuild.
The differentiator is that close work becomes repeatable and auditable. Every variance is cited to the underlying transactions, so when a reviewer asks 'what drove that?' you drill straight to the rows instead of hunting through workbooks. Because iDBQuery queries one live model, you can reconcile figures across the ledger and a subledger or bank export in the same question, catching mismatches early. The result is a faster close where the manual chase, exporting, pivoting and cross-checking, is replaced by asking, and the numbers you sign off are traceable end to end.
Updated 2026-06-22