Author Gavin Monteiro
Introduction: This SoP is for Manual Bank Reconciliation using Excel Upload
Transaction Code: ZFF67
In SAP, the transactions for Bank reconciliation are as follows:-
1) For vendor payments
Vendor A/c Dr.
To Clearing Cheque Out A/c Cr.
During month end, bank reconciliation will be done with the main bank A/c
Clearing Cheque Out A/c Dr.
To Main Bank A/c
(The same goes for Customers as well)
2) Bank Charges, Interest Received & Interest Paid during Reconciliation, the transaction will happen directly with the main bank A/c
Bank Charges A/c Dr.
To Main Bank A/c Cr.
For this Test, we will be using House Bank, Bank of Baroda Nariman Point Branch (Current A/c)
GL 180000- Main Bank A/c
GL 180001- Clearing Cheque Out A/c
GL 180002- Clearing Cheque In A/c
GL 706100 Bank Charges A/c
GL 706200- Interest Paid A/c
GL 503100 Interest Received A/c
Steps Description/Test Data Screen Shot
For this SoP, we would start from the Customer &
Vendor Invoice. We would first create a Vendor Invoice
1 using FB60
Document No. 110000016
We would create another Vendor Invoice for another
Vendor using FB60
2
Document No. 110000017
We would then clear these 2 Invoices using F-53.
3
After entering the data, click on Process Open Items.
Step 7 Step 8
4. Document Overview:
Double click on the Cheque Out line item
Make sure to enter the Cheque number in the
Assignment field. This field is used to clear the line
items when we run Bank reconciliation.
And then Post the document.
Document No. 120000011
Now we will clear the 2nd Invoice using F-53.
5
Click on Process Items
Simulated View:
Make sure to enter relevant text in the assignment
field of the Cheque Out Line Item.
6
And then post the document.
Document No. 120000012
We would create a Customer Invoice using FB70.
7.
Document No. 70000005
We would create another Customer Invoice for another
customer using FB70.
8
Document No. 70000006
Step 8
Step 7
Now we will clear the 2nd Invoice using F-28
9. Make sure to enter the Cheque In Account in the bank
Data.
Click on Process Items
Simulated View:
Double click on Cheque out line item and enter the
relevant text in the assignment field.
10.
And then post the document.
Document No. 80000000
11. We would now clear the 2nd invoice using F-28
Simulated view:
Double click on Cheque out line item and enter the
relevant text in the assignment field.
12.
And then post the document.
Document No. 80000001
Before running Bank Reconciliation, go to T Code:
FF67.
Click on Settings Specifications.
The following screen appears:
13.
Make sure to fill the data as shown in the image, and
not to make any kind of changes.
This only has be done once, unless someone changes
it.
During Bank reconciliation, the data has to be put in an
excel file. And the system would automatically run the
transaction after uploading the file.
1. In the first field: Transaction, we have to enter either
of the 5 entries as follows:-
LC01 - Cheque Issued
LC02 + Cheque Deposit
LC03 + Interest Received
LC04 - Interest Paid
LC05 - Bank Charges
14. 2. The entered value date is used to find the item on the
entered customer, vendor that is to be cleared with
payment.
3. Enter the amount.
Make sure to put the negative sign, if the value is
negative.
4. Bank Reference: This is the field that directly clears
items using the assignment field stored in the
payments.
No bank reference values are needed for Bank
charges and interest, as it is directly posted in Main
Bank A/c.
15. We may often forget the statement number, opening &
closing balance of bank accounts. So to view them
follow the following steps:
Go to T Code: FF67 and click on Overview
Double click on the respective House Bank to view the
previous transactions.
We can view the Bank Key & Bank Account Number as
well through this.
Currently there are no statements created.
Now that we could see the previous balances, we will
go to T Code: ZFF67
1. Once all data is filled, press Execute.
2. Enter the Bank Key. (The Bank Keys in the system
are the IFSC codes of the respective banks).
3. Enter the Bank Account
4. Enter the respective statement number. Make sure
not to miss statement numbers as that could cause an
error. Always assign the next statement number.
5. Enter the Statement Date - The statement date
indicates only when the bank generated the statement.
16.
6. Enter the opening Balance, if it is nil, make sure to put
a Zero.
7. Enter the closing balance. If the transactions made in
the month, do not match the difference between the
opening & closing balance, the system will generate an
error. If the opening or closing balance are negative, put a
sign at the end of the amount.
8. Date under which the document is entered in financial
accounting
9. Enter any text for the Posting Session
10. Upload the file.
11. Click on Bank Postings Only.
17. After entering the required data, click on Execute or F8.
The following screen appears:
18.
Click on Allow.
After executing the first statement, this is the screen
that appears.
19.
Statement/list is saved & posted.
Now we will go to T Code: FF67, just to check whether
20.
the statement is posted.
Double click on the House Bank, to view the statement.
21. Then double click the opening & closing balance to
view the individual items.
22.
Bank Reconciliation is still not completed, as we need
to run SM35 to complete the posting session.
As you can see the line named LAVACAST1 as we had
entered in ZFF67.
Select that line and then click on Process.
The following screen appears:-
23. Make sure to select fields only as shown in the image.
And then click on Process.
Once this screen appears, that means all the line items
have been posted successfully.
Even the amounts that had to be cleared automatically
have been done.
24.
Then click on Exit Batch Input.
You can view the account balances, using T Code:
FAGLB03.
We will now try to post a wrong statement using
ZFF67.
Click on Execute.
As you can see that the opening balance of this
25.
statement and the closing balance of the previous
statement do not match.
The system should show an error.
This is how an error is displayed.
This shows that the Statement is not posted.
26.
Make changes to the statement and then post if
required.
