Skip to Content

Initial accounts not coming to zero

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 15, 2014 at 11:42 AM

    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,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 15, 2014 at 11:57 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 16, 2014 at 09:45 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2014 at 05:51 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 23, 2014 at 02:45 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.