QuickBooks, like Life, can be complicated…

and like life, there are ways to simplify it.

First, know what it is that you need QuickBooks to do. Small business owners usually need a way to log income, track inventory and purchases, and record expenses to see if their company is profitable and to give the IRS and State agencies the information they require on income tax returns. To determine your QuickBooks needs, it helps to make a visual representation of the workflow processes that take place within your company. 

QuickBooks Work Flow

It doesn’t have to be as fancy as the one above.. scribbling it on a napkin or a white board will do just fine.   Better yet, gather key employees and go through this exercise as a team.

For most QuickBooks transactions, you can ask yourself:

  • Is this entered manually?
  • Is there an integration to save time entering this transaction?
  • What happens after the transaction is entered?
  • Where does the paperwork go (either physical or digital copies)?

Take each part of the workflow process and break it down.   For example: Order Entry – how do the orders get into QuickBooks (ask the four questions above);  How are payments received (as the four questions above); what happens to those payments – do they go into undeposited funds or right into a bank account in QuickBooks?….

Understanding the workflow processes that happen in your company, then breaking them down into QuickBooks related steps, will help you simplify and streamline your day-to-day tasks so you can become more efficient and more productive.

The Importance of Proper Preferences

Setting up your preferences in QuickBooks to properly reflect the way you do business is important, in fact critical, to accurate transactions which lead to accurate financial statements.

I encourage you to make time to review your preferences in your QuickBooks company file.

Preferences are located under the Edit Menu.  They are broken down by two tabs – My Preferences and Company Preferences.

My Preferences are your personal preferences that affect how QuickBooks works for you, but not for other users.

Company Preferences are company-wide and affect all users. Only the QuickBooks Administrator can change them.

Preferences

There are up to 23 different Function categories listed in the left hand column.   I’m going to go through only a few of the most important and most common preferences, but I encourage you to go through each category and review both the My and Company Preferences. Also, the Preferences are mostly the same in all versions of Pro, Premier and Enterprise from 2009 to 2014. The Preferences for Point of Sale are different and not covered in this blog.

Accounting/Company Preferences/Use class tracking for transactions – this feature is extremely useful for tracking special circumstances without expanding or complicating your chart of accounts.   For example, if you want to track the income and expenses related to all the events you go to, you could create a class for each event (say a specific trade show or networking event).  Whenever you enter income or expense related activities, you select the appropriate class.  Then when your event is done or you are reviewing your financials for next year’s budgeting, you can run a report by class that shows all the transactions.

Class Tracking

Desktop View/Company Preferences –  here is where you can turn on and off features which ultimately appear on your Home Page.   If you don’t collect Sales Tax, or use Time Tracking, for example, you can turn them off so they do not appear on your desktop.

Desktop View FeaturesThere are many potentially annoying features in the General/My Preferences tab that can be unchecked if they are a nuisance.   If you do not want to here a beep every time a transaction is entered, make sure that box is unchecked under the My Preferences tab.   Also, if you do not want Intuit to tell you about its products and services, place a check-mark in the box to turn off these pop-up messages.

General Preferences

One last feature I want to mention in Preferences is the Tax:1099 which is were you let QuickBooks know whether or not you file 1099-MISC forms, and if you do, where you map out your accounts to be included on the 1099 forms.

If you do file 1099′s – remember they are due out by January 31st.   We have partnered with Onlinefiletaxes.com, is an IRS approved tax e-filing provider for all your 1099 and W-2 filing needs, to offer you a 10% discount on your order.

Sign up today at www.onlinefiletaxes.com.  Use coupon code: QZ-LFP-DVE

As mentioned earlier, there are many other important preferences in QuickBooks to help make using QuickBooks a little easier so check out your Preferences today.

Bill Payment Options within QuickBooks

There are a few options for paying bills and expenses within QuickBooks:

Cash

Cash purchases can be entered through the Write Check window using a petty cash bank account.   Make sure to reconcile Petty Cash at the end of every year.

Handwritten Checks

