real-time sap fico reporting in excelcollateral.excel4apps.com/sap/glwand/tear-sheet_glwand... ·...

2
Real-Time SAP FICO Reporting in Excel GL Wand, an Excel add-in, delivers real-time FICO data directly to Excel. Pre-configured against specific FICO Objects and integrated with SAP Security, GL Wand allows easy retrieval and analysis of essential financial information. GL Wand Balance Sheet Finance Reports Balance Sheets Income Statements Trial Balance GL Account Reconciliation Intercompany Reconciliation A/R Reconciliation A/P Reconciliation Fixed Assets Reconciliation Cash Flow - 12 months rolling Cash Flow - 5 year annual trend Controlling Reports Cost Center Actual-to-Plan Variance Profit Center Profit and Loss Monthly Cost Analysis Project Expenditure Personnel Expense Internal Orders - % of completion Product Profit Margin Analysis Customer Profit Margin Analysis FI to PA Reconciliation Currency Translations GL Wand Report Examples www.excel4apps.com/sap ECC 6 & S/4HANA Compatible Log on securely to SAP with username and password.

Upload: others

Post on 16-Apr-2020

23 views

Category:

Documents


2 download

TRANSCRIPT

Real-Time SAP FICO Reporting in Excel

GL Wand, an Excel add-in, delivers real-time FICO data directly to Excel. Pre-configured against specific FICO Objects and integrated with SAP Security, GL Wand allows easy retrieval and analysis of essential financial information.

GL Wand Balance Sheet

Finance Reports• Balance Sheets• Income Statements• Trial Balance• GL Account Reconciliation• Intercompany Reconciliation• A/R Reconciliation• A/P Reconciliation• Fixed Assets Reconciliation• Cash Flow - 12 months rolling• Cash Flow - 5 year annual trend

Controlling Reports• Cost Center Actual-to-Plan Variance• Profit Center Profit and Loss• Monthly Cost Analysis• Project Expenditure• Personnel Expense• Internal Orders - % of completion• Product Profit Margin Analysis• Customer Profit Margin Analysis• FI to PA Reconciliation• Currency Translations

GL Wand Report Examples

www.excel4apps.com/sap

ECC 6 & S/4HANA Compatible

Log on securely to SAP with username and password.

GL Wand Key Features

• Real-Time FICO Data: Build and use refreshable templates and ad-hoc reports that extract real-time summary balances for GL Accounts, Cost Centers, Profit Centers, Projects, etc.

• Powerful Drilldowns without Programming: Drill down to line items, documents, and attachments in Excel and configure drilldown layouts for deeper analysis.

• Easy Build and Customization: Create or modify reports and combine different balance types with basic Excel skills.

“ The value of real-time data is something you don’t comprehend until you actually have it.”

Manager, SAP Business Platform

Upsher-Smith Pharmaceuticals

®2018. Excel4apps.

GL Wand Monthly Cost Analysis Report

GL Wand Income Statement

Custom product demos

Proof of concept (POC) in your SAP environment (Installation under an hour)

Access to our online private Success Community

Product training: online and onsite

Get StartedLearn more about our solutions by taking advantage of the following offerings: