on 02-18-2014 8:29 AM
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 ACCOUNT | 4822709.00 |
BANK CHARGES DEBITED BY BANK BUT NOT CREDITED IN SYSTEM | 3562.00 |
AMOUNT TRFD. FROM SAVING TO SWEEP A/C | 256238.00 |
INTEREST CREDITED BY BANK BUT NOT ENTERED IN SYSTEM | 73125.00 |
CHK ISSUED BUT NOT CLEARED | 25543.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 TALLY | 4443643.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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
In Batch input it will display list of BDC Uploaded.
Select and Process
I hope you will hlep this process
With regards
Ganesh
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
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!
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.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.