Skip to Content
Author's profile photo Former Member

Lockbox Configuration

Lockbox process

The predominant way payments are made in US is by checks. Lockboxs help in speedy deposit of funds and clearance of customer accounts. Lockboxs are special depository accounts set up at a bank to which customer remit their invoice payments.

Banks daily than submit company’s an electronic file listing all deposits and invoices that are paid against. Company’s than upload these files in SAP and update their balance and clear customers i.e. A/R accounts.

Some company’s setup single lockbox whereas others set up lockboxs at different locations thought the country in order to decrease the time it takes to receive the customer payments.

first Image.png

     Figure 1: Lockbox Process Flow

Lockbox File Formats

SAP supports both US lockbox file formats – BAI & BAI2.Each bank has its own standard BAI and BAI2, hence configuration and testing needs to be done depending on bank file configuration.

Hence if you are not comfortable with bank file format either you can approach them to modify it depending on your requirement else ABAP can help in writing a preprocessing program and make file fit with SAP standard format.

Difference between BAI and BAI2

Table.JPG

BAI2 is advised as because it has greater probability of producing automatic matches in the processing and because it allows one to record deduction information and create proper residual postings.

Relationship between EBS and Lockbox

Assume on Day 1 company receives Lockbox file from bank and on Day 2 receives EBS file.

Day 1 When the bank receives a check from customer with remittance information its sends it in Lockbox file. Lockbox file when processed will generate below accounting posting

          Dr Bank Clearing account – incoming

     Cr Lockbox Clearing Account

          Dr Lock box clearing account

     Cr Customer account (customer sub ledger)

Day 2 when the check is cleared in bank, it appears in EBS. EBS when processed produces below accounting entry

Dr Bank Main GL

          Cr Bank Clearing Account – incoming

Lockbox Configuration

House Bank Configuration

Create House banks

  1. Menu Path: Financial Accounting à General Ledger Accounting à Bank – Related Accounting à Bank Accounts à Define House Banks

Transaction Code: FI12

1.JPG

Under the house bank create Bank account from FBZP transaction code.

2.JPG

After creation of House bank and Bank account under company code, it should look like this in FBZP transaction code.

3.JPG

Lock Box Configuration

  1. Path: IMG à Financial Accountingà Bank Accounting à Business Transactions à Payment Transactions à Lock box àDefine posting parameters

T Code: OBAX

4.JPG

Select highlighted row and click on change item button.

5.JPG

Document Number Length: Field is only applicable for BAI record

  1. Num. of doc numbers in type 6: Field is only applicable for BAI record
  2. Num. of doc numbers in type 4: Field is only applicable for BAI record

G/L account Postings: Activate this indicator to make postings to your cash account in the G/L for deposits. Activating this field is recommended

Incoming Customer payments: Activate this indicator to make postings to A/R sub ledger in order to clear customer accounts and create residual postings. Activating this field is recommended

Insert Bank Details: Applicable for batch input session name that updates bank details of master records for customers who have either changed bank information or did not have bank information maintained for them

G/L account posting type

1 – Creates posting to G/L account for every check in the file     

2 – Creates one posting to the G/L account for entire lockbox file

3 – Creates one posting to the G/L account for entire batch

Automatic Posting from lockbox        

  1. IMG à Financial Accountingà Bank Accounting àBusiness Transactions àPayment Transactionsà Lock boxà Define posting data

OBAY

6.JPG

Destination: This field should contain the destination code the bank submits to you in your lockbox file

Origin: This field should contain the your lockbox number (bank account) number at the bank

7.JPG

IMG à Financial Accountingà Bank Accounting àBank Accounts à Define Lockboxes for House bank

Click on first option

8.JPG

9.JPG

Customer Master Data

Transaction Code: XD03

Maintain Bank details in customer master data which bank will send in lockbox file

10.JPG

11.JPG.

Customer Invoice Posting

Post one 600 amount customer invoice. Invoice will display in open state.

T code FB70

13.JPG

Open the invoice

Transaction code: FB03

14.JPG

15.JPG

T code: FBL5N (Customer Report)

Below report shows customer item and it’s not cleared.

