cancel
Showing results for 
Search instead for 
Did you mean: 

Bank data upload at go-live for MAIN , IN, OUT

former_member214876
Participant
0 Kudos

Dear All,

    I have to upload all bank transaction data for go-live. The client gives me his bank statement as on 31.01.2014 . Our system is going live from 01.02.2014 onward.

We have used Main , In , Out bank concept in SAP.

The client bank statement data is as follows.

AS ON 31.01.2014
BALANCE AS ON BANK ACCOUNT4822709.00
BANK CHARGES DEBITED BY BANK BUT NOT CREDITED IN SYSTEM3562.00
AMOUNT TRFD. FROM SAVING TO SWEEP A/C256238.00
INTEREST CREDITED BY BANK BUT NOT ENTERED IN SYSTEM73125.00
CHK ISSUED BUT NOT CLEARED25543.00
849.00
595.00
1022.00
1722.00
12681.00
8831.00
1526.00
1361.00
3652.00
4870.00
3311.00
4650.00
17198.00
47694.00
10438.00
96394.00
138786.00
2300.00
56979.00
27354.00
97985.00
BALANCE AS PER TALLY4443643.00

Could anybody guide me how should upload these figures in SAP . Also how should I manage bank reco (manully - FF67) for the above also.

Regards

     Soumya Ranjan.

Accepted Solutions (0)

Answers (2)

Answers (2)

raheem_baksh
Contributor
0 Kudos

Hi Soumya,

As Mr.Jan Said that first you have to know the concept of Legacy Account that is Correct.

As you have mention "System is going live from 01.02.2014".

For Cut over activity you have to post entry with Legacy Account.

Eg. Main Bank Account Dr

     To Legacy Account

After system gone live you can use FF67 for BRS.

Regards

Raheem

former_member183294
Active Participant
0 Kudos

Soumya Ranjan

With help of ABAPers  - through BDC  you can upload Excel File.

WIth Regards,

Ganesh

former_member214876
Participant
0 Kudos

hi,

That I know. But which fig. to take on main bank in bank out bank as on 31.01.2014 .

former_member183294
Active Participant
0 Kudos

1.1      Maintaining BRS Document

  • In the header data, Bank statement opening balances and closing balances are provided before creating the bank statement. This is the control check after entering all the lines in the bank statement.
  • After providing the bank statement header data, we need to enter or create the bank statement in the system. The bank statement data can also be copied from an excel file to create the bank statement in the system.

Op- Opening bal i.e closing bal of last statement

Cl- Closing bal i.e. Op+Z001-Z002 = Closing bal.

Tras – Z001 – Receipt document nos.     

           Z002 – Payment document nos.

  1. Eg.  T.code-Zff67

File name - Upload excel file

Processing Mode

After selection of file execute zff67 then it read from BDC .

After completion uploading data through BDC

It gives Posting entries

1.2      Batch Input: Session Overview

In Batch input it will display list of BDC Uploaded.

  1. T.code :- sm35

Select and Process

I hope you will hlep this process

With regards

Ganesh

former_member214876
Participant
0 Kudos

Dear Ganesh,

Thanks for your effort. I know all the processes that you have shown. Actually what my concern is what should be my accounting entry for cut over data for Main , In , Out Bank. for above case.

Regards

Soumya Ranjan.

former_member183294
Active Participant
0 Kudos

Soumya Ranjan,

This may be helpful-- http://scn.sap.com/docs/DOC-50621

Still i am not be in part of Implementation ...

I am glad to know ... what is process to be follow at cut over activity

With regards,

Ganesh

Former Member
0 Kudos

Hi Soumya,

Nobody can give you an answer on this forum. For that, you need to have the knowledge of your company - which only you and your colleagues have.

First, what is the relation between the "legacy" GL accounts and the ones you want to introduce with electronic bank statement (EBS) in SAP?

It appears that in "legacy", there are multiple "in" and "out" accounts by purpose. For example,

- How do you plan to book bank charges? Some companies debit them to P&L automatically from the bank statement, others first put them to a "transit" account and then move them from there manually after approval. Which account will you use?

- If there will be transfers from one account to another (in your case, from savings to sweep), where will the EBS make the offset entries?

- etc.

After answering these questions, you will know which "new" account corresponds to each of your client's "legacy" accounts. Then you load the balances against a "data migration" account (many companies choose 9999999999 or so) which will be zero after loading the whole trial balance.

Then, in the next step, you may want to set the balances of the "in" and "out" back to zero and loading them back as "open items" in the same structure as you will expect them on the future bank statements and with texts / assignments / references etc. to help users with reconciliation. Or you can combine these two steps together (load some accounts as balance and others by item) but it is usually less practical.

Does this help? It looks like you are simplifying the structure of "in" and "out" accounts compared to legacy which may in the end become confusing to users (outgoing checks, acct-to-acct transfers and unreconciled bank charges may end up on the same "out" account). You may also want to reconsider it - and perhaps take the legacy as an inspiration what level of detail could be technically feasible and beneficial to users. But it is just a thought.

Good luck!

former_member214876
Participant
0 Kudos

HI Jan,

        Thanks for your effort. The client is only using a single bank GL for all the payment , recipt etc.

I have created 3 GL for a single bank a/c in order to easily reconcile the data. I just put the question in order to gain some knowledge and solution for it as asked by the client.

Regards

       Soumya Ranjan.