Beyond Taxes: 7 Ways to Put QuickBooks to Work in
2006
Certified QuickBooks ProAdvisors Inga Arendt, Bruce Downs,
Suzi Graden, and Bonnie Nagayama have helped many clients take
better advantage of QuickBooks features in their years of practice.
Different businesses have different needs, but the following
suggestions apply to most. We hope they'll help you save time and
put QuickBooks to work for your business.
(Read more about our contributors' many qualifications,
and get their contact information at the end of this
article.)
1. Job Costing
"The non-accounting features of QuickBooks that I've
found most useful are the job-costing and/or class features. Many
of my clients have been amazed at how easy it is to 'slice and
dice' their business information into a variety of different ways
that allow them to determine the profitability of various
departments, product lines, customers/jobs, etc. The terms
'job-costing' and 'tracking information by departments' can
intimidate a lot of small business owners, but QuickBooks makes
the whole process easy and relatively painless.
"To learn
more about how to capture and use job-costing information using
QuickBooks, type Job Costing into your QuickBooks Help.
"Once you've started collecting job costing information
into QuickBooks, you'll find the fruits of your labor under
Reports > Jobs & Time, where you'll be able to assess each
job's profitability."
— Inga Arendt
2. Timesheets
"Timesheets have also been very helpful for many of my
clients. When you enter your and your employees' time into
QuickBooks timesheets, you get two things: an easy-to-use data
entry screen for employee hours, plus the ability to link those
hours with specific jobs, service codes, and paychecks.
"I've amazed more than one client by getting them to use
this feature. They find it hard to believe that just using the
timesheet screen properly provides the opportunity to include the
time details on a customer invoice as well as include the hours on
employee paychecks.
"Additionally, you can run a wide
variety of reports based on timesheet data. The Time by Job
reports will reveal on which jobs and tasks your employees spend
their time, and Job Profitability reports will be able to include
payroll costs and revenues."
— Inga Arendt
3. Write Letters using QuickBooks and
Word
"The Write Letters feature (in QuickBooks 2005 and
2006) allows you to merge information from within QuickBooks into
an unlimited variety of letters. It recently helped me provide
extra customer service to a few of my best clients — in about five
minutes.
" 'Curing a New Tax Headache,' an article in the
December issue of the Intuit ProConnection® newsletter for
accountants, pointed out the nuances of the Section 199 Production
Deduction (has a nice ring if you enunciate).
"The
authors, Terry Myers and Dee DeScherer, also attached a Microsoft
Word document with a great client letter, which introduced this
new deduction for producers of finished goods.
"As I read
the article, I realized the deduction could apply to several of my
clients. So, I highlighted and copied the text of the letter, and
opened up QuickBooks.
"I went to the customer navigator
(OK so I was still using 2005), selected Letters to customers, and
selected Customize letter templates. I pulled the template for a
thank you note, highlighted the body of the letter, and pasted in
Terry and Dee's text (hope this ain't a copyright violation).
"I saved the letter as "199 Deduction" and closed it.
QuickBooks queried 'Use Template?' 'Why sure!' I said, and clicked
Yes. I then selected the clients it applied to, and clicked the
Next button a couple times. Finally, QuickBooks prompted me to
print envelopes and letters, and voila. I had letters to
all my clients who might benefit from the 199 production
deduction.
"In the space of about 5 minutes, I had a
handful of professional-looking letters to some of my best clients
that said 'I care.'
"Thanks Terry and Dee, ProConnection —
and QuickBooks."
— Bruce Downs
4. Export Reports to Excel
"Exporting reports from QuickBooks into Microsoft
Excel is a fantastic time-saver. There is a lot of flexibility
within QuickBooks to customize reports but there are still often
specific reports that my clients want that are not available
within QuickBooks. I recommend that they take a report that's
close to what they want, export it into Excel, and then customize
it further. Doing this expands the range of available reports well
beyond what is shown in QuickBooks."
— Inga Arendt
5. File Documents Electronically
"I make many recommendations to clients about how to
improve their efficiency and use of QuickBooks, but this year my
partners and I had our own New Year's Resolution for managing our
business. We now keep all of our accounting documents
electronically, attached to the relevant transaction in QuickBooks
using SourceLink®, a QuickBooks-Compatible application.
"The result: No more time wasted by filing paperwork, and
no more time wasted looking for the document in the file cabinet
(or worse yet the 'to be filed' pile).
"Plus, I now have
more space since I gave away my huge metal 4-drawer lateral filing
cabinet to another business owner!"
— Bonnie Nagayama (Learn more about
SourceLink QuickBooks-Compatible software at the QuickBooks
Solutions Marketplace, at www.marketplace.intuit.com or SourceLink Home Page)
6. Keep Contact Information in One
Place
"Most of us have multiple places for keeping track of
addresses, phone numbers, email address and other pertinent
contact information for our business contacts. With QuickBooks,
there are many ways to centralize all of this contact information
and eliminate redundancies.
"QuickBooks vendor, employee,
and customer lists will track all your basic contact and vital
information. You can also synchronize QuickBooks lists with
QuickBooks Customer Manager, Microsoft® Outlook®, ACT!, Legrand
CRM, or GoldMine®. This is extremely helpful for keeping
information accurate and up to date."
— Suzi Graden (Learn more about ACT!,
Legrand CRM, and GoldMine QuickBooks-Compatible software at the
QuickBooks Solutions Marketplace, at www.marketplace.intuit.com. -Eds.)
7. Enter Budget, Compare Budget vs. Actual
Info
"Entering budgets and comparing budget versus actual
information gives my clients the ability to compare where they
hope to be with where they actually are.
"QuickBooks makes
the process very easy. Once you enter the budget, you can 'slice
and dice' it in the same way as financial information (by account,
date, customer/job, and class).
To learn how more about
entering budgets in QuickBooks, type 'budget' into your QuickBooks
Help."
"Monitoring budgeted versus actual information
allows my clients to become more pro-active and less reactive to
their financial information. I find that to be extremely important
for running a successful business."
— Inga Arendt
The following Certified
QuickBooks ProAdvisors provided content for this article:
Inga Arendt, CPA Ms. Arendt is a CPA and a member
of the 2004-2005 Accountant and Advisor Customer Council for Intuit.
She is a manager at the Green Bay, WI office of WIPFLI, LLP. iarendt@wipfli.com www.wipfli.com
Bruce Downs,
CPA Mr. Downs is a CPA who specializes in new and small
business accounting and QuickBooks consulting. He served as a member
of the Accountant and Advisor Customer Council for Intuit from
2003-2005. He lives in Alabama. www.BruceDownsCPA.com
Suzi
Graden, CPA Ms. Graden is a CPA with Creamer, Green &
Associates in Salem, Oregon. She is a member of the 2004-2005
Accountant and Advisor Customer Council for Intuit. suzi@bestcpas.com
Bonnie J.
Nagayama, CPA Ms. Nagayama is a CPA and the president of
McWilliams & Associates, Inc., a small business and QuickBooks
consulting firm. She teaches classes to other accountants about
QuickBooks, and her company publishes a free weekly newsletter of
QuickBooks tips and tricks, filled with suggestions for using
QuickBooks more effectively (details at the company web site, linked
below). www.4luvofbiz.com
Certified
QuickBooks ProAdvisors can be a valuable resource for your business.
They can help you get the most out of QuickBooks, whether it's
through training, customization, or troubleshooting, so that you can
spend more time on your business — and less time on your books.
Follow this link to find a certified
QuickBooks ProAdvisor near you.
Back to
Top
 |
 |