Process Manual Bank Statements (FF67)
Purpose
Use this procedure to post the entries on the fleet bank statement to the main US bank account and to clear the sub bank accounts.
Trigger
Perform this procedure when it is necessary to post the entries on the Fleet bank statement to the main US bank account and to clear the sub bank accounts.
Prerequisites
•  Invoices requiring payment in $US must exist on SAP.
Menu Path
Use the following menu path to begin this transaction:
•  Select Accounting è Treasury è Cash Management è Incomings è Manual Bank Statement è Enter to go to the Process Manual Bank Statement screen.
Transaction Code
FF67
Additional Information
•  Receipts should be posted to the lodgements account immediately they are received.
•  Transfers between the NatWest account and Fleet account are to be posted at the time they are actioned.
•  Invoices for payment method U are input into Accounts Payable and a payment proposal run to identify invoices requiring payment in $US.
•  SAP produces a clearing document which debits the appropriate vendor's account and credits the $US unpresented cheques account.
•  Accounts payable has to manually enter the cheque numbers on each payment record.
Note Account assignment models maybe useful for these if the posting details are always to the same accounts.
Procedure
1. Start the transaction using the menu path or transaction code FF67.
screen  Specifications
2. As required, complete/review the following fields:
• Start variant
• Processing type
 
3. Click on Image .
screen  Process Manual Bank Statement
4. To select processing details for the statement, click on Image .
screen  Manual Bank Statement Overview
5. Double click on the bank details to review the last statement.
screen  Manual Bank Statement Overview
Note Check the last statement date processed to ensure it is not replicated.
6. Click on Image .
screen  Process Manual Bank Statement
Note Statement number, opening balance details and bank posting session details are brought through.
7. As required, complete/review the following fields:
• Ending balance
• Posting date
• Bank postings only
 
8. Click on Enter .
screen  Transaction (1) 22 Entries found
8.1 The following transaction types are configured for the manual bank statement. Use the matchcode button to view transaction types.
Transaction
Debit
Credit
ZM01- $-cleared cheque payment
18501 unpresented cheques
18500 Fleet bank
ZM02 -bank charges
66210 bank charges
18500 Fleet bank
ZM03 - $ cleared credit transfers
18500 Fleet bank
18510 Credit transfer
ZM04 - $ cleared lodgements
18500 Fleet bank
18511 lodgements
 
8.2 Enter the statement transactions as required.
screen  Process Manual Bank Statement
9. As required, complete the following fields for all transactions included in the statement:
• Tran
• Value date
• Bank refer.
• Amount
 
Note Cleared cheques and bank charges should be entered as negative amounts and credit transfers and lodgement as positive amounts. When all entries from the bank statement have been entered click on Save .
screen  Process Manual Bank Statement
Note The system displays the message "Statement/list saved".
10. To post the statement follow the menu path Bank statement è Post è Individual statement.
screen  Post Bank Statement/Cheque Deposit List
Caution Ensure that the posting is completed without errors.
11. You have completed this transaction. A batch session has been created by this procedure.
Note The system displays the message,"Statement /list posted."
Result
You need to process the batch session. The batch session name in this case is NATWE -CURR and the users' name is displayed in the created by column.
Comments
Reference See transaction SM35.