My understanding of QQube current behavior is that when you select the financial summary subject it runs the trial balance report in QuickBooks and retrieves the result and that this report is run based on the general preference in the QuickBooks file of Cash or Accrual.
We are currently using this report as a sanity check against the General Ledger subject - for example it has already allowed us to catch files which need to be rebuilt and that has fixed problems instead of waiting for the customer to find a report to be wrong.
The problem is that the General Ledger subject is inherently accrual, but the customer may want their QuickBooks to produce Cash by default.
It would be nice if in the QQube configuration we could specify Cash or Accrual explicitly. I assume you would also want a Default option of however QuickBooks is configured as well.
Related to this, it would be nice if in the vd_Company view it would state which one was used. It currently tells you the date range, but not the detail of whether the report ran as Cash or Accrual.
Thank you for this suggestion.
Just to clarify, the only subjects available for either cash or accrual are the financial summary subjects.
We do not have the ability for cash basis on any detail subject.
The only place this preference is currently available is in our Lookup Subject for Data Entry Preferences. The field is called "Summary Reports Basis".
I would also like to see this as an option and not based on QB preference.
Choose a location