Job Tracking in Conversions

21 Nov Job Tracking in Conversions

Update: Classes and Jobs extended to all Conversion models including MYOB / Quickbooks /Reckon / Sage.

Back in 2015 we were excited to announce the second new conversion feature based on your feedback from Xerocon 2015. A few weeks ago, we added the ability to choose how bank accounts are created in Xero. You can select whether they are Bank, Credit Card, PayPal, Current Asset or Current Liability.

Our next new feature is (drum roll please) ….

Job tracking and categories converted into Xero tracking categories

If a client used job details or categories in their MYOB / Quickbooks /Reckon / Sage  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 trackingThere is nothing you need to do, our conversion software automatically checks whether jobs and categories have been used in MYOB / Quickbooks /Reckon / Sage . 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.

How are the options named?

We use the job/category names from MYOB / Quickbooks /Reckon / Sage. Descriptions do not come across as they are often too long to be useful. Equally job codes are mostly too short to mean much.

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

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

What about jobs that have started before the conversion date?

We are not migrating job/category 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 MYOB / Quickbooks /Reckon / Sage 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 and Category codes.

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.


No Comments

Post A Comment