Answer / arun samal

There are different programs to upload electronic bank
statement.
FF.5 or FF_5.
I think your case Multicash format you are using.

You need have three files in FF.5 and two files in FF_5

You can prepare a Z program in order to truncate the
electronic bank statement into two or three part files and
save them on the application server.

1. Take all the external codes list from bank.
2. Take any available documentation from the Bank
describing the relevance of the external codes.
3. Make sure that your Chart of Accounts (Bank Accounts)
last digits logic is appropriate to meet the requirements.
4. Based on this decide the Account Symbols that are
required to be created.
5. Make sure that the masking rules are configured properly.
6. Decide the posting rules that needs to be created.
7. Link up your external symbols provided by the bank with
Posting rules and give proper algorithms for posting and
clearing logic.
6. Concentrate on the posting areas to be posted while
uploading the bank statement.

Further explanation would help you to understand the
functionality when uploaded the electronic bank statement.

Main purpose of uploading the bank statement into SAP is to
make your Bank Main Account and physical bank statement
balance in sync.

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

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'

why do we request parallel currency?

3 Answers  

---

Hi i am preparing for sap fi certification how is the oppurtunities as per the current position.if i may do that certification either i could get the job or not.kindly give your advice thanks in advace regards jos

1 Answers  

---

Tell me the 3 to 4 functional specification?

0 Answers  

---

What is our role in production support and post implementation support as a fico consultant?

0 Answers  

---

what is cycle count in SAP

1 Answers   Infosys,

---

I have one issue in Outgoing Payments - through Trasaction codes F-53 i have i invoice in EURO already posted int he month of March the invoice amount is EURO 80,600 and the amount in local currency in AED 518800 when iam going to make the payment in local currency AED the payment amount is 512800 becoz of Foriegn Exchange Differene and it is gained of 6032 when i am going make a payment trhou F-53. when seleect the invoce it shows me in the value is in the open line items the invoice value is showing is 510800 becoz it is picking the new Exc rate from this month but when i click the currency button it show me the original Amount 518800 and i select and then i have to chareg Off the 6000 diff to Exchange rate Gain/loss account to be Credit when i am going to simulate it show me the an error message The difference is too large for clearing this is an error The difference is too large for clearing Message no. F5263 Diagnosis A non-assigned difference exists for the specified clearing amount. The difference for an automatic difference posting must not be greater than the difference permitted for the user, nor greater than the difference permitted for the tolerance group that is contained in the customer/vendor master record. System Response It is not possible to automatically charge off the difference. Procedure You can charge off the difference manually using the function "Clear differences". You define the upper limits for automatically clearing differences in the tolerance group assigned to the user. Change tolerance groups for user Please helptosolve this issue.

4 Answers  

---

What is the use of account payable in fi?

0 Answers  

---

A finance document usually has an assignment field. This field automatically gets populated during data entry. Where does it get its value?

0 Answers  

---

I have posted asset with 1,00,000/- value. After posted I want to segregate the same asset with 2 dep.terms i.e.25000/- with SLM and 75000/- with Decli.value. how do u customize this settings in asset accounting?

3 Answers   iGate,

---

How we define void reason code in SAP?

4 Answers  

---

what is the diff between profit center a/ctg and copa

3 Answers  

---

DME file configuration steps , how to attach DME file in FBZP configuration.

1 Answers   Cap Gemini,

---