Forum Discussion

Selloaccount1's avatar
Selloaccount1
Experienced User
6 years ago

importing data into new company file

Hi all,

Our company file size is over the limit now. We are planning to move data(01/01/2019 to now) to a new MYOB company file. we want to keep the Monthly Ending balance for all accounts from 1/7/2018 to 28/2/2019. So we export account information for each month. But when we import account information to the new myob accountright company file. The system only accept one month figure.

 

Is anyone could assist?

  • Neil_M's avatar
    Neil_M
    6 years ago

    Hi Selloaccount1 

     

     

    In terms of what can be exported, I recommend going to File >> Import / Export Assistant. This will let you see all of the different information that can be exported. This includes open bills and invoices from the previous file.

     

    When importing, anything that is imported will impact the company file. This does mean that transactional information like sales will impact the various accounts. In contrast if the sales / purchases are manually entered in as preconversion sales and purchases, they wont impact the existing account balances

  • Neil_M's avatar
    Neil_M
    Former Staff

    Hi Selloaccount1 

     

    Within AccountRight if you are importing account balances, the system will only bring across the one figure, it doesn’t have the capability to bring across monthly balance figures for each account.

     

    If you were wanting to have historical monthly balances in an account history you would need to start the file using the conversion date on or before the first month you want the balances for and then record a transaction for each month to adjust the monthly balance to the desired figure. As this would potentially be a number of journal entries, I recommend speaking with your accountant over how these should look

    • Selloaccount1's avatar
      Selloaccount1
      Experienced User

      Hi Neil,

       

      Thank you for your reply. it's helpful. I have one more question.

      Since we import current balance into new myob company file. Can i also export open bills and open invoice from the old company file? will that affect any figure to current balance?

      • Neil_M's avatar
        Neil_M
        Former Staff

        Hi Selloaccount1 

         

         

        In terms of what can be exported, I recommend going to File >> Import / Export Assistant. This will let you see all of the different information that can be exported. This includes open bills and invoices from the previous file.

         

        When importing, anything that is imported will impact the company file. This does mean that transactional information like sales will impact the various accounts. In contrast if the sales / purchases are manually entered in as preconversion sales and purchases, they wont impact the existing account balances