company preferences

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.

By Leon Clinton
August 4, 2013

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.

By Leon Clinton
April 22, 2013

Are You Defining Items In QuickBooks Correctly?

Figure 1: Clearly-defined items result in precise reports.

Obviously, you’re using QuickBooks because you buy and/or sell products and/or services. You want to know at least weekly — if not daily — what’s selling and what’s not, so you can make informed plans about your company’s future.

You get that information from the reports that you so painstakingly customize and create. But their accuracy depends in large part on how carefully you define each item. This can be a laborious process, but it’s a critical part of QuickBooks’ foundation.

QuickBooks’ Item Lineup

You may not be aware of all of your options here. So let’s take a look at what you see when you go to Lists | Item List | Item | New:

Service. Simple enough. Do you or your employees do something for clients? Training? Construction labor? Web design? This is usually tracked by the hour.

Inventory Part. If you want to maintain detailed records about inventory that contain up-to-date information about value, quantities on hand and cost of goods sold, you must define these items as inventory parts. Before you start creating individual records, make sure that QuickBooks is set up for this purpose. Go to Edit | Preferences | Items & Inventory | Company Preferences and select the desired options there, like this:

Figure 2: QuickBooks needs to know that you’re planning to track at least some items as inventory parts.

Inventory Assembly. Just what it sounds like; it’s sometimes referred to as a Bill of Materials. Do you sell items that actually consist of multiple individual products, services and/or other charges (though you may also sell the parts separately)? If you’re planning to track the compilations as individual units, then you must define them as assemblies.

Non-Inventory Parts. If you don’t track inventory, you can set up items as non-inventory parts. Even if you do track inventory, there may be times when you’ll want to use this designation. For instance, you might sell something to a customer that they asked you to obtain, but you don’t plan to stock it. In that case, QuickBooks only records the incoming and outgoing funds.

Figure 3: The New Item window looks a bit intimidating, but it’s critical that you complete it thoroughly and correctly. We can help you get started.

Other Charges. This is a catch-all category for items like delivery charges or setup fees. You can’t designate a unit or measure here; they’re just standard costs.

Groups. Unlike assemblies, these are not recorded as individual inventory units. Use this designation when you sell a combination of items together frequently but you don’t want them tracked as one entity.

Discount. This is a fixed amount or a percentage that you subtract from a subtotal or total.

Payment. Normally, you would use the Receive Payments window to record a payment made. But if your customer has made a partial or advance payment upfront, use this item to subtract it from the total when you create the invoice or statement.

Figure 4: Use the Payment item to record an upfront remittance.

Sales Tax Item. One sales tax, one rate, one agency.

Sales Tax Group. If a sale requires two or more sales tax items, QuickBooks calculates the total and displays it for the customer, but the items are tracked individually.

Additional Actions

The Item menu provides other options for working with items. You can:

Edit or delete
Duplicate
Make inactive
Find in transactions and
Customize the list’s columns.

Let us know if you’re not confident about items you’ve already created or if you’re just getting started with this important QuickBooks feature. Some extra work and attention upfront can save you from hours of back-tracking and frustration–and from reports that don’t tell the truth.