Initial accounts not coming to zero

[zunaid_hingora2]

Hi ,

In our one of client, initial upload account is not coming to zero. We have checked the uploaded file and all entries are there but balance in this accounts are not coming to zero. This relates to period 2013 which is closed and financials are prepared.

Now client is asking the solution for the same. Means now if accounts are not coming to zero, what adjustment is to be done in the system or what accounting entries are to be passed in 2014.

Please guide.

Regards

Zunaid

[zunaid_hingora2]

Hi All,

I agree to all of you regarding initial upload should coming to 0. But reality is not coming to 0. Is there any adjustment entry can we pass.

Regards

zunaid

[sanilbhandari]

Hi

You cannot pass an entry unless you know what the differences are. I would suggest the following approach both at company code and account assignment level:

1. Use F.01 to down load the trial balance from system

2. Create an excel sheet with the following details

SAP GL Account No          SAP GL Balance            Legacy GL No             Legacy GL Balance

3. Check the differences where they exist in the excel file and than think of a way to pass the adjustment entry

Thanks & Regards

Sanil Bhandari

[abdul_jabbar]

Hi,

Enter your all Initial Upload accounts in Tcode FAGLB03, Balance should be zero at the end.

Actually Cumulative Initial uploads GL balance should be zero.

Regards

AJ

[Former Member]

Hi Zunaid,

Generally while uploading the legacy balances to SAP, Legacy GL accounts will be created separately for Assets, Liabilities, Expenses and Income GL accounts.

Try to identify for which legacy GL balance is not matching, so that you can try to reconcile only those entries.

While uploading the balances  two entries should be posted

For example while uploading Liabilities Vendor balances,

1) Legacy GL account Dr   XXXX

Actual Vendor Account Cr (for liability)  XXXX

2) Legacy Clearing account DR XXXX

     Legacy GL account CR XXXX (which was debited in 1st entry)

So this Legacy clearing account will be tallied once the entire TB balance comes inside SAP.

But also ensure that TB given earlier is actually matching..

Reg

karthik

[sanilbhandari]

Hi

There is nothing which can be done in SAP, unless you match your upload files with your legacy balances. Once you identify the differences, than only you can decide what entries have to be passed in SAP and how to pass the entires. You should have tallied the balances that they zero out before even uploading.

Regards

Sanil Bhandari

[Former Member]

Hi Zunaid,

I have one question to you, if the initial upload account is not matching then how the upload data given to you were matching? You can ask this to client.

So they have to match the data given and identify the entry to be posted.

Hope you got my input.

Thanks,