Manual bank statement

[Former Member]

Hi,

Can someone explain me why do we need the manual bank statement, under what circumstances we create and when do we use electronic bank statement and how to upload the same in the SAP.

Plz. help me in configuring the same.

Regards,

Aman

[Former Member]

Dear all

I am getting the message that "Bank account number not unique" at FF67. I have change many house bank but there is still the above message exist.

Tell me the solution.

THanks

Mehdi

[former_member182098]

Question:

Can someone explain me why do we need the manual bank statement, under what circumstances we create and when do we use electronic bank statement and how to upload the same in the SAP.

Plz. help me in configuring the same.

Answer:

If you have few transactions which can be managable to enter manually, you go to with manual bank statement.

If you have large number of transaction, then it is preferable to go with Electronic bank statement.

Hello,

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

Always the main bank account in SAP will be in sync with Physical or Electronic Bank Statement. Balances in sub-account (In and Out) will be form part of your Bank Reconciliation Statement (BRS)

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

Please go through SAP Note. 48854. You will get an idea regarding the functionality of the algorithms.

Though this note is in relevant to GB specific, you will find this very useful.

description follows below regarding the normal procedure for maintaining table T028G. Due to the different bank codes and posting rules, pre-Customizing is not possible at this point.

The following processing types are available - unless stated otherwise, you should use the interpretation algorithm: '000 - No interpretation' in each case.

1. '00': There is no processing. The entry line is ignored.

2. '01': A validation is made whether an entry exists for the transferred check number in the check table (PAYR). The check number and payment document number are transferred for further processing. Interpretation algorithm: outgoing check processing '011'-'013'; the update in the check file is via the interpretation algorithm.

3. '02': Transfer of the ending balance to the electronic bank statement

4. '03': Transfer of the opening balance to the electronic bank statement

5. '04': Clearing via the allocation number which is delivered with the bank statement. No interpretation algorithm.

6. '05': Clearing of BACS payments or BACS bank collection. The reference text field is first read to ascertain whether it involves payments initiated by users or bank collection via BACS. Providing it does involve a cash transaction initiated by the user, the payment document numbers concerned are determined via the reference number and transferred as a reference to further processing. Interpretation algorithm: '000 - No interpretation' or '019 - Reference number DME'.

Note

To differentiate between the two procedures in table T028G, you have to maintain two separate entries.

Example: the bank uses bank code '62' for cash receipts and for BACS bank collection.

Ext. Transaction +/- sign Posting rule Int. Algorithm Processing type 62 + GB62 001 5

62 SAPBACS + GB63 000 5

7. '06': Bank costs or interest revenues

Recommended interpretation algorithm: '000 - No interpretation'

8. '07': Total amount of cash disbursements

9. '08': Total amount of cash receipts

10. '09': Items not paid

Recommended interpretation algorithm: '000 - No interpretation'

Regards,

Ravi

[Former Member]

Hi,

Check this thread searching for BRS, thanks to Mr.Para for giving exhaustive explanation.

This is a basic issue where we compare the Bank Statement issued by the Bank upto last working day of a month and the balance in our Company accounts. We reconcile the balance between the two. There may cheques issued by us posted in our system not reflecting in the Bank books; cheques deposited by us in the bank waiting for realisation etc. We will be uploading the Bank statement through FF67 so that the balance in the main Bank A/c tallies with the balance of Bank issued statement.

Sadashivan

[former_member625419]

HI

Configuration Document for Manual Bank Reconciliation Process.

1. Define Posting Rules :

Path : SPRO u2013 Financial Accounting (New) u2013 Bank Accounting u2013 Business Transactions u2013 Payment Transactions u2013 Manual Bank Statement u2013 Define Posting Keys and Posting Rules for Manual Bank Statement u2013 Define Posting Rules.

2. Maintain Variants for Bank Statements :

In this we define variants for Manual Bank Statements as required and then this variant is attached in FF67.

Path : SPRO u2013 Financial Accounting (New) u2013 Bank Accounting u2013 Business Transactions u2013 Payment Transactions u2013 Manual Bank Statement u2013 Define Variants for Manual Bank Statements.

3. Additional Rules for Automatic Clearing :

For clearing bank accounts we need to maintain clearing rules.

Path: SPRO u2013 Financial Accounting (New) u2013 General Ledger Accounting (New) u2013 Business Transactions u2013 Open Item Clearing u2013 Prepare Automatic clearing.

Thanks,

Rup