QAD 2012 Enterprise Financials Financial Report Writer Financial

  • Slides: 43
Download presentation
QAD 2012 Enterprise Financials – Financial Report Writer Financial Reporting Lance La. Cross, CPA

QAD 2012 Enterprise Financials – Financial Report Writer Financial Reporting Lance La. Cross, CPA Senior Solutions Consultant March 19, 2012

QAD 2012 Enterprise Financials – Financial Report Writer Road to Reporting Financials 2

QAD 2012 Enterprise Financials – Financial Report Writer Road to Reporting Financials 2

QAD 2012 Enterprise Financials – Financial Report Writer Reporting - Matching Need To Solution

QAD 2012 Enterprise Financials – Financial Report Writer Reporting - Matching Need To Solution Executives CEO, COO, CIO, CFO Strategic QAD Business Intelligence - Long term trend analysis -Both QAD and non-QAD data - Easy access (web, mobile) Tactical Dept. Managers Finance, Mfg. , Sales, . . . QAD Enterprise Applications Operational Operations Prod. Mgr, Planners Warehouse, Staff - Inquiries & Standard Reports - Operational Metrics - Reporting Framework - Browses & Collections -2012 – Financial Report Writer 3

QAD 2012 Enterprise Financials – Financial Report Writer Different Flavors of Information Local GAAP

QAD 2012 Enterprise Financials – Financial Report Writer Different Flavors of Information Local GAAP US GAAP IFRS Italia GAAP US GAAP 4

QAD 2012 Enterprise Financials – Financial Report Writer Browses & Collections • Consolidate various

QAD 2012 Enterprise Financials – Financial Report Writer Browses & Collections • Consolidate various transaction information and display in a single view • Develop drill-down / through data paths • “Connect” to non-native data • Limited graphical representation of data • Instantaneous view of current position • Limited historical perspectives • Viewed only using QAD UI 5

QAD 2012 Enterprise Financials – Financial Report Writer Operational Metrics • Configurable based on

QAD 2012 Enterprise Financials – Financial Report Writer Operational Metrics • Configurable based on browses • Graphical representation of data • Drill-down / through to source transactional data • Instantaneous view of current position • Limited historical perspectives • Viewed only using QAD UI 6

QAD 2012 Enterprise Financials – Financial Report Writer Financial Operational Metrics • Currently 43

QAD 2012 Enterprise Financials – Financial Report Writer Financial Operational Metrics • Currently 43 Enterprise Financials metrics, grouped in 6 metric collections Customer data AR operations Supplier data AP operations Addresses Banking/GL 7

QAD 2012 Enterprise Financials – Financial Report Writer Reporting Framework • • Built –In

QAD 2012 Enterprise Financials – Financial Report Writer Reporting Framework • • Built –In report writer Configurable query builder Limited graphing functions Instantaneous view of current position • Limited historical perspectives • No drill-down / through capabilities • Viewed only using QAD UI 8

QAD 2012 Enterprise Financials – Financial Report Writer Alternate Chart of Accounts • The

QAD 2012 Enterprise Financials – Financial Report Writer Alternate Chart of Accounts • The Alternate COA function provides the ability to generate reports using alternate COAs, in addition to a company’s operational COA • An alternate COA consists of one or more account structures, each containing a group of non-duplicate alternate accounts. Each alternate account is assigned an account code, description, and account level indicator, and, optionally, a column label and an alternate COA group code. • Reporting according to multiple account structures - Legally mandatory chart – France, China, etc - Group chart, Operational chart - Multi-GAAP reporting • IFRS, US-GAAP, other GAAP 9

QAD 2012 Enterprise Financials – Financial Report Writer Alternate COA Reporting Flow Alternate COA

QAD 2012 Enterprise Financials – Financial Report Writer Alternate COA Reporting Flow Alternate COA 1 = USA Source Chart of Account: = Canada Alternate COA 2= Government 10

QAD 2012 Enterprise Financials – Financial Report Writer Standard Reporting – Trial Balance 11

