GL Wand (Excel4apps): What is it and how does it Work?

In any organization, financial data and reports are very important and sometimes even critical. Many reports and analyses done in the Finance Department are used by managers in making key decisions.

Closing month-end, performing ad hoc analysis, reconciling, and other reports are increasingly difficult tasks. If you are a manager or work in Finance, you probably know that by now.

The best news is that there are tools that can make your life easier, GL Wand is a perfect help.

What is GL Wand, and how does it help you?

1. GL Wand: Intro

GL Wand is an add-in to Microsoft Excel that allows you to have real-time financial reporting and analysis. It has been designed to work with your ERP security settings with no middleware needed, so it is very easy to set up.

It features an easy-to-use Excel interface, providing self-service tools. You can create highly customized reports with complex requirements. You can then schedule mass distribution of reports in multiple formats via email or shared drive.

This amazing tool can be used for all modules of your company. Access data covers the most common information requests from Finance, HR, Projects, and other modules.

2. Integration with Oracle E-Business Suite

Gl Wand has integrations will Oracle E-Business Suite. On installation, the add-in will automatically detect your Oracle E-Business Suite. Moreover, you can use HTTP, so it will connect to the Oracle Application Server.

It is an alternative to Oracle Standard or Custom Reports, OBIEE, Discoverer, Web ADI, and others for operational reporting.

3. Integration with SAP

It works perfectly with SAP. You can run a report from any SAP module, including MM, SD, AP, AR, and AA. Furthermore, in the GL Wand tab, you can run CDS Views.

Nonetheless, you can use this great tool as a complementary solution for BOBJ, BW, and other reporting software.

4. Budget, Planning, and Journal Wand

Other great Excel-based solutions that can be used combined with GL Wand are Budget, Planning, and Journal Wand.

You can use Budget Wand to import budget values or journals through the Oracle budget-loading interface. It effectively replaces Web ADI and allows for faster creation and uploading of budgets.

Use Planning Wand to enable the validation and upload of budget planning
and forecasting data from Excel to SAP. This amazing feature will reduce manual work and time-consuming tasks for maintaining planning models.
You will quickly update plans and produce new forecasts, critical tasks in today’s economic environment.

Besides these two ideal Excel-based solutions for your company, you can also have Journal.

Journal Wand allows you to batch-upload journal entries with multiple attachments into Oracle. In addition, you can quickly create custom templates, populate them with journal data, validate, and upload the journals into Oracle.

GL Wand: Verdict

With GL Wand, obtaining, analyzing, sharing, and presenting essential information when and how you need it is easy. Because of these great features, this Excel add-in is a reliable solution for any company, helping your Financial department work more efficiently.

⇒ Get GL Wand