Manual Bank Statement FF67

[Former Member]

Hi Guys,

What is the purpose of doing manual bank statement in SAP?

I understand this is for the purpose of reconciliation.

Why does the bank send us a file in the first place and what do we reconcile this with?

Do we do some kind of clearing with this file and what file does the bank send.

what is this process about.

pls clarify.

thanks

srikanth.

[Former Member · Accepted solution]

Hi,

1) The purpose of manual bank statement is for bank reconciliation

2) Bank sends bank statment for a period (say, weekly, monthly etc,)

3) In SAP, bank accounts are maintained as sub accouts and main bank account

for example, if the corporate has an account with a bank, the corp creates bank GL accounts in the following manner

a) a main bank account

b) bank sub GL acounts for, incoming payments, out going payments, bank charges, etc

Day to day bank transactions are posted in the sub accounts. When the manual bank statement is uploaded, the system clears the sub accounts and the amounts will be transfered to the main bank account

Ex: Out going payment is posted

vendor a/c Dr.

Bank Outgoing sub account Cr.

Now, bank out going sub account has a credit balance, when the bank statement is uploaded, the credit balance in the sub account will be cleared and transfered to main bank account

Bank outgoing sub account Dr.

Main Bank account Cr.

Hope this will clarify your doubts. Feel free to revert in case futher clarifications are needed

[Former Member · Accepted solution]

Hi Guys,

Thanks for your valuable replies.

I came to the understanding that BRS is used to reconcile the bank statement with our main Bank account in SAP so that both are in sync.

Then why do we need so much configuration in setting up of this BRS.

What is the kind of format that the bank sends us and what does it contain.

What is again the electronic bank statement.

thanks

srik.

[Former Member · Accepted solution]

HI,

The configuration is needed for automatically clearing the open item in the sub accounts, when the bank statement is upladed.

Different banks send bank statment in different formats. You can use a BDC for uploading the bank statement thorugh FF67 (say using EXCEL sheet)

Electronic bank statement is used when the bank sends the bank statement in MT940, or MULTYCASH formats. This makes life easy as the bank statement can be uploaded with out much of manual work. In case of manual bank statement, the transaction details have to be fed into the system in FF67 txn.

[former_member130680]

the purpose of doing manual bank statement in SAP is to match the balance of Bank with cash Book bank balance or for reconciliation purpose. For manual bank statement the bank provide the statements hard copy and with that we reconcile the balance of Bank and match balance of Bank.

[Former Member]

Firstly, i have mix background (auditor --> Bank reconciliation --> doing FICO now), so my answer is diff from other.

What is the purpose of doing manual bank statement in SAP?

There are advantage in doing manual bank statement in SAP

1. can review the bank statement in SAP anytime without pull hard copy bank statement  from your warehouse, this can using TCode FF_6

2. provide audit trail and control for users.

3. can utilize the manual bank statement to generate bank statement entries (as mention by SAP gurus like above), this will enable the matching with the other correspondence entries. SAP enable to show how you match it by display FI Doc (F-03), check the clearing doc number and display the payment usage of the clearing doc.

Why does the bank send us a file in the first place and what do we reconcile this with?

Bank may sent you CSV file, txt file or other SAP compatible file like MT940, Multicash or BAI format. If bank is send the compatible format, you may utilize bank statement to post and maintain in SAP.

Do we do some kind of clearing with this file and what file does the bank send.

SAP have some functionality on auto clearing the GL account like F.13, you may utilize the benefit of this standard tcode.

[Former Member]

Hi

In SAP we create house bank so this is the main bank a/c and we also create 2 sub bank a/c i.e payment and collection. In main bank account we don't pass any manual entry and all collection will be pass in collection a/c and all payment will be in payment a/c so accounting entry will be like that

in case of payment----

Vendor A/c ---dr

To Bank Payment

In case of collection

Bank Collection a/c dr

To Customer

When bank send us a Bank statement (in this statement we find how much check cleared within that time period includind check number and clearing date) we go for FF67 manual BRS

Here entry will be

In case of payment

Bank Payment A/c -

---

dr

to Main Bank

In case of Collection

Main Bank A/c -

---

dr

To Bank Collection

Mainly Ww do that process because - say this month company issued 100 checks and when the bank send us the details of check clearing we found that only 70 checks are cleared so we do that to match BANK BOOK balance with main bank a/c balance

Regards

Tanmoy

[Former Member]

Hi

In SAP for every house bank (Bank account of customer) 3 GL accounts are defined

Incoming account - For all incoming receipts

Outgoing account - For all outgoing payments

Main bank account - Based on bank statement entered in FF67 system would match the above entries with that bank statement and then move to this account from above accounts. Thus the entries in bank statement and main bank account would then be reconciled. Incoming recepits and outgoing paments made but not reflected in bank statement would remain as open entries in the above 2 accounts

Thank You,

[former_member182098]

Hello,

What is the purpose of doing manual bank statement in SAP?

To reconcile your main bank account in SAP with your manual bank statement sent by your bank.

Why does the bank send us a file in the first place and what do we reconcile this with?

This an electronic format, SAP has provided different formats such Multicash, BACS formats. This is also similar like manual statements, but you can upload mass data of bank transactions into system to match you rmain bank account in SAP with the electronic file sent by bank.

Do we do some kind of clearing with this file and what file does the bank send.

Based on the configuration, you will clear the customer and vendors. You are required to maintain proper algorithms. The algorithms play a pivotal roles in clearing the open items.

The following notes may be useful to you.

You do not have any traditional Bank Reconciliation Statement (BRS) report in SAP.

SAP is normally you maintain bank main account and bank sub account. Whenever you make a payment through F-53 or F-58 or F110, the entry would be:

Vendor Account Dr

To Bank Sub Account

The ending digits of the sub-account would be important in configuring the masking rule. Based on this masking rule when you upload the bank statement the entry the system would pass is:

Bank Sub Account Dr

To Bank Main Account

It depends on the configuration, either the sub account will be cleared by the system automatically or you need to run F.13 to clear the sub accounts.

At the time of receipts, you have different accounting entries unlike payments. It needs to post to two posting areas. 1. GL Accounting 2. Sub-Ledger Accounting

The entries would system itself pass is:

Bank Main Account Dr

To Bank Sub Account

Bank Sub Account Dr

To Cutomer account.

Clearing logic mentioned for your posting rules and the alogrithm used for your external bank symbols will also play pivotal role in clearing the accounts.

Ideally you will use

FF67 / FF.5 / FF_5 for uploading manual or electronic bank statement

FEBA / FEBA_BANK_STATEMENT is used for furthe rprocessing.

GO THROUGH SAP NOTE 48854

Regards,

Ravi

[Former Member]

Hello

In one of your posts you had mentioned that deleting a statement once uploaded , even though possible, was not recommended. So if we have an issue that require reversing entries and reuploading statements because previously the statements were not uploaded in the correct sequence, what is the solution?  Should we resort to manual entry FF.67?

thanks

suresh