Companies that are small and do not have many bills to pay can manually write out paper checks from their business account and record the check in QuickBooks using the Write Check or Pay Bills Window.

Check writing

Printed Checks

Pre-printed checks for both laser, ink-jet and continuous printers are available from office supply stores and other online paper supply companies.  Checks can be printed immediately one at a time or in a batch later. Checks can be printed using the Write Check or Pay Bills Window.

Pre-printed checks come in a variety of styles:

Checks

Pay with Credit Card

Another option for paying bills that many companies are choosing is to use a company credit card that earns reward points.

If you use Enter/Pay Bills, make sure to select Credit Card under “Method” in the Pay Bills Window.

If you do not use Enter/Pay Bills, make sure to enter all credit card purchases using the Enter Credit Card Charges, after setting up the credit card in your Chart of Accounts.   Reconcile the Credit Card as you would your bank statement each month.

Use QuickBooks Bill Pay Feature

Write checks as you normally would in QuickBooks. Instead of selecting “To be Printed”, select “Online Bank Payment” and choose the date on which you would like the payment to be delivered.

OR 

Pay bills as you normally would in QuickBooks. Select “Online Bank Payment” and choose the date on which you’d like the payment to be delivered. 

THEN Send the payments from the Online Banking Center within QuickBooks, and the payments will be made by the delivery date.

Intuit charges a monthly fee for this service.

Use Third-Party Software

There are many cloud based software programs to automate your Accounts Payables (and Receivables). These programs are ideal for companies who want to automate their A/P process and have separate people to enter the bills and authorize the bills.

These programs send out the payments for you and sync the information with your QuickBooks. This is a great option for reducing paperwork, reducing officer/management time and protecting against fraud and errors.

Most programs charge a per transaction fee and/or a monthly fee.

Inventory Management 101 – the critical component of your business and taxes

Generally, if you produce, purchase, or sell merchandise in your business, you must keep an inventory.  This inventory, and the management of it, directly impacts the profitability of your company and is recorded on your income taxes in terms of Cost of Goods and Inventory Valuation.

Inventory Management is Critical to your Business

Inventory Management is Critical to your Business

Many small business who sell products do not  manage their inventory properly or utilize all the features in QuickBooks for doing so.  This can result in over or under estimating profits, over or understated inventory values at year end and consequently over or under payment of taxes.  I am going to briefly discuss some of those QuickBooks features and the most common mistakes I see in inventory management.

To understand how important inventory is to your business, you only have to perform a simple calculation:    Gross sales (the revenue generated by selling your product) minus the cost to make those items you sold (Cost of Good Sold or COGS) equals Gross Profit.    This basic financial formula tells you whether or not you are making money selling your product.

From the Gross Profit, you subtract all the other costs of running your business (operating expenses) and you have your Net Profit.

The cost for ALL the components that go into making your products, and any unsold products are totaled and kept in an account on your Balance Sheet called Inventory Value (or Raw Materials and Finished Products).

The inventory component in the above calculation is the Cost of Goods Sold.    This is not the total cost of all the components that go into making your product – only the cost of the components for the items you sold, which is transferred from the total (Inventory Value) when you sell it.

For any of you who are not following me… the good news is that QuickBooks automatically does all of that for you IF you use QuickBooks properly.

There are two important parts in QuickBooks to set up properly:   the Items & Services (or Products & Services in QBO) and your Chart of Accounts.  The best QuickBooks software for handling Inventory and Assemblies is QuickBooks Premier and QuickBooks Enterprise.   You can track inventory in both QuickBooks Pro and QuickBooks Online, but not Inventory Assemblies (two or more components you assemble to sell).

You need to set up an item for each component you purchase that goes into the finished product.   In QuickBooks Desktop, you want to make sure that you set them up as double-sided Inventory Parts with the Purchase side pointing to the correct COGS account the the Sales side to the proper Income account.

Inventory Part in QuickBooks Desktop Versions

Inventory Part in QuickBooks Desktop Versions

Inventory Part QBO

Inventory Part QBO

