Reporting
Reports at the speed of thought
Quickly build any report on live ledger data, iterate on it together, and engage everyone. Any transaction or report loads in under 500ms — across every entity, currency, and book.
The world's most demanding finance teams run on Light.
- 01
Multi-entity by default
Pull a consolidated report across every entity without a spreadsheet in sight — eliminations and FX handled at the ledger.
- 02
Custom reports
Complete financial visibility: build custom reports on customers, vendors, and spend with the dimensions you actually manage by.
- 03
Instant answers
Built on an in-memory HTAP database — reports that took minutes in legacy ERPs load in milliseconds.
Analyze it your way
From drag-and-drop pivots to raw SQL, the ledger answers in whatever shape you ask.
Pivot tables, like Excel
Build full pivot tables exactly as you know them from Excel: drag any dimension to rows or columns — entities, cost centers, vendors, customers, custom properties, tax codes — and pivot live ledger data with subtotals, filters, and drill-down to the underlying entries. No exports and no stale copies; the pivot reads the same real-time, consolidated ledger as every other report, so the numbers you slice are the numbers in the books.
SQL for advanced analytics
When a question outgrows the report builder, query the database directly with SQL. Join transactions, dimensions, and metadata to run cohort analyses, custom reconciliations, and ad-hoc investigations, then save queries as reusable reports for the team. It is warehouse-grade access without standing up a warehouse: the data is already multi-entity, multi-currency, consolidated, and current.
Custom and system tax codes
Report on both system tax codes and the custom codes you define. Break VAT, GST, and sales tax down by code, entity, country, or period; reconcile filed returns against the ledger; and trace every figure to its underlying transactions. Custom codes behave as first-class reporting dimensions, so jurisdiction-specific schemes and edge-case treatments report just as cleanly as the defaults.
Chart artifacts in chat
Ask the Light Chat Interface for any cut of your data and it renders an artifact: a live bar, line, or waterfall chart built from any data in the system. Waterfall the month’s P&L bridge, trend cash by entity, compare vendor spend quarter over quarter — then keep iterating in the same thread until the chart says what you need, and share it with the team. Every artifact stays wired to the ledger, so it is a view, not a screenshot.
From close to board pack
One source of truth from the trial balance to the slide.
Live, not exported
Reports read the ledger directly — no data warehouse lag, no version-eleven spreadsheet. Share a report and everyone sees the same current numbers, drillable down to the underlying entries.
Management views
Reclassify for management reporting without touching the statutory books — booked versus accounted views side by side, custom properties as dimensions, every figure traceable.
Need it in a spreadsheet anyway? The Google Sheets plugin keeps your models wired to the same live data.
Unify your
financial data
Reporting is amplified by the Light platform. Experience the agentic ERP.
100x faster
A powerhouse for processing data. Up to 100x faster than NetSuite.
Automated
Slash 80% of manual finance tasks.
Integrated ledger
Single source of truth for all your global finance data.
AI native
Let Light streamline finance and deliver effortless insights.
Real-time reporting
Quickly build any report, iterate on it together, and engage everyone.
Advanced auditing
Track every interaction, every document, every detail all in one place.
