Bank reconciliation ff67

SAP FI FI16

1. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
Bank Reconciliation Statement
FF67
Purpose
Processing of Bank Statement in order to clear the Open Items in the Clearing Accounts and
transfer the same to the Main Bank Account. Running the statement on daily basis ensures
that the balance as per the bank’s statement and the balance as per the books of accounts
are always reconciled.
Trigger
Bank Statement received from Banks in physical or soft copy.
Prerequisites
·Bank Statement (soft copy / hard copy), House bank, Account ID, Statement Number
and Statement Date
Menu Path
Use the following menu path(s) to begin this transaction:
·Select Accounting  Financial Accounting  Banks  Input  Bank
Statement  Manual Entry to go to Initial screen.
Transaction Code
FF67
Helpful Hints
·Press F1 for help
·Press F4 for getting input values
·R – Required
·O – Optional
·C – Conditional
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 15/07/2007 Page 1 / 18

2. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
Procedure0
1. Start the transaction using the menu path or transaction code FF67
SAP Easy Access
2. 0Double-click to start the transaction.
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 2 / 18
FF67

3. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
3. Enter information in the fields as specified in the following table.
Field Name Description R/O/C User action and valuesComments
Company
Code
Company Code for which
you want to the run the
Bank Statement
R Select the Company
Code
Defaults
House Bank House Bank in the
Company Code
R Select the house Bank Defaults
Account ID Account ID defined for the
bank account defined in
the House Bank for which
you want to run the bank
statement
R System will list down the
Account IDs under the
House Bank. Select the
Account ID for which you
want to run the statement
Defaults
from the
first screen
Statement
Number
Number by which the
system will record the
bank statement
R Enter the number
mentioned on the
statement if any, or enter
your own number
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 3 / 18

4. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
Statement
Date
Bank Statement date
R Enter the date mentioned
on the statement
Control data
Opening
Balance
Opening Balance as per
the Bank Statement
R Enter opening balance
from the statement
Closing
Balance
Closing Balance as per the
Bank Statement
R Enter Closing Balance
from the Bank Statement
Posting Date O
Further
Processing
Bank posting
session
Session name for Bank
Postings
R Enter any name for the
Session
Sub-ledger
session
Session name for sub-
ledger postings
O If checked, Select one of
the three options.

Press Enter
4. In the subsequent screen select the variant for entering the bank Statement.
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 4 / 18
Enter the opening balances as per
the bank statement.
Note:
As the fields in the Standard SAP
are right aligned, incase you want
to copy and paste the figure from
excel file, it is requested to make
the field left aligned using arrow
keys.

5. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
5. Enter information in the fields as specified in the following table.
Field
Name
Description R/O/C User Action and Values Comments
TransactionDetermines how and to
which account the
system is to Post the
payment
R Select the proper transaction
from the drill down list.
List of
transactions
defined in the
system are
shown below in
the next table
Value DateValue date of the item to
be cleared
R
Amount Amount in account
currency
R Enter the amount as per the
bank statement
For check issue
transaction enter
amount with
negative sign
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 5 / 18

6. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
Document
No.
Accounting Document
Number. Using this the
system tries to find in a
customer, vendor or G/L
account the item that is
to be cleared by the
payment.
R From the Clearing Accounts
enter the document no.
Applicable for
check deposit
transactions
Bank
Reference
Bank reference for
amount debited /
credited
R Enter the Bank reference
against the amount debited /
credited.
Applicable while
posting items like
Interest, Bank
Charges etc.
Reference Reference number of the
item to be cleared
O Enter the Check number
against which the amount
has been debited in the bank
statement
Applicable for
check issue
transactions. See
note below
The following is the list of transactions defined :
IN01 - Cheque Issued
IN02 + Cheque issued Reversal
IN11 - Transfer out to other bank A/c
IN13 - Cash Withdrawal
IN21 - Unresolved (Credit bank in our books)
IN31 - Interest Paid
IN32 + Interest Paid Reversal
IN33 - Bank Chargeslkk bi cvil
IN34 + Bank charges Reversal
IN51 + Cheque deposits
IN53 + Direct Deposit Customer known
IN54 - Direct Deposit Cust known Reversal
IN61 + Transfer in from other bank A/c
IN63 + Cash Deposit
IN71 + Unresolved (Debit bank in our books)
IN81 + Interest Received
IN82 - Interest Received Reversal
IN82 + Interest Received Reversal
IN91 + Cheque deposit via interim A/c
IN93 + Direct cheque deposit
IN95 - Deduction by Customers
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 6 / 18

7. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 7 / 18
Ensure that the
balances
match
Amount field in Standard SAP Bank Statement program is right
aligned. Hence to copy and paste from Excel file, first make the
field left aligned using arrow keys and then copy and paste.
Enter Check No. for checks issued
and cleared.
Enter FI document number from the
Cheque Deposit Clearing A/c for checks
deposited and cleared as per Bank
Statement.
Select Transaction

8. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
Save the transaction by clicking on “Save button” or pressing “Ctrl + S”.
6. Post Bank Statement
In the main menu go to Bank Statement  Post  Individual processing or click on Save
button once again.
This will create a Session in the name of “List1” in the current case for posting the
transaction to G/L Accounts.
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 8 / 18

9. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 9 / 18

10. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
The system will show the details of the session to be posted.
7. Process Session
Transaction Code : SM35
Select the Session to be processed and click on Process.
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 10 / 18

11. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
In the pop-up screen select “Display errors only” and “Dynpro standard size”.
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 11 / 18

12. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
Click on Process
After process the system will pop-up a message saying that “Processing of batch input
Session completed”
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 12 / 18

13. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
In case of amounts to be debited to expense accounts like interest and bank charges, the
system will stop the processing. The user has to enter the cost center.
Press enter and enter the cost center.
Press Enter.
Click on “Session overview” to check whether the batch has run in Error. Incase the batch
has run successfully, the same will not appear in the Session list.
8. Check Accounting Entry
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 13 / 18

14. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
Transaction code : FB03
a. Entry for check deposited document number 2000000020:
Similarly entries have been passed for other Check deposit transactions.
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 14 / 18

15. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
b. Entry for Check Issued and cleared.
If you want to see all document then select the posting date in FB03
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 15 / 18

16. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
Then Execute
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 16 / 18

17. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
9. You have completed this transaction.
Result
Entries have been posted from Clearing Accounts to Main Bank Account
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 17 / 18

18. Title: Bank Reconciliation Statement
mySAP: ECC 6.0
SAP Module:FI-FINANCIAL ACCOUNTING
Comments
The above procedure ensures that you’re the balance as per your bank account and the main
bank account in your books of account always match, thus ensuring reconciliation through
Clearing Accounts at any given point of time.
CAUTION : ENTER BUSINESS AREA IN ALL TRANSACTIONS
bankreconciliation-ff67-
130519130827-
phpapp02.doc
Version: 0
Last Modified: 26/06/2007 Page 18 / 18