Bank Statement Processing BSP Setup SAP Business One

Bank Statement Processing – BSP Setup SAP Business One Version 9. 0 INTE RNA L

Objectives After completing this unit, you will be able to: n Install bank statement processing (BSP) for a company. n Configure the initial settings for the Bank Statement Processing. © 2014 SAP AG. All rights reserved. 2

Install Bank Statement Processing n To activate Bank Statement Processing, choose the menu path: Administration System Initialization Company Details Basic Initialization tab. n Select Install Bank Statement Processing. n Note that after activating this option: n The checkbox is disabled and cannot be deselected. n The Cash and Bank program in the Payment Engine add-on is no longer available © 2014 SAP AG. All rights reserved. 3

The Bank Statement n When working with BSP, we use the Bank Statement Details window to record the bank statement as received from the bank. n To work properly with this form, we must define the correct system settings. Each setting will determine the data available in this window. © 2014 SAP AG. All rights reserved. 4

Configure the Initial Settings for BSP n You need to configure the following settings: 1. Banks Slide 5 © 2014 SAP AG. All rights reserved. 2. House bank accounts 3. Internal bank operation codes 4. External bank operation codes 5. Matching criteria 5

Setting Up Banks n n 1. Banks You define the banks with which your company works in the Banks – Setup window. Activating bank statement processing adds several columns to this window. Administration Setup Banking Banks Slide 6 © 2014 SAP AG. All rights reserved. 6

Setting Up Banks n 1. 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. Dates for Posting Creation © 2014 SAP AG. All rights reserved. 7

Setting Up Banks n 1. Banks In the Bank Operation Code List column, you

Setting Up House Bank Accounts 2. House bank accounts n Define an internal representation of a company's bank account. n Activating bank statement processing adds several columns to this window. Administration Setup Banking House Bank Accounts Slide 9 © 2014 SAP AG. All rights reserved. 9

Setting Up House Bank Accounts 2. House bank accounts n Define whether the bank statement is imported automatically or entered manually. n If you choose the automatic option, specify the relevant file format. Slide 10 © 2014 SAP AG. All rights reserved. 10

Setting Up House Bank Accounts n 2. House bank accounts The file formats available to choose in the House Banks Accounts – Setup window are of bank statements format type. Slide 11 © 2014 SAP AG. All rights reserved. 11

Setting Up House Bank Accounts 2. House bank accounts n Valid file formats are available for most countries where BSP is available. n SAP Business One partners can create. bfp files by using the Electronic File Manager (EFM) add-on. Slide 12 © 2014 SAP AG. All rights reserved. 12

Demo – BSP Activation, Set Up Banks and House Bank Accounts © 2014 SAP

Setting Up Internal Bank Operation Codes 3. Internal bank operation codes n Internal bank operation codes are used to determine the type of each transaction row in the bank statement. n Based on the internal code, SAP Business One creates the correct transaction for each bank statement row when the bank statement is finalized. Administration Setup Banking Bank Statement Processing Internal Bank Operation Codes © 2014 SAP AG. All rights reserved. 14

Setting Up Internal Bank Operation Codes 3. Internal bank operation codes n The Posting Method is used to create transactions after the internal code is identified. n Each method you choose affect the values presented in the Posting Transaction and the Expected Result columns. © 2014 SAP AG. All rights reserved. 15

Setting Up Internal Bank Operation Codes 3. Internal bank operation codes n These are the options available to choose from the dropdown menu in the Posting Method column. n Each method will end up with a different expected result. Slide 16 © 2014 SAP AG. All rights reserved. 16

Setting Up Internal Bank Operation Codes n 3. Internal bank operation codes Posting Transaction is used as one of the criteria to define which transaction should be posted when identified by this internal code. Slide 17 © 2014 SAP AG. All rights reserved. 17

Setting Up Internal Bank Operation Codes 3. Internal bank operation codes n The system populates the Expected Results column based on the choices made in the Posting Method and the Posting Transaction columns. n In the Fee Account column specify the account to which any fee amount charged for a transaction is posted. Posting Method + Posting Transaction = Expected Results Slide 18 © 2014 SAP AG. All rights reserved. 18

Setting Up Internal Bank Operation Codes 3. Internal bank operation codes n The Operation Details button is enabled only for operation codes where the assigned Posting Method is G/L Account from/to Bank Account. n You can define if and how to split the transactions posted according to this operation code. n 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. Slide 19 © 2014 SAP AG. All rights reserved. 19

