Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
Share your ideas for improving MYOB Business/Essentials. Vote on ideas and discuss them with the MYOB product development team.
Need to make all reports exportable to excel
Cant export trial balance to excel
Cant export GST reports to excel
Balance sheet exports account numbers and account description into separate columns yet P&L is concatenated - WHY?
All this makes it time consuming to prepare working papers
"Export reports to excel"
Thank you for all showing your support for this idea
MYOB Business allows for all reports to be exported to Excel.
Hi Essentials Team,
Previously from memory - Live Accounts allowed export of to excel for the trial balance.
1) Could we get this feature reinstated for the trial balance for Essentials? Similar to that it would be great if we could get the GL to be exported in excel format as well. This is a heavily used feature for accountants and if all reports could eventually export to excel - we will love the product even more!
In addition to the above, if you could introduce report customisation of:
2) Being able to remove $ symbols and format ZEROs as dashes or just leave it as blank.
3) All Reports to be able to filter out accounts with zero balances so that the reports will be shorter (removes lines with nil balances).
Suggestion 2) and 3) will ensure that we don't go crazy from looking through the reports that come out of MYOB Essentials. Suggestion 1) will make the data much more usable for us in excel.
Thanks - I am happy to take a call if you need me to demonstrate the above.
03 9894 2500
Saward Dawson Chartered Accountants
Would definitely agree. We are in the process of transitioning our business from a sole trader operation to a company structure - which requires two MYOB profiles. Yet all our customers and suppliers remain the same. Was searching online to try and figure out how to export contacts from our old MYOB profile to the new.... but clearly not an option and will all have to be done manually painful.
I use MYOB Essentials and i am looking to export my customer details so i can create a database of my customer details.
It seems a large oversight to not allow a business owner the option to export his customer details?
How do i export details?
Hi @Merchandisingli - run Reports - Contacts - Customers and print your report to a PDF File (using Cute PDF, pdfDocs, Acrobat or similar).
Then open your file in Adobe Acrobat Reader. Using its' Tools menu, you can convert it to Excel or Word, with their online converter (you'll need an annual subscription, which costs about $22 - but it's well worth it !).
Doing exactly the same thing😥
I have used the app on the go to view the files on my phone while entering into essentials on my ipad......I dont have a pc
but painful.....just entering them as I need them, not in one go
I want to put my hand up for this one. It is Christmas time and I can't even export a customer list. This restricts any extra contact with customers. No contacting them for Christmas and no way of letting them know of any special offers.
I need this!
Please consider allowing Customer details to be exported to Excel
Had a client wanting to do this for Trial balances and thought this should be a feature...
Just an idea.
What is it that you would like to export to Excel?
In the past I have ususally run the General Ledger detail report and exported that to Excel. The accountants I work with are happy with this, if they don't want their own log in to the business data.
Don't forget that there is already an option to export to an MYE file, but that file format may only work with Accountant's Office software.
The trial balances report?
Generating report only gives the option to save as PDF?
Client wanted to be able to export this report to Excell..
From what I found this wasn't possible? Is that correct? And only way would be to convert the PDF after saving?
It looks like you are correct. The trial balance cannot be saved as an Excel file.
There are some big holes in Essentials and it looks like this is another one.
I also tried to run the General Ledger report as a summary without any details, but that is not an option either.
I have voted for this suggestion.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.