How to integrate Prism and MYOB master data

How to integrate Prism and MYOB master data

Release Date: 22 October 2020

This release applies only to Prism Finance subscribers who also use the MYOB Accounting solution.



EXPORT TAX RATES AND CHART OF ACCOUNTS FROM MYOB

Pre-requisites:

  1. The User must be a MYOB Administrator or Accountant/Bookkeeper (with authority to import or export data). You can check your role on Setup menu > User Access).

Steps:


1. Go to the File menu > Import/Export Assistant.
2. In the Import and Export Assistant window select Export data and click Next button.



3. Select the Data Types you want to export from the Export list. If additional options appear in this window, you can complete them to filter the data that will be exported.

-    Tax Code List (Tax Rates)



-    Chart of Accounts:


4. Specify the Format for the export file. Select Commas option and include field headers in the file check box (the data in the exported file will be separated using commas and included the headers). Then click the Next button.


 

5. Click the Add All button. All Available fields will be displayed in the Fields to export.


 
6. Complete the selection, click the Export button.
7. Enter the name and select the location where you want to save the exported file and click the Save button. The data is exported and saved as a text file.
8. When the data has finished exporting, click the Close button.
9. Return to step 3 and this time select Accounts (Chart of Accounts) to export, and repeat steps 4-8.

IMPORT TAX RATES AND CHART OF ACCOUNTS TO PRISM

Pre-requisites:


  • Prism users subscribed to Finance module and configured to use MyOB. Contact support@prism.horse otherwise.

  • Possess recently exported tax rates and chart of accounts files from MyOB.


Steps:

1. Go to Prism Finance > Configure > Tax Rate. Click on Import from MYOB.


2. Browse your computer and select the Tax Rates csv file recently exported from MYOB.
3. Upon import, results should appear in the Prism Finance > Configure > Tax Rates screen.


4. Go to Prism Finance > Configure > Chart of Accounts. Click on Import from MYOB.


5. Browse your computer and select the Chart of Accounts csv file recently exported from MYOB.
6. Upon import, results should appear in the Prism Finance > Configure > Chart of Accounts screen as per below.




EXPORT MYOB CUSTOMER ID CARDS

Pre-Requisites:
  1. Customer Accounts setup in MYOB
Each Prism owner’s billing account must match a corresponding Customer Card in MYOB.  
To ensure this match occurs between MyOB and Prism, you need to copy each customer’s Card ID from MYOB onto the Prism Owner Account profile.  
You can manually source the Card ID for each customer in MYOB.



Or you can export those Card IDs by performing the following:

1. Go to the File menu and choose Import/Export Assistant. The Import and Export Assistant appears.
2. Select Export data then click Next.
3. In the Export field, select Cards from the drop-down list.
4. Select Customer Cards to export and click Next. The Format step appears. 
5. Leave the default format options and click Next. The Select Fields step appears. The fields in the left panel are the fields you can export. You only need to export First Name, Co./Last Name, Email and Card ID
6. Click Export. The Save As window appears.
7. Specify where you want to save the file. Click Save.

UPDATE PRISM OWNER ACCOUNT PROFILES WITH MYOB CARD IDS

Pre-Requisites:
  1. MYOB Card IDs exported for easy viewing
Steps:

1. For each Customer exported from MYOB, locate the relevant Owner Profile in Prism
2. Go to the Owner's Finance Account tab, and edit the MYOB Card ID field.

3. You can Edit or Delete this Card ID where required, on each Owner Finance Account.

After Card ID is configured for Owner’s billing account, it will be used to map the Prism Owner with the respective Customer in MYOB, when exporting Invoices to MyOB.


Head over to How to integrate Prism and MYOB during each billing cycle to understand the integration between MYOB and Prism during each billing cycle.

    • Related Articles

    • How to integrate Prism and MYOB during each billing cycle

      Export Statements From Prism Prerequisites: Prism user has statements (monthly or single/quick invoices) Chart of Accounts and Tax Rates of transactions in the statements to be exported, match the ones imported from MYOB Each Prism owner’s billing ...
    • Prism Finance and MYOB Overview

      OVERVIEW OF BOTH SYSTEMS  The integration with MYOB allows Prism Finance users to manage finance transactions and billing processes in Prism, along with payment reconciliations and other accounting specific tasks in MYOB. Specifically, MYOB is used ...
    • Get Started with Prism Finance

      Prism has partnered with Xero, Thoroughbred Payments and Thoroughbred Recoveries to bring you a revolutionary new dimension to efficiently manage your operation’s expenses, invoicing, payments and overall management.  Prism Finance Overview Prism ...
    • How to integrate Prism and Xero

      Prism has chosen Xero as its Finance partner quite simply because they are recognised as the best online accounting system in the world. It is simple and easy to use, affordable but powerful and also able to be integrated to a wide variety of third ...
    • Prism Finance And Xero Overview

      Overview of Both Systems The integration with Xero allows Prism Finance users to manage finance transactions and billing processes in Prism, along with payment reconciliations and other accounting specific tasks in Xero. Specifically, Xero is used ...