MYOB

Setting up MYOB Integration
  1. When you are going to integrate MYOB with Jobman you need to contact us to help set it up.
  2. Then log into Jobman, and then go to
    /integration_myob/integration_myob
    e.g. https://clientsite.jobman.com.au/integration_myob/integration_myob. 
  3. This should then ask you if you want to allow Jobman access to your data file. You need to
    choose “Yes”.
  4. This will then save the relevant details in the config table so that the link should be working
    properly. 
  5. Make a new user for Jobman to use for accessing the company file. 
  6. Ensure that this account is set up to NOT sign on with a my.MYOB account, otherwise nothing will work.  Below is a screenshot showing what you will see. You will need to enable Cards, Inventory Management, Purchases, and Payroll.

 
Timesheet Integration

To get timesheets to integrate properly, you need to ensure that certain fields match identical between Jobman and MYOB. The below image shows you will need to make sure the below-highlighted sections in each of the staff profiles are set up correctly.  Staff first and last name must match in both software, and if you have populated the staff email signature, the signature name must also match including any middle name. The final step is to assign the correct pay rate to each staff profile, and this will activate the timesheet sync through to MYOB. 

The required fields below that need to be set up identical in both MYOB and Jobman are:

Staff Names

The names of staff must match perfectly between Jobman and MYOB.  If they don’t match, then times won’t move across. If the timesheet data sync doesn’t work initially, please check to ensure the staff name has been entered the same in both software, this includes case/character sensitivity, and if the staff middle name is listed in MYOB this will also need to be entered in Jobman. If the email signature is populated in Jobman, the signature name requires to be the same as the first and last name, this includes any middle name. If middle names are used in MYOB, once entered in Jobman and the first sync has been successful, the link has now been established, therefore you can then remove the middle name for the staff profile in Jobman without causing any issue with timesheet data sync moving forward.

Note: Please check to ensure no space is either before or after the staff’s first and the last name in Jobman, this often does occur and will cause the timesheet sync not to flow through to MYOB.

Pay Rate Award

The Pay Rate Award set up must match the Employee Payroll Categories set up in MYOB for the relevant employees. A screenshot below shows the red highlighted areas that require to reference the same in both software, the pay rate award name is the payroll category you have assigned in MYOB to each employee, and the code is the actual account ledger code you have set up in MYOB. The next step is to set up all the required pay rate hours, by adding in the days matched to the correct code that will need to match identical as per what is set up in MYOB for standard wages/hours, overtime 1.5x and overtime 2x assigned to the required days with the correct hour requirements.  

Pay Rates

Once you have set up the Pay Rate Awards required for all relevant employees, you will also require to set up the employee pay rates. These can be set up and named as either in an employee name, for example, John Smith, or as a department name, for example, Machine Operator. The code field requires to be the same the pay rate name to be the same, then select the pay rate type of either hourly or salary, and pay rate award from the drop-down menu tabs, enter in the hourly pay amount, and lastly, you can enter in the overhead percentage for the pay rate. 

Note: Once pay rates have been set up, please ensure you go back into each staff profile in Jobman and assign these pay rates to each requires staff to activate the timesheet data sync.

NoteOnce pay rates have been set up, please ensure you go back into each staff profile in Jobman and assign these pay rates to each requires staff to activate the timesheet data sync.

 
Leave Types

You can set up the leave types in Jobman to match what you have set up in MYOB for the required leave to apply to a staff timesheet. The below image shows the red highlighted area which requires to be identical in both Jobman and MYOB.

Note: Once the leave types are set up, you will require to add these in as Operation Types, assigned to an Internal Job Type and Nil status. This will allow you to create an internal job# for your staff leave to add to their timesheet when leave is taken. To set up staff leave operation types, head to Admin/Production/Operation Type

Invoice Integration

You need to ensure that the Invoice Status codes match in Jobman the ones set up in MYOB, to set the invoice status up correctly, you will need to be under Admin/Invoices/Invoice Status.  The default ones in MYOB are: “Open”, “Credit” and “Closed”. The below image shows the invoice status set up in Jobman and the highlighted red area for the Code, is what is required to match the ones set up in MYOB.

NoteYou also need to find the item in MYOB that corresponds to the item you want all invoice lines to be for.  This item should be able to be sold, and also not have quantities tracked. Once you have found that item, contact us and tell us the number for that item.

Invoice Account

You will also need to set up the invoice accounts in Jobman that are required to match MYOB, to allow you customer invoices to sync across from Jobman to MYOB. To set up these, you will need to be under Admin/Invoices/Invoice Account. To create the required invoice accounts in Jobman to reference the same as your set up in MYOB, click “Add Record”  type in the name of the invoice account, enter the code that is used in MYOB, apply the correct account type, apply required customer types, select Active for the status, current will need to be AUD (Australia Dollars) or NZD (New Zealand Dollars), add in a sort number, tick the active check box and then click Save to apply this invoice account set up.

Below is an example of how the invoice account is set up for customer invoices to sync through to MYOB:

Below is an example of how the invoice account is set up for supplier purchase order invoices to sync through to MYOB:  

Note: When setting up the invoice accounts, these will need to be identical to the setup in MYOB, this includes case/character sensitivity. If these account codes aren’t set up identical, then the invoice will not sync across to MYOB. 

Customer Invoices:

An invoice type can be for a deposit, a partial or full invoice can be created in either a lead or job for a required customer payment. If you are creating an invoice within a lead, the Quote must be at the status of “Quote Accepted” before you can add a record in the invoice tab. Below is an example of what is required to have the invoice successfully sync through to MYOB. Note: Once the invoice does sync through, the invoice will automatically approve in MYOB, you will just require to send it through to your customer. 


Note: Once an invoice is saved at the “Submitted” status, the sync between Jobman and MYOB is every 10mins, if you don’t wish to wait 10mins, you can perform a manual MYOB sync, you will require to be a level 5 Admin user, to be able to access the Control Panel, under the Admin area.  

Supplier Purchase Order Invoices:

The supplier purchase order invoice created in Jobman on a purchase order that is updated to the “Delivered/Fully Received” status will sync across to MYOB and appear under Draft invoices. To ensure this does happen, you will need to set up your Purchase Order status to allow sync with accounting software to be active on the Delivered status. The same actions mentioned above do apply, with invoice account codes requiring to be identical in Jobman as set up in MYOB for your materials purchased. 

Note: Above image shows to have ticked both the check box for create invoice and sync with accounts on the Delivered/Fully Received purchase order status to apply the invoice sync. 

Below is an example of a supplier purchase order invoice created from when the purchase order was updated to “Delivered/Fully Received” for the sync to be successful, you do need to ensure that the correct contact person is assigned to the invoice, the invoice status is at Submitted, and the correct invoice account code has been assigned next to the items. Note: If any of these are missing or do not match identically, then the invoice will fail to sync through to MYOB until corrected.

Note: It’s recommended to update the purchase order item prices in Jobman prior to the invoice sync through to MYOB. Once an invoice is generated from the update of the PO status “Delivered”  the invoice will be already at the “Submitted” status, the sync between Jobman and MYOB is every 10mins, if you don’t wish to wait 10mins, you can perform a manual MYOB sync, you will require to be a level 5 Admin user, to be able to access the Control Panel, under the Admin area.