Docs/Financial Core/Reports & Financial Analytics

Reports & Financial Analytics

Comprehensive reporting across financial statements, tax compliance, SaaS metrics, and multi-entity consolidation

8 min read

Reports & Financial Analytics

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

← PreviousChart of Accounts Next →Financial Period Management

Subscribe to new posts

Get notified when we publish new insights on AI-native finance.