QAD 2012 Enterprise Financials – Financial Report Writer Standard Reporting – Trial Balance 11

QAD 2012 Enterprise Financials – Financial Report Writer Standard Reporting – Trial Balance View

QAD 2012 Enterprise Financials – Financial Report Writer Standard Reporting – Trial Balance View 12

QAD 2012 Enterprise Financials – Financial Report Writer Consolidation Features • Multiple consolidations within

QAD 2012 Enterprise Financials – Financial Report Writer Consolidation Features • Multiple consolidations within the same organization are possible • Proportional consolidation is possible • Entities to be consolidated may have differing or conflicting accounting periods • All reporting options available in the system apply to consolidation entities as well • Transactions options are also available in the consolidation entities • One or several periods can be consolidated in one run (i. e. quarterly consolidation) 13

QAD 2012 Enterprise Financials – Financial Report Writer Consolidation - Management Example Company Group

QAD 2012 Enterprise Financials – Financial Report Writer Consolidation - Management Example Company Group A Product 1 Export Product 2 Group B Product 3 Product 4 Group C Product 5 Product 6 14

QAD 2012 Enterprise Financials – Financial Report Writer Consolidation - Legal Example Company USA

QAD 2012 Enterprise Financials – Financial Report Writer Consolidation - Legal Example Company USA Group A Holdings Inc. Group B Inc. China Beigi Foton Inc. Mexico El Dorado Inc. Brazil ACE S. A. Acme Products Inc. 15

QAD 2012 Enterprise Financials – Financial Report Writer See the Whole Picture 16

QAD 2012 Enterprise Financials – Financial Report Writer See the Whole Picture 16

QAD 2012 Enterprise Financials – Financial Report Writer Summary of Reporting Options • Browses:

QAD 2012 Enterprise Financials – Financial Report Writer Summary of Reporting Options • Browses: • Ad Hoc Browses • Standard Browses • Collections / Workbenches • Operational Metrics • Reporting Framework • Structured and Standard Reports • Variant Concept Flexible • • • Excel Integration Supplemental Analysis Fields - SAF Alternate Chart of Accounts Consolidation Views Group Reporting Business Intelligence 17

QAD 2012 Enterprise Financials – Financial Report Writer • Objectives - Single solution for

QAD 2012 Enterprise Financials – Financial Report Writer • Objectives - Single solution for GL reporting - Real time - Multi-domain - Consolidated - Chart Translation - Currency Translation - Multi-GAAP

QAD 2012 Enterprise Financials – Financial Report Writer 19

QAD 2012 Enterprise Financials – Financial Report Writer 19

QAD 2012 Enterprise Financials – Financial Report Writer – main features 1. Build and

QAD 2012 Enterprise Financials – Financial Report Writer – main features 1. Build and Run flexible Reports - Flexible report hierarchies Flexible row & column definitions with in-line calculations Reusable analysis codes 2. Based on harmonized data in a Reporting Cube - Across multiple COA, Currencies, GAAP Optimized for reporting inquiries 20

1. Build and Run Reports Report Cube Reports -Entity -Layer -GL -Sub-Account -Cost Center

1. Build and Run Reports Report Cube Reports -Entity -Layer -GL -Sub-Account -Cost Center -Project -SAF 1 -10 -Intercompany -Daybook -TC Presentation Currency Report Calendar 21

2. Based on harmonized data in a Reporting Cube Source domains Report Cube Reports

2. Based on harmonized data in a Reporting Cube Source domains Report Cube Reports Source domains 22

QAD 2012 Enterprise Financials – Financial Report Writer Report Chart and Report Cube Source

QAD 2012 Enterprise Financials – Financial Report Writer Report Chart and Report Cube Source domains Source domains Report Chart Maintenance Report Cube COA Cross-Reference Reporting COA Cube Definition Maintenance Reports Presentation Currency Report Calendar 23

Real Time update of the Report Cube Source domains Source domains 1. Report Cube

