November 2012
WB Logo

 From the office of:

Weltman Bernfield

Follow us on TwitterView our profile on LinkedInFind us on Facebook 

Join Our Mailing List
Our Monthly Tip:  
Memorize Transactions
by Josh Lipkin,
Pro Advisor


For every company, a significant number of transactions recur regularly, and QuickBooks accommodates this by enabling you to memorize recurring transactions. For example, suppose a company makes the same monthly rent payment, bills clients for recurring monthly services or records the same monthly depreciation entries. In these cases, QuickBooks can memorize the transactions and automatically enter them for you at regularly scheduled intervals. This feature can help save time, reduce mistakes and increase accuracy. You also can use this feature to memorize complex journal-entry templates, such as detailed allocations, and enter the actual amounts later. To access the tool, type Ctrl+M.

 Memorize Transaction will generate electronic payments or paper checks but it does not automatically send or print them. Once a check is created in QuickBooks, you can send or print the check using the File menu's Send Documents or Print Documents menu options.
__________

    



Webinars Designed
To Peak Your Interest
and sharpen your skills!

 

Be a part of one of the upcoming QuickBooks webinars and increase your understanding of the software.

If you have a friend who
is interested, make sure they
sign up for the QB Newsletter so they
can receive future announcements.


An email will be sent to all people on our QB list with details on how to sign up.

 
Webinar Topics
 
Wed., Nov. 14, 10 am 
"Electronic Banking and Cloud Accounting" 
Learn how to use electronic banking in QuickBooks and how to use QuickBooks in the cloud. 

Wed., Dec. 12, 10 am 
"QuickBooks at Year End"  

Cost: $49 each   
1 hour CPE credit for CPAs
 
To register, please
email your name and
contact information to:
 
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!      

 

Greetings!

 

Have you heard that QuickBooks® does electronic banking? Would you prefer the convenience of getting your transactions from your bank or credit card company without having to enter them in one by one? If you'd like to learn more about this feature, we invite you to join our webinar on November 14. (See left column for registration information.) 

In this webinar, we will also discuss having QuickBooks on a hosted environment...known as "QuickBooks in the Cloud." We will show you how it works and how you can utilize this popular way of accessing QuickBooks. Please join us for this informative webinar. CPE credit is available.

 

Please contact us with any questions you have. 

 

Sincerely,

Your QuickBooks Pro Advisory Team

rkane@weltmanbernfield.com

 

QBC Logo

Are You Defining Items in QuickBooks Correctly?

Create item records in QuickBooks carefully, and QuickBooks will return the favor by running useful, accurate reports. 

November 2012 QuickBooks, figure 1

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 Parts. 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:

Nov 2012 QuickBooks, figure 2  

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.

Nov 2012 QB, figure 3  

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.

Nov 2012 QB, figure 4

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  
  • 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.