Converting
Download
1 / 13

Converting GL Report Writer to Financial BI - PowerPoint PPT Presentation


  • 77 Views
  • Uploaded on

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:

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Converting GL Report Writer to Financial BI' - orpah


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Converting gl report writer to financial bi

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…


Converting gl report writer to financial bi

Senior Management Expectations:

  • On time, accurate and adequate reporting to be able to steer the course of the business


Converting gl report writer to financial bi

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…


Converting gl report writer to financial bi

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


Converting gl report writer to financial bi

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


Converting gl report writer to financial bi

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


Converting gl report writer to financial bi

  • 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


Converting gl report writer to financial bi

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


Converting gl report writer to financial bi

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.


Converting gl report writer to financial bi

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


Converting gl report writer to financial bi

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


Converting gl report writer to financial bi

QUESTIONS?

THANK YOU!

Visit us online http://www.32soft.com