Real Time update of the Report Cube Source domains Source domains 1. Report Cube generate (initial) Report Cube Reports Reporting Data 2. Cube Daemon (continual and real time) 24

Building and Running Reports Report Cube Reports -Entity -Layer -GL -Sub-Account -Cost Center -Project

Building and Running Reports Report Cube Reports -Entity -Layer -GL -Sub-Account -Cost Center -Project -SAF 1 -10 -Intercompany -Daybook -TC Presentation Currency Report Calendar 25

Financial Report Writer 26

Financial Report Writer 26

Building and Running Reports Report Master Report Cube Report Column Group Reporting Data Report

Building and Running Reports Report Master Report Cube Report Column Group Reporting Data Report Analysis Codes Report Tree 27

Report Analysis Codes for a Sales Report Cube data China 01 41100 Auto China

Report Analysis Codes for a Sales Report Cube data China 01 41100 Auto China 01 41200 Auto USA 01 41100 Auto France 01 41200 Auto …. Japan 01 51100 Pack China 01 51100 Pack USA 01 55100 Pack France 01 55100 Pack … USA 01 … 63010 Auto Report Analysis Codes Europe Americas Asia Entities France 01 …. Entities USA 01 … Entities China 01 Japan 01 … Sales Auto Sales Pack Global Sales GL 41100 -41200 Sub-Acct. Auto GL 41100 -41200 Sub-Acct. Pack Sub-Total 28

Report Tree for a Sales Report Global Sales Europe Sales Auto France 01 ….

Report Tree for a Sales Report Global Sales Europe Sales Auto France 01 …. Sales Pack Americas Sales Auto USA 01 … Sales Pack Asia Sales Auto China 01 Japan 01 … Sales Pack 29

Report Analysis Code - Maintenance 30

Report Analysis Code - Maintenance 30

Report Tree Maintenance 31

Report Tree Maintenance 31

Report Tree Excel Integration 32

Report Tree Excel Integration 32

Column Group Maintenance Column 1: Opening 2011/01 Column 2: Activity 2011/01 -12 Column 3:

Column Group Maintenance Column 1: Opening 2011/01 Column 2: Activity 2011/01 -12 Column 3: Closing 2011/12 999, 999. 99 999, 999. 99 999, 999. 99 Colu mns Report Rows Tree 33

QAD 2012 Enterprise Financials – Financial Report Writer Column Group Maintenance 34

QAD 2012 Enterprise Financials – Financial Report Writer Column Group Maintenance 34

QAD 2012 Enterprise Financials – Financial Report Writer Report Master Maintenance Column 1: Opening

QAD 2012 Enterprise Financials – Financial Report Writer Report Master Maintenance Column 1: Opening 2011/01 999. 99 999. 99 Column 2: 3: Activity Closing 2011/012011/12 12 999. 99 Tree 999. 99 999. 99 Title: “Global Sales” Report Global Sales Europe Sales Auto France 01 …. Sales Pack Americas Sales Auto USA 01 … Sales Pack Asia China 01 Japan 01 … Sales Auto Sales Pack 35

QAD 2012 Enterprise Financials – Financial Report Writer Report Master 36

QAD 2012 Enterprise Financials – Financial Report Writer Report Master 36

QAD 2012 Enterprise Financials – Financial Report Writer Report Run 37

QAD 2012 Enterprise Financials – Financial Report Writer Report Run 37

QAD 2012 Enterprise Financials – Financial Report Writer Report Run 38

QAD 2012 Enterprise Financials – Financial Report Writer Report Run 38

Balance Sheet Sample 39

Balance Sheet Sample 39

IFRS and XBRL 40

IFRS and XBRL 40

Browsing the report Cube • Cube Balance View browse 41

Browsing the report Cube • Cube Balance View browse 41

Drill down to the source transactions 42

Drill down to the source transactions 42

QAD 2012 Enterprise Financials – Financial Report Writer 43

QAD 2012 Enterprise Financials – Financial Report Writer 43