Taking Your Financial Reports to the Next Level with Management Reporter – Postings Audit (5 of 8)
The fifth report in the “Taking your Financial Reports to the Next Level with Management Reporter” series is called “Postings Audit.” Entering transactions accurately is important for proper reporting. Transactions should be posted to the correct accounts and dimensions with the correct amounts. The Audit report helps you evaluate how transactions were posted by providing a look a the details for each transaction in a straightforward way.
The Row Definition for the report contain a Dimension Value Set of several accounts that commonly have posting issues. Alternatively, a Row Definition similar to a trial balance containing all natural accounts could be used. The Column Definition contains the month-to-date amounts as well as several columns with specific transaction attributes. These attributes may vary by the Dynamics ERP you use, but for Dynamics GP I used the following:
- Transaction Date
- Audit Trail Code
- Journal Entry
- Distribution Reference
- Source Document
- Series
- Originating Master Record Name
This video contains how to create a Postings Audit report for your business.
[embed]https://www.youtube.com/watch?v=tjnKpkABges&feature=youtu.be[/embed]
In summary, the key features included in the “Postings Audit" report were:
- Dimension Value Set to display a list of the accounts that should be reviewed.
- Transaction attributes to show the journal entry number and other key transaction details.
- Downloading the report to Excel, where it's easier to review large amounts of data.
Links to other posts in this series:
- Quarterly Revenue by Business Unit - Are we making a profit?
- Weekly Material Usage - Are we being efficient?
- Budget to Target - Are we hitting targets?
- Postings Audit - Are we entering transaction accurately?
- Statement of Cash Flow - Are we making the right investments?
- Quarterly Tax Form - Are we getting the data needed for taxes?
- Financial Matrix - How are we performing?
Comments
- Anonymous
February 26, 2014
Any insight on how adding attributes works with AA/GP/MR? In some initial testing, I am only able to pull "Originating Master" data when looking only at GL financial dimensions. When Analytical Accounting data is added to the MR report, the originating data no longer populates.