cancel
Showing results for 
Search instead for 
Did you mean: 

Manual Bank Reconciliation statement

zunaid_hingora2
Active Contributor
0 Kudos

Hi Experts,

I am totally new to Bank Reconciliation in SAP.

I have gone through the nodes in SCN and found out some steps to achieve the Bank Reconciliation.

I have few doubts regarding Manual BRS in SAP.

1. Do we need to upload the Bank statement received before doing Manual BRS .

2. What is the tcode for uploading the Manual statement.

2. What is the opening and closing balance field. Is it opening balance of Bank statement or SAP balance. When i put the balance it is giving me error.

3.Is there any document available for Manual brs. Please share.

Please guide.

Regards

Zunaid

Accepted Solutions (0)

Answers (2)

Answers (2)

zunaid_hingora2
Active Contributor
0 Kudos

Hi Hidyath,

This is main account and as per my discussion main account do not need to be open item management.

Is it right?

Regards

Zunaid

former_member183690
Participant
0 Kudos

HI Zunaid

no its not right

Main GL and sub GL account should have open item check .

Regards

Hidyath

zunaid_hingora2
Active Contributor
0 Kudos

Hi Hidyath,

I will check and will get back to you.

Regards

Zunaid

zunaid_hingora2
Active Contributor
0 Kudos

Hi Hidyath,

we have change setting from 4 to 1 in Processing type. Now batch is getting generated. Now the problem is in variant we have given Bank reference field. This is related to check number. Now question is we are putting assignment number in Bank reference field and still document is getting posted. My question is assignment number is ZUONR field which is correctly being displayed in foreground processing but in config we have not given ZUONR any where.

Can you please help you this?

Regards

ZUnaid.

former_member200703
Active Contributor
0 Kudos

Hi

As far A my knowledge i will answer your question:

1) yes you have to upload the bank statement before bank recon

2) T-Code FF67

3) Open & Closing balance is Bank balance not SAP balance and the open balance for current month should be the same closing balance of previous month

4) you may refer to the below document for more info.

Regards

Mahmoud El nady

zunaid_hingora2
Active Contributor
0 Kudos

Hi Mahmoud,

I am getting below message. Now exactly now sure what to be done.

Company Code                     Bank statement posting                     Time 14:44:30     Date  17.11.2015

Mumbai                                     Processing Statistics                      RFEBBU00/10615569 Page           1

    Posting Ar       Bank Key    Account Nu   Sessn Group FB01 FB05 PmtAcc No Posting Error Total Total Deb. Total Cred

    Bank Accounting  ICIC000XXXX 62XXX5382XXX               0    0      0          0     1     1   1,740.00       0.00

*  Bank Accounting                                         0    0      0          0     1     1   1,7X0.00       0.00

** Bank Accounting                                         0    0      0          0     1     1   1,7X0.00       0.00

    Subledger acctng ICIC0006235 623505382219               0    0      0          0     1     1   1,740.00       0.00

*  Subledger acctng                                        0    0      0          0     1     1   1,740.00       0.00

** Subledger acctng                                        0    0      0          0     1     1   1,740.00       0.00

***                                                        0    0      0          0     2     2   3,480.00       0.00

Please guide.

Regards

Zunaid

zunaid_hingora2
Active Contributor
0 Kudos

Hi Mahmoud,

I am not getting message Statement/list posted. Also session is not getting created. Please check below screenshot. Please guide.

Regards

Zunaid

former_member200703
Active Contributor
0 Kudos

Hi

Please share screen shot for the Error ..

Regards

Mahmoud

former_member183690
Participant
0 Kudos

Hi Zunaid,

Your Bank GL has open item check in FS00 .

then only system can clear automatic when you run batch run input

what posting have you define in the configuration of BRS posting rules key can you please share the screen shot.

Regards

Hidyath

zunaid_hingora2
Active Contributor
0 Kudos

Hi Hidyath,

Please check below screenshot of GL.

Regards

Zunaid

former_member183690
Participant
0 Kudos

HI Zunaid.

As per your screen shot your GL account not tick open item management .

Regards

Hidyath