Reports & Financial Analytics
Comprehensive reporting across financial statements, tax compliance, SaaS metrics, and multi-entity consolidation
ON THIS PAGE · 15
AI-Native ERP provides a unified reporting system that covers everything from core financial statements to SaaS subscription metrics. All reports are generated through a single interface, making it easy to request any report using natural language or structured parameters.
How Reporting Works
Every report flows through one unified entry point. You specify the report type and a set of parameters, and the system routes your request to the appropriate report handler. Results come back in a consistent format regardless of report type.
Common Parameters
- Legal Entity -- Required for single-entity reports; specifies which business unit to report on
- Entity List -- Used for consolidated reports spanning multiple entities
- As-of Date -- Point-in-time snapshot for balance reports (e.g., balance sheet)
- Date Range -- Start and end dates for activity reports (e.g., income statement)
All dates use the standard YYYY-MM-DD format.
Financial Reports
Core financial statements and account-level analysis.
| Report | Description | Parameters |
|---|---|---|
| Trial Balance | All accounts with debit/credit balances | Entity, as-of date |
| Balance Sheet | Assets = Liabilities + Equity | Entity, as-of date |
| Income Statement | Revenue - Expenses = Net Income | Entity, date range |
| Cash Flow Statement | Operating, investing, and financing flows | Entity, date range |
| Account Activity | Transaction detail for a single account | Entity, account number, date range |
| General Ledger Detail | All journal entries organized by account | Entity, date range |
| Statement of Changes in Equity | Movement in equity components | Entity, date range |
| AR Aging | Customer balances grouped by aging bucket | Entity, as-of date |
| AP Aging | Vendor balances grouped by aging bucket | Entity, as-of date |
| Vendor Aging Detail | Invoice-level aging for a single vendor | Entity, vendor, as-of date |
Point-in-Time vs. Period Reports
- Balance reports (trial balance, balance sheet, AR/AP aging) use an as-of date to show a snapshot at a specific moment
- Activity reports (income statement, cash flow, account activity) use a date range to show what happened over a period
Consolidated Reports
Multi-entity reports that combine data across business units, with automatic intercompany elimination.
| Report | Description | Parameters |
|---|---|---|
| Consolidated Trial Balance | Combined trial balance across entities | Entity list, as-of date |
| Consolidated Balance Sheet | Combined balance sheet with eliminations | Entity list, as-of date |
| Consolidated Income Statement | Combined profit and loss | Entity list, date range |
| Entity Comparison | Side-by-side metrics for selected entities | Entity list, date range |
Intercompany eliminations are included by default. You can optionally disable them to see raw combined figures.
How Consolidation Works
When entities operate in different currencies, the system automatically converts amounts to a common reporting currency using stored exchange rates. Each entity's functional currency amounts are translated at the appropriate rate for the report date.
Tax Reports
Tax compliance and filing preparation.
| Report | Description | Parameters |
|---|---|---|
| Sales Tax Summary | Tax collected by jurisdiction | Entity, date range |
| Tax Filing Worksheet | Data preparation for tax filings | Entity, period |
| VAT Report | VAT input/output summary | Entity, date range |
| 1099 Report | Vendor payments for 1099 reporting | Entity, tax year |
| Tax Exemption Report | Exempt transaction listing | Entity, date range |
These reports are designed to feed directly into your filing process, whether you file manually or use an accountant.
Operational Reports
Business performance analysis across customers, products, and expense categories.
| Report | Description | Parameters |
|---|---|---|
| Revenue by Customer | Customer revenue ranking | Entity, date range |
| Revenue by Item | Product/service revenue breakdown | Entity, date range |
| Expense by Vendor | Vendor spend ranking | Entity, date range |
| Expense by Category | Expenses grouped by account type | Entity, date range |
| Deferred Revenue | Unrecognized revenue balances | Entity, as-of date |
| Prepaid Expenses | Unexpensed prepaid balances | Entity, as-of date |
Ranking reports support a top N parameter (default: 20) to focus on your most significant customers, vendors, or products.
Banking Reports
Cash management and reconciliation status.
| Report | Description | Parameters |
|---|---|---|
| Cash Position | Current cash across all bank accounts | Entity |
| Cash Forecast | Projected cash flows based on open items | Entity, forecast horizon (days) |
| Reconciliation Summary | Bank reconciliation status overview | Entity |
| Outstanding Reconciliation Items | Unmatched items for a bank account | Entity, bank account |
The cash forecast uses open receivables, payables, and recurring patterns to project future cash positions.
Budget Reports
Variance analysis comparing budgeted amounts to actuals.
| Report | Description | Parameters |
|---|---|---|
| Variance Summary | High-level budget vs. actual overview | Budget version |
| Variance by Account | Account-level variance detail | Budget version |
| Variance by Period | Variance trend over time | Budget version |
You can filter variance reports by account type (e.g., show only expense variances) to focus your review.
SaaS Metrics
Subscription business analytics for recurring revenue companies.
| Report | Description | Parameters |
|---|---|---|
| MRR | Monthly Recurring Revenue and trends | Entity, as-of date |
| ARR | Annual Recurring Revenue | Entity, as-of date |
| Churn | Customer and revenue churn rates | Entity, date range |
| Customer Lifetime Value | CLV analysis by segment | Entity |
| Subscription Cohort | Cohort-based retention analysis | Entity |
The MRR report supports a months back parameter (default: 12) to show historical trend data alongside the current snapshot.
Dimension Reports
Analysis across organizational dimensions such as department, location, project, or cost center.
| Report | Description | Parameters |
|---|---|---|
| Dimension Analysis | Financial results by dimension value | Entity, dimension type, date range |
| Dimension Hierarchy | Hierarchical rollup through dimension tree | Entity, dimension type, date range |
You can combine dimension analysis with account type filters to answer questions like "What was revenue by department?" or "What are expenses by project?"
Cost Allocation Reports
Track how shared costs are distributed across departments or entities.
| Report | Description | Parameters |
|---|---|---|
| Allocation Summary | Allocations grouped by rule and period | Entity, date range |
| Allocation Waterfall | Step-by-step allocation flow for a rule | Entity, rule, period |
Report Discovery
Not sure which reports are available or what parameters they need? You can query the system for a complete list of report types, organized by category. Each report listing includes its display name, description, and all required and optional parameters.
Categories include: financial, consolidated, tax, operational, banking, allocation, saas, dimension, and budget.
Best Practices
-
Discover before generating -- Query available report types to understand required parameters before requesting a report
-
Choose the right date type -- Use as-of dates for balance reports, date ranges for activity reports
-
Scope appropriately -- Single-entity reports give detailed views; consolidated reports provide the big picture across your organization
-
Use ranking limits -- For operational reports, set a top N to focus on the most meaningful data points
-
Check for completeness -- Ensure all transactions are posted and reconciliations are complete before generating period-end financial statements
-
Leverage dimensions -- Use dimension reports to slice financial data by department, location, or project without creating separate entities