Re: how do i export data from excell to myob i have the...
You are going to do the opposite.
Not exporting from excell to myob but to import data of excell from myob)
You might need to save your excell data as an older office 2000 or office 97 version or even comma or tab sepperated file so myob could read it, it depends on your myob version and if it possible.
Thank you for using agadycom.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Go to File - Start a New Year - Start a New Financial Year. Continue through the next few screens until you see the Current financial year and a box showing the New Financial Year. Say your current financial year is 2013 and the New Financial Year shows as 2014. Change this to 2012 and then continue through the screens til the end. Then check your financial year under Setup - Company Information, you will find it now shows 2012. Enter the transactions you need, then go through the process again to change to 2013.
This is an undocumented feature un-supported by MYOB. Try with caution - not aware of any serious consequences but a few I know have done this.
Changing your system date and opening MYOB is a sure fire way to get locked out. MYOB records the date each time you open it. If the date goes backwards, it locks you out. Part of their protection.
when u give the print commant u get an export button on the right side. Press that button and then then selest the rewuired format. XML is the genaralised format used these days. Then import the data in tally
Export to Excel With new release now you would get one more options while exporting data. One added format option is Excel format. If you export in this format then file would be saved in xls format. More over if you put Excel formating option to Yes then tally would automatically format the data in presentable format. Tally would automatically bold the headlines and main fields for you and format data in a good way. Take a look at excel snapshot of balance sheet exported from Tally.
The special thing here is that you can do the calculation on any amount figure or any row or column, which was earlier not possible. The only drawback which i could find was that amount figures are not right aligned which is must for numbers for easy calculation, although you can do it by selecting the amount figures and putting them right aligned.
This implies that basically the versions are causing the problem and there are compatibility issues with your program. I would suggest that you should copy the report files to a detachable media and transfer it to your new system because this is a one time process.
You can also install the same version on both PCs. You can also do following for tracking changes in documents:
In Word 2002 and 2003: Tools > Track Changes.
In Word 2000 and earlier versions: Tools > Track
Changes > Highlight Changes. Tick Track Changes