This integration allows for financial data to transfer to MYOB for accounting purposes and bank reconciliation.
You MUST have an AccountRight MYOB account for this setup - MYOB Essentials does not support integration and can't be linked to TransVirtual.
There are two broad steps:
1. Link TransVirtual to your MYOB account
2. Export your invoices (EDI) to MYOB.
Navigate to Account Packages (Finance > Other Setup > Account Packages)
Select + New Account Package button
(Users of the 2022 navigation update should proceed to Finance > Configuration and Setup > 3rd Party Account Links)
Give your new account package a name, this may just be MYOB if you only run one account package however TransVirtual has the ability to split your invoices across multiple account packages and companies
Click the Create button
Your Account package will start as disabled (highlighted orange) until setup is complete
Select your new account package from the list on the left and then select the relevant account package in this case being MYOB and click Update at the top right
Click the Refresh MYOB Link button
You will be taken to the MYOB web page where you will need to enter the online user login details of an admin user for your account package and presented with a page giving TransVirtual permission to transfer data to your MYOB account.
You will also need to create an offline admin user for TransVirtual also to access your company file. You can do this in your MYOB software as below by going to Setup>User Access
As below select New User, the user name and password will need to be later entered into the TransVirtual for us to access your company file. The
Also deselect the option below for the user to sign on with a my.MYOB account as this will need to be a login just to your company file
Also ensure the new user is given Administrator access
Once complete you can now return to TransVirtual and enter this username and password as below
Now we can select the relevant GL Accounts in MYOB for the invoices to Transfer against. As per below select Link Income Code and Link Expense Code and you will see a list of accounts from your account package and select the relevant code for Customer Invoices/Income and Supplier/Agent Invoices/Expenses
You are now able to toggle the Enable Package to Yes then click the Update button
Now navigate to Export Invoices (EDI > Data Export > Invoices) where we will need to setup conditions surrounding the use of the Link to MYOB
Select New Rule from the center of the page and create a name for your rule, for a simple setup this can just be MYOB and select the AccountPackage option from the Export Framework dropdown as below
(Users of the 2022 navigation update should proceed to Import/Export > Data Export > Invoices)
Now we need to set a trigger for these invoices to transfer to MYOB
In the data filter section you have a rule builder as below, if you choose Invoice State from the dropdown and select Next, then select Equal from the drop down and click Next, then choose Approved and Locked from the dropdown and select Add Rule
Now we are ready to enable the rule
Linking to Xero
The Xero integration allows for financial data to transfer to Xero for accounting purposes and bank reconciliation.
There are two broad steps:
1. Link TransVirtual to your account package
2. Export your invoices (EDI) to the account package.
Navigate to Account Packages (Finance > Other Setup > Account Packages)
Select + New Account Package button
(Users of the 2022 navigation update should proceed to Finance > Configuration and Setup > 3rd Party Account Links)
Give your new account package a name, this may just be Xero if you only run one account package however TransVirtual has the ability to split your invoices across multiple account packages and companies
Click the Create button
Your Account package will start as disabled (highlighted orange) until setup is complete
Select your new account package from the list on the left and then select the relevant account package in this case being Xero and click Update at the top right
Click the Refresh XERO Link button
You will be taken to the Xero web page where you will need to enter the login details of an admin user for your account package and presented with a page giving TransVirtual permission to transfer data to your Xero account.
Once complete you can now return to TransVirtual where we can select the relevant GL Accounts in Xero for the invoices to Transfer against. As per below select Link Income Code and Link Expense Code and you will see a list of accounts from your account package and select the relevant code for Customer Invoices/Income and Supplier/Agent Invoices/Expenses
You are now able to toggle the Enable Package to Yes then click the Update button
Now navigate to Export Invoices (EDI > Data Export > Invoices) where we will need to setup conditions surrounding the use of the Link to Xero
Select New Rule from the center of the page and create a name for your rule, for a simple setup this can just be Xero and select the AccountPackage option from the Export Framework dropdown as below
(Users of the 2022 navigation update should proceed to Import/Export > Data Export Invoices)
Now we need to set a trigger for these invoices to transfer to Xero
In the data filter section you have a rule builder as below, if you choose Invoice State from the dropdown and select Next, then select Equal from the drop down and click Next, then choose Approved and Locked from the dropdown and select Add Rule
Now we are ready to enable the rule
Xero does not accept future dated invoices