amp

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.

Preparing Purchase Orders Precisely

Part of the reason for QuickBooks’ success is its exceptional flexibility. By allowing users to turn features and preferences on and off, the same software can be used by a wide variety of business types and sizes.

In some cases, the default settings that QuickBooks supplies will work fine for your company. This is not necessarily true in the case of purchase orders, since the whole inventory procurement process is so complex, and users can have such a diverse range of needs.


Figure 1: QuickBooks 2013’s default Create Purchase Orders screen. You can see that formatting options are available when you click the Formatting tab. 

So before you order your first widget, make sure that your purchase order form is designed to accommodate all of the information you want to record and track, with no unnecessary data fields to confuse staff.

Working with Templates

There aren’t many program preferences to check. If you can open a purchase order, you’re set. If not, go to Edit | Preferences | Items & Inventory and be sure that the box next to Inventory and purchase orders are active is checked.

What you want to find first is the Additional Customization screen for the Custom Purchase Order Template. This is easily accessed from the Create Purchase Orderscreen itself in QuickBooks 2013, but if you’re using an earlier edition, go to Lists | Templates | Custom Purchase Order Template. Double-click on it to open the Basic Customization page. Here, you can add a logo, change fonts and colors, etc. But go ahead and click on the Additional Customization button at the bottom of the screen. This window opens:


Figure 2: The left pane of the Additional Customization window contains additional fields that you might want on your purchase orders, like Ship Via and Terms

(Tip: If you want to design multiple purchase order templates, click Manage Templates on the Basic Customization screen, then Copy on the Manage Templates page. Rename the form and make your modifications. This version will always be available as an option when you create purchase orders.)

Making It Yours

Each of this window’s four tabs opens a new screen that gives you customization control over a different element of the purchase order form: the top, bottom and midsection, and printing options. You simply check the boxes next to the fields that you want to add to the current form (be sure to check both columns if you want the fields to appear both onscreen and in your printed versions; sometimes, one is not an option) and uncheck any you want to delete.

In the right pane of this window, a dynamic preview changes to reflect each addition or deletion. And when you’ve finished altering the set of fields, you can see an actual print preview. Close that and keep clicking OK until you get back to the Templates window.

This simplicity and ease carries over into the more cosmetic elements of your purchase order. Make sure the template you want to redesign is highlighted and click Templates | Create Form Design. QuickBooks walks you through the process of adding a logo and background, colors and fonts, and a grid style, and it lets you apply this same theme automatically to all of your forms. (You can modify your design similarly on the Basic Customization page, minus the wizard-like approach and the background options.)

Simple but Complicated

One more comment about the QuickBooks 2013 purchase order screen. Beyond making your formatting options available in the “ribbon,” it also moves you through purchasing to the receiving process. With the appropriate purchase order open, click Create Item Receipts in the ribbon. This window opens, with the correct vendor name selected. When you click in the Item field, this small window appears:


Figure 3: Click Yes here and select the correct PO, and QuickBooks fills in the data. If you check the Bill Received box, the Enter Bills window opens. 

QuickBooks’ purchasing and receiving tools makes your inventory-tracking job easier, but you still need to understand the workflow. We encourage you to let us work with you as you begin managing inventory – or to contact us if you’re tangled up in what can be a very challenging element of QuickBooks.

Spring Cleaning: Streamlining QuickBooks 2013

Although Intuit did a great job of giving QuickBooks’ home page a fresher, more “open” look in its 2013 versions, maybe some of your screens have become unnecessarily cluttered. Perhaps your QuickBooks company file needs some attention as well. By taking a few minutes to do some “spring cleaning” you’ll have a tidier workspace, and you’ll save time and frustration. The following suggestions will help you to do just that.

Make a Clean Start

One simple way to take care of cluttered screens is to do the following:

  • Minimize icons. That pretty graphical process map on the home page is great for quick access to frequently-used actions. Some of them must remain there if they’re related to activities you do (i.e., Invoices has to stay if you use Estimates), but you can remove some of the ones you don’t use. Go to Preferences | Desktop View | Company Preferences. You’ll see this:


Figure 1: You can turn off some of the feature icons on your home page.

Some of the options have been grayed out because they support other processes. To remove an active feature icon like Inventory, click on it. In the window that opens, uncheck the box next to Inventory and purchase orders are active (you can also modify options here).


Figure 2: Clicking the checkbox next to Inventory and purchase orders are activegrays out the other options and removed related feature icons from the home page.

To reduce the number of feature icons even more, go to the Finance Charge, Jobs & Estimates, Payroll & Employees, Sales & Customers, Sales Tax and Time & Expenses. QuickBooks removes the related icons and reroutes the process map on the home page.

More Time-Saving Tweaks

  • Don’t allow multiple windows to open in your work area. Tired of seeing all of those overlapping open windows on your desktop? Open the View menu and select One Window. All of your open windows remain active in the background. To return to one of them, open the Window menu and select the one you want to move to the front (Window | Close All returns you to a blank work area).


Figure 3: Your Icon bar can be your fastest route to often needed screens–if you modify it to only contain the functions you use, in order of importance. You can also change the labels to make them more meaningful to you.

    • Trim down your icon bar. Seems like a minimal change, but it’s one of those things that can add unnecessary moments of frustration throughout the day (“Where’s the Calendar!”). Click View | Customize Icon Bar.

 

  • Customize columns in Lists. You probably work in QuickBooks’ Lists often, but are you spending too much time tracking down the right information? Customize their columns so your registers contain only what you usually need (and add additional ones if it’s helpful). Open a list, right-click anywhere within it and select Customize Columns to modify the display (re-size column widths by placing your cursor on the vertical set of dots between labels and dragging).


Figure 4: When you customize your columns in Lists, you’ll find what you’re looking for faster. 

  • Hide inactive items. Highlight an item, right-click and select Make Item Inactive. Open the Item menu in the lower left and click Hide Inactive Items (this action won’t delete them).

Internal Cleaning

These may all seem like cosmetic changes, but you will save time and frustration over the long run.

The most critical spring cleaning task is company file analysis and maintenance. We can handle this for you. QuickBooks can slow down and start generating error messages when the data file becomes unwieldy and sloppy. Preventing file corruption before it crashes your system is a lot faster and less expensive than a reconstruction project.

Scroll to top