importing data into new company file

[Selloaccount1]

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]

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]

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 · Accepted solution]

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