to generate the report showing pending items to be reconciliated...

17
CSI BANK RECONCILIATION CSI, Command and Control Team [email protected] Process to generate the Report showing pending items to be reconciliated: Step 1 : Logon in SAP portal and enter Tcode “FAGLL03” command and enter. Step 2 : Now enter the following parameters 1. GL Account4867000112For bank drawings, 4867700111for bank remittances 2. Company code – DOPI 3. ALL Items : date required( preferable one month)

Upload: others

Post on 17-Jul-2020

10 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Process to generate the Report showing pending items to be reconciliated: 

Step 1 : Logon in SAP portal and enter Tcode “FAGLL03” command and enter. 

 

Step 2 : Now enter the following parameters  

1. GL Account‐ 4867000112‐ For bank drawings, 4867700111‐ for bank remittances 2. Company code – DOPI 3. ALL Items  : date required( preferable one month) 

 

Page 2: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 3 : Now click on “ Custom selections” as shown to select the profit center. 

 

Step 4: Select “ General Ledger Line Items” as shown. 

 

Page 3: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 5 : Select Profit center Option as shown  

 

Step 6: Enter the profit center of your office and click on “POST” as shown. 

 

 

Page 4: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 7 : Now execute the command as shown. 

 

Step 8: We can view the Pending items indicated in RED and Cleared item Indicated in Green, Our Objective is to clear those pending items, here we will be reconciliating the First entry with assignment AS~~949931 

 

Page 5: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

PROCESS OF BANK RECONCILIATION 

Step 1 : Enter the Command “ FF67” and enter. 

 

Step 2 : Enter the following parameters below scrren as shown. 

1. Start variant – DOPI 2. Processing type – 4 

 

Page 6: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 3 : Enter following details and Click on Enter 3 times. 

1. Bank KEY – Your office bank key (available in FCH5 command) 2. Bank Account Number‐ Your office Bank account number. 3. Currency – INR 4. Statement Number ‐1 5. Statement Date‐ Present date. 6. Tick the Bank Postings Only as shown. 

 

 

 

 

 

 

Page 7: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 4: Enter following details 

1. Tran  ‐ DP02 for withDrawals/ DP01 for remittance 2. Profit center‐ enter you office profit center 3. Bank ref – enter the value displayed in Assignment column in 

FAGLL03 command while viewing Pending Items. 4. Amount‐ enter the amount to be reconciliated( which is ‐10000/‐ as 

shown above with assignment AS~~949931 ) 5. Doc date‐ date of issue of cheque 6. Value date ‐ Present date 

 

 

 

 

 

Page 8: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 5 : Click ENTER Button twice now the entered value will show the amount to be reconciliated, Now Click on GOTO on top of the screen and select change control option, enter Opening balance as 0 and closing balance as ‐10000( Amount to be reconciliated) as shown. 

 

 

 

 

Page 9: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 6 : Now the entered value and bank value will be equal as shown, only after this we have to proceed further, if any mismatch in these values then there is some mistake in the process followed. 

 

 

 

 

Page 10: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 7 : Now click on POST button  as shown 

 

Step 8 : Again click on POST button as shown below. 

 

Page 11: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 9: We can observe the document generated below which should be compulsorily entered in Bank Scroll. 

 

Step 10 : Enter “FEBAN “ Command as shown 

 

Page 12: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

 

Step 10 : Enter the following details as shown and click on execute. 

 

Step 11 : Select the Pending red item and click on POST as shown. 

 

Page 13: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 12 : Now we can verify that Pending item is been reconciliated and converted to Green item. 

  

Step 13 : For further reconciliation Enter the same Command “FF67” and click on OVERVIEW as shown. 

 

Page 14: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 14 : Select the name of the bank belongs to you office. 

 

Step 15 : Select the option “ New Statement”  as shown, enter the closing balance by adding/subtracting the pending amount with opening balance.( In this case the pending amount to be reconciliated is             ‐250000 with assignment as     AS~~949432) therefore the closing balance is ‐10000+(‐250000)=‐260000 as shown and click on enter. 

 

Page 15: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 16: Enter following details 

1. Tran  ‐ DP02 for withDrawals/ DP01 for remittance 2. Profit center‐ enter you office profit center 3. Bank ref – enter the value displayed in Assignment column in 

FAGLL03 command while viewing Pending Items. 4. Amount‐ enter the amount to be reconciliated( which is ‐260000/‐ as 

shown above with assignment AS~~949932 ) 5. Doc date‐ date of issue of cheque 6. Value date ‐ Present date 

 

 

Page 16: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected] 

Step 17 : Click on ENTER button two times, Both entered and Bank values will be equal. 

 

Step 18 : Click POST option two times and document number is generated which should be written in Bank scroll as shown 

 

Page 17: to generate the Report showing pending items to be reconciliated …utilities.cept.gov.in/csi/CSI-SOP/CSI BANK RECONCILIATION.pdf · CSI BANK RECONCILIATION ... 4. Statement Number

CSI BANK RECONCILIATION 

CSI, Command and Control Team    [email protected]