cancel
Showing results for 
Search instead for 
Did you mean: 

LockBox Functionality and Bank Reconciliation

Former Member
0 Kudos

Hi Gurus,

How can we use lockbox and bank reconciliation both?

How many bank accounts we will be having and what accounting entries system will create?

How will system do clearing?

Please tell me the correct process.

Thank You

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks to everyone for such a good explaination.

Former Member
0 Kudos

Hi Mohit,

Point 1) Lockbox and Bank Reconciliation are two different things. I will try to give below example for better understanding:

If you are having Vodafone or Airtel connection and wanted to make payment through cheques then you drop your cheque along with Vodafone or airtel bill slip to nearest location. Now, Vodafone or airtel executive will come and collect all the cheques from that drop box and deposit the cheques into the bank.

Similarly, lockbox is like a depository set up in bank where customers drops their cheques along with slip and remit their invoice payments. A bank setup lockboxes at different locations like Vodafone or airtel store to ease the customers in making the payments.

Bank Reconciliation will be done at later stage when cheques get presented into the bank.

Point 2) One House Bank and 3 sub accounts are needed for Bank Reconciliation and one GL for lockbox clearing. For Eg

House Bank : CITIBK

CITI Bank Main A/c

CITI Bank Clearing Incoming A/c

CITI Bank Clearing Outgoing A/c

and one GL for Lockbox Clearing A/c

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 CITI Bank Clearing Incoming A/c

Cr Lockbox Clearing Account

Dr Lock box clearing account

Cr Customer account

when cheques get realized from the bank then through EBS or Manual Bank Reconciliation, following entry will get passed.

Dr CITI Bank Main A/c

Cr CITI Bank Clearing Incoming A/c

3) For lockbox configuration, you can refer link provided by Shiva above.

Thanks,

Ankur

Former Member
0 Kudos

Hi Mohit,

Please close the thread if it serves your requirement.

Thanks,

Ankur

former_member183378
Active Contributor
0 Kudos

Hello Mohit,

Please go through this doc once.

http://scn.sap.com/docs/DOC-46723

Please let us know do you still need any issues.

Thanks & Regards,

Lakshmi S

Former Member
0 Kudos

Hi Mohit,

Please go through the below link. It may help you

http://scn.sap.com/docs/DOC-46723

Thanks,

M.Shiva Kumar