Is your Item setting skewing your QuickBooks reports?

By Anne Coles

Troubleshooting item problems in QuickBooks can be a challenge because setup issues (i.e. using a single-sided item) don't stand out on the income statement. Often the only indicator that there is a problem is that the income is either grossly over- or under-stated.

A single-sided item has only one box to choose an account. You can tell which item is single-sided because the "This service is used in assemblies or is performed by a subcontractor or partner" box is not checked. When the box is not checked (i.e. a single-sided item), QuickBooks uses the account selected for all transactions, whether income or purchase.

A double-sided item is one that is set up with both a Cost of Goods Sold (COGS)/Expense account AND an income account. When a double-sided item is used, QuickBooks is smart enough to use the COGS/Expense account on a purchase transaction, and an income account on a sales transaction.

Reports are skewed when a single-sided item is used because all transactions go to the same account. All the sales transactions may hit an income account, but all the purchase transactions hit the same account, so reported income is really low. Alternately, all the purchase transactions will hit an expense account, but the sales transactions will too, often making the expense account negative.

QuickBooks makes it easy to track down items that are not set up properly. Follow these steps to make sure that your item setup is not skewing your reports.

  1. From the home screen, click Items and Services. This brings up your item list.
  2. Right-click anywhere on the screen and click "Customize columns."
  3. Add the COGS account and move it up under the Account column.
  4. Any blank in the COGS account column means that the item was set up as a single-sided item (the sub-contractor box not checked) and is a likely culprit. You can also see each item's assigned accounts and quickly note which ones are not the same (i.e. the wrong income account).
  5. Double-click into the items that are not set up properly, check the "This service is used in assemblies..." box, and then add the correct COGS or expense account. Insure that an income account is used on the Income Account side.
  6. When you click OK, QuickBooks will ask you if you want to update all transactions. If you say yes, you will affect all transactions that used this item, so be very careful. Say no if you do not want to affect prior periods. You can't split the transactions and affect current year only.
  7. To affect current year only, you'll have to create a new item with the correct COGS and Income account, change current transactions to use the new item, and inactivate the old one. Add the words DO NOT USE to the old item so it is clearly marked.

Regularly scan the item list, especially if there is more than one person entering items into your QuickBooks file, to make sure that all items are being set up double-sided.

About the author
Anne Coles is an Advanced Certified QuickBooks ProAdvisor, an Enterprise Certified QuickBooks ProAdvisor, and is the president of The Wren Group, Inc.

You may like these other stories...

By Jason Bramwell San Francisco–based online accounting software provider Xero launched a free conversion platform on October 8 that will enable small businesses to migrate their Intuit QuickBooks data into Xero...
By Michael Callan, CPA, cofounder of Swizznet It wasn't that long ago that small and medium-size business (SMB) accounting software resided on a PC – and only on a PC. Today, with more than 1.3...
By Stacy KildalSo you have a client that wants to make the jump from QuickBooks Pro, Premier, Mac, or Enterprise? This is indeed exciting news, and I shall happily guide you through this process. Come with me, and let's...

Upcoming CPE Webinars

Jul 31
In this session Excel expert David Ringstrom helps beginners get up to speed in Microsoft Excel. However, even experienced Excel users will learn some new tricks, particularly when David discusses under-utilized aspects of Excel.
Aug 5
This webcast will focus on accounting and disclosure policies for various types of consolidations and business combinations.
Aug 20
In this session we'll review best practices for how to generate interest in your firm’s services.
Aug 21
Meet budgets and client expectations using project management skills geared toward the unique challenges faced by CPAs. Kristen Rampe will share how knowing the keys to structuring and executing a successful project can make the difference between success and repeated failures.