90 bsp setup

5/21/2018 90 BSP Setup

1/36

Bank Statement ProcessingBSP

SetupSAP Business One

Version 9.0

5/21/2018 90 BSP Setup

2/36 2014 SAP AG. All rights reserved. 2

Objectives

After completing this unit, you will be able to:

Install bank statement processing (BSP) for a company.

Configure the initial settings for the Bank Statement Processing.

5/21/2018 90 BSP Setup


Install Bank Statement Processing

Select Instal l Bank Statement Process ing.

Note that after activating this option:

The checkbox is disabled and cannot be

deselected. The Cash and Bank program in the Payment

Engineadd-on is no longer available

To activate Bank Statement Processing, choose the menu path: Administ rat ion

System Init ia l izat ion Company Detai ls Basic Init ial izationtab.

5/21/2018 90 BSP Setup


The Bank Statement

When working with BSP, we use the Bank Statement Detailswindow to record the

bank statement as received from the bank.

To work properly with this form, we must define the correct system settings. Each

setting will determine the data available in this window.

5/21/2018 90 BSP Setup


Configure the Initial Settings for BSP

Slide 5

5.

Matchingcriteria

4.

Externalbankoperation

codes

3.

Internalbankoperation

codes

2.

House bankaccounts

1.Banks

You need to configure the following settings:

5/21/2018 90 BSP Setup


Setting Up Banks

You define the banks with which your company works in the BanksSetup window.

Activating bank statement processing adds several columns to this window.

Slide 6

1.

Banks

Administ rat ion Setup Banking Banks

5/21/2018 90 BSP Setup


Setting Up Banks

In the three columns that refer to date definition, you specify the method

according to which the dates of bank statement transactions is determined.

1.

Banks

Dates for PostingCreation

5/21/2018 90 BSP Setup


Setting Up Banks

In the Bank Operation Code Listcolumn, you specify the relevant list as defined in

External Bank Operation Code window.

1.

Banks

5/21/2018 90 BSP Setup


2.

House bankaccounts

Setting Up House Bank Accounts

Define an internal representation of a company's bank account.

Activating bank statement processing adds several columns to this window.

Slide 9

Adm inist rat ion Setup Banking House Bank Acc ounts

5/21/2018 90 BSP Setup



Define whether the bank statement is imported automatically or entered manually.

If you choose the automatic option, specify the relevant file format.

Slide 10

2.

House bankaccounts

5/21/2018 90 BSP Setup

11/36

2014 SAP AG. All rights reserved. 11


The file formats available to choose in the House Banks AccountsSetupwindow

are of bank statements format type.

Slide 11

2.

House bankaccounts

5/21/2018 90 BSP Setup

12/36



Valid file formats are available for most countries where BSP is available.

SAP Business One partners can create .bfp files by using the Electronic File Manager

(EFM) add-on.

Slide 12

2.

House bankaccounts

5/21/2018 90 BSP Setup

13/36


Demo

BSP Activation, Set Up Banks and House Bank Accounts

5/21/2018 90 BSP Setup

14/36


3.

Internalbank

operationcodes

Setting Up InternalBank Operation Codes

Internal bank operation codes are used to determine the type of each transaction

row in the bank statement.

Based on the internal code, SAP Business One creates the correct transaction for

each bank statement row when the bank statement is finalized.

Adm inist rat ion Setup Banking Bank Statement Processing

Internal Bank Operat ion Cod es

5/21/2018 90 BSP Setup

15/36



The Posting Method is used to create transactions after the internal code is

identified.

Each method you choose affect the values presented in the Posting Transaction

and the Expected Result columns.

3.

Internalbank

operationcodes

5/21/2018 90 BSP Setup

16/36



Slide 16

These are the options available to choose from the dropdown menu in the Posting

Method column. Each method will end up with a different expected result.

3.

Internalbank

operationcodes

5/21/2018 90 BSP Setup

17/36



Slide 17

Posting Transaction is used as one of the criteria to define which transactionshould be posted when identified by this internal code.

3.

Internalbank

operationcodes

5/21/2018 90 BSP Setup

18/36


Posting Method + Posting Transaction


Slide 18

The system populates the Expected Results column based on the choices made in the

Posting Method and the Posting Transaction columns. In the Fee Account column specify the account to which any fee amount charged for a

transaction is posted.

= Expected Results

3.

Internalbank

operationcodes

5/21/2018 90 BSP Setup

19/36



Slide 19

The Operation Details button is enabled only for operation codes where the assigned

Posting Method is G/L Account from/to Bank Account. You can define if and how to split the transactions posted according to this operation code.

Specify the G/L account to be used by default as an offsetting account to the bank account

when the bank statement transaction is posted.

3.

Internalbank

operationcodes

5/21/2018 90 BSP Setup

20/36


4.

Externalbank

operationcodes

Setting Up External Bank Operation Codes

You align external bank operation codes with relevant internal bank operation codes.

In the External Bank Operation Codes window, you can define more than one list of codes.

Administ rat ion Setup Banking

Bank Statement Process ing

External Bank Operat ion Codes.

Specify the list(s) of external

codes as provided by the national

bank, or by each bank with which

your company works.

5/21/2018 90 BSP Setup

21/36


4.

Externalbank

operationcodes

Setting Up External Bank Operation Codes

Slide 21

In the Operation Code Category field specify a name for the list of external codes.

In the Internal Code field you choose the relevant internal code as defined in Internal BankOperation Codeswindow. You can relate the same internal code to more than one external

code if necessary.

5/21/2018 90 BSP Setup

22/36


Demo - Set Up Internal and External Bank Operation Codes

4

5/21/2018 90 BSP Setup

23/36


4.

Externalbank

operationcodes

Setting Up Matching criteria

Matching criteria are rules that enable automatic reconciliations in SAP Business One, as part

of bank statement processing. These matching criteria are based on the posting methods specified in the Posting Method

column of the Internal Bank Operation Codeswindow or in the bank statement row of the

Bank Statement Details window.

5.

Matchingcriteria

Post ing Methodcolumn

of the Internal Bank

Operat ion Codeswindow.

4

5/21/2018 90 BSP Setup

24/36


4.

Externalbank

operationcodes

Setting Up Matching criteria5.

Matchingcriteria

Documents

BP Journal Entries

Interim Account

External Reconciliation

Matching Criteria:

Dependencies between matching criteria and posting methods:

G/L Account from/to Bank Account

Business Partner from/to Bank Account

Bank Interim Account from/to Bank Account


Posting methods:

Ignore

Internal

reco

nciliations

4

5/21/2018 90 BSP Setup

25/36


4.

Externalbank

operationcodes


Matchingcriteria

Matching criteria consist of three successive rounds.

Once matching transactions have been found by a round, the system does not continue tofind further matches in the subsequent rounds.

4

5/21/2018 90 BSP Setup

26/36


4.

Externalbank

operationcodes


Matchingcriteria

You can set a combination of up to three rules for each round.

Each rule can consider one parameter. Note! Each parameter can be used for only one rule in a specific round. .

4

5/21/2018 90 BSP Setup

27/36


4.

Externalbank

operationcodes


Matchingcriteria

It is recommended to narrow the first round as much as possible and broaden the selection in

round 2 and 3.

4.

5/21/2018 90 BSP Setup

28/36


4.

Externalbank

operationcodes

Setting Up Matching criteria - Documents5.

Matchingcriteria

We use this window to specify matching criteria for reconciling sales and purchasing

documents with their respective payments. Posting Date - selecting this parameter lets you reconcile documents whose assigned posting

dates are a consideration.

In the Variation in Days field you can specify the number of days to consider as a

legitimate difference, below which reconciliation takes place.

4.

5/21/2018 90 BSP Setup

29/36


Externalbank

operationcodes

Setting Up Matching criteria - Documents

Slide 29

5.

Matchingcriteria

Selecting the Balance Amount parameter lets you reconcile documents according to their totals.

In the Matching Difference field specify the amount (in local currency) that SAP BusinessOne should tolerate as a legitimate difference between the documents total amount.

4.

5/21/2018 90 BSP Setup

30/36


Externalbank

operationcodes

Setting Up Matching criteria - Documents5.

Matchingcriteria

BP Reference No.parameter - allows the system to reconcile documents while comparing the

value in Customer Ref. No. or Vendor Ref. No.in sales and purchasing documents, with therespective reference field in payment documents.

In the Relate toFirst Characters field specify a number to define a corresponding level

of accuracy of this parameter.

For example, the Customer Ref. No.in A/R Invoice No. 100 is IN123456

IN123456

4.5

5/21/2018 90 BSP Setup

31/36


Externalbank

operationcodes


Slide 31

5.

Matchingcriteria

Customer/Vendor Name parameter - reconciles documents while comparing the value set in the

Name field in sales or purchasing documents with the value set in the bank statement line. In the Relate toFirstCharacters field specify a number to define a corresponding level of

accuracy of this parameter.

Note that leaving this field empty prompts SAP Business One to look for a complete match

of customer or vendor name.

4.

S5

5/21/2018 90 BSP Setup

32/36


Externalbank

operationcodes


Slide 32

5.

Matchingcriteria

Example of the documents matching criteria set of rules defined in OEC Computers.

4.Setting Up Matching criteria 5

5/21/2018 90 BSP Setup

33/36


Externalbank

operationcodes

Setting Up Matching criteria


Slide 33

5.

Matchingcriteria

Use the Matching Criteria - External Reconciliation - Setup window to specify matching

criteria for performing external reconciliation.

The parameters available when defining a rule for the reconciliation matching criteria are:

Posting Date, Due Date, Balance Amount andRef. 1, Ref. 2, Ref. 3.

The Balance Amount parameter lets you reconcile journal entries using transaction amounts

as a matching criterion.

5/21/2018 90 BSP Setup

34/36


Demo - Set Up Matching criteria

5/21/2018 90 BSP Setup

35/36


Thanks

You have completed the Bank Statement Processing setup topic

Thank you for your time!

2014 SAP AG or an SAP affiliate company

5/21/2018 90 BSP Setup

36/36

2014 SAP AG or an SAP affiliate company. All rights reserved. 36Public

2014 SAP AG or an SAP affiliate company.

All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG or an

SAP affiliate company.

SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG

(or an SAP affiliate company) in Germany and other countries. Please see http://global12.sap.com/corporate-en/legal/copyright/index.epx for additional trademark

information and notices.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.

National product specifications may vary.

These materials are provided by SAP AG or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP AG

or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP AG orSAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and

services, if any. Nothing herein should be construed as constituting an additional warranty.

In particular, SAP AG or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to

develop or release any functionality mentioned therein. This document, or any related presentation, and SAP AGs or its affiliated companies strategy and possible

future developments, products, and/or platform directions and functionality are all subject to change and may be changed by SAP AG or its affiliated companies at

any time for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or

functionality. All forward-looking statements are subject to various r isks and uncertainties that could cause actual results to differ materially from expectations.

Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in

making purchasing decisions.
http://global12.sap.com/corporate-en/legal/copyright/index.epxhttp://global12.sap.com/corporate-en/legal/copyright/index.epxhttp://global12.sap.com/corporate-en/legal/copyright/index.epxhttp://global12.sap.com/corporate-en/legal/copyright/index.epxhttp://global12.sap.com/corporate-en/legal/copyright/index.epxhttp://global12.sap.com/corporate-en/legal/copyright/index.epx