Knowledgebase
[QODBC-Desktop] Troubleshooting - "Transactions" table, but they don't appear to "balance"
Posted by Jack - QODBC Support on 06 July 2017 12:22 PM

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 "balance." I think the amount column should net to zero - as the credits (negative) Amount should earn against the debits (positive) amounts.

 

Solution:

In the Transaction table - the total of Credit (negative) will not match he 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 have to also format the Amount column to Number (show two decimal values) to avoid any round-off issue 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.

 

 

(1 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).