How to repair QuickBooks data files with Negative Quantity on Hand

Negative Quantity on Hand (QOH) or Negative Inventory in a QuickBooks data file is caused when you sell items you do not have in stock i.e. by entering sales transactions before entering purchase transactions. This results in the Quantity on Hand being negative when you sell the item. Even if the corresponding purchase transactions are… read more »

How to convert your Xero online data to QuickBooks

When converting a company file from Xero to QuickBooks Online, the first thing to decide is whether the historical transactions will be part of the new file and if so, how far back to go with them. It is certainly convenient to have historical transactions in the file in case a question comes up, rather… read more »

How to convert from Microsoft Great Plains to QuickBooks

As per Intuit QuickBooks, there isn’t a way to import “All Transactions” from Microsoft Great Plains or Dynamics into QuickBooks Online. Transactions would have to be entered manually using different file formats since the QuickBooks Online platform is different from Microsoft Dynamics. You’ll need to identify the transaction type and the file format to ensure that QuickBooks Online will be… read more »

How to Convert From NetSuite to QuickBooks

Converting from NetSuite to QuickBooks can be a cumbersome process. Although it is possible to download all the files from NetSuite and then re-upload them to QuickBooks, this can cause the issue of missing or double counting data, which requires tedious manual entries to fix. This being said, however, they both represent the data in… read more »

How to convert an AccountEdge datafile to QuickBooks

Migrating from one accounting package to another can be a daunting process. These procedures are very time consuming and will have you switching back and forth between exporting, tweaking what has been exported, importing into QuickBooks, and re-tweaking what has been imported. Miss a step and you might find yourself starting over. Getting assistance from… read more »

How to remove the audit trail from a QuickBooks data file

A slow and unresponsive QuickBooks file is usually because it has grown very large. One of the main reasons that file sizes grow large is the Audit Trail function in QuickBooks, which tracks all transactions, modifications, and deletions. You can increase the file performance by clearing the data in the audit trail file when it… read more »

Intuit launching an Uber for Bookkeeping?

QuickBooks has recently started a test on their main pricing page to gauge interest in bookkeeping services. It is a high likelihood that Intuit may be offering bookkeeping services as an add-on to a QuickBooks subscription in the near future. According to the new feature, potential clients would be able to access a live bookkeeper… read more »

How to merge multiple QuickBooks data files with Classes

QuickBooks does not have an in-built functionality to merge QuickBooks data files together. In fact, it is quite a challenging task because QuickBooks has very strict rules for names i.e. a Customer name in one file cannot be the same as a Vendor name in another file. Perhaps, the biggest issue in merging file is… read more »

How to convert QuickBooks Canada to QuickBooks UK

There could be several reasons why switching from one QuickBooks nationality to the other would be required. Sometimes it could be because businesses have operations in different countries or sometimes it simply is because the bookkeeper chose to use that particular version of QuickBooks. One common issue that businesses with operations in different countries face… read more »

How to Optimize a QuickBooks file size for improved speed and performance

QuickBooks data files larger than 1 GB need to be optimized every 6-12 months to ensure they run at peak performance. The computer system contains a lot of files and each file has a specific location and function. When QuickBooks fails to function properly, a message saying ‘QuickBooks is unable to start’ or ‘QuickBooks slow… read more »