Management Reporter Tips & TricksPresented By: Tina Haerr/Philip Nichols

Agenda

• Report Design • Formatting • Report Groups & Scheduling• Report Distribution• Web Viewer• Report Security• Missing Account Analysis• Cash Flow Statement• Client Speaker

Report Design Tips & Basic Review

• Building Blocks• Normal Balance• Dimension Sets• Hard code values• Report Tree Basics• Build Attribute columns for Transaction level• Accuracy –Build P&L Checks• Include Duplicate Account Report• Folders• Wizard

Formatting Tips

• Zero Value Override• Remove Day of the Week in

Header for Report Viewer• Add an Image• Sorting by Natural Account• Excel Layout

Before & After

Report Groups & Scheduling

• Group reports for ease of printing and distribution

• Override individual report settings with group settings

• Gain further benefit of Groups via Scheduling

• Schedule for automated report generation across multiple report groups and destination locations

Report Distribution

• Report Library• Shared Folder via Web Viewer• Distribute via Report Group• Link to Sharepoint

Web Viewer

• View and print reports

• Export to Excel• Drill down capabilities

Library Viewer

• Control report access• Create report comments• Add graphs to reports• Access multiple report

versions

Report Security

Types1. GP Security2. Management Reporter Roles3. Unit Security (Trees)4. Report Library Permissions

• Apply to Report definitions and Building blocks• Prevents overwriting of reports

Missing Account Analysis

• Assist in report creation • Assist in error diagnoses

Cash Flow Statement – Introduction

• Indirect Method• Inflows and Outflows

point in time• Reconcile with P&L and

Balance Sheet• Blend of period activity

and Beginning and Ending Balances – tricky!

Cash Flow Statement – Key Points

• Use Non-Print formatting - for Calculations use Column and Row Format

• Row Format Account Modifier -to override column period format to get respective Cash Beginning Balances

• Advance Cell Placement to Calculate Cash BB

Any Questions??