How to Set up Payroll for Job Costing in QuickBooks for Contractors?

QuickBooks is the most popular accounting software for construction companies. It has in-built tool which is very helpful in creating […]

Voiced by Amazon Polly

QuickBooks is the most popular accounting software for construction companies. It has in-built tool which is very helpful in creating custom report. It is very important to assign expenses and revenue to specific job in QuickBooks. So, that customer can easily track your financial performance.

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.

This process also helps you to make budgetary adjustment in real time.

Setting up Job Costing in QuickBooks

The job costing is only available in pro and advanced subscription. Follow the following steps in order to setting up job costing:

Enable Job Costing in Accounting Setting

Firstly, you have to enable job costing in accounts setting.

  • On the home screen in QuickBooks online plus or advance version you can easily create a list of your current projects from the starting date.
  • Click on the gear icon on the screen upper right corner.
  • Then select account and setting from the drop down list.

Turn on Customize Transaction Number

  • Now you have to turn on the customize transaction number option. In this the sales tab gives you the opportunity in order to select customized transaction number. You need this transaction number in order to track and review invoices in progress.

Tracking Expenses by Customer

  • With the help of this tab you can track the expenses done by the customer. You can also make expenses bill for those customers who have to pay something to the company. This option can be choose in bill and expenses menu.

Turn on Automatic Invoices

  • When any estimates you create it automatically transformed to the customer invoices along with all the process. In order to enable the automatic invoice unbilled activity, you have to select advance option under automation settings. All the contractor will not able to enable this setting.

In last save all the changes and exit from the page.

Creating of Customers and Projects

Firstly you have to create a customer to assign the project to in order if you didn’t done this before.

  • Create a Customer
    • Select get paid and pay option in order to add new customer.
    • In this section you will see the option of creating new customer.
    • When you select the drop down arrow then you can import customer list from the Google spread sheet or excel sheet.
  • Add Job
    • Now you can create the job in order to track expenses and profit.
    • Select projects under the business overview menu.
    • The projects option will open the list of projects, so you can select from there and it also shows basic information about income and expenses.
    • Now select new project in order to create a new job.
    • As sub customer some of the contractors are already tracking the project.
  • Now you can view list of customer in this and the job of each individual that there work is in progress or already completed.

Creating Product and Services

  • You can set up product and services in the application of QuickBooks i.e setting up a list of product and services.
  • This option allows you to customize job expense category.
  • You can find this option in the drop down menu of gear icon.
  • You can also select get paid and pay option on the left of the screen.

Creating of Estimate for the Job

  • On the QuickBooks screen there is a Quick create option is visible to you.
  • Quick create option is visible on the upper left side of the page and its icon is + sign or +new.
  • As you click on the + sign then you will see many option in drop down menu i.e Invoices, checks, expenses and estimates etc.
  • Now click on the estimates option from the list.
  • Assign estimate to the job
  • From the customer list, select the correct job on your estimated screen.
  • You can create multiple estimates for each job.
  • Multiple estimates will be helpful in making contractor job easy as they can create single estimates for the entire job.
  • Add product and services to estimate
  • You can enter materials and labor cost on each line of estimate by adding a date of service, product or service type, rates, description, quantities, rates and dollar amount which can be label as taxable.
  • For the rendered product or service, there is a detail box that work performed or materials are purchased from the outside vendor.
  • Once you enter all the data then click on Ok in order to save the estimates.
  • This option will pop out during the invoicing process at that time you have to choose it.
  • You can also send email to the customer if you want any approval from them.
  • Now all the pertinent expense and Subsequent income all will flow to each and every customer.
  • In this option you can also view cost and revenue you earn by the job or project.

Creating Invoice during the Job

  • QuickBooks have the feature of creating invoice from the scratch.
  • QuickBooks automatically convert estimates in single invoice or progress invoice.
  • In this we can create the parent estimate for each project , it will save your lot of time.

Turn Estimates into Invoice

  • Select blank invoice from the + new drop down menu.
  • Now click on customer tab.
  • Select project from the drop down menu of customer.
  • QuickBooks allows you to add estimates which you have already created to this invoice.
  • Now click on Add button in order to add the invoice.

Choose the Amount for Invoice

  • The pop up window will be appearing and the screen asks you that what is the percentage of estimate you want to add to the invoice.
  • For the each line you can select custom amount.
  • If you are not using straight line percentage across the board then you can select custom amount here.
  • QuickBooks have the feature of editing the bill amount in each and every line item.

Creating Job Costing Report

  • In last or in the end of work QuickBooks have the feature of reporting it.
  • Report is helpful in showing the job progress in the terms of profitability.
  • Under the business overview click on the profit and loss report from the report menu.
  • In order to add the custom filters you have to click on the customize tab.
  • Now scroll down the customer field in order to view job cost y the customer for each and every job.
  • You can track income and expenses by this report by taking the snapshot of the particular job.
Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.


Frequently Asked Questions (Faqs)

What are the Job Costing Payroll Service Items?

Follow the following steps in order to view the steps of job costing payroll service item:

Select the item list from the list tab.
Click the new from the item drop down menu.
Select for the type of item you want to create.
Fill the entire items field as asked and you can also select them from the selection options.
Select customized field from the menu of custom field.
Now hit save button in order to save the data.

How can I Set up Job Costing in QuickBooks?

In order to set up the job costing in QuickBooks follow the following steps:

Select the payroll item list from the drop down menu of list.
For editing payroll item right click on payroll item and select edit option from the menu.
Now select track expenses from the job.
Click on next and wait for a while until it finishes its job.
Repeat these steps for each payroll item that you want to track.

Is QuickBooks is Good for General Contractors?

QuickBooks is the best software among all the accounting system. It is used by the small companies or for the contractor who are just started or starting.

How Can use QuickBooks as an Independent Contractor?

Follow the following steps:

Click on the expenses,
Then click on the vendor option.
Now click the new vendor.

How Can I do Job Costing?

Calculate the following methods in order to find job costing:

Total Job Cost = direct material + Direct Labor + applied over heat.
Permitted overhead rate = Estimated Overhead/Estimated activity.
Total job cost = direct material + Direct Labor + Applied Overhead.

What kind of Expense is a Contract Labor?

Contract labor is a tax deductible expense.

In QuickBooks What is the Difference Between Vendor and Contractor?

The product or the service is sold by the person or business is known as vendor.

Whereas

The contractors are those people who had a assigned task to do in order to provide service to the clients.

What is the Job Costing in Construction?

The detail accounting method which is used to calculate track and assigned expenses in a particular project and keep monitoring the budget is known as construction job costing.

What are the Three Categories in Which Job Costing Fall?

There are three categories in which job costing is falls i.e labor, material, overhead. The cost can be in any mode i.e direct or indirect.

Which type of Costing is used in Construction Industry?

The businesses and company in the construction industries generally use the following:

Job costing
Activity based costing
Life cycle costing.

Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Dancing Numbers: Case Study

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Call Now+1-800-596-0806
Top