Skip to main content

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

by Jack Boyer
Founder, Boyer & Associates, Boyer & Associates

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) 

Microsoft Dynamics SL Statistical Ledgers

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) 

Microsoft Dynamics SL Headcount Statistical Ledger
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 ...

FREE Membership Required to View Full Content:

Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Jack Boyer

Jack founded Boyer & Associates in 1994 with a vision to create a firm that could attract and keep the area’s best ERP consultants, developers, and business development people.

Follow Jack Boyer on Google+

Jack’s career began doing application and sales support for Solomon Software- the firm that created Dynamics SL. Jack was promoted to regional manager when the firm moved him from Philadelphia to Chicago in 1988.

Jack believes that finding the right software is only a piece of the challenge in implementing software. Without the right people to implement it, you only have half a solution. You need the right business analyst to flush out a company’s requirements and you need the right consultants to make the software align with those needs.

Jack has an honors degree in accounting from Penn State (1984) and passed the CPA exam while at Boyer & Associates.

More about Jack Boyer