In QuickBooks Desktop, there are 12 different Item Types you can set up so it’s important to know how each one works.  Inventory Parts and Inventory Assemblies are the only types that have a count associated with them.

Non Inventory Parts can be used to track inventory COGS… BUT you need to make sure to check the box to make it a “double-sided” item.

Non Inventory Parts

Non Inventory Parts

Important Things to Know about Inventory

  • You need to physically count your inventory at least once at year at the end of your fiscal year.
  • You need to account for any changes in inventory including sales, returns, damaged goods, donated items, items pulled for personal use and spoilage.   There is a procedure for handling each of these in QuickBooks.
  • Inventory management is the process of efficiently overseeing and recording the constant flow of units and dollars into (purchasing, assembly, stocking and returned goods) and out of (sales, invoicing, donations) existing inventory.
  • QuickBooks uses Cost Averaging to determine the value of your inventory unless you purchase additional inventory modules (Premier & Enterprise).

Inventory can be easily managed in QuickBooks, including direct labor costs, landed costs and other components of your true Cost of Goods.  If you are not managing your inventory properly in QuickBooks, please get training on how to do so – the result could be tax saving and profitable!

Credit Card Transactions

If your company uses credit cards to make purchases,  learning how to use the QuickBooks credit card feature is easy and effective.

I have heard all kinds of other ways credit card purchases have been entered such as using Bill Pay, Write Checks, or Journal Entries.  Don’t use these methods!   Here is why you should use the credit card feature:

  • A liability is created and appears on the Balance Sheet until you pay it.  This accurately reflects what actually happens.
  • The purchase date and the date you pay the credit card bill are different – you can log them both using the credit card feature.
  • Reconciling the credit card statement is a good thing.   Just like reconciling a bank statement – it catches errors, and allows you to enter interest income or finance charges.
  • Can be used effectively for employee or owner reimbursable expenses.
  • It is much easier to track expenditures if you have more than one credit card.

Here is the basic procedure for setting up and using the Credit Card feature.

1.  Create a Credit Card account by selecting New in the Chart of Accounts, then Credit Card as the type, in either QBO (QuickBooks Online) or Desktop versions.

2013Pro;COA;Credit Card

2.  Name the Credit Card and enter any opening balance and the date from the credit card statement you are going to start with.   I usually recommend starting with a new year if possible but any month is okay.

2013Pro;COA;Credit Card Opening Balance3.  Once a credit card account is set up, QuickBooks adds an icon in the Banking area of the Home Page called “Enter Credit Card Charges”.   This is almost identical to the Write Check feature, but you choose the credit card you used rather than a bank.  By using this window, you are capturing the real vendor and can charge the correct expense account, item account and even make it a billable charge similar to the write checks).

2013Pro;Credit Cards;Homepage

4.  These charges go into a liability account on the balance sheet until the credit card bill is paid, which can either be done through write check or through the reconcile account.

5.  When you receive the monthly credit card statement, you use the Reconcile window, just like you would a bank statement, only you choose the appropriate credit card.    This way you ensure all the charges on the statement are correct, and you can enter any finance charges at that time.

2013Pro;CreditCards;Reconcile

QuickBooks is often Underutilized and Misunderstood

QuickBooks is a powerful tool.    Used properly, it can not only track your income and purchases for easier tax preparation, but it can help you make better business decisions through the understanding of financial reports to grow your company more quickly.   These reports are based on the invoicing and purchasing transactions that are entered through the Chart of Accounts via the Items & Services (Products & Services online).

While most QuickBooks users figure out how to enter invoices and expenses, many struggle with utilizing the features and understanding the basic functions, that can most help them save time and frustration.  Some of the most common underutilized and misunderstood features include

  • Credit Card Transactions
  • Inventory Management
  • Financial Reports
  • Sales Tax Managementquestion mark
  • Third-Party Merchants (PayPal, Square, etc.)
  • Two-sided Inventory Items (pointing to an Expense and an Income account)

My first few posts will be dedicated to answering questions regarding these features.