Harriet Gatter

Harriet Gatter
Adding Data to Stock Reports

Question: Is there a way to add data to stock reports in QuickBooks? Answer: QuickBooks Premier and Enterprise allow a great deal of customization of its reports, but sometimes you will want to add, rearrange or manipulate data beyond the scope allowed in QuickBooks. In that case, you can export that QuickBooks report to an…

Making Default Templates

Question: How do I make a template in QuickBooks to be the default template for sales orders, purchase orders or invoices? Answer: QuickBooks Premier and Enterprise do not have a means to designate a “default” template, but there is a workaround to achieve the same result. Go to "Lists" and then "Templates." The list shows…

Why Use QuickBooks Over Other Software?

Question: My accountant wants me to start using QuickBooks Premier instead of industry software. Why? Answer: As described in another blog, QuickBooks Premier works very well for our industry, but your accountant may or may not know that. Likely, your accountant knows how to work within QuickBooks since it is the No. 1 accounting software…

Don't Do Unnecessary Work

Question: In QuickBooks, I prefer to set up items as categories, such as apparel or pens, and type in the individual descriptions. Is there any reason not to do it that way? I feel like I'm going to end up with too many items otherwise. Answer: I can understand why you might want to do…

Setting Up Non-Inventory Items

Question: I have my non-inventory items set up in QuickBooks, but I don't see anything in my cost of goods sold account, and my sales numbers seem very low. Why is that? Answer: Chances are you don't have your non-inventory items set up correctly. This is a common error for our industry, and one of…

Correctly Updating QuickBooks

Question: I am using an older version of QuickBooks and want to upgrade to the current year. What should I do to prepare for this? Answer: First of all, back up your current QuickBooks file. Then, run your balance sheet, and profit and loss (income) statements on both the accrual and cash bases for the…

Combining Duplicate Customers in Quickbooks

Question: I have created a duplicate customer in QuickBooks that has a slightly different name. How do I combine them into one customer account? Answer: Go to "customers" > "customer center." Highlight the customer name you want to change, right click on it and click "Edit Customer: Job." Change the customer name to match the…

'Knowing QuickBooks' Isn't Enough

Question: I am interviewing a bookkeeper who is familiar with QuickBooks. Is that all I need to know? Answer: No! Setting aside the issues of the complexity of a bookkeeper's former experience, which is the subject of another blog, you need to know more about which QuickBooks this person has used in the past. QuickBooks…

Organizing by Class

Question: Is there a way to view my profit by type of customer? Answer: QuickBooks has a function within it to allow segmenting your business in reports. It is called "classes." You can create a set of classes, which you enter into QuickBooks and apply to customers, vendors or other categories. For instance, you can…

Trust Your Instincts

Question: I called Intuit/QuickBooks support and was told something that I know is not the way we do business. How can that happen? Answer: We have a complex and unique business. We do not fit typical business models, and it is confusing to many bookkeepers, CPA's and, yes, even QuickBooks support on occasion. Recently, a…

Inventory Versus Non-inventory Parts

Question: In QuickBooks, do I set up my items as “non-inventory part” or “inventory part?” Answer: Most always, ad specialty transactions are of the “non-inventory part” variety. The items ordered are customized to our clients' specifications—drop shipped directly to them, and we, the distributor, do not take physical possession. And in QuickBooks, these transactions are…

Intuit Merchant Services Versus Bill&Pay

Question: I want to be able to invoice and receive payments electronically from clients and have them entered automatically in QuickBooks. What are my options? Answer: Currently, the best two options you have are Intuit Merchant Services and a service that integrates with QuickBooks called "Bill&Pay." Intuit Merchant Services, being a QuickBooks service, is the…

Save Time When Making Sales Tax Changes

Question: I need to change sales tax settings for a large number of my customers. Do I need to go into each customer to make the changes? Answer: No, fortunately! QuickBooks has a wonderful feature to save you time with that chore. Go to “Lists”>”Add/Edit Multiple List Entries”>”Select Customers” from the dropdown box at the…

Simplify Your File Search

Instead of a question today, I'm going to pass along a tip from a client. I’m always interested in new ideas to simplify the accounting, bookkeeping and order management systems for ad specialty distributors. And recently, my client, Bruce Cunningham of Great Ideas in Santa Fe, N.M., shared an idea that reduces paper usage and…

What Do You Know About Buying Groups?

Question: What do you know about buying groups? Answer: There are variations of buying groups in our industry—from a couple of distributors banding together loosely to companies that offer other services and approaches. To answer this question fully, I went to Jamie Coggeshall, president of AIMastermind (AIM), a group that purely is a buying group.…