Finance
The Finance data model covers live financial reporting for Acumatica, built around a general ledger history fact table with pre-aggregated period balances. It includes measures like beginning balance, turnover, debit, credit, and ending balance, combined with dimensions such as account, branch, ledger, sub-account, and financial period. Use it for live trial balances, period reconciliation, and account-level financial analysis without the heavy transformations or transactional joins a standard data model would need.
This data model is built around a specific structure that requires precise parameters to return data correctly. Creating custom views directly inside this data model is not recommended as they will not have the required setup to function properly.
How to use this data model
- View balances directly from Acumatica, without scheduled ETL processes or data replication.
- Analyze general ledger data summarized by period instead of individual transactions.
- Compare beginning and ending balances for trial balances, roll forwards, and reconciliation from one period to the next.
- Break down balances by currency or dimension, reporting in home or transaction currency.
- Avoid complex data pipelines, since the model requires no data warehouse setup.
Available views
| View | Type | What it shows |
|---|---|---|
| Trial Balance | Worksheet | A snapshot of all ledger account balances at a given date. |