16.JPG

Lockbox file processing

SAP gives option of using one of the two standard algorithms for lockbox processing. A common misrepresentation is that one can create own algorithm which is not correct. We can only use the pen delivered by SAP. Program RFEBLB00 is the processing program. Documentation can be viewed for this program from SE38 transaction code. This program contains lot many user exits whether one can add any additional business logic.

Two algorithms that are used are 001 and 003. If file contains checks that cannot be applied against specific invoice but for which customer account is known, SAP posts them on the customer account without reference to any specific invoice. Using algorithm 003, SAP distributes the check across open invoices, beginning at the oldest invoice and working its way forward until the check amount is fully distributed.

File Import:

  1. Menu Path: SAP Easy Access à Accounting àFinancial Accounting àBanks  à Lockbox à FLB2 Import.

Transaction Code: FLB2

Save the lockbox file attached with this document and modify the document number in file with open customer invoice.

20.JPG

Click on green execute button.

21.JPG

Click on back button.

22.JPG

Transaction Code: FLB1

Enter Lockbox details and click on execute button

23.JPG

Select the one which contains data in file. For example if file contains 1123456 is second session name will be 1123456. Right click on 1123456 and select Process Checks options.

24.JPG

30.JPG

Right click on Session name and click on Process option.

31.JPG

Vendor Document Clearing Report

Again view customer invoice it will be displayed as cleared from the payment received and posted via lockbox

32.JPG

Notes

1)   If you get below message, modify the following in file. Unique key for each lockbox file is its header record i.e. Destination, Origin name, Date and time. Modify the seconds’ part and rerun the file.

33.JPG

1)   Sap file generation

            Use Test Lockbox Generation Programs RFEBLBT2 to generate BA12 format and RFEBLBT3 for IDOC format. These programs will generate customer open items and a lockbox file for processing.  Utilize program RFEBKA96 to delete loaded test data

2)   Sample File Understanding

100MANGDESTINMANGORIGIN130903123557

20000000000000000000000

56660011123557130903MANGDESTINMANGORIGIN

666600200000600000110003900345205865100000002

466600360191800000023   00000000600000000000

766600411235571309030010000060000

8666005112355713090300010000060000

9000000

File content explanation with help of differnet Color Codes

100000002 =Check Number

666 = Batch ID

1800000023 = FI customer Invoice

123557130903 = Date & time in Header (i.e. first record) and Time & Date in below records.

600000 = Check/Invoice Amount depending on Row

110003900345205865 = Customer Master Record Bank details.

3)   Sample file of BAI2 program can also be generated from SAP directly on execution of programs

Same can be downloaded and uploaded with just modification of document number else copy from below location

100MANGDESTINMANGORIGIN130903123557

20000000000000000000000

56660011123557130903MANGDESTINMANGORIGIN

666600200000600000110003900345205865100000002

466600360191800000023   00000000600000000000

766600411235571309030010000060000

8666005112355713090300010000060000

9000000

