10 Things Your Accountant
Never Told You About QuickBooks®….
Because they Didn’t Know or
Didn’t Take the Time To Share!
Using QuickBooks® effectively is a
learning process. Set realistic expectations about what QuickBooks® can do for you
and develop your action plan on how you are going to learn to use the various
aspects. What was the last software that you learned in a day? Nothing as vast
as QuickBooks®, I can assure you.
- Chart
of Accounts. Your Chart of Accounts is the backbone of your
QuickBooks® file. It’s critical that you understand the various types of
accounts so you can establish them correctly. The account types link to
reports, so if your chart of accounts is inaccurate, your reports will be
too. Setting up the accounts and determining whether they are assets,
liabilities, equity, income or expense accounts maps the information to
your financial reports.
- Items.
Items…what are they? The Item list is what we utilize to track the
products or services we provide. It allows us to have a way of interacting
with the estimating, invoicing, and job costing aspects as these all
function through the item list. It enables us to have more detail than we
could otherwise effectively manage through our chart of accounts. For
example, on your chart of accounts you will only have 1 inventory account.
Though you may have hundreds of inventory items on your item list flowing
through to that one account.
- Tax
Liabilities. When paying sales tax or employee tax liabilities, you
have to do it through a certain process. For paying sales tax, you must go
through the Vendor Menu. Employee taxes are paid through the Employee
menu. You cannot just use the “Write Checks” feature, as this does not
remove the liability off of your books.
- Journal
Entries. You cannot do journal entries with accounts payable and
accounts receivable accounts. I can’t tell you how many QuickBooks® files
I’ve seen where an accountant tried to “fix” someone’s problem by just
entering a journal entry. If your accountant tries to do this….just say
NO! While it may clear out the account to zero, you will notice on your
Accounts Receivable and Accounts Payable Aging Reports that those “fixes”
remain there indefinitely.
- Forms.
If you want to efficiently customize your forms, make sure to import your
logo or pictures first before you take the time to adjust other areas.
Speaking from experience, logos and pictures can rearrange parts of your
forms that you’ve just spent time adjusting. You can make your forms look
however you want. I’ve not found a client that we weren’t able to give
their form just the “right” look so that they weren’t using a “standard”
QuickBooks® form. Give your forms a personalized look that represents you!
- Reports.
Customize your reports easily. Want to know your profit margin? Just
modify your standard Profit and Loss Statement to include % of Income and
you’ll be able to see your gross and net profit margins. In addition,
you’ll be able to see what percentage of income you spend on all aspects
of your cost of goods sold and expenses. What does this mean to you? It
enables you to easily calculate how much you are keeping as profit within
the business out of each sales dollar. All reports can be modified to fit
your needs! You can also download free templates off the QuickBooks®
website right through your QuickBooks® file.
- Email.
Email your reports and forms right through your QuickBooks® file. No
additional costs or tools needed, except for Internet access. QuickBooks®
converts your form or report into a pdf file and emails it through web
access. Your recipient only needs the free Adobe Acrobat Reader. It can’t
get any easier! You can customize your email to meet your needs. Just
remember it goes via the web, not through Outlook or Outlook Express. If
you prefer to send your emails through your traditional email option, you
can covert any of your forms or reports to a pdf file through options
found under your File menu.
- Estimating
and Budgeting. Do your estimating and budgeting right in QuickBooks®
so that you can utilize special reports to compare actual with
estimated/budgeted figures. Why make more work for yourself? Set up these
aspects (estimating/budgeting) within your QuickBooks® file to manage
these critical aspects within one system. Utilizing other software for these
functions creates duplication of efforts and increased difficulty for
comparing actual to budgeted or estimated figures. QuickBooks® already has
preformatted reports available to make these comparisons quick and easy to
access.
- Payroll.
Looking for the answer to your payroll woes? Try QuickBooks® Complete
Payroll. It doesn’t get any easier than this! You can outsource your full
payroll function to QuickBooks®. You simply enter hours via the web or
call them in and let them do the rest for you! They’ll calculate the taxes
and net pay, direct deposit it into your employee’s account or onto a
paycard (this card functions in a similar way to a credit card only you
are using your paycheck as you go) and then they’ll also remit all the
necessary tax payments and report filings. Then you can download the
information right into your QuickBooks® file. No more trying to decipher
what those payroll reports mean from other companies and trying to decide
how you should enter the data into your file. You just click the button to
download and within seconds your information is input into your file! Sign
up through RPPC, Inc. and your $100 setup fee is waived!
- Credit
Cards. Accept credit cards? Looking for an easy way to track your
credit card receipts? You can process credit cards right in your
QuickBooks® file! You can also use this merchant account on the Internet
and download information right into your QuickBooks® file through a
gateway! It doesn’t get any easier than this! There is an additional
investment for a merchant service number, but going through QuickBooks® is
competitively priced and the ease of having it all within QuickBooks®
provides a great benefit.
Ongoing education about the various aspects of QuickBooks®
is the key to success. Depending on your learning style, there are a variety of
help options available. There are online help features within your QuickBooks®
file or online at www.quickbooksinformation.com.
Other options include Self Help books, Group Trainings (www.quickbooksseminar.com),
Teleseminars (www.quickbooksteleseminar.com),
Newsletters (www.quickbooksteleseminar.com),
Personalized Consulting (www.rppc.net), etc.
Though your goal may not be to become an accountant, you will benefit greatly
from ongoing learning about the vastness of what QuickBooks® can provide you
including Estimating, Job Costing, Budgeting, Invoicing, Cash Flow Management,
Financial Reports, Bookkeeping, and more! If you are feeling frustrated with
QuickBooks®, give yourself a chance for success by attending our ongoing Teleseminars!
We’ll also be doing some teleconferences for group consultations…they’ve been
well received by our clients as ways to share tips and war stories with other
businesses! We’ll be here to help you every step of the way!
Contact: Pam Newman is a Certified Management Accountant,
Author, and Certified QuickBooks® ProAdvisor for Financial and Point-of-Sale
software. For more information, visit her website at www.rppc.net or 816.304.4398. QuickBooks® is a
registered trademark of Intuit. RPPC, Inc. is a third party provider of
training for QuickBooks®, and is not part of Intuit.