General Ledger Balance Sheet

This section lists the Key Performance Indicators (KPI) for the General Ledger Balance Sheet domain and the calculation used to determine their results.


KPI name	KPI calculation
Assets	`(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code]='Bal_Assets') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 1 Report Code]='Bal_Assets'))`
Liabilities	`(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 2 Report Code]='Bal_Liablty') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 2 Report Code]='Bal_Liablty'))*-1`
Equity	`(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 2 Report Code]='Bal_StckHldr_Eqty') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 2 Report Code]='Bal_StckHldr_Eqty'))`
Return on Equity	`Net Profit/loss divided by Equity ([fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 0 Report Code] = 'Inc_Net_Prof_Los')/(SavedExpression('Equity'))`
Inventory	`([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 3 Report Code]='Bal_Inventory') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 3 Report Code]='Bal_Inventory')`
Accounts Receivable	`([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 3 Report Code]='Bal_AR') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 3 Report Code]='Bal_AR')`
Accounts Payable	`(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 4 Report Code]='Bal_Acct_Payable') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 4 Report Code]='Bal_Acct_Payable'))*-1`
Debt Ratio	`Liabilities divided by Assets ((([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 2 Report Code]='Bal_Liablty')+ ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 2 Report Code]='Bal_Liablty'))/(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code]='Bal_Assets') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 1 Report Code]='Bal_Assets')))*-1`
Quick Ratio	Current Assets, minus Inventories, divided by Current Liabilities (((([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code] = 'Bal_Assets')+([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 1 Report Code] = 'Bal_Assets')) - (([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 3 Report Code] = 'Bal_Inventory') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 3 Report Code] = 'Bal_Inventory')))/(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 2 Report Code] = 'Bal_Liablty')+([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 2 Report Code] = 'Bal_Liablty')))*-1
Current Ratio	`Current Assets, divided by Current Liabilities (((([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code] = 'Bal_Assets')+([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 1 Report Code] = 'Bal_Assets')))/(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 2 Report Code] = 'Bal_Liablty')+([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 2 Report Code] = 'Bal_Liablty')))*-1`
Return on Assets	`Net Profit/loss divided by Total Assets (([fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 0 Report Code]='Inc_Net_Prof_Los')/(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code]='Bal_Assets') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 1 Report Code]='Bal_Assets')))*-1`