Job Costing in QuickBooks Online + KeyPay

Follow

Job Costing in QuickBooks Online + KeyPay

QuickBooks Online

Job costing can be done in QuickBooks Online by setting up classes and locations.  Matching the class and location in QBO to the location in Keypay will allow the P&L by class report to be a job costing report.

KeyPay

KeyPay does not do job costing, however you can structure locations in a similar way to jobs which will allow you to allocate earnings and therefore see the wages expense for each location. This is to allow you to ​expense by job, department or physical location. This information can then be exported via a journal entry into your accounting software e.g QuickBooks Online when a pay run is processed..  

Please note: KeyPay cannot handle billings or invoices and you cannot assign a rate or dollar value to the hours worked.

To get started you would first need to set up classes and locations in QuickBooks Online then import/assign these into Keypay.

Set up Classes and Locations in QuickBooks Online

Set up Class or Location Tracking in QuickBooks Online.

Track Classes and Locations

This article refers to QuickBooks Online

The best method to track different parts of your company is to use either Class Tracking or Location Tracking. Both features let you track income and expenses for separate parts of your business. You can use either one of them or both of them together. These features are available only in Quickbooks Online Plus.

Class Tracking specifies a different class for each detail line of a transaction. With Location Tracking you can assign a location to an entire transaction. You can choose the term by which Location tracking is described within Settings as well. You can then run reports for the whole company or per class or location.

To turn on either of these features:

  1. Click on the  Gear icon > Company Settings (or Account and Settings depending on what you see).
  2. Click on Company (or Advanced if you entered this menu through Account and Settings) from the left menu bar
  3. In the Categories section, click on the Edit icon
  4. Place a check in the box for the category you want to enable and select the settings for the category
  5. Click Save  

To establish the categories:

  • Go to the Gear icon > All Lists
  • Click on Classes or Locations
  • Click on New on the upper right
  • Enter the information
  • Click Save

Note: In order to add or modify Classes or Locations you must have master administrator, company administrator or the appropriate custom user access. If you are unsure of your access rights please contact your master administrator.

Importing QuickBooks Locations into KeyPay

Import your QuickBooks Online Locations to KeyPay.

Import your QuickBooks Locations to KeyPay

This article refers to KeyPay

You can import locations into KeyPay by following these steps:

Log into QuickBooks Online and go to the "Employees" tab

  1. Click on "Settings" and then "Locations"

From the locations screen, click the "Add" button and select the "Import QuickBooks Locations" option

  1. Your QuickBooks locations will now be available in KeyPay

Assigning QuickBooks Classes to Locations

Assign Your QuickBooks Online Classes to Locations in KeyPay

Assign your QuickBooks classes to locations in KeyPay

This article refers to KeyPay

You can assign classes to locations by following these steps:

  1. Log into QuickBooks Online and click on the "Employees" tab
  2. Click on the "Settings" tab and select "Locations"

  1. Click on the location to which you want to assign a class

  1. From the "Classes" drop down, choose the class you want to assign to the location

  1. Click "Save"

Your class will now be assigned to your location

VIDEO: Using locations for "Job Costing" in KeyPay

The following video will take a look at how you can set up locations in KeyPay which will allow you to allocate earnings and therefore see the wages expense for each location.

https://www.youtube.com/watch?v=DQJ321rPRUk



 

 

Powered by Zendesk