Use Report Drilldown Behavior

<!– Last validated: 2026-07-15 (SPRK 0.4.10, Demo Company) –> <!– Screenshot status: Current; related reconciliation warning captured 2026-07-15 –>

Report drilldown window showing supporting journal entries

Open a report card, subtotal, total, or row with supporting detail when SPRK exposes drilldown, then review the underlying journal entries without changing the original posting.

When To Use This

Use this workflow when you want to move from a report summary card, subtotal, total, or account row into the supporting journal-entry detail behind that amount.

Before You Start

  • You are on the Reports page.
  • The report you are using has been run for the date or period you want to inspect.
  • The row you want to inspect has a non-zero amount and supports drilldown.

Steps

  1. Open Reports.
  2. Run a statement report such as Income Statement or Balance Sheet.
  3. Review the report summary cards, subtotals, totals, and account rows to locate the amount you want to inspect.
  4. Select the clickable amount on a supported card or row.
  5. Review the drilldown window that opens:
  • The window title uses the account label and the report date context, such as 4000 · Sales Revenue · Jan 1, 2026 – Jun 4, 2026 for a range-based report.
  • Some drilldowns represent a scoped group of accounts such as Income, Expense, Net Income, Assets, Liabilities, Equity, or Net change in cash.
  • Range-based reports open detail for the report date range.
  • As-of reports open detail through the selected as-of date.
  • Open-ended drilldown contexts can use date filters such as Before or After instead of a two-date range.
  • Dimension or filter context from the report can carry into the supporting detail when the report exposes that filter.
  1. Review the supporting journal entries in the drilldown table.
  2. Open a journal preview from a drilldown row when you need to inspect the full entry.
  • Some report-launched journal previews expose Edit when the journal edit policy allows it.
  • A report-launched edit follows the same settlement-account safeguards as an edit started from Ledger. If the date and affected account reach posted reconciliation history, SPRK can require Void affected reconciliation? before saving.
  • Other previews remain view-only because of posting-window policy or other audit restrictions.
  1. If the supporting detail opens in the shared register modal, use Export or Print when you need the exact filtered register rows outside SPRK.
  • Export and print use the current modal rows and visible columns.
  • Print opens a print-friendly table; use the system print dialog if you want a PDF.
  1. On transaction-detail report tables such as General Ledger or Account Detail, use the visible column controls when you need a narrower or reordered review table before output.
  • Confirm the exported or printed file after changing visible columns.
  1. Use the drilldown filters if you need to narrow the supporting rows further:
  • Text filter for entry number, memo, description, or account.
  • Minimum and maximum amount filters.
  • Date modes On, Before, After, or Between.
  1. Close the drilldown window when you are done and return to the report.

What Happens Next

SPRK opens a supporting-entry view for the selected account or account group and date context so you can trace report amounts back to posted activity.

  • Drilldown does not create a correcting entry or edit an existing one.
  • Drilldown only exposes journal entries that are already posted in the ledger for that company and date context.
  • Report drilldown can open an edit path only when normal journal edit policy allows it; it does not bypass posting-window or audit controls.
  • Canceling a reconciliation-void confirmation leaves the report-launched journal edit uncommitted. Void and save should be used only after reviewing the named account and affected statement-ending date.
  • Register-level Export and Print are output actions for the open detail view only.
  • Column controls tailor supported transaction-detail tables for review. They do not edit the underlying journal entries.
  • Closing the drilldown window leaves the underlying report and ledger unchanged.

If Something Looks Wrong

What You See What To Check What To Do Next
The page does not show the expected result Expecting every report card, total, subtotal, or row to be clickable Drilldown only applies where SPRK exposes a supported non-zero target
The result looks ready, but a key check is unresolved Assuming drilldown always edits the transaction you are viewing It is primarily a review path, and editing remains conditional
A needed review step is missing Forgetting that an as-of report uses detail up to the selected date, not only activity on that one date Go back to that check before continuing
The result looks ready, but a key check is unresolved Assuming column visibility changes are accounting changes They are presentation and output-review controls

Practice And Examples

Use the practice file and screenshots to review how report rows open supporting journal-entry detail without changing the original posting.

General Ledger report rows available for detail review

Journal-entry drilldown modal opened from a report row

Report drilldown is a review path, and the journal preview keeps the underlying entry separate from the report itself.