In this topic, you will read about using and updating data in statistical ledgers.
You can use statistical data to better understand and analyze your company’s financial data. Statistical ledgers can be a source of data for reporting, for calculation of allocations, or for consolidations. With Acumatica ERP, your organization can define an unlimited number of statistical ledgers to store statistical information.
The system uses the same chart of accounts to post transactions to a statistical ledger as to an actual ledger. Depending on the policies established in your organization, you can create special accounts to be used for statistical information and use only those accounts with statistical ledgers, or you can use the same accounts as you use for financial data. Balances for each account are calculated by a ledger. For details on accounts, see Modification of the Chart of Accounts.
You enter statistical data into ledgers through batches of journal entries. You can create batches of statistical entries on the Journal Transactions (GL301000) form. When you create journal entries for a statistical ledger, you can specify the quantities of goods or services and the units of measure (in which the quantities are measured), along with monetary amounts. To make statistical data on reports more useful, follow your organization's policies on selecting the units of measure for specific goods or services. For details, see Processing Transactions.
A batch of journal entries to be posted to a statistical ledger may be unbalanced—that is, it may not comply with the double-entry bookkeeping rule and may have a total credit amount that is not equal to the total debit amount even if the Validate Batch Control Totals on Entry check box is selected on the General Ledger Preferences (GL102000) form.
For batches of journal entries containing statistical data for a statistical ledger, you can apply all the options available for batches intended for actual ledgers: You can create auto-reversing batches and schedule recurring batches by using the Recurring Transactions (GL203500) form. For details, see Processing Adjusting Transactions and Processing Recurring Transactions.