Share your ideas for improving. Vote on ideas and discuss them with the MYOB product development team.

Product Ideas

API: Connecting to Excel

Experienced Cover User

15Posts

2Kudos

0Solutions

15 Posts
Experienced Cover User
Australia

Just recently upgraded from v19 to 2013.3. Not very happy with the export to Excel formatting at all. I now have to reformat all the exported reports as the numbers come through as text, not numbers.

Also, I had an ODBC connection in the last version which has now disappeared.

I am used to being able to download information directly into Excel from the accounting package without having to "Export"it.

I would like to see the reporting functionality improved to allow for more customisation. I understand that MYOB wants us accountants to move away from using Excel as a reporting tool, but that is just denying the the fact that everybody uses Excel as a reporting tool whether you like it or not.

OK - rant over.

 

"Excel add-in"

Current Status: Done
Last Changed: September 2013

You can use the AccountRight Live API to export you data into Excel. It is similar to how users were able to extract data using ODBC Driver for the AccountRight classic product range. The tutorial on how you can extract data in Excel via the API is available from the following link. http://developer.myob.com/api/accountright/tips-tricks-tutorials/ms-excel/connect-ms-excel-myob-accountright-live/

7 Comments
Nic-acc-addons
Super Partner
507 Posts
Super Partner

Hi EdenInOz,

 

Rant away. And as you do, head on over to our website at http://accountingaddons.com.au/ as we specialise in enhancing MYOB and other accounting packages all within Excel.

 

You get the power of MYOB and the familiarity of excel. Have a look at our stuff and let us know what you think.

 

We also have a youtube page with a few videos you can find here. http://www.youtube.com/user/AccountingAddons/videos

 

Regards

 

Nic

EdenInOz
Experienced Cover User
15 Posts
Experienced Cover User

Thanks.

 

I have already check out your website and have requested a copy of budgetlink and sent an email regarding Excelreportlink.

 

Cheers

Yvonne

Mark_Smith
26 Posts
Former Staff
Hi EdenInOz, You'll be glad to know that we'll be fixing excel export in the next release (2013.4). The numbers will come through as numbers and you'll be able to do calculations. regarding working in Excel using ODBC, you can now use the API to do the same thing. I don't want to steal their thunder, but the API guys over at http://developer.myob.com/ will soon be posting a tutorial on using the API with excel. stay tuned.
Dharmesh_Shah
Trusted User
206 Posts
Trusted User
You can use the AccountRight Live API to export you data into Excel. It is similar to how users were able to extract data using ODBC Driver for the AccountRight classic product range. The tutorial on how you can extract data in Excel via the API is available from the following link. http://developer.myob.com/api/accountright/tips-tricks-tutorials/ms-excel/connect-ms-excel-myob-acco...
EdenInOz
Experienced Cover User
15 Posts
Experienced Cover User

Great tutorial and nice to know that the developers were listening to their users. However, my MYOB file is in the cloud. How do I get this to work?

Barry_C
MYOB Staff
2,948 Posts
MYOB Staff

Hi @EdenInOz 

 

In order to connect to an online file through API, you would be best checking out our great Developer site - http://developer.myob.com

 

The first step will be to sign up to our Developer program so you can obtain some API keys. 

 

As for connecting to an online file, I found some documentation here but it is of a very technical nature.

 

As another solution, there are some 3rd party programs such as Easydownloader that can download data on your behalf from a Live file to excel which may suit some users better.

AGerson
Contributing Partner
10 Posts
Contributing Partner

How does one connect Excel to a datafile hosted by MYOB Cloud?