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…
Read More
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…
Read More
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…
Read More
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…
Read More
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…
Read More
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…
Read More
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…
Read More
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…
Read More
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.…
Read More
Question: I have a vendor who has become a customer. QuickBooks will not let me use the same name. What do I do? Answer: You can use a variation of the name, such as “ABC Company” for the customer and “ABC Company Inc.” for the vendor. Alternatively, you can do something as simple as adding…
Read More