XERO

Integration – Initial Setup

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.

Contact Migration

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.

Invoices

To use invoices, the basic flow is as follows:

  • Go into a job that was recently awarded.
  • Click on the “Invoices” tab.
  • Create a new invoice by clicking on the “Add Record” button.
  • Set the Type to “Deposit Invoice”, and add 40% (or whatever your deposit terms are) of the quote. These are drop down boxes. Then click “Add”.
  • Set the Template to “Default Template”.
  • Save the invoice.

To send the invoice to supported accounting software, open that invoice, and change the status to “Submitted”.

Overview

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).

Authorised 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.

Frequently asked question regarding Xero and Jobman;
Q: I have submitted an invoice in Jobman, it has been authorised 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 authorised invoice, adjust it in Xero, and then this will flow back to Jobman and be accurately reflected.

Different invoice types
These are:

  • “Deposit Invoice” – This easily allows adding a certain percentage of the accepted quotes to an invoice. It comes through as a line item.
  • “Partial Invoice” – Identical to Deposit invoices, except in name.
  • “Full Invoice” – This will grab all the line items from the accepted quotes, and also allows you to add adjustments to already paid invoices.

Purchase Orders

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.

Split Purchase Orders

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.

Received Orders and Pricing Updates

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.

Xero Timesheet Synchronisation

In order for timesheets to synchronise 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 privilages in both Xero and Jobman. Once this is complete then you must reconnect.

Time and Attendance

  • Any staff members who exist both in Xero and in Jobman (the names must match exactly) will have their timesheets updated every hour.
  • All times will come through at the default earnings rate for that person (as set up in Xero).
  • Once approved, that timesheet won’t be updated any more by Jobman.
  • Once that pay run is posted, the timesheet for the next pay run will start to be updated by Jobman.

The below 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.

Below is a sample screenshot from Xero waiting to be approved.