How do I do cash-flow analysis with iDBQuery?
Ask iDBQuery 'Show net cash flow by month this year, split into operating inflows and outflows.' It aggregates your transactions into inflows and outflows across accounts, returns the monthly trend as a chart, and cites every figure back to the source transactions behind it.
Cash-flow analysis tracks the money moving in and out of your business over time, the clearest signal of financial health. iDBQuery builds it from your transaction data without a manual model.
- You'd ask iDBQuery: 'Show monthly net cash flow this year, broken into inflows and outflows by category, and highlight the tightest month.'
- It aggregates transactions across your bank and ledger tables, classifies them, and returns a waterfall or bar chart plus a table.
- Every figure is cited to its source transactions, so 'March outflows = £142k' can be audited down to the individual payments.
The strength is chaining questions in one thread: 'What drove the outflow spike in March?' or 'Project next quarter's cash position from AR and AP due dates.' iDBQuery keeps the context and pulls receivables and payables from the same one live model, so cash forecasting draws on real due dates rather than guesses. Because transactions may span several bank accounts and an accounting system, it unifies them with no pipeline. Save a live cash-flow report for weekly treasury review, and let the Analyst agent flag months where projected outflows outpace inflows, with the rows that explain why. Combined with runway analysis, this gives finance a full liquidity view in plain language.
Updated 2026-06-22