Assigned tags

      38 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Godavari SAP
      Godavari SAP

      Thanks a lot, Gagan. It is explained well.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks

      Author's profile photo Former Member
      Former Member

      Hi Gagan,

      Can you please look into this thread and resolve this issue. Appreciate your effort.

      LOCKBOX UNPROCESSED STATUS need help !

      Sam

      Author's profile photo Former Member
      Former Member

      Hi Gagan,

      Good document.. thanks for sharing..

      Kind Regards,

      Prasad

      Author's profile photo Former Member
      Former Member

      Good one Gagan.. thanks

      Author's profile photo Mohammed Kalim
      Mohammed Kalim

      Nice Document Gagan...thanks for posting.

      Regards,

      Kalim

      Author's profile photo Vinod Vemuru
      Vinod Vemuru

      Good document Gagan.

      Author's profile photo veenu gulati
      veenu gulati

      Hi Gagan,  Thanks for Sharing. I have a doubt in Day 2 entry   Dr Bank Account   Cr Incoming Payments  2)   Dr Incoming Payments           Cr Customer Account  Since you have already credited the Customer a/c in Day 1 it would be double entry in Customer's a/c  Regards  Veenu

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Veenu for highlighting that ...Rectified the entries now

      Author's profile photo NARRA LINGESH
      NARRA LINGESH

      Nice Document..Thanks for Sharing...Gagan.

      Regards,

      Lingesh.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks @narra lingesh

      Author's profile photo Former Member
      Former Member

      Hi Gagan Pareek

      Thanks for share the document with us.

      Regards.

      Jandoval Nascimento.

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      Author's profile photo Lakshmi Sama
      Lakshmi Sama

      Hi Gagan,

      Very explained document on lockbox. Thanks for sharing!

      Please modify the T code as XD03 for customer master data in the document and suggested to avoid typo erors

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Lakshmi.

      Author's profile photo Former Member
      Former Member

      Nice document . well explained . Thanks

      Author's profile photo Former Member
      Former Member

      Nice Document Gagan..

      Author's profile photo Former Member
      Former Member

      Thank you so much and it is very informative. Easy to understand.

      Regards,

      Anu.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank Anu

      Author's profile photo Former Member
      Former Member

      I have IBAN number in BAI2 format file. The account number & bank number in file are not correct. But if same are found using IBAN, are correct. But how FLB2 can handle IBAN field in BAI2 lockbox processing? Please provide solution asap.

      Author's profile photo Marius Reck
      Marius Reck

      Thanks a lot. This helped me to get started with lockbox, as I am new to the US.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Marius

      Author's profile photo Former Member
      Former Member

      Thanks a ton !! I executed FLB2 and FLB1 successfully only because of this document..

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Prakash

      Author's profile photo Former Member
      Former Member

      Thanks !! Very Informative !! and the explanation for Lockbox file is amazing !!

      Kind Regards,

      Prakash Kumar

      Author's profile photo Former Member
      Former Member

      Hi Gagan,

      Thanks... Very Informative..

      Regards

      Srinu

      Author's profile photo CA. Prasad Atmakuri
      CA. Prasad Atmakuri

      Thank you very much Gagan for sharing valuable document

      Regards

      Prasad

      Author's profile photo Former Member
      Former Member

      Gagan,

      Thanks for sharing the knowledge.

      Regards,

      Satya

      Author's profile photo Former Member
      Former Member

      Thanks Gagan sir , sharing you knowledge !!!!!!

      Regards

      Jay

      Author's profile photo Former Member
      Former Member

      Very helpful .

      Author's profile photo Former Member
      Former Member

      Thanks a lot Gagan.

      It's very helpful.

      Regards,

      Atul

      Author's profile photo Former Member
      Former Member

      Thank you Gagan, very useful and a nice document.

      Regards,

      Syam

      Author's profile photo Erico Mattos
      Erico Mattos

      Great Job dear friend!

      Thanks!

      Author's profile photo Former Member
      Former Member

      Beautiful document. Thanks for sharing 🙂

      Author's profile photo Latish Adnani
      Latish Adnani

      Guys,

      how does this process works in case of MDG to ECC interface of a business partner

      1 ) New business partner created in MDG and info flows to ECC

      2) lockbox fie processed and that will update ECC bank master

      3) Next update from MDG to ECC will wipe the bank master details

      How do we avoid step#3 and keep the info in sync between the two systems? Looking for std SAP solution here..  or if there are std interfaces to keep the data in sync.

      Author's profile photo Somasekhara Kolisetty
      Somasekhara Kolisetty

      Thanks for your valuable information

       

      Author's profile photo Reinaldo Camargo
      Reinaldo Camargo

      Hi Gagan, very helpful document:

       

      Could you support me in these case scenarios:

      1 - I have a invoice number that were created with the same number but in the different years. How the program will work?

      ie: Invoice 111 from 2013 and invoice from 2015. The program will try to apply to last one or will check the MICR number and after to decide in which account to apply?

      2 - I have a invoice number that already was cleared. How the program will work?

      3 - If I have a invoice number in open items assigned to customer 111, but the MICR number is from customer 222. How the program will work?

       

      Thank you so much,

      Author's profile photo Jeff Sirkis
      Jeff Sirkis

      The best post I have found on this topic. Thank you for sharing!