Electronic Bank Statement EBS Setup

Electronic Bank Statement – EBS Setup Assume that the business gets the following EBS File from its bank and this has to be uploaded into SAP using EB...
Author: Rodney Copeland
16 downloads 0 Views 209KB Size
Electronic Bank Statement – EBS Setup Assume that the business gets the following EBS File from its bank and this has to be uploaded into SAP using EBS File Upload.

Let’s explore if the above file needs to be uploaded into SAP, what is it an SAP FICO Consultant needs to do in IMG as well as SAP Application side. Assumptions: In the above file following assumptions are made 01. Only two external transactions are included in the file while organizations use various other transactions that are not shown in this file. 02. Just a single House Bank was used with two different account numbers – one for the Controlled Disbursement Account and the other for the Lockbox Account.

Sample Text File of the EBS File for your test purposes 01,EBSTest,EBSTest,070312,0944,1,99,99,2,,,,,,,/ 02,EBSTest,021000021,1,070312,0944,USD,,,,,,,,,/ 03,008311049,USD,010,100000,,,015,140000,,,045,140000,,,/ 16,115,40000,Z,,,Lockbox Payment from 6015630,,,,,,,,,/ 49,140000,99,,,,,,,,,,,,,/ 98,140000,1,99,,,,,,,,,,,,/ 99,140000,1,99,,,,,,,,,,,,/ 02,EBSTest,021000021,1,070312,0944,USD,,,,,,,,,/ 03,008172915,USD,010,200000,,,015,100000,,,045,100000,,,/ 16,475,100000,Z,,,Check #10003,,,,,,,,,/ 49,100000,99,,,,,,,,,,,,,/ 98,100000,1,99,,,,,,,,,,,,/ 99,100000,1,99,,,,,,,,,,,,/ Copy the data between the lines and paste in text file and save the file. Make sure it can be accessed by the EBS Import program.

Step 01 – Setup House Bank Define House Bank

(I have used an existing House Bank – JP Morgan Chase for the organization)

House Bank Details

Bank Accounts Overview

Bank Account Details – Check (Checks Paid)

Enter the following data as shown in the following table S No 01 02 03 04 05

Field Bank Account GL Currency Bank Key Bank Name

Value 008172915 (Account Number of your org with bank 111553 (whatever GL Account you want to use USD (Organizational Currency) 021000021 (Each bank is identified by bank key) JP Morgan Chase (Name of your bank)

Bank Account Details – Lkbox (Lockbox Account)

Enter the following data as shown in the following table S No 01 02 03 04 05

Field Bank Account GL Currency Bank Key Bank Name

Value 008311049 (Account Number of your org with bank 111552 (whatever GL Account you want to use USD (Organizational Currency) 021000021 (Each bank is identified by bank key) JP Morgan Chase (Name of your bank)

Step 02 – Define and Setup EBS Framework Create Account Symbols

S No

Account Symbols

Description

01 02 03

ZMASTER ZCHKLOCK ZCHKOUT

Maser GL Account Checks In (Lockbox) Checks Out

Note: Based on the requirement additional account symbols can be created. Right now only those account symbols that are highlighted are going to be used.

Assign Accounts to Account Symbols

S No

Account Symbol

GL Account

Comments

01 02 03

ZMASTER ZCHKOUT ZCHKLOCK

111550 +++++3 +++++2

Pick the account from the chart of accounts of your organization.

Create Keys for Posting Rules

S No

Posting Rule

Description

01 02

Z004 Z010

Outgoing Check (Outsource) Checks In

Define Posting Rules

Define the Posting Rule as show in the following screenshots for each of these Z004 – Outgoing Check (Outsource)

Z010 – Checks In

Create Transaction Type

Note: In this demo we are using BAI format, hence prefixed BAI with ‘Z’.

Assign External Transaction Types to Posting Rules

Assign Bank Accounts to the Transaction Types

This completes the EBS Configuration for the Electronic Bank Statement upload.

Step 03 – Test the EBS Upload TCode: FF_5 Application Menu: Accounting Æ Financial Accounting Æ Banks Æ Input Æ Bank Statement Æ Import

Enter the parameters as show above for File Specifications, Posting Parameters, Cash Management, Algorithms, and Output Control. In Posting Parameters we have selected radio button ‘Do Not Post’ to do a test run. Click Execute.

The program upon execution generates the following screen shots detailing the information on EBS Upload file being uploaded. Screen - 001

Click Back to display the next screen Screen – 002

Click Back to the final screen Screen – 003

After you run the FF_5 – Import transaction and if all these screens appear with no errors, then your EBS Configuration and Framework definition is good to go.

And this completes the final and most important step of testing what we did earlier. Note: To get a better understanding of the Transaction Types, Posting Rules, House Banks etc., please refer to SAP Standard Guide for Electronic Bank Statement guide.

Suggestions/Requests [email protected]

The content outlined in this document is intended for the purposes of demonstrating a specific functionality in SAP R/3. A detailed study should be carried out to analyze the requirements and to configure the system to meet the business requirements... Sri Logix Inc., does not take any responsibility to whatsoever purpose this document is/will be used for.