First name:
Email:




HACKER SAFE certified sites prevent over 99.9% of hacker crime.

 

4luvofbiz QuickBooks Tips and Tricks Newsletter

  4luvofbiz QuickBooks Tips and Tricks Newsletter
 

QuickBooks Edition - Issue 9.05

July 12, 2010

It was great to see so many of you at Joe Woodard's Conference in Atlanta and I cannot wait to see you again at the Sleeter Conference in Las Vegas November 8-10. For those of us in the US and Canada, summer is in full swing: I hope you are making some time to enjoy it!

Bonnie

In this issue:

Tips and Tricks

Ask the Expert: Volume Pricing

Q - My question has to do with inventory vs non-inventory items. For example, if I had a t-shirt company, and to simplify things, let us just assume that all the t-shirts are the same size and same color. I sell these t-shirts in boxes of 500, 250, 100, 50, 25, and as a single t-shirt. The price goes down when the quantity bought goes up. How do I track the inventory is my question. The blog example states that I should do all this as volume pricing and set the items as non-inventory, however, how do I track the amount of t-shirts I have on hand. I receive these shirts by the thousands and I package them as they are sold, priced accordingly to the quantity of the order. I would love to be able to know how many t-shirts I have at all times, as well as being able to price the t-shirts accordingly upon receiving the order and the knowledge of the amount of quantity of the order. Submitted by Rich

A - I agree that you want to use the inventory functionality to keep track of what you have on hand, re-order points, etc. so using non-inventory items does not seem to make sense to me either. In your example, you said assume that all the t-shirts are the same size and color, but I am assuming that is not the case in your business. My suggestion would be to use a custom field which will show on the sales order, invoice, etc but does not print which includes the pricing. If the price breaks are always based on the same quantity, you could put the price per each separated by a comma, dash, etc. so you know that the first price is for the 500 piece order, the second price is for the 250 piece order, etc. With this method, as you review the pricing for that item, you will simply override the per piece price on the sales transaction.

For a more robust inventory solution, you might consider an inventory add-on from www.marketplace.intuit.com. For one suggestion: While not specifically designed for the apparel industry (since it is not set up to handle a matrix type item so the size and color results in individual items like there is in QuickBooks) Fishbowl Inventory does handle volume pricing as you have described as well as providing a much more robust feature set. If you would like to investigate this option, contact me for a complimentary demo.

The decision will really depend on what makes the most sense for the business.

QuickBooks Integrated Application Solution - Virtual Software

Most of you know I have been an advocate for the Intuit developer community since before the Intuit Developer Network was even established almost a decade ago. I love the fact that we can provide solutions that work for the client while still keeping them happy and productive with QuickBooks. To that end, there is a new section of the newsletter specifically designed to highlight an application and provide information as to how they are a real world solution for a client pain point.

This week, the product to be highlighted is Virtual Software. This product is more robust than the time tracking features provided by Intuit directly, and not as complex as BillQuick. They fit in the sweet spot between the two with the ability to easily manage multiple bill rates and pay rates by employee and project; administrative control for the customer list; and compatability with QuickBooks, Peachtree, ADP, Paychex and others. It is a good fit for employment agencies, professional service firms, and more.

We are just getting started trying out this product internally. The set up was quick and easy. The support has been great. With our business being completely remote, an online solution makes sense. Watch for more information on our personal experience in future issues.

PS I have been able to negotiate the same deal as I am getting for you: FREE! Free
accounts will be provided to accounting professionals who provide accounting
services to other companies on a full-time basis by using the link below.

Learn more: http://www.virtualsoftware.net/index.php?r=0018000000b47ex
For AOL Users: <a href="http://www.virtualsoftware.net/index.php?r=0018000000b47ex">click here</a>

Live Events

The Top 5 Ways to Be a Hero to Your QuickBooks Clients - There is a group that is open to everyone, not just CPAs here in my local area. This course is just about sold out for the live event in Walnut Creek, CA so I plan on offering it in a webinar format to my subscribers. Watch next week for the date and time as well as sign up instructions.

Save the Date - I will be presenting my "What's New for 2011" session on the Intuit Mountain View Campus on October 19, 2010. There may be a second session added that same day. These sessions are sure to fill up fast, so please let me know if you want to "pre-register" so I can save a spot for you. One session will be sponsored by the local CPA Society chapters, the other will be specifically for my subscribers. Send me an email or fill out the contact us form on the website if you would like to be added to the list to receive more information as it becomes available.

