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

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

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

Finding the Right Credit Cards to Pay Suppliers and Maximize Points

Ask the Accountant… Question: How do you suggest I research credit cards to pay my suppliers and get points? Answer: Credit card points are a nice perk for our industry, but you should only use credit cards for this purpose if you pay the complete balance off each and every month. If you don’t plan…

Read More

When QuickBooks Enterprise is Overkill for Your Business

Ask the Accountant… Question: I have a Promotional Products business using QuickBooks Enterprise. Our business has changed, and QuickBooks Enterprise is overkill for us now. Can we convert from Enterprise to Premier? Answer: QuickBooks makes it easy to convert from Premier to Enterprise (a more expensive product), but not convert from Enterprise to Premier. I…

Read More

Who Do I Call With QuickBooks Problems?

Ask the Accountant… Question: What numbers do I call if I have a problem with QuickBooks? Answer: Let me introduce you to www.softwarediscountcenter.com. In addition to being a quality reseller of QB products, they also have a help desk. Click the “Help” tab Select “Support and Training.” Here there are numbers to contact QB. Let…

Read More