Partner Zone
Partner Zone

importing data into new company file

Highlighted
Contributing User Selloaccount1
6 Posts
Contributing User
Selloaccount1
Contributing User

6Posts

0Kudos

0Solutions

Solved: Go to Solution

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?

3 REPLIES 3
MYOB Moderator Neil_M
11,386 Posts
MYOB Moderator
Neil_M
MYOB Moderator

11386Posts

1302Kudos

1605Solutions

Re: importing data into new company file

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

Regards,
Neil

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Contributing User Selloaccount1
6 Posts
Contributing User
Selloaccount1
Contributing User

6Posts

0Kudos

0Solutions

Re: importing data into new company file

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?

MYOB Moderator Neil_M
11,386 Posts
MYOB Moderator
Neil_M
MYOB Moderator

11386Posts

1302Kudos

1605Solutions

Accepted Solution Solved Solution

Re: importing data into new company file

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

Regards,
Neil

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post