How to use Dynamics SL Statistical Ledgers to enhance your management reports

Many companies use statistical data in combination with financial information to create key metrics that management uses to track the performance of a company. What many people don't realize is that you can utilize Statistical Ledgers in Microsoft Dynamics SL to add metrics to existing financial reports. 

What is a Statistical Ledger?  Statistical Ledgers are like regular Financial Ledgers except that they are for non-financial statistical data. Instead of currency, they track units.  (Financial>General Ledger>Ledger Maintenance) 

For example, a company might use Revenue per Headcount to measure the efficiency and productivity of its employees.  Accounts for headcount by department would need to be set up in the Chart of Account Maintenance.  (Financial>General Ledger>Chart of Accounts Maintenance) 

Tip: It is best to create an account using alpha charcters so the account does not get picked up in financial reports that use a range of account numbers.

Once a the accounts are set up, they can be used for reporting in Management Reporter or FRx.  In our example, the calculation Revenue / Headcount could be added to the Income Statement so it would show Revenue per Headcount for each deparment.

Budget information can also be added by creating an additional Statistical Ledger.  This would allow a company to report on variances just like financial accounts.  A company can ...