Weltman Bernfield LLC 

June 2013

 From the office of:

Weltman Bernfield LLC

Join Our Mailing List


& connect with us on...   

Follow us on Twitter View our profile on LinkedIn Find us on Facebook 
Our Monthly Tip:

Keyboard Shortcuts
by Dean Klemenz,   
QuickBooks Pro 

Here is a list of keyboard shortcuts that I feel can be helpful to the general QuickBooks user:

Create a New Invoice -
Ctrl + I

Find a Transaction -
Ctrl + F

A/R History or A/P Transaction - Ctrl + H

Memorize Transaction or Report - Ctrl + M

Open Account List -
Ctrl + A

Open Customer and Jobs List - Ctrl + J

Open Help for Active Window - F1

Open List of Current Drop Down Choices - Ctrl + L

Open Memorized Transaction List - Ctrl + T

Open Transaction Journal - Ctrl + Y

Print - Ctrl + P

Quick Report on Transaction or List Item - Ctrl + Q

Create (Write) a New Check - Ctrl + W

Display Version and Product Information - F2
               
Close Active Window - Esc

Start QuickBooks Without Company File
Press the Ctrl Key while QuickBooks is Loading

Use List Item - Ctrl + U


Webinars Designed
To Peak Your Interest
and sharpen your skills! 
 
Upcoming Topics:
 Monday, August 19
11am  CST
 
Cost: $59 (regularly $79)
Discount code is RK49
2 hour CPE credit for CPAs
 

Topics include:
 
  • Pro, Premier & Enterprise differences
  • Behind the scenes accounting
  • Customizing reports in QuickBooks and the Intuit Statement Writer
  • Cleaning up your data file
  • Fixed assets and loan manager
  • Security features 

Click here to register. 
If you have an idea for a topic or need more information, please email Rich Kane.


Have a question that needs a solution?

  

Contact one of our QuickBooks® Pros...
they have the answers!
 
Rich Kane 
847.941.0253
Dean Klemenz
847.941.0205

Adam June
 
847.941.0204  
 
Rich Bauer 
847.941.0237 

  

Weltman Bernfield 
485 E Half Day Rd, Suite 250 
Buffalo Grove, IL 60089

P: 847.941.0100 
F: 847.941.0101

 
Intuit Certified ProAdvisor - Quickbooks Intuit Certified Pro Advisor - QuickBooks Advanced





Greetings!  

 

Here are some important highlights for the upcoming month:
  • Bye Bye QuickBooks® 2010... it has officially been retired. If you are using this version or a prior version, Intuit will no longer answer any questions or help you if your data file is corrupt. You might want to consider upgrading to QB2013. Contact Rich Kane for upgrade information.
  • Just a reminder to be sure to get a tax ID or social security number for each of your outside contractors. LLCs are also in this group.
  • QuickBooks "in the cloud" is becoming the buzz word for 2013. You might want to consider going to the cloud for your accounting package. Give Rich Kane a call to learn more.

Please e-mail us (see contact info below) with any suggestions for webinar topics you'd like to see us cover. Our last one--"Reporting in QuickBooks"-- was well received.

 

Sincerely,

Your QuickBooks® ProAdvisory Team 

 


QBC Logo

How to Create a Progress Invoice
from an Estimate
 

Not using progress invoices? Maybe you should be.
 

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:

 

June 2013 QuickBooks figure 1

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 predefined 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:

  June 2013 QuickBooks figure 2

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 to Edit | 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 amount.

 

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:

 

June 2013 QuickBooks figure 3
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, click Create 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 require some administrative control.