Mapping Customer Names Into QuickBooks From Excel

Ask the Accountant… Question: I have been trying to load customers into QB Premier from an Excel file, but I keep getting error messages about duplicates. How can I fix that? Answer: Here’s the fix: QB Premier runs on lists. Once you enter data into lists, you can use that list entry over and over…

Read More

QuickBooks Online Might Not Be For You

Ask the Accountant… Question: I was talking to someone at QuickBooks. They told me to try QuickBooks Online, and if I didn’t like it, it is very easy to switch back to QB Premier. Is that true? Answer: No, that is not true at all. QB is pushing QuickBooks Online (QBO) heavily. Its subscription income…

Read More

Six Sheets to Look at for Novice Bookkeepers in QuickBooks

Ask the Accountant… Question: I have someone doing my bookkeeping, but I really don’t know anything about QuickBooks. What reports should I look at every month? Answer: There are six reports that provide a practical overview of your business. First, create, or have your bookkeeper create: 1. The balance sheet 2. The profit and loss statement…

Read More

How To Use Two Item Numbers in QuickBooks

Ask the Accountant… Question: I use two item numbers for my distributorship—one is the item number I assign internally and show the customer, and the other is the supplier’s number. Can I use both in QuickBooks? Answer: Yes, QB Premier and Enterprise allow for two different fields of item numbers. When you set up an…

Read More

Do You Need to Collect Sales Tax In Other States?

Ask the Accountant… Question: I have sales in several states. Do I have to collect sales tax in states other than my own? Answer: Sales tax has always been a complicated issue, and it was made infinitely more complicated by the Supreme Court ruling in South Dakota v. Wayfair in 2018. The decision means that…

Read More

Do You Know Where Your Order History Is?

Ask the Accountant… Question: Do You Know Where Your Order History Is? Answer: I have been working with OrderMaster users recently, because this software system is no longer supported by the manufacturer and the software is crashing. Hundreds of distributors have been using OM for as long as 20 years. It is now failing because…

Read More