Job Tracking in Conversions

If you have used Job details, Categories or Classes in your file they come across in our conversions as Tracking categories. This means that more detailed historical information is preserved for reporting and business analysis.

How do I make sure the jobs/categories are coming into Xero?

job trackingAs long as there are less than 500 Jobs + Categories / Classes in your file then there is nothing you need to do, our conversion software automatically checks whether jobs and categories have been used in the file . If so, it creates a Tracking category called Job or Category in Xero. Each job/category is created as an option, so that they are accessible for future transactions.

We convert up to 100 Jobs + Categories / classes under the Standard conversion package and up to 500 under the Accelerate package.

If there are more than 500 Jobs + Categories / Classes then we will convert the accounting data without the associated tracking.

Please note that with Reckon and Quickbooks we do not convert Jobs associated with Customers. Please see here for more information.

How are the options named?

We use the Job / Category / Class names from the file. Descriptions do not come across as they are often too long to be useful. Equally job codes are mostly too short to mean much.

Here is an example from MYOB showing how the job number and job name convert:

What if my client wants to use different tracking in Xero?

This is really easy to achieve by archiving the Job / Category /Class tracking categories and setting up the new tracking you want to use.

Please note that we convert into Tracking categories and not ‘Projects’.

What about jobs that have started before the conversion date?

We do not migrate opening balances. The tracking only commences at conversion date.

You are able to add manual journals to add these opening balances if this is essential for you. Or you might want to choose an earlier conversion date so that the relevant job details are in Xero.

How is tracking applied during the conversion?

Categories are per transaction in the file where Xero tracking is by transaction line.

How does that work? Any transaction line that we migrate to Xero gets the correct tracking option applied to it. Where categories are used in MYOB, we just assign a category to each transaction line in that transaction.

Do I have to do anything to run job tracking reports?

As soon as you receive your Xero org you can run Profit & Loss, Balance Sheet and Tracking Summary reports by any job/category.

How do Header Jobs convert?

Header Jobs will be converted as Category options and will have $0 balances as they are not linked to other Category options in Xero. To manage this moving forward you can set up Tracking categories with Category options:

Limit on Tracking Options

Note that Xero has recommended limit of 100 Tracking Options in the P&L and other reports. The conversion will bring in up to 500 Jobs + Category / Classes codes.  If you have more than 500 then the transactions will still convert but without the corresponding Jobs / Classes / Categories.

Note also that tracking associated with payroll will not be converted.

Xero Help Centre information on tracking

As always, please let us know if you have any other suggestions to make the conversion experience even better for you.

Wendy

Leave a Comment