Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

MYOB for Excel uses up-to-date data straight from your MYOB business so you can export data directly to Excel. Now, the data you need to run reports is readily available and easy to access. And the best part? MYOB for Excel is part of your MYOB subscription.

Setting up MYOB for Excel

To get started, you need to download MYOB for Excel.

Here's how:

  1. Open a blank workbook in Excel.
  2. Click the Insert tab, then click Get Add-ins. The Office Add-ins page will appear.
  3. Enter MYOB for Excel in the search field.
  4. Click Add, then Continue to complete the download.
  5. Close Excel and reopen so the MYOB for Excel add-in appears on your task bar.

Once that's done, just use your MYOB log in details to gain access to your online company file data.

UI Text Box
sizemedium
typeinfo

MYOB for Excel is also available via the Microsoft 365 App Store.

 

 

Using MYOB for Excel

Already have MYOB for Excel and ready to dive in? Let's do it.

UI Expand
titleSign in to MYOB for Excel

Sign in to MYOB for Excel

  1. Open a blank workbook in Excel and click the MYOB for Excel icon.
  2. When prompted, sign in to your MYOB account. A list of all of your MYOB businesses appears.
  3. Select the business file you'd like to use and click Submit. The MYOB data selection panel appears.
  4. Select whether you'd like to switch the Automatically refresh data on open option on or off.
    If you select:
    1. On: the data will automatically refresh.
    2. Off: the data will need to be refreshed manually by clicking the Refresh data button .
UI Expand
titleSelect your data

Data selection

Once you've signed into the business file, you need to select which type of data you'd like to retrieve.

Here's how:

  1. Select the preferences for the type of data you'd like to see, such as the account type, tax code, and current balance. These will be displayed as the column headings in Excel.
    For example, if you'd like a list of all of your suppliers and their current balance, go to Contacts > Suppliers > and select Current balance.
  2. Once you've selected the relevant data, scroll down to the bottom of the panel and click Run. The selected data will now appear in Excel.

Now you can filter, sort and manage your latest data in Excel.

UI Text Box
sizemedium
typetip

Save Excel files to your desktop making it easy to open again.

HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Reporting

Importing and exporting data

Export for accountants