Dashboards and Reports have different jobs. Dashboards display live metrics, charts, goals, record tables, and agendas. Reports create structured financial and operational outputs from reusable setups, with saved versions that preserve their figures and context.

Build a useful dashboard#

  • Open Dashboards and choose New dashboard. Describe a result, start from a suggestion, or configure the blocks yourself.
  • Choose sources, filters, widths, and ordering. The inspector separates Data from Appearance and previews each block.
  • Preview the layout, inspect its records, then save the reviewed setup.

Check what a dashboard number means#

A source can be all sheets in scope, one sheet, or a saved view. Numeric measures use one sheet and field so unrelated units are not silently combined. Calculations query the complete authorized dataset. Select a figure, segment, or trend point to open matching records; drilldowns page through the full selection. Missing or deleted fields produce a repair state rather than invented values.

Choose the right report#

ReportSource and meaning
Balance sheetReviewed, classified accounting CSV. Assets, liabilities, and equity at an as-of date.
Profit & lossReviewed accounting CSV. Revenue, cost of sales, expenses, gross profit, and net profit for a period.
Cash flowReviewed accounting CSV. Operating, investing, and financing activity; opening and closing cash reconciliation.
Receivables agingMapped invoice records. Current open balances, overdue buckets, and customer credits; optional draft, void, and cancelled invoice exclusions.
Expense breakdownMapped expense records, grouped by category and filtered by spending date.
Project financialsMapped project records. Current budgets, recorded costs, and remaining budgets.
Work summaryMapped records grouped by current status, with optional date filtering and supported period comparisons.

Prepare and preview#

  • Open Reports and choose a template. Name the report, set the applicable dates and currency, and add notes.
  • For financial statements, import the reviewed accounting CSV requested by the template. For operational reports, select an allowed sheet and map its supported fields.
  • Inspect the live preview and validation messages. Check source coverage, reporting dates, classifications, and totals.
  • Where supported, configure comparison periods and inspect the change columns. Use consistent currencies; conversion and mixed-currency consolidation are not supported.

Save the setup and the version#

Save setup keeps the report configuration reusable. Save version computes and preserves the reviewed definition, figures, notes, and output. Source changes do not rewrite that saved version. Open version history to return to a prior result and download its PDF or CSV. Supporting sheet records remain available for inspection.

A workflow report step can generate a version from a saved setup, including on a schedule. Add a human approval or notification where your process needs one. A dashboard’s Print / PDF action remains a separate way to print its current layout; it is not a saved financial report version.