excel based sap financial spreadsheet...

Excel Based SAP Financial Spreadsheet Uploader

GLSU (Financial Uploader for GL, AP, AR) is a flexible, intuitive Excel interface for collecting and posting/parking financial transactions, into SAP. Using SAP security, built-in business logic and error handling, GLSU eliminates manual procedures, and improves accuracy in the upload processes.

GLSU Multiple Document Posting

SAP T-Codes Replicated by GLSU

www.excel4apps.com/sap

ECC & S/4HANA Compatible

* GLSU does not support these T-Codes directly, only through the 4 Base T-Codes in the legend.

F-02 Enter G/L Account PostingF-05 Post Foreign Currency ValuationF-65 Preliminary PostingFB01 Post Document FB01L General Posting for Ledger GroupFB41 Post Tax PayableFB50 G/L Acct Pstg: Single Screen Trans.FB50L Enter G/L Account Doc for Ledger GrpFBB1 Post Foreign Currency ValnFBCB Balance Carryfwd for Ledger GroupFBS1 Enter Accrual/Deferral Doc.FBV1 Park DocumentFV50 Park G/L Account ItemsFV50L Park G/L Acct Doc. for Ledger Group

ABAD Asset Retire. frm Sale w/Customer ABB1 Correction of Asset Accounts ABF1 Post DocumentABF1L Post Document in Ledger Group ABZK Acquisition from purchase w. vendor

General Ledger Transactions

Asset Transactions

F-21 Enter Transfer Posting F-22 Enter Customer InvoiceF-27 Enter Customer Credit MemoF-64 Park Customer InvoiceF-67 Park Customer Credit MemoF-92 Asset Retire. frm Sale w/ Customer FB70 Enter Outgoing InvoicesFB75 Enter Outgoing Credit Memos FV70 Enter Outgoing InvoicesFV75 Park Outgoing Credit Notes

Customer TransactionsF-41 Enter Vendor Credit Memo F-42 Enter Transfer Posting F-43 Enter Vendor InvoiceF-63 Park Vendor InvoiceF-66 Park Vendor Credit MemoF-90 Acquisition from purchase w. vendor FB60 Enter Incoming InvoicesFB65 Enter Incoming Credit MemosFV60 Park Incoming Invoices FV65 Park Incoming Invoices

Vendor Transactions

FB01 Post FI DocumentFBV1 Park FI DocumentFBB1 Post Foreign Currency ValuationFBS1 Post Accrual/Deferral

Legend* (Base T-Codes)

GLSU Key FeaturesEasy-to-Use Interface: • Create templates initially from scratch, from previously

posted SAP documents or from a previously saved template.

• Choose and order fields from a picklist.

• Map fields to your template for use with 3rd party data.

• Dropped header field functionality (i.e., for multiple document postings).

• Pin favorite fields in picklist.

Efficient Posting: • Post greater than 999 lines.• Park documents and utilize SAP Workflow.• Multiple document posting from a single Excel template.

“ We have seen great benefits with GLSU and GL Wand.”

SAP Project Manager

Goldcorp

®2018. Excel4apps.

Raw Data

GLSU Multiple Vendor Template

• Pre-validation prior to posting.• Attach the source Excel file to your document in SAP

(for better audit controls).

Primary Mapping

Post-Mapping Template

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: