Light's reporting engine generates financial statements, custom reports, and pivot tables directly from your ledger. This article explains the report types available and how to use the core reporting ...
Last updated Apr 8, 2026 · 3 min read
Light includes pre-built system reports for the four primary financial statements:
Balance Sheet shows your financial position at a point in time: assets (what you own), liabilities (what you owe), and equity (owners' stake).
Income Statement (P&L) shows your financial performance over a period: revenues earned, expenses incurred, and resulting profit or loss.
Cash Flow Statement shows how cash moved across operating, investing, and financing activities.
Trial Balance lists all GL accounts and their debit/credit balances. Used to verify posting accuracy.
System reports are read-only and cannot be edited or deleted.
Light has three types of reports you can create:
Table — A custom report template built with a formula-based row and column structure. You define up to 5 columns (A–E) with editable labels and build rows using formula references and tax tags. Rows can be hierarchical (parent/child). This is the format used by all system financial statements.
Pivot table — A flexible cross-tabulation of your ledger data. You choose dimensions (rows and columns) and a measure (transaction amount, local amount, or group amount), then apply filters. Useful for ad hoc analysis across entities, accounts, currencies, business partners, and custom properties.
Text to chart (beta) — An AI-powered report generator. Describe what you want to see and Light produces a structured table or chart from your ledger data.
Go to Planning & Reports → Reports to see your full report list.
The list shows Name, Type, and Last updated for each report. Click any row to open it.
Each report has a menu (⋮) with three actions:
When viewing any report you can control what data is shown:
Entity — Select a single entity, multiple entities, or switch to Consolidated view (which combines all selected entities and shows subtotals, eliminations, and a group total).
Date range — Select start and end dates. Snapshot reports (e.g. Balance Sheet) use a single as-of date.
Currency — Two options:
Note: Entity currency cannot be used when multiple entities with different currencies are selected simultaneously.
Comparison — Add a prior period or prior year alongside the current period:
Custom properties — Filter report data by any custom property values configured in your organisation.
Reports can be exported as CSV. Click the export button on any report to download a CSV file named {reportName}_{startDate}_to_{endDate}.csv.
The CSV includes all rows and columns as displayed, respecting your CSV separator setting. You can open the file in Excel, Google Sheets, or import it into a BI tool for further analysis and presentation.
Click any cell value in a report to drill into the underlying ledger transactions. The drilldown view shows the individual postings that make up that figure, and can be filtered by posting date, currency, amount, document type, and entity. Drilldown results can also be exported as CSV.
For aged AP and aged AR reports, the drilldown shows invoices grouped by due date ranges.
Select multiple entities and switch to Consolidated view to see:
You can drag to reorder entity columns using the entity order control.
All reports support two currency views:
The Home page (/dashboard) provides a summary view with fixed widgets showing your bank account balances, pending tasks, card accounts, and a budget YTD accuracy summary. This is a read-only overview and is not customisable.
Was this article helpful?