Troubleshooting - "Transactions" table, but they don't appear to "balance."

Problem Description:

I am attempting to extract data from a client's hosted QuickBooks Enterprise system. I need every transaction in the system as we are transitioning to a different approach. I have removed all of the records from the "Transactions" table, but they don't appear as a "balance." I think the amount column should net to zero, as the credits (negative) Amount should be offset against the debits (positive) amounts.

Solution:

In the Transaction table, the total of Credit (negative) will not match the sum of Debit because the transaction table has additional rows for the subtotal.

You have to exclude all such records/rows having AccountRefListID/AccountRefFullName as empty. You can exclude blank AccountRefListID/AccountRefFullName by clicking the column filter, unchecking "Blanks," & click "OK."

You may also have to format the Amount column to Number (show two decimal values) to avoid any round-off issues in Excel.

You can format cells by right-clicking on the "Amount" column & click "Format Cells."

After applying the above changes, you will notice that the Amount appears in balance.