Why Am I Getting Duplicate Customers When Integrating SAGE and QuickBooks?

Ask the Accountant… Question: I am integrating SAGE Online with QuickBooks Premier. I am getting duplicate customers and vendors. Why is that happening? Answer: When integrating two software packages, if any data in the receiving system is not identical to that being exported, it will be identified as a new and different entry. For instance,…

Read More

The Future of QuickBooks Desktop

Ask the Accountant… Question: I’ve heard rumors that QuickBooks Desktop is going away. Is that true? Answer: I’ve heard those rumors for years, but QB Desktop (Pro, Premier and Enterprise) is improved upon year-over-year, and appears to be here to stay. I recently attended a webinar by Joe Woodard about this very subject. He quoted…

Read More

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