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
|