Intuit QuickBooks for Mac Little Square

Intuit's QuickBooks for the Mac team is launching a new website called Little Square. The concept is that it will be more like a town square than a big New York Times Square: a place where people can gather and share ideas.

Also, I am still on the Intuit Mac Council so if you have any feedback on the product, I would be happy to pass it along.

Learn more: http://www.qblittlesquare.com/
For AOL Users: <a href="http://www.qblittlesquare.com/">click here</a>

Intuit's Path to Productivity Virtual Conference July 21st and 22nd

Intuit is hosting Path to Productivity, a two-day virtual conference designed to increase accounting and tax professionals’ productivity when using Intuit’s professional line of products so they can spend more time growing their practices. The conference covers an array of topics and products, including common QuickBooks mistakes clients make and tips to help professionals process payroll more efficiently. Additionally, attendees will be offered a session on ProSeries navigation and data entry essentials and two Lacerte sessions focusing on productivity tools and practice management. During the conference, attendees also can visit the event booths to chat live with peers, Intuit Academy trainers and product experts.

The Registration, Event Overview and Agenda is available at http://events.unisfair.com/index.jsp?eid=611&seid=31
For AOL Users: <a href=”http://events.unisfair.com/index.jsp?eid=611&seid=31 ”>click here</a>

About Us

McWilliams and Associates can help you keep pace with all your QuickBooks clients. Through many self-service options on our website www.4luvofbiz.com, group settings like seminars and tele-classes, or one-on-one services, we help you quickly and painlessly navigate through the obstacle course of QuickBooks and related add-ons. Our clients are primarily from all over the United States with 95% of our work being done remotely with other Accountants and Pro Advisors, or with their clients if they prefer. We do not do any income tax work or financial statements so there is never a conflict of interest. Most of our QuickBooks consulting clients need 2-6 hours with us to deal with a specific issue, transition, or just for those occassional questions that come up.

In addition to QuickBooks we love working with integrated applications: Some specific examples include XpandedReports, Fishbowl Inventory, and Legrand CRM. We have experience with all these products and would love to partner with you as you help your client address needs that are beyond the scope of QuickBooks alone.

If you want more information on how we might best work together, call 800-787-8744. We would love to talk with you about your needs and any special deals we have for Bookkeepers, Accountants, and ProAdvisors.

Quick Links

Monthly Discussion Forum Visit http://www.4luvofbiz.com/product.php?productid=349 (the link stays the same, the date/time is updated each month)
For AOL Users: <a href="http://www.4luvofbiz.com/product.php?productid=349">Monthly Discussion Forum</a>

XpandedReports for QuickBooks Use affiliate code of "4luvofbiz" for an additional 1 month extension on the 1 month trial.
For AOL Users: <a href="http://quickbooks.xpandedreports.com/index.html">XpandedReports for QuickBooks</a>

For online CPE courses I will be presenting, go to CPE Link: http://www.cpelink.com/instructor/detail.php?i=52&s= ysg86k6

We have a non-ownership business relationship with Intuit, XpandedReports, Fishbowl Inventory, Virtual Software, BQE Software, and CPE Link.

If you do not want to receive emails from McWilliams & Associates, please send an email by clicking here.

You have been selected to receive this email because you indicated you wanted to receive valuable information and product updates from McWilliams & Associates when you provided your e-mail address to 4luvofbiz.com. Your email address has not been given to any Third Parties.

© Copyright 2010 McWilliams & Associates Inc. All rights reserved.

McWilliams & Associates Inc.
1480 Moraga Road, Suite I, PMB 385
Moraga, CA 94556-2005
Telephone: 800-787-8744
Fax: 925-376-3454
URL: http://www.4luvofbiz.com

 

 

For further information, visit the following articles:
QuickBooks Tips & Tricks - FREE Add-on: QBTimer (Free!)
Weekly QuickBooks Tips & Tricks Newsletter (Free!)
QuickBooks Tips and Tricks - Sick and Vacation Accruals (Subscription required)
Smart Reports for Financial Statement Prep (Subscription required)
QuickBooks Tips & Tricks – Minimize Use of the Mouse (Subscription required)

 
 

 

 

 

 
 

  [ Privacy Policy ] [ Terms of Use ] 800-787-8744 Copyright © 1992-2010 McWilliams & Associates Inc