1 / 13

Converting GL Report Writer to Financial BI

Converting GL Report Writer to Financial BI. Accounting Department Activities. Journal Entries Postings Reconciliations Financial Analysis Budgeting and planning Financial Reporting Cost Management Etc…. Senior Management Expectations:

orpah
Download Presentation

Converting GL Report Writer to Financial BI

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Converting GL Report Writer to Financial BI

  2. Accounting Department Activities • Journal Entries • Postings • Reconciliations • Financial Analysis • Budgeting and planning • Financial Reporting • Cost Management • Etc…

  3. Senior Management Expectations: • On time, accurate and adequate reporting to be able to steer the course of the business

  4. Reporting Solutions • External • Pros: flexible, powerful • Cons: complicated in use, expensive, IT overhead, extra maintenance, decentralized data storage, data availability delays Microsoft SQL Global Software Other…

  5. QAD GL Report Writer module Pros: • Integrated core QAD module • No extra cost • Designed for end users no IT help required • Upgradeable to next version of QAD Cons: far from ideal • Cumbersome user interface • Report output is not friendly • No drill downs • Manual run, long time to wait

  6. Case Study Problem our client was facing • Business growth, out staffed • Manual compilation of Excel reports with summary / details each month Requirements • Executive-quality reports [easy to use, read and feel, mid & senior managers, CEOs] • Fully automatic generation of reports • Data visibility, accuracy, integrity • Users will be able to create reports themselves • Multiple Views (MTD, QTD, YTD, LYTD) Total business or individual product lines • Drill down into GL account level, transactional level and sub ledger documents. • Access security [restrictions by reports and drill downs] • Maintenance free [no IT overhead to baby seat app nor create reports] • Comparable to next versions of QAD • Reasonable cost

  7. What if we use GLRW? Which requirements does GLRW satisfy? (gap analysis) • Executive-quality reports • Completely automatic generation of reports (batch processing) • Data accuracy integrity (built-in module) • Users will be able to create reports themselves • Multiple Views (we can link different images together, use GLRW building blocks) • Drill down into GL account level, transactional level and sub ledger documents. (QAD has all required detailed info) • Security • Maintenance free (no extra IT overhead) • Comparable to next versions of QAD (reports automatically converted to next ver.) • Reasonable cost

  8. Executive Quality User Interface • Easy to use, look and feel - key factor • Web interface • Distinctive and friendly • Web drill downs • To lower level statement lines • To various QAD screens • Web Security • New web security menu to control access to sensitive information

  9. Menu Programs Web Security What reports user can see & drill down to accounts, subs, Cost centers, documents, transactions You may restrict access to payroll Details, etc Multiple views One report can have multiple views

  10. On-time data accuracy Online performance GLWR data synchronization and report preparation done offline via QAD batch processing Overnight batch, right after GL postings, so next day reports have been refreshed and quickly served online. No need to wait until end of the month, so department managers can track their spending against budget. Accruals can be excluded (RV transactions). If user need to refresh reports manually during the day, they go to secured QAD menu and submit refresh request. Email will notify user when done.

  11. Report Structure Sections and Statement lines Use analysis codes to define sections. Enclosed sections are fine. Use indentation to control Hidden/visible and position In hierarchy Show

  12. BENEFITS • Fully automatic daily reports (IT is not involved) • Real time financial performance visibility • Complete details to analyze cost drivers • Senior management: toolkit to steer business • Mid level management can track spending • Accounting department: toolkit for financial planning and analysis • Fast, distinct executive level user interface • Great value for money

  13. QUESTIONS? THANK YOU! Visit us online http://www.32soft.com

More Related