Accounting Document Lookup

Track accounting documents and postings regardless of the document type, company code, or fiscal year

Generate reports based on real-time SAP data

Query populating an account lookup to Excel

Query populating an account lookup to Excel

Financial accounting reports are crucial for a company to track financial performance and ensure regulatory compliance. This not only affects internal operational and strategic decision making, but also external creditors.Inaccurate or incomplete reports can negatively impact the organization in several areas:

  • Budgeting and financial planning
  • Year to year projections
  • Increased Operational costs
  • Bad Decision making
  • Delayed Month-End and Year-End close

Although the SAP ERP system contains a wealth of financial data and reports, many challenges are still left to be addressed:

  • Standard reports do not provide a complete data set.
  • Data format is not easily extracted in a friendly format for distribution
  • SOX and SOD violations if reports cannot be limited on an Organizational Level
  • No Simple way to track approvals and setup workflow

Product demo

Winshuttle Query

Watch the Winshuttle Query Demo

Winshuttle Query is an SAP data extraction and analysis tool that allows users to securely shuttle live data from the SAP transactional system into Excel for immediate analysis, action and reporting. See how Query enables both developers and business users to easily create, distribute, and maintain content-rich queries with minimal impact on SAP performance. Watch the demo to see how it works.

Account lookup in Excel using Winshuttle Query

Account lookup in Excel using Winshuttle Query

Business users can use Winshuttle Query pre-built templates or create their own ad-hoc reports to extract live SAP data for financial accounting.

Winshuttle Query enables users to:

  • Look up accounting document data by any criteria
  • Display general ledger line item information
  • Check processing status and look up parked and posted documents
  • Research inter-company postings
  • Query any type of document, such as settlements, transfer postings, and incoming invoices
  • Create consolidation reports
  • Calculate and reconcile accounts on demand


I am unable to join cluster tables that contain financial data to create a meaningful report. How can Query help me?
Unlike standard reporting tools, Query enables users to join cluster and pool tables. For example, users can join an accounting document’s header table BKPF to the accounting document’s segment cluster table Bit Segment (BSEG).
Can I add formulas to perform calculations as data is being pulled from SAP?
Yes. Query enables users to add any Excel formula within the Mapper section and write the results to the same column to replace the old value or to a separate new column.
Can I extract my SAP Accounting Report to Excel directly? Or do I have to manually edit it?
Query supports Excel natively, so users can extract data, format, and sort it directly.
Can reports be scheduled to be run offline?
Yes. Users can schedule reports for offline processing at recurring intervals as desired. They can also add email addresses to receive notifications or choose to have the results file attached to the email message.
I have analyzed my report data and it prompts for corrections in SAP, do you have a solution?
Yes. After a user creates and extracts data using Query, they can easily use Winshuttle Transaction to upload any modifications or conversions back to SAP.
Multiple users need to run the same reports but with different variants, is this possible?
Yes. Winshuttle Runner—available as a tool or an Excel add-on—enables anyone to publish and embed reports to Excel. Users can set selection criteria at run-time, or they can use one query as the base and toggle selection and list fields as desired.

White paper

5 Ways Excel Accelerates Your Return on SAP FICO Business Processes

How can a finance and/or controller professional access SAP FICO data leveraging Microsoft Excel in a highly usable and interoperable fashion while respecting all of the SAP core security and governance controls? In order to fully explore this question, this white paper highlights five valuable ways to leverage Microsoft Excel to reduce Finance & Controller operational costs while making your SAP FICO systems implementation, management and maintenance life easier.