Forum Discussion

Selloaccount1's avatar
Selloaccount1
Experienced User
6 years ago
Solved

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/...
  • 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
6 years ago

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
    6 years ago

    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
      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