To connect your Jobman installation to Xero, you need to first ensure that you have level 5 access to Jobman, and also an account with Xero for the business you want to connect to Jobman. You must also be logged in to your Xero account, then follow the below steps.
Then inside Jobman, go to Admin->Control panel, and then choose “Connect to Xero”.
Click on the “Integrate with Xero” button.
You will then need to choose “Allow Access”, and then “Connect”.
If you have already connected to Xero and you are having difficulties, you may have to delete the connection to Xero and redo the connect to Xero process. The Connect to Xero button in the control panel will change to Delete connection to Xero when you have done the integration.
To further reduce double data entry, Jobman will reflect additions and changes made to a contact on either Xero or Jobman and the changes will flow through to the other end. When you add or change a contact in either list, the other one will get the updated information within ten minutes. These changes will reflect all fields that are the same. Any other data that is not recognized will have to be entered manually into the respective software.
Note: Xero does allow you to have a contact labeled as a customer and supplier, in Jobman these will require to be two separate contact types.
To use invoices, the basic flow is as follows:
To send the invoice to supported accounting software, open that invoice, and change the status to “Submitted”.
1) Create the invoice, and modify it as necessary. Keep it in the “Draft” status while doing this. You can modify invoices as much as you like, while they are in the “Draft” state.
2) When ready to synchronize, change the status to “Submitted”. This will submit the invoice to the accounting software. You should then approve the invoice in the accounting software (not in Jobman). It is important that invoices are approved in the accounting software.
3) The invoice will then automatically change to “Approved” in Jobman when it’s been approved in the accounting software.
4) It’s not a good idea to approve invoices in Jobman, it’s better if you approve them in accounting software.
Note: Only invoices that are in the “Submitted” status will be sent to the accounting software. See the screenshot above for more detail on this.
This invoice will now show up in your accounting software, in the “Draft Invoices” section. Invoices in the draft state can be edited, and those edits will flow back to Jobman. The person doing accounts should look at the invoice, ensure that everything is correct, and mark this as “Approved”.
Once approved, that invoice will be marked as “Authorised” in Jobman (after a ten-minute delay).
Authorized invoices amounts and line items can’t be modified in Jobman (the same as in accounting software).
When a payment comes in, and it’s reconciled against that invoice, that payment will show up in Jobman on that invoice.
The invoice number generated by Jobman (shown below), which displays the prefix of JBMN-INV#, is only a placeholder, and once the invoice comes through to Xero it will be overwritten with the invoice number Xero will generate. This will update back to the invoice in Jobman.
Unlink an Invoice
This feature has now been added to Jobman, which will allow you to unlink an invoice from Xero. This would be useful for when you have updated an invoice in Xero to the Deleted status, which will update back to the invoice in Jobman. Having this unlink invoice feature will disconnect the invoice if this is required. To access this feature, you need to have Xero and Jobman connected, then in the invoice, the status will require to be at either Submitted or Draft to see the Unlink From Xero icon in the bottom right corner of the invoice.
Note: Once the invoice is unlinked, you will not be able to re-link it again.
Frequently asked questions regarding Xero and Jobman;
Q: I have submitted an invoice in Jobman, it has been authorized in Xero, but I now need to make a change to that invoice. How do I do this?
A: To make a change to an authorized invoice, adjust it in Xero, and then this will flow back to Jobman and be accurately reflected.
Q: The invoice has been created and saved in Jobman, however, it hasn’t come into Xero, why would this be?
A: Firstly, make sure the invoice status is at “Submitted”. If it is, the next step is to check the notes field on the invoice in Jobman, you will see a listed error message and potentially multiple times. See below the common error messages.
Existing clients will need to make sure they have set up their Purchase Order Status under Admin first.
When Purchase Orders are marked as “Fully Received”, it will make an invoice that will go across to Xero in the Ordered state. The tab located next to Purchase Order Details is Invoices and where you will see the status of all orders.
Whenever an invoice is modified in Xero (marked as Approved, Deleted, or any other change), those changes will flow back to Jobman within ten minutes. This can currently be forced by going to Admin/Control Panel/Sync with Xero. There are plans to make this instant.
Unfortunately, things don’t always go to plan. Orders come in multiple deliveries and with them so to do a new invoice number. Jobman provides the ability to Split items that have not been received in full to another purchase order with a new invoice number. This information will also flow to Xero for accounts payable.
Managing your availability charts is one thing. Keeping on top of your price increases is another. The ability to adjust prices and save to the Availability Charts as Purchase Orders are received will keep your pricing up to date for future reference.
In order for timesheets to synchronize with Xero, the initial connection must be performed by the person that has Payroll permission in both Jobman and Xero. If this has not been the case, delete your connection with Xero in Control Panel, then log in again as the person with Payroll privileges in both Xero and Jobman. Once this is complete then you must reconnect.
The below Pay Rate Award sample is set up so that the person is paid 8 hours at normal time, then the next 2 hours at time and a half, then the rest at double time. Work on weekends and public holidays is paid at double time.
This will automatically come across to Xero (assuming that the pay rates are set up properly) as above. Note that these come across as draft timesheets, which need manual approval. This is a good thing, as manual intervention can pick up if a staff member forgets to log on/off a job on a certain day. Also note that this pay structure is weekly, from Thursday to Wednesday, and these draft timesheets will be updated every ten minutes as people log on and off every day.
Note: when setting up the payroll for staff in Jobman, the staff name must be identical in both Jobman and Xero, this includes being character sensitive. The below image demonstrates the name set up in Jobman that matches Xero, if you have the employee created in Xero with all capital letters, this must be created in Jobman the same for the timesheet sync to work.
Below shows wherein the staff, you are required to assign the correct staff type, once saved the timesheet sync will flow through to Xero every hour.
Below is a snapshot of the Payroll report and the detail that will display once the payroll setup is complete in Jobman.
Below is a sample screenshot from Xero waiting to be approved.