Connect Learn Share Lunch Learn Series Management Reporter

Connect Learn Share Lunch & Learn Series: Management Reporter Crash Course – Make Building Financial Reports a Breeze in 60 Minutes Presented by: Derek Krebs & Nick Sercer (MSX Group) Welcome

Agenda • Management Reporter (MR) Overview • Financial Reports Created: – Detailed Trial Balance – Summary Trial Balance – Income Statement – Departmental & Company Income Statement • Q&A @GPUG

MANAGEMENT REPORTER A real-time financial reporting application for creating, generating, securing, and publishing financial statements, such as Profit & Loss (P&L), balance sheets, and Actual vs. Budget variance reports Boardroom-quality reports without IT assistance Integration with Microsoft Dynamics ERP solutions @GPUG

BUSINESSBENEFITS • Real-time results without IT assistance • Product created BY Accountants FOR Accountants • Custom reports based on GL data • Saves time – Speed up month end reconciliation – Quickly generate reports month after month – Automate report distribution • Short implementation cycle @GPUG

KEY FEATURES & FUNCTIONALITY • Building block approach to report design – Rows – Columns – Reporting Trees • Mix and match building blocks • Run time options – Date, Level of detail – Output , Headers, footers… @GPUG

REPORTDESIGN (ROWS C , OLUMN , AND TREE ) @GPUG

REUSABLEBUILDINGBLOCKS @GPUG

Detailed Trial Balance • Row Definition • Add Dimensions from COA • Using TOT Format Codes • Column Definition • Building Column Definitions • Report Definition • Assign Building Blocks • Settings • Headers (Inserting Graphics) @GPUG

Summary Trial Balance • Row Definition • Using Wildcards and Ranges • Column Definition • Building Column Definitions • Report Definition • Assign Building Blocks @GPUG

Income Statement • Row Definition • Edit | Insert Rows • TOT vs CAL • Reconciliation / Check • Column Definition • Column Variations • Report Definition @GPUG

Departmental Income Statement @GPUG

Departmental Income Statement • Row Definition • • • Defining row headers Using DES and CAL Format Codes Applying Format Overrides to rows Establishing relationships between rows Utilizing Font Styles • Column Definition • Reporting Tree Definition • Building Reporting Trees • Adding Reporting Units from COA • Modifying Reporting Tree hierarchies • Report Definition • Modifying existing reports @GPUG

Learn More & Influence Financial Reporting Features! 1. Microsoft Connect Site: http: //Connect. Microsoft. com – Search for existing product suggestions and vote – Enter new suggestions 2. Dynamics Financial Reporting: http: //blogs. msdn. com/b/dynamic s_financial_reporting/ – Latest New Features – Nice videos & Blogs – Sign Up for New Posts @GPUG

Microsoft FRx, Forecaster and Management Reporter User Group Forum LIVE Virtual Conference Dates (FREE, no charge): FRx Forum Wednesday April 18 Forecaster Forum Thursday April 19 Mgmt Reporter Forum Friday April 20 Website: 10 am-6 pm ET http: //msxgroup. com/ffmr 2014/ Email for Details and To Register: Info@MSXGroup. com @GPUG

Questions & Answers Call or Email Anytime with Product Questions * FREE 1 -hour phone consultation to review your reporting and budgeting requirements, goals, setup and recommendations for Microsoft FRx / Management Reporter / Forecaster Email: Derek. Krebs@MSXGroup. com Nick. Sercer@MSXGroup. com 60. 274. 6670 Website: www. MSXGroup. com @GPUG