One of the frustrating quirks of QuickBooks reporting, is that if you ran any report, and pulled in the fields "Paid" or "Open Balance", you won't get what you expect. And it appears that there is no particular logic to the results.
Additionally, the Intuit SDK (Software Development Kit) is missing some of the transaction links that we would need to reverse engineer A/R or A/P from the raw data. Granted the missing transaction links were rare types, such as journal entry to journal entry, but nevertheless possible within a QuickBooks file.
So suffice it to say that QQube was missing a few items, and to compound it, we did not have consistent or congruent rules.
So, in QQube 7.1, we set out to provide four things:
It is important to note that the signage rules have changed from previous versions. Previously Document Amounts for Credit Memos and Vendor Credits were reversed sign. This has now changed to the following consistent rules:
There are also some changes from previous versions with regard to signage, but the current rules are consistent, and congruent across all detail analytics.
NOTE: There is one thing you can do in QQube, that you couldn't do before: You can now choose Line Open Amounts in the General Ledger Detail Analytic, filtering for either A/R or A/P account(s) and match to QB Open A/R or A/P reports (for all dates) respectively.
Here is an example of a few types of transactions and various open and paid lines, and applied and open document amounts:
We now address transactions that could appear in A/R or A/P, but were not handled correctly in earlier versions of QQube:
The rules for this date is as follows:
We now address transactions (as listed under Fully Paid Dates above) that have no due date in the SDK, but could appear in A/R or A/P - and were not handled correctly in earlier versions of QQube.
One more reason why QQube is still the most complete and comprehensive data warehouse on the market.
Go here for more information on the QQube Version 7.1 release