How To Do Job Costing In Quickbooks Online?

Job costing means income and expenses tracking by a job, and then comparing its actual amount to its estimated amount. It is extremely necessary for any successful contractors, whatever software you use. Usually, contractors choose a specific job costing software that is sophisticated enough for billing, payroll, and reporting. However, some contractors are not ready to use this complex software. That is when QuickBooks or Xero are recommended. Although there are many comments that QuickBooks cannot do job costing, it is still suitable for small contractors, who would like to track expenses and income as well as pull some project reports in the easiest way.

So, how could you use QuickBooks Online to do job costings?

In this blog, we introduce you to 3 ways to do job costing in the QuickBooks Online Plus. In case you do not have that edition, it is still okay then.

Before going through some ways to do job costing in QuickBooks Online, let us set up the job-costing cost codes in QuickBooks Online:

For contractors, a basic traditional job cost structure might include:

· Jobs or projects

· Cost codes for particular activities on the project

· Cost types or cost classes that tie out to expense types on the Income statements.

Because QuickBooks is not built for job costing purposes, QuickBooks users could use items (in QuickBooks desktop) or products and services (in QuickBooks Online) to represent cost codes. These exist on both expense and sale sides, therefore you can use them on both invoices and bills, for instance. As the result, you could set up profit and loss reports per item across your whole company.


Adding Products and Services in QuickBooks

· Click on the Gear icon, select Lists > Products and Services. You can also access to Products and Services list by the Sales on the left sidebar and click on the Products and Services tab

· Click on the [New] button in the upper right corner.

· Select an item type — either “Inventory,” “Non-Inventory,” “Service” or “Bundle.”

· Enter the relevant item information and choose a category to record the income of this item.

· To be able to track costs for this item, tick the checkbox I purchase this product/service from a vendor.

· Click [Save and close].

1. Using Sub-customer as Job:

Sub-customer is the word that QuickBooks Online uses to call Job of QuickBooks Desktop edition. Just like one job is under only one customer, one sub-customer belongs only to 1 customer, whereas one customer can have many jobs or sub-customers.

Adding sub-customers into QuickBooks

· To add a new sub-customer, chose “Sales” on the left sidebar

· Click on the Customer Tab

· On the upper right, click on New Customer.

· On the Company and Display name as a field, enter the name of the desired project. To avoid confusion, this name should be distinct from the name of the customer. For example, you could use the project number.

· You should also fill in all information for deep tracking.

· Tick the box Is sub-customer and choose the customer name in the underneath box.

· Select “Bill with parent” in order to tie the invoice to the customer when recording an expense under the sub-customer.

· Click [Save].

Sub-customers can be used for different purposes by numerous other industries. A consulting company uses it to track businesses operated by the same person. An advertising company might use them to track multiple projects for a single client. For contractors, sub-customers could be used to gain some amount of job cost reporting.

Sub-customer method Reports

By using the cub-customer method, you can view many reports on the job costing perspective. For example, from the left sidebar, you can go to Reports and find Income by Customer Summary. This should allow you to view your project income, expenses, and net income for each sub-customer.

2. Using Classes and Locations

QuickBooks Online classes and locations provide an additional view to look at your data, apart from the formal job costing. Locations are usually used to represent geographical areas and the classes could be used for business units. The biggest difference between them is this: You can attach a transaction to only one location, but you can specify line items to different classes.

Turning on Classes and Locations feature in QuickBooks.

In order to use classes and locations in QuickBooks Online Plus:

· Click the Gear icon and select Your Company > Accounts and Settings.

· Select the “Advanced” tab.

· Click the edit icon across from “Categories” to enable Track classes and Track locations.

· Click [Save].

From the main menu, click the Gear icon, and select All Lists > Locations > New or All Lists > Classes > New.

· Enter your location or class information. You can use this same process to create sub-classes by also enabling the checkbox Is sub-class and selecting the parent class.

 Contractor Invoice: What makes a Construction Invoice?


How To Write Off Invoice in QuickBooks Desktop? – Step by Step Guideline



Progress Invoice in QuickBooks for Construction Accounting – Step by Step Instruction

Progress Invoice in QuickBooks for Construction Accounting – Step by Step Instruction



3. Using Project

Project is the additional feature in QuickBooks Online that could help you keep all job-related information organized together. With projects, you can see all transactions, outstanding invoices, and profitability of an individual job.

Turning on Projects in QuickBooks

To begin accessing project features in QuickBooks Online Plus:

· Click the Gear icon and select Your Company > Accounts and Settings.

· Select the “Advanced” tab.

· Click the edit icon across from “Projects” to enable Organize all job-related activity in one place.

· Click [Save].

As a result, you will be able to see “Projects” in the left sidebar and can begin working with them. Click on “Projects” to add your first project and attach it to a customer.

To add project transactions, go to your “Projects” list, select your job and click the [Add to project] button in the upper-right corner. Alternatively, you can use the plus icon at the top, select the desired transaction type and choose the project name from the Customer/Projects drop-down menu.

Reporting Projects

The QuickBooks Online projects feature adds three reports, as well as a project-centered transaction list. You’ll find these under “Projects” as well. Project Profitability gives you a P&L report for the job without needing to filter for a sub-customer. Similarly, Unbilled Time and Expenses brings these transactions under one project. Finally, Non-billable Time is a report contractor may want to use to track time on a job that won’t be directly billable, such as administrative or overhead labor.

Because projects function the same way that sub-customers do, previous reports such as Income by Customer Summary and Budget vs. Actual are still available with projects turned on. When setting up custom filtering, you’ll simply select the name of your project or sub-customer from the Customer filter drop-down menu.

CONCLUSION

Using small business accounting software is no reason not to track your costs to the job. While it’s not specifically designed for these purposes, QuickBooks Online provides a number of feature sets that can be useful for organizing and reporting some of your crucial job data.

If you use QuickBooks or just aren’t ready yet for a full job cost accounting system, make sure you’re maximizing your resources, gathering good cost data, and practicing good habits that will help you be successful in the next stage of your growth.

Construction Cost Accounting help you solve construction accounting problems, we are the leader in accounting services for the construction industry. Contact us now for a free consultation.

Are you ready to get help, or are you still not sure if you need help to run your construction business? Contact Construction Cost Accounting to have a free 15-minute consultation!

#jobcosting #adjustedstandarddeduction #irs #quickbooks #quickbooksdesktop #constructionaccounting #creditor #contractors #accountingtips #constructionquickbooks#constructionbusiness #constructionaccounting #constructioncostaccounting #costaccounting #constructionbookkeeping #ca #california

construction-cost-accouting-book

9 views0 comments