Job Costing in QuickBooks

Each expense and revenue item must be given a job number before the job costing process can be completed in QuickBooks Online. You must update the settings on your customer list, products, and services, and then submit estimates and invoices to your customers to begin using QuickBooks’ job costing functionality.

A business accounting term known as “job costing” refers to tracking costs and revenues by “job” and the uniform reporting of profitability by the job. It is a tool for keeping track of the precise costs of labor, supplies, and overhead associated with individual jobs and using that data to determine whether costs can be decreased in subsequent employment.

What is a Job Costing

The costs of overhead, labor, and materials for a particular job are added up as part of job costing. This strategy is a great tool for tracking costs to specific jobs and looking at them to see if the costs can be decreased in subsequent jobs. Checking to see if any extra costs incurred can be charged to a customer is an alternative use. Costs are accumulated at the small-unit level using job costing. For instance, job costing is suitable for determining the cost of creating a unique machine, designing a piece of software, erecting a structure, or producing a small quantity of goods.

Features of Job Costing

Every small business needs to be able to bid competitively to keep a healthy profit margin. Businesses can generate job-specific financial reports, track expenses, and income carefully, and refine estimates to increase profitability thanks to proper job costing. Although using job costing in QuickBooks may seem like a difficult task, the advantages are crucial for keeping a successful small business running.

• Keep Track of Your Expenditures: You can keep a close eye on how much money you’ve spent on a job by using QuickBooks’ proper job costing. To make sure that every job is being completed at cost, using QuickBooks gives you a thorough way to keep track of every receipt, invoice, and payment.
• View the Revenue Generated by each Job: In addition to keeping track of expenditures, job costing in QuickBooks shows you the final profit for each job. When a job is finished, you can see not only how much money you spent, but also how much money you made and how closely your actual costs adhered to your original estimate.
• Identify the Level of a Job: You can identify the jobs that are most lucrative and advantageous for your company using the data and reports that QuickBooks can produce. You’ll have the knowledge you need to make informed decisions about which jobs you should accept and which you should reject thanks to this.
• Compare Estimated Job Costs: You can compare your estimated costs to your actual costs after the job is finished thanks to job costing in QuickBooks. This comparison will demonstrate whether your estimates are accurate or whether your bid is too high or too low. Your ability to estimate will increase if you pay close attention to job costing.

What to do Job Costing in QuickBooks Online

Budgets aren’t included in the Simple Start or Essentials levels of QuickBooks Online, so you’ll need one of those before you can start keeping track of expenses.

Step 1: Track Customer Expenses

• You must first modify your preference for expense tracking in the Company Settings before you can track expenses by customer. On your QuickBooks Online screen, click “Company Name” or the gear icon in the top right corner, followed by “Company Settings.” Check the box next to “Custom transaction numbers” by selecting the Sales form content in the menu under the “Sales” tab. For receiving partial purchase orders and progress billing, we will require this: 
• Next, let QuickBooks Online know that you want to track expenses by customer. This can be done by selecting “Bills and Expenses” from the “Expenses” tab on the Settings screen. The following three boxes need to be checked: “Make expenses and items billable,” “Show Items table on expense and purchase forms,” and “Track expenses by customer.” When you’re finished making your changes, don’t forget to click “Save.”

Step 2: Modify Your Customer List’s Settings

• Setting up your customer list’s settings is the next step. We’ll be using sub-customers, or what QuickBooks desktop users refer to as Jobs, and selecting the “Bill with Parent” option in the customer preferences:

Step 3: Modify the settings for the goods and services

• You must inform QBO that you buy each of your Products and Services from a vendor to use them for job costing (Products and Services are referred to as the Item List in QuickBooks Desktop editions). Not all the items on this list must be set up in this manner; only those that you hire a contractor to complete or any merchandise you buy to sell are exempt.

Step 4: Submit estimates and bills

• Creating an estimate, getting your customer to approve it, and then turning that estimate into an invoice is the typical workflow. The simplest way to create an estimate is to use the “Quick Create” button, which is the name given by QuickBooks to the plus sign that can be seen on any screen of QuickBooks Online.
• Fill out the “Estimate” form with the necessary information, hit “Save,” and then send it to your client.
• You’ll be able to convert to an invoice once the customer has approved the estimate. We suggest getting the signed estimate approval and any engagement agreements signed, scanned, and attached to the estimate using the “attach documents” feature.

How to Create QuickBooks Payroll By Job Report

Many reports are to be generated under QuickBooks to get a complete picture of the business and its growth. One such report is related to the Job Cost Report also including total payroll/labor burden costs and hours worked. Generating a job cost report showcasing the hours put in by the employee, on a particular job or for all jobs, for a particular week, or at the end of a job including payroll

Steps to generate payroll summary report by job…

• Go to the main menu bar locate the Reports option and then click on Custom Transaction Detail report from the drop-down menu bar.
• Next, select the Display tab, locate the Columns section, and using the scroll bar on the right of the window select only the following options (Date, Num, Name, Source Name, Item, Payroll Item, Qty, Sales Price, Amount, and Balance.) All other items in this list that were pre-selected should be unchecked.
• Select the Filters tab
  • Under the Choose Filter section, click on Transaction Type and then on the Paychecks option from the drop-down menu.
  • From the Choose Filter segment again, click on the Account tab and then choose Multiple accounts from the drop-down menu then in the new window select all the required Payroll Expense or Payroll Cost of Goods Sold Payroll Costs accounts.
• Click on the OK button.

Activating Job Cost Tracking in the Payroll Items List in QuickBooks

You can track your payroll costs by a job with QuickBooks Desktop Payroll. You can also monitor hourly labor costs and project profitability in QuickBooks Online Payroll. 

Step 1: Configure your QuickBooks preferences

• configure your QuickBooks job costing preferences
• Select Edit, then Preferences.
• Choose Accounting, then Company Preferences.
• Make certain that the option to use class tracking for transactions is chosen.
• Choose Payroll & Employees, then Company Preferences.
• For payroll costs, choose Job Costing, Class, and Item tracking.
• Choose whether to track it by the entire paycheck or a specific item of earnings.
• Select OK.

Step 2: Configure payroll items to monitor costs by job

To keep track of expenses by job, you can create a new payroll item or edit an existing addition, deduction, or company contribution item.

If a new payroll item needs to be created:

• Payroll Item List can be found under Lists.
• Choose New from the Payroll Item dropdown menu.
• Next, choose Custom Setup.
• Then click Next after selecting Deduction, Addition, or Company Contribution.
• After entering the item’s name, choose Track Expenses by Job.
• Finish by selecting the information as needed on each window.

If the payroll item needs to be modified or edited:

• Payroll Item List can be found under Lists.
• Select Edit Payroll Item by performing a right-click on the payroll item.
• the option Track Expenses by Job.
• Click Lists, then select Payroll Item List.
• You can edit a payroll item by selecting it with the right mouse click.
• Decide on Track Expenses by Job.
• Before you can choose Finish, select Next.
• Repeat for every payroll item you want to keep track of.

Step 3: Construct and process payroll

You must access the paycheck details for your employees as you create and process payroll. Add the hours or pay by choosing the job title from the Customer: job column in the Earnings item section. Apply this principle to each job the employee holds. Amounts are divided in reports according to the division of jobs on paychecks.

Create job costing reports:

If you want to see the payroll wages, taxes, deductions, and contributions broken down by job, run job reports. The same report can be used to determine which jobs are profitable and which are not.

• Go to Jobs, Time & Mileage, then Reports.
• Job Profitability Summary should be chosen.
• To view the wages, taxes, deductions, and contributions for each job, double-click the job amount.

Steps to Print QuickBooks Payroll Job Costing Report

Now print the report without closing it off by following the instructions below:

• Firstly, the user needs to make a comparison of the report with that of the employee’s paycheck to ensure all the imperative amounts included in the Paycheck Details category of the Company summary are available within the report as well.
• Select the Modify Report button, followed by clicking on the tab for the header or footer.
• The next step is to make changes under Report Title by naming it as ‘Job Cost Report with Hours & Payroll/Labor Burden Costs.
• Click on the ‘OK’ tab and then on the Memorize Button followed by the Save tab.

User can now generate the memorized report at any time of their convenience and make further modifications for a specific date range or even a specific job.

How Should I Use a Job Costing System?

Job costing produces discrete “buckets” of data about each job that the cost accountant can examine to determine whether it really should be assigned to that job. There is a good chance that costs will be incorrectly allocated if there are many jobs actively being worked on, but the job costing system’s very nature makes it highly auditable.

If costs are to be covered by customers, job costing necessitates a high level of cost accuracy. 

• Types of business that uses Job Costing
• Key features of Job Costing
• Key Components of Job Costing
• Example of Job Costing.

FAQs