Manual Bank Statement Processing - Ff67 5g62e

1.1

Bank Reconciliation – Manual Bank Statement Processing – FF67

This transaction (Manual Bank Statement Entry - FF67) allows the to enter bank statements manually to SAP. The postings are made through “bank sub s”. Effect is given to the main bank in the books only when the reconciliation really happens. 1. To enter a manual bank statement, choose the following menu path or use transaction code; Menu path Transaction Code

ing → Financial ing → Banks → Incoming → Bank Statement → FF67 -- Manual Entry FF67

NOTE:A specification screen must pop up if it is the first time to process a manual bank statement. If the specification screen do not pop up and it is the first time to the Bank reconciliation screen, the following menu path may be used in the same background screen: Setting-> Specifications 2. Update the following details in the Specification screen; Field name Start variant Customer match code Vendor match code

Processing Type

Description Variant to differentiate the BRS processing. Code to identify the customer transaction Code to identify vendor transaction Use this field to control whether postings via batch input are carried out online or as a background job.

M/O/C M M M

;

action and values Select a variant from the drop down list. Select D for customer transaction. Select K for Vendor transaction Select a processing type variant from the drop down list

Comment DGPC = DG01 company code variant.

Select 1 for Batch Processing(generate online) Select 2 for posting Via batch input session.

M Select 3 for background processing. But select 4 for online processing.

3. Click on the enter

button to process further.

4. Select button to view the existing statement and to enable the system to pick bank details and statement number automatically.

5. In the Manual Bank Statement Overview Screen: Select the bank from the list and click on the button to create a new bank statement.

6. System will pick up the bank details, next statement number and opening balance automatically.

7. If the bank statement is going to be ed for the first time, then update the following in the Process Manual Bank Statement Processing screen;

Field name

Description

Statement number

Bank Statement number

Statement date

Statement number

Opening balance Closing Balance

Bank statement opening balance Bank statement closing balance

M/O/C M M M M

action and values Provide bank statement number This date describes the validity of the bank statement data. Provide opening balance Provide closing balance

Comment

Statement date

Date in the bank statement

O

Provide bank statement date.

8. Press ENTER or Click on the button to enter the transactions. 9. On process manual bank statement, enter the following details; Field name

Transaction type

Value date

Amount

Bank reference

Description

Transaction type identifies determines how and to which s the system is to post the transaction The date of the transaction as per bank statement Transactional amount in the statement This reference information is used to determine which open items should be cleared.

M/O/C

action and values Select the relevant transaction type.

Comment

Select the date of transaction as value date Enter amount

Value date will be considered for currency valuation For outgoing payment, the Minus (-) sign will precede the amount. For outgoing payment, use cheque and advice number and for incoming payment use also cheque number or advice number as per the reference that banks normally display in the bank statement.

M

M

M

M

to enter relevant reference number as are reflected in the bank statement.

DG10 = Incoming payment DG20 = Outgoing payment DG30 = Bank Charges

NOTE:For outgoing payment, it is mandatory to assign Minus (-) sign in front of outgoing amount, if not assigned, system will show error message; . 10. Make sure that transaction entered and closing balance is equal in the BRS processing screen. 11. Click on save

button or Ctrl + S to save the statement.

12. System will show a message in the message bar “Statement/List saved. 13. Click on save

button Ctrl + S again to update the statement.

14. In case any errors, system will show in the Error Column.

15. Click on the 16. Click on the Exit

button to go back to the main screen. button or press Shift+F3 to return to the SAP Easy Access screen.

The system task is complete.