invoicing

Quickbooks

How to Create a Progress Invoice from an Estimate

The U.S. economy may be picking up, but your customers are probably still being very careful with expenditures. If your company’s finances will allow it, you can help them out on sizable jobs by using progress invoicing, also known as partial billing or progress billing.

You could, of course, simply create invoices for smaller chunks of the job as they come. A smarter way is to build estimates for the entire job or sequential phases so your customer can see the big picture. You can still use progress invoicing to start collecting funds one segment at a time.

How to Proceed

First, be sure you have progress invoicing turned on. Go to Edit | Preferences | Jobs & Estimates | Company Preferences and make sure the Yes button is filled in next to the questions about estimates and progress invoicing.

Now create your estimate (these instructions are for QuickBooks Premier 2013; your steps may vary slightly). Go to Customers | Create Estimates. When you’ve entered all of the items you want to include in this phase of your project, click the Create Invoice button. This window will open:


Figure 1: You can decide how many of your estimate items will be included on your progress invoice. 

By clicking one of these buttons, you can bill the customer 100 percent of what’s due on the invoice or just a percentage. But let’s say you and your customer have agreed that payment will be due in pre-defined stages, so click the third button and select one or more of the line items. Click OK. QuickBooks will display a new window that lets you select items and/or percentages of amounts due.

In our example here, we’re going to invoice the customer for two items, the blueprints and floor plans. So we selected the button next to Show Quantity and Rate and entered the full estimated quantity for each item in the QTY columns (if you chose Show Percentage, new columns would appear). It would look like this:


Figure 2: You can select specific items or percentages for your progress invoice. 

Click OK. QuickBooks will return to your progress invoice, which you can save and print or email to your customer. Your original estimate will remain unchanged.

Tip: If you don’t want any of the zero amounts to appear on the progress invoice, go toEdit | Preferences | Jobs & Estimates | Company Preferences and make sure there’s a check mark in the box next to Don’t print items that have zero amounts.

Following Up

When you want to bill for another set of items on this estimate, simply repeat these steps.

Here’s an easy way to determine how much (if any) of the estimate has been invoiced. Go to the Customer Center and select the customer. Click the arrow next to the Show field and select Estimates. Any estimate that has a zero in the OPEN BALANCE column has been completely billed.

QuickBooks provides a report that tells you where you are with all of your progress invoices. Go to Reports | Jobs, Time & Mileage | Job Progress Invoices vs. Estimates. Your report will include the progress invoice you just created:


Figure 3: You can see what percentage of each estimate has been included on a progress invoice in this report. 

More Options

What if you determine that you won’t have one or more of the items on the estimate? QuickBooks lets you quickly generate a purchase order. With your estimate open, clickCreate Purchase Order to select the item(s) needed and generate the form. You can also click Create Sales Order if one is necessary.

Estimates provide a useful way to fine-tune your bookkeeping and inform your customers about impending costs. They can also be confusing if you don’t keep up with them. We can help you determine when they’re a good idea and how to keep them organized. QuickBooks provides good tools here, but they do require some administrative control.

Accounting Business Technology

Billing for Time and Expenses: How It Works

Billing for inventory parts is easy. Pick the items from a list and specify a quantity. Poof. Done.

Billing for costs, time or mileage is a little more complex. QuickBooks has built-in tools to help you do this, but it’s a bit of a process.

To simplify your workflow, do this groundwork first:

  • Go to Edit | Preferences | Time & Expenses | Company Preferences. Click the Yes button under Time tracking and indicate your choices under Invoicing options. If you plan to mark up some costs and want a default number, enter a percentage and account (these can be changed on individual invoices).


Figure 1: As you do with other QuickBooks processes, make sure that your Preferences are set correctly.

  • Add any billing items necessary by clicking Lists | Item List and then Item | New in the lower left corner.
  • If you plan to bill for mileage, go to Lists | Customer & Vendor Profile List | Vehicle List and enter information about every business vehicle.

Invoicing for Services

If you’re a service-oriented company, you bill for time frequently. This is easy. You’re probably already familiar with the Enter Time entry in the Employees menu. Whether you make individual time entries or complete a timesheet, it’s critical that you make the correct selections for each Customer: Job, Service Item and Payroll Item field, and check the Billable box.

When you create invoices, this box will open after you select a customer:


Figure 2: QuickBooks lets you know when there are time and costs to be billed for each customer.

You can let QuickBooks enter the time totals now, or add them later by clicking the Add Time/Costs button. Either way, the Choose Billable Time and Costs window opens. Add a checkmark next to each entry that should be billed, and click Options… to indicate whether you want one line for each time entry or would rather combine all similar service item types.


Figure 3: QuickBooks wants to know which entries should be invoiced.

More Complexity

If you’re done with billable expenses for this invoice, click OK. If there are other costs that you covered, click the Expenses tab to see all transactions that you earmarked for this client on a bill, check or credit card. You have the option here to mark up the cost by a percentage or amount (even if you established this in Preferences), and to specify an account.

Do the same for Mileage, which you would have entered previously — when it was incurred — at Company | Enter Vehicle Mileage. Then select any Items that you purchased for the customer. Your records should be correct, assuming that you were conscientious about assigning expenses to customers and jobs.


Figure 4: It’s easy to pull billable expenses into invoices if they’re documented carefully.

Turning expenses into invoices and then into income can be complicated. Let us know if we can help. We are your partner in building a successful business.

QuickBooks Tip: Here’s a cool little keyboard shortcut. Hit F2 while you’re in QuickBooks, and you’ll get the Product Information screen. It’ll tell you everything you want to know about your specific copy of QuickBooks, like your release and license number, the file size, number of users logged in, audit trail status and the total number of accounts, customers, employees, etc.

QuickBooks News Update

Please note that as of May 31, 2012, Intuit is discontinuing support for QuickBooks Pro, Premier and Simple Start 2009, QuickBooks for Mac 2009 and QuickBooks Enterprise Solutions 9. You can continue to use these solutions, of course, but live technical support and add-on services like payroll, credit card processing, online banking and bill-pay will not be accessible. Talk to us about upgrading if you’re using any of these products or services.

Scroll to top