Setting Up External Bank Operation Codes 4. External bank operation codes n You align external bank operation codes with relevant internal bank operation codes. n In the External Bank Operation Codes window, you can define more than one list of codes. n Specify the list(s) of external codes as provided by the national bank, or by each bank with which your company works. Administration Setup Banking Bank Statement Processing External Bank Operation Codes. © 2014 SAP AG. All rights reserved. 20

Setting Up External Bank Operation Codes 4. External bank operation codes n In the Operation Code Category field specify a name for the list of external codes. n In the Internal Code field you choose the relevant internal code as defined in Internal Bank Operation Codes window. You can relate the same internal code to more than one external code if necessary. Slide 21 © 2014 SAP AG. All rights reserved. 21

Demo - Set Up Internal and External Bank Operation Codes © 2014 SAP AG.

Setting Up Matching criteria 4. 5. External Matching bank criteria operation codes n Matching criteria are rules that enable automatic reconciliations in SAP Business One, as part of bank statement processing. n These matching criteria are based on the posting methods specified in the Posting Method column of the Internal Bank Operation Codes window or in the bank statement row of the Bank Statement Details window. Posting Method column of the Internal Bank Operation Codes window. © 2014 SAP AG. All rights reserved. 23

4. 5. External Matching bank criteria operation codes Setting Up Matching criteria Internal reconciliations Dependencies between matching criteria and posting methods: Matching Criteria: Posting methods: Documents G/L Account from/to Bank Account BP Journal Entries Business Partner from/to Bank Account Interim Account Bank Interim Account from/to Bank Account External Reconciliation Ignore © 2014 SAP AG. All rights reserved. 24

Setting Up Matching criteria 4. 5. External Matching bank criteria operation codes n Matching criteria consist of three successive rounds. n Once matching transactions have been found by a round, the system does not continue to find further matches in the subsequent rounds. © 2014 SAP AG. All rights reserved. 25

Setting Up Matching criteria n You can set a combination of up to three rules for each round. n Each rule can consider one parameter. n Note! Each parameter can be used for only one rule in a specific round. . © 2014 SAP AG. All rights reserved. 4. 5. External Matching bank criteria operation codes 26

Setting Up Matching criteria n 4. 5. External Matching bank criteria operation codes It is recommended to narrow the first round as much as possible and broaden the selection in round 2 and 3. © 2014 SAP AG. All rights reserved. 27

Setting Up Matching criteria - Documents 4. 5. External Matching bank criteria operation codes n We use this window to specify matching criteria for reconciling sales and purchasing documents with their respective payments. n Posting Date - selecting this parameter lets you reconcile documents whose assigned posting dates are a consideration. n In the Variation in Days field you can specify the number of days to consider as a legitimate difference, below which reconciliation takes place. © 2014 SAP AG. All rights reserved. 28

Setting Up Matching criteria - Documents n 4. 5. External Matching bank criteria operation codes Selecting the Balance Amount parameter lets you reconcile documents according to their totals. n In the Matching Difference field specify the amount (in local currency) that SAP Business One should tolerate as a legitimate difference between the documents total amount. Slide 29 © 2014 SAP AG. All rights reserved. 29

Setting Up Matching criteria - Documents n 4. 5. External Matching bank criteria operation codes 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 the respective reference field in payment documents. n In the Relate to…First 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 IN 123456 © 2014 SAP AG. All rights reserved. 30

Setting Up Matching criteria - Documents n 4. 5. External Matching bank criteria operation codes 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. n In the Relate to…First Characters field specify a number to define a corresponding level of accuracy of this parameter. n Note that leaving this field empty prompts SAP Business One to look for a complete match of customer or vendor name. Slide 31 © 2014 SAP AG. All rights reserved. 31

Setting Up Matching criteria - Documents n 4. 5. External Matching bank criteria operation codes Example of the documents matching criteria set of rules defined in OEC Computers. Slide 32 © 2014 SAP AG. All rights reserved. 32

Setting Up Matching criteria – External Reconciliation 4. 5. External Matching bank criteria operation codes n Use the Matching Criteria - External Reconciliation - Setup window to specify matching criteria for performing external reconciliation. n The parameters available when defining a rule for the reconciliation matching criteria are: Posting Date, Due Date, Balance Amount and Ref. 1, Ref. 2, Ref. 3. n The Balance Amount parameter lets you reconcile journal entries using transaction amounts as a matching criterion. Slide 33 © 2014 SAP AG. All rights reserved. 33

Demo - Set Up Matching criteria © 2014 SAP AG. All rights reserved. 34

Thanks You have completed the Bank Statement Processing setup topic Thank you for your

© 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: //global 12. 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 or SAP 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 AG’s 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 risks 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. © 2014 SAP AG or an SAP affiliate company. All rights reserved. Public 36