QuickBooks Pro and higher versions contain the job cost estimating feature, which allows you to create estimates for your work and track income and expenses on a job-by-job basis.
An estimate is a bid or quote for a job. You create an estimate and then invoice the customer either at the completion of the job or as the job progresses. Estimates can be revised as work on the job advances, and QuickBooks enables you to create more than one estimate for the same job.
Keep in mind that an estimate is not the final word on what a job will cost. Consider placing a disclaimer in the message area of the estimate form indicating that the numbers presented in the estimate are based on reasonable assumptions but that you reserve the right to change the estimate prior to the completion of the job and with the approval of the customer.
To take full advantage of the Estimates feature in QuickBooks Pro or Premier, you need to set the preferences for jobs and estimates. Here you can turn on the access to estimates and progress billing and protect yourself against accidentally issuing two estimates with the same number. If you use progress billing, you might appreciate a feature that enables you to leave zero-balance amounts from partially billed estimates off your invoices.
Select Edit, Preferences.
Click Jobs & Estimates on the left side of the Preferences window.
Click the Company Preferences tab. (The My Preferences tab has no options for Jobs & Estimates.)
If you plan to track jobs by status, check to see whether these status descriptions are appropriate to your work and make any necessary changes.
Click Yes to turn on the estimates feature.
Click Yes to turn on the progress invoicing feature.
Check Warn About Duplicate Estimate Numbers to have QuickBooks give you a warning if you attempt to issue a duplicate. This option is not available if you do not choose to use estimates.
Check Don’t Print Items That Have Zero Amount to remove zero-balance items from printed invoices. (The zero balance items still appear on the screen version of the invoice.) This option is not available if you do not choose to use progress invoicing.
Click OK to save your settings.
Depending on the type of business you have, you might need to track revenues and expenses on a job-by-job basis. You can track multiple jobs for the same customer and then create invoices and record your expenses as they relate to the individual jobs. Before allocating revenue and expenses to a particular job, you must set up the job and identify with which customer the job is associated.
Display the Customers & Jobs list by clicking the Customer Center icon (or choose Customers, Customer Center) and then clicking the Customers & Jobs tab.
Click the name of the customer to whom this job relates.
Right-click the customer name; then choose Add Job from the pop-up menu (not shown).
Timesaver
You can also open the New Job window by clicking the New Customer & Job option at the top of the list and then clicking Add Job.
Enter a name in the Job Name field.
Verify the contact name and address for this customer and make any necessary changes.
Important
Be sure to click the customer name before selecting Add Job. Although you can change the customer name in the Add Job window, the related customer information, such as address and contact information, is not automatically updated. Rather than trying to change all this information each time you add a new job, select the customer name first and then open the Add Job window.
If this is all the information you plan to add at this time, click OK to save your entries.
Click the Payment Settings tab to enter more information relating to the job. (If you need to reopen the Job window, right-click the job and then choose Edit Customer:Job.)
If you use account numbers for your jobs, enter the number in the Account No. field.
If applicable, enter a number in the Credit Limit field if your company has assigned a limit to this customer. You are warned if you attempt to issue an invoice for more than the customer’s credit limit.
Indicate the payment method typically used by this customer in the Preferred Payment Method field. If a credit card is chosen, you can enter the customer’s credit card information.
Complete or make changes to other fields as needed.
Did You Know?
Credit limits generate warnings when you issue an estimate or invoice. If you attempt to create an estimate or invoice for more than the customer’s credit limit, QuickBooks gives you a warning.
Select the customer type. If the type you want to use does not appear, select Add New from the drop-down menu to add a new type to the available options.
If applicable, select from the Rep list (not shown).
Click the Job Info tab to enter more information relating to the job.
Enter a description for the job in the Job Description field.
Select a job type for this job. If the applicable job type does not appear in the Job Type list, select the Add New option in the list to enter a new type of job.
Choose an option from Job Status if you track this information.
Type or select a date in the Start Date field.
Type or select a date in the Projected End Date field.
Type or select the actual end date in the End Date field.
Click OK to save your entries.
Did You Know?
Some of this information might already appear. Much of the information relating to individual jobs, such as price levels and credit limits, was already entered when you set up the customer. Unless a change relating to the specific job occurs, you can accept the information that carries over from the customer.
If your company works on only a handful of jobs at a time, you can probably keep track of the status of those jobs in your head. But for those companies with many balls in the air, QuickBooks provides a job status feature to keep track of how close to completion each job is. You might also want to filter reports for type of job. For example, a construction company might perform commercial, residential, or government work. This is an excellent use for job types.
Select Edit, Preferences.
Click Jobs & Estimates.
Click the Company Preferences tab.
If you want, change the name of any job status by deleting the name you see and entering your own choice for a job status.
Click OK.
Display the Customers & Jobs list by clicking the Customers icon (to open the Customer Center), and then clicking the Customers & Jobs tab (not shown).
Double-click a job name if you want to change its status (not shown).
Click the Job Info tab.
Select the appropriate job status from the Job Status drop-down list.
Click OK.
Did You Know?
Updating the job status is a manual process. You need to remind yourself to regularly update the statuses of all your jobs. QuickBooks does not do this for you.
You have the option to define the Job Type field for each job. Unlike the Job Status field, no standard entries are available in the Job Type field; therefore, you can customize job types to go with your business. For example, a construction company’s job types might include New Construction, Repairs, and Renovation. Job types can also be subtypes of other job types; for example, the New Construction job type might include the subtypes Commercial and Residential. After you enter a job type, that type stays in your company file and becomes available as a selection on other jobs.
Display the Customers & Jobs list by clicking the Customers icon (to open the Customer Center), and then clicking the Customers & Jobs tab.
Double-click a job name.
Click the Job Info tab.
Click the down arrow in the Job Type field.
Select an existing job type, or click Add New to enter a type that is not listed.
Click OK.
Did You Know?
An advantage of using job types is that QuickBooks allows you to search and report on them. A drop-down list in the Job Type field provides an easy way to choose from existing job types. Also, if you open the Lists menu, select Customer & Vendor Profile Lists, and then select Job Type List from the side menu, you can create quick reports, easily edit job types, and search for job types in your transactions.
You can use the Job Dates feature in QuickBooks to keep track of the dates on which you start jobs, the projected end date of each job, and the actual end date of each job.
QuickBooks gives you the option of entering a narrative description for each job. This is an optional feature. There is no menu of standard descriptions from which you can choose, so you can create your own description for each job.
Display the Customers & Jobs list by clicking the Customers icon, and then clicking the Customers & Jobs tab.
Double-click a job name.
Click the Job Info tab.
Enter a brief description in the Job Description field or update an existing description. You are limited to 99 characters, including spaces.
Enter or update the dates for this job.
Click OK.
Did You Know?
You can make a standard list of descriptions for use in your company. Although QuickBooks doesn’t include a provision for storing job descriptions and making them accessible to other jobs, your company can set up a standard job description list of its own, print it, and circulate it to anyone entering job information in QuickBooks.
For example, if you are a tax practitioner, some standard descriptions for the type of tax work you perform might include the following:
Quarterly Estimates
Annual Tax Planning
Estate Planning
Individual Income Tax Returns
Business Income Tax Returns
Payroll Tax Forms
You can use the Estimates form to create estimates that provide preliminary planning information for each of your jobs. The forms QuickBooks provides for your estimates look similar to Invoice forms. Fill out an estimate showing the anticipated time, items, and expenses you plan to allocate to this job. Estimates are saved, referred to, revised, and (ultimately) used to create invoices as the job is completed. Be sure you have enabled the Estimates feature before starting this task (see “Setting Jobs and Estimate Preferences” earlier in this chapter).
Select Customers, Create Estimates.
Timesaver
You can also open the Create Estimates window by clicking the Estimates icon on the Home page. Or, you can click the New Transactions option at the top of the Customer Center and choose Estimates.
Indicate the customer and, if applicable, the job for which you are preparing an estimate in the Customer:Job field.
Verify that the correct date appears on the form.
Enter all the items that relate to this estimate.
Select a Save option to complete the estimate.
Double-click the estimate you need to change.
Timesaver
Alternatively, you can click the Customer Center icon to open the Customer Center, click the Transactions tab, and then click Estimates. Double-click the estimate you want to revise.
Make changes on the estimate form.
Click a Save option to save your changes.
Confirm that you want to make the changes to the estimate by clicking Yes.
If the Add Change Order window appears (not available in all QuickBooks versions), click Add to add text to the bottom of your estimate describing the exact change(s) and the date of the change. Click Do Not Add if you want to change the estimate without calling attention to the change. With this choice, no descriptive text appears on the revised estimate.
If you selected Add, the estimate now includes the change order text.
Did You Know?
Changes made on progress billed invoices don’t flow back to estimates. Although QuickBooks keeps track of payments received from customers and any edits you might make to invoices, the original estimate remains unaltered by these events. Only changes you make on the original estimate form itself alter that form.
After you have an estimate in your QuickBooks file, you can refer to that estimate when you’re ready to prepare an invoice. When you prepare an invoice for a job that has been estimated, you have the option of invoicing for the complete estimate, a percentage of the estimate, or specific items on the estimate. The concept of invoicing a portion of the estimate is called progress invoicing.
Press Ctrl+I to open an invoice form.
Enter the name of the customer and, if applicable, the job. If an estimate exists, the Available Estimates window displays.
Click to select the estimate against which you want to invoice.
Click OK.
Select the option to Create an Invoice for the Remaining Amounts of the Estimate or Create Invoice for a Percentage of the Entire Estimate.
Click OK; the amounts from the estimate are entered on the invoice.
Verify that all amounts on the invoice are correct. Make any necessary changes to the amounts on the invoice.
Select a Save option to complete the invoice.
Select Create Invoice for Selected Items or for Different Percentages of Each Item.
Click OK.
Click Show Quantity and Rate to show the quantities and prices (rates) of the estimated items.
Click Show Percentage to show the percentages of the estimated items.
In the appropriate column, indicate the percent, quantities, or prices of each item you want to include on the invoice.
Click OK.
Depending on the choices you made in Step 6, you might see a warning indicating that some invoice items display a zero amount and suggesting that you not delete these items. After you read the warning, click OK to close the warning window.
Save your invoice (not shown).
Did You Know?
Zero-balance items don’t show on the printed invoice. Assuming you set the jobs and estimates preferences to hide zero-balance items from your invoice, you won’t see those items on your printed invoice. They do, however, appear on the invoice you see onscreen. Click the Print button at the top of the invoice and then select Preview to view the actual invoice before it prints. You see that the zero items do not appear.
After you enter estimates into your QuickBooks file, you can produce a report that displays all outstanding jobs, the amount of estimates on these jobs, and a comparison of the budgeted costs to the invoiced amounts. Use this report to ensure your job’s profitability.
Select Reports, Jobs, Time & Mileage, Job Estimates Vs. Actuals Summary or Job Estimates Vs. Actuals Detail.
Click OK to display the report.
See Also
For more details on working with reports in QuickBooks, see Chapter 18, “Working with Reports in QuickBooks.”