Measures
Overview
Measures are one of the key concepts in xpna. A measure is a numeric value which is able to be aggregated, such as a financial account movement or a non-financial metric. Measures are used in conjunction with hierarchies in xpna to provide a complete picture of the data in your workspace.
Movement measures
Amount DRCR
The Amount DRCR measure shows the sum of the debit (positive) and credit (negative) amounts for the General Ledger. Typically, expenses will show as positive amounts, and revenue as negative amounts. The Amount DRCR measure does not treat any account as a debit or credit account and does not treat balance sheet accounts differently to profit and loss accounts. It simply sums the movements in the General Ledger.
Amount Reporting (default)
The Amount Reporting measure is similar to the Amount DRCR measure, but it allows users to specify the sign of the amount. This is useful for reporting purposes, where you may want to reverse the sign of the amount for certain accounts. Typically, users would set expense accounts to be Debit positive, and Revenue accounts (or anything which contains revenue) to Credit positive. This setting can be set in using the Manage Hierarchy: Account feature. When using the xpna.DATA* functions, the Amount Reporting measure will be used by default.
Cash Movement (Xero only)
The Cash Movement measure is similar to the Amount DRCR measure, but it only includes transactions which have a cash impact. A journal is considered to have a cash impact if any of the lines in the journal are recorded against a cash or bank account. Additionally, payments for Accounts Receivable and Accounts Payable accounts are also considered to have a cash impact but xpna records the cash movement against the accounts impacted by the original invoice, rather than the Accounts Receivable or Accounts Payable accounts. The Cash Movement (Gross) measure is is identical, but contains the tax portion of the transaction.
Balance measures
Closing balance
The Closing balance measure is the sum of all transactions for selected GL accounts up to and including the selected period. Typically this is used to create balance sheet reports, where you want to see the balance of an account at a specific point in time. The Closing balance measure is not available for non-financial accounts.
Closing balance reporting
The Closing balance reporting measure is similar to the Closing balance measure, but it allows users to specify the sign of the amount. This is useful for reporting purposes, where you may want to reverse the sign of the amount for certain accounts. Typically, users would set asset accounts to be Debit positive, and liability and equity accounts to Credit positive. This setting can be set in using the Manage Hierarchy: Account.
Opening balance
The Opening balance measure is the sum of all transactions for selected GL accounts up to and including the previous period. Typically this is used to create balance sheet reports, where you want to see the balance of an account at a specific point in time. The Opening balance measure is not available for non-financial accounts.
Opening balance reporting
The Opening balance reporting measure is similar to the Opening balance measure, but it allows users to specify the sign of the amount. This is useful for reporting purposes, where you may want to reverse the sign of the amount for certain accounts. Typically, users would set asset accounts to be Debit positive, and liability and equity accounts to Credit positive. This setting can be set in using the Manage Hierarchy: Account.
Exchange rate measures
Average rate
The Average rate measure is the monthly average exchange rate for the selected period. This rate is used for foreign currency reporting for profit and loss accounts. Most users won't need to use this measure, as currency conversion is handled automatically by xpna, but it is available for users who want to see the exchange rate used for a specific period.
Month end rate
The Month end rate measure is the month end exchange rate for the selected period. This rate is used for foreign currency reporting for balance sheet accounts. Most users won't need to use this measure, as currency conversion is handled automatically by xpna, but it is available for users who want to see the exchange rate used for a specific period.