How to Perform the Bank Reconciliation in CSI post office?

The first step in bank reconciliation is checking the date and the amount of realization of the cheque with respective to the concerned offices.

Step 1

We should use the t-code FAGLL03 for the above process. Go through the article linked below to know the use of the t-code FAGLL03.

How to View General Ledger Account Details in CSI Post Office?

Use the following parameters.

GLRemittance GL (or Drawn GL)
DateFrom and To
Profit center numberHO or particular SO Profit Centre number

You will get a list of remittance or drawn of that office.

For reference, you can see the below image.

How to Perform the Bank Reconciliation in CSI post office?

I have taken the example of Remittance from November to January. Note down the date of realization of the respective amounts. Once you have confirmed the amount and date on this list, you can go to the second step.

Step 2

Enter the T-code FF67. The following screen will appear.

How to Perform the Bank Reconciliation in CSI post office?

Click on Overview. The next screen will appear.

How to Perform the Bank Reconciliation in CSI post office?

Here you can find the names of the banks along with Bank key and Account number. Select and double click on the respective bank name which is linked with that particular office.

Now, click on New Statement. The below window will appear

How to Perform the Bank Reconciliation in CSI post office?

Here change the Statement Date and Posting Date to any previous dates (For eg. If you are doing reconciliation on 21.2.2018, then you can enter the date as 1.2.2018 which is almost month prior to current date).

Check the option Bank postings only.

In the bank scrolls provided by Banks, you will find receipts and payments.

If you are doing receipts, then add each receipt amount to the Opening Balance. The added amount should be the Closing Balance.

If you are doing payments, then the total amounts of payments should be subtracted from opening balance and that should be your closing balance.

For e.g.

OB = 18595878
receipt = 20000
CB = OB + receipt (18615878)
OB = 18595878
payment = 20000
CB = OB - payment (18575878)

Once you have entered the value in the Closing Balance column, hit the Enter button. The following window will appear.

For instance, in the following example, I have taken the receipt scroll of our SO. The remittance amount is 80,000.

How to Perform the Bank Reconciliation in CSI post office?

Enter the following details.

Tran codeDP21 (for Receipt) or DP02 (for payment)
Profit centerProfit Center Number of SO
Amount80,000
Doc dateDate of Realisation
Value dateDate that you have entered previously at Statement Date and Posting Date

In our example, is only one entry. In your case, there can be multiple entries.

Once you have filled in the column, press the enter button till the Entered and the Bank amount should be equal.

Here, the Bank amount is the amount of receipt or payment except opening balance which we have taken at closing balance. (For eg: we have taken receipt 80000)

If you are reconciling payment scroll then, the amount should be followed by a negative sign(For eg 80000-).

Once the amount is equal, click on SAVE button. You will be redirected to the previous window and a message will be shown as Statement/list saved

Again click on SAVE button. The below window will be shown.

How to Perform the Bank Reconciliation in CSI post office?

Once again click on SAVE button. Again you will see the same window.

How to Perform the Bank Reconciliation in CSI post office?

So you have to click on SAVE button 3 times. Thus 2nd step will be completed.

Step 3

Enter the T-code FEBAN. The below window will appear.

How to Perform the Bank Reconciliation in CSI post office?

In the list of closing balance, some values are in green and some are in red color.

The fresh list which is entered in the last step will be at the bottom. Click on that folder and the amount will be shown in red color (0001 INR 80,000).

Now, select that value and click on Save button at the top. The below screen will appear.

How to Perform the Bank Reconciliation in CSI post office?

Click on Posting Date and click on Process Open Item. The following window will show up.

How to Perform the Bank Reconciliation in CSI post office?

Here enter the Posting Date. Now, click on Process Open Items. The below window will appear.

How to Perform the Bank Reconciliation in CSI post office?

Here the amount entered will be listed. The receipt amount 80000 is seen here.

We have to post it. But before that, click on 1 (select all) and 2 (deactivate).

Now, click on the amount in the list (3). So that the Amount Entered and Assigned should be equal(4).

Now, click on Save button.

How to Perform the Bank Reconciliation in CSI post office?

The amount Rs. 80,000 will appear green in color which depicts that it has been posted.

Thanks for reading!

Comments

Like us to get updates

Share it with friends