MYOB AccountRight

Integrating with MYOB AccountRight

Last Updated: May 10, 2024

 

 

GL Code Setup  

Prior to exporting invoices to MYOB AccountRight, you may wish to set the default GL Code for your Suppliers. This enables a streamlined export process wherein the nominated GL Code is selected and applied when transferring your approved invoices to MYOB AccountRight. Two main methods for applying these default exist; by Supplier and by Line Item.

Tip: If your database consists of multiple Outlets, GL Code details will be automatically retrieved from parent Outlets. This enables the below GL Code methods to apply default values from your Mid- or Corporate-Level Outlets unless otherwise specified.

Default Supplier GL Code

To apply a default GL Code across all of a Supplier's stock items, navigate to your Address Book under the Admin page:

AddressBook

Select your desired Supplier from the list provided and open the Supplier Settings tab:

MYOB_AccountRight_1

Enter your desired GL Code under the Default Account Code field. Your changes will be automatically applied. If required, repeat this process for any other Suppliers you wish to update.

Please Note: This default GL Code will only apply to stock items which are Food/Beverage/Default enabled. Stock items which do not fall within this category must be directed to a specific GL Code manually when exporting an invoice which contains them. Alternatively, please see Individual GL Codes below to specify individual GL Codes to bypass this requirement.

Individual GL Codes

Should you wish to customise the GL Code assigned to individual stocks, this can be accommodated by enabling the Stock Maintenance - GL Code column. To enable this column, expand the Admin heading and navigate to the Settings page:

Settings

Under the Main Settings tab, scroll down to locate the Grid Settings button:

MYOB_AccountRight_2

Enable the Stock Maintenance - GL Code column and click Save Setting to apply:

MYOB_AccountRight_3

This column will now be visible when viewing your stock items under the Stock Browser window. This is the window that appears wherever stock can be selected and edited, such as under the Stock Maintenance page. Any individually supplied GL Code for your stock items will take precedence when exporting to MYOB AccountRight.

Connecting to MYOB AccountRight

Begin by navigating to the Integration page to view and selecting the MYOB AccountRight icon:

MYOBIntegration

You will then be prompted to log in to your CTB AND CO. account. Please enter your email address and password and click Login to proceed:

MYOB_AccountRight_4

Once you have verified your access, click the Connect to MYOB link when prompted:

MYOB_AccountRight_5

A new window will be displayed which directs you to MYOB's login page. Enter your MYOB credentials and sign in. This window will then close and your connection to MYOB will be established. Click Continue to proceed:

MYOB_AccountRight_6

You will then be asked to select the desired Company File you wish to connect to. Select the desired file from the list provided and click Select:

MYOB_AccountRight_7

Lastly, you will need to sign in to the selected Company File. Enter the applicable credentials and click Login:

MYOB_AccountRight_8

Please Note: If the selected Company File is not password protected, leave the Username field as 'Administrator' and do not enter a password. Simply click Login to proceed.

Tax Codes & Configuration

Before transferring your invoices to MYOB AccountRight, please take a moment to check your Tax Codes and supply a Category if required using the appropriate toolbar buttons at the top of the page: 

MYOB_AccountRight_9v2

To review and make changes to the default Tax Codes applied, click the Check Tax Code button. You will then be able to view and edit the Tax and Tax Free codes as desired. Make any required changes and click Save to apply.

To review and update the nominated Category, click the Configuration button and enter the desired Category Code.

In this window you can also optionally provide a Job Code or choose to Prevent duplicate invoices. Once you have made your selections click Save to apply.

myobnew

Finally, to save the MYOB Business File per outlet, you can use the new Change Location button that is found beside the Configuration button.

Change Location

Transferring an Invoice

Using the checkboxes provided, select the invoices you wish to transfer then click Transfer Invoice:

MYOB_AccountRight_10v2

You will then be prompted to select the default Account / GL Code for the invoice. This is the GL Code that will be assigned to each line item under the selected invoices (unless otherwise specified directly against the stock item itself. See Individual GL Codes for clarification). From the list provided, expand the desired classification section and select the desired Account, then click Continue to proceed:

MYOB_AccountRight_11

Tip: If a valid default GL Code was assigned to the Supplier of the selected invoice/s, this step will be automatically skipped.

At this stage, you will need to clarify how you intend to record any Freight that may be shown on the selected invoices. You may either use MYOB's designated Freight field for this amount, or otherwise record it as a line item under a specific Account. Click your desired option to proceed:

MYOB_AccountRight_12

If you opted to use a separate Account, you will then be asked to specify which Account you wish to apply Freight under. Select the desired Account and click Continue.

To determine which Supplier your invoices are to be matched against, you will need to specify a corresponding MYOB Supplier using the provided drop-down lists. Click under the MYOB Suppliers column to view and select the desired Supplier for each record:

MYOB_AccountRight_13

The selected invoices will now be checked for any non-Food / Beverage / Default items. If an invoice contains such stock items, you will then be asked to specify a separate GL Code / Account. This can be applied to all non-Food / Beverage / Default items which exist across all selected invoices to be transferred, or on a per-item basis. Select your desired approach and use the drop-down lists provided to select an Account, click Continue to proceed:

MYOB_AccountRight_14

Your invoices will now begin to be transferred to MYOB AccountRight. Please wait while the transfer is completed and note the Status and Message of each invoice which indicates the success of the export:

MYOB_AccountRight_15

Your transferred invoices will then appear within MYOB AccountRight as an open bill. Where supported, PDF attachments will also be displayed in MYOB AccountRight for each corresponding invoice.