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 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

Which Invoices Are Open? When Are They Due?

Ask the Accountant… Question: How can I find out which invoices are open and when they are due? Answer: In QuickBooks Premier, go to: “Reports” > “Customers and Receivables” > “A/R Aging Detail” This report will list all of your open invoices and their due dates. It will also “age” the invoices, showing how long…

Read More

Which QuickBooks Edition Is Right for You?

Ask the Accountant… Question: I am downloading QuickBooks Premier. Which edition do I pick? Answer: QB Premier has multiple editions built into it. You purchase QB Premier, but select the edition when you are downloading the software. For our industry, choose the Manufacturing and Wholesale Edition. It best suits our business needs, and has a…

Read More