Skip to main content

I created a Power BI data model using the QuickBooks Online connector and successfully built some basic reports. However, I noticed that certain transactions are missing from the data. I queried all available tables but couldn’t locate these transactions. Interestingly, when I used the 'TransactionsList' stored procedure, I was able to retrieve all transactions, including the missing ones.

I suspect that some transaction types, such as Payroll Checks, may not be accessible through the CData connector or Intuit Accounting API. Has anyone else encountered this issue? Is there a known limitation or a workaround to include these transaction types in the data model?

Hi ​@Shakil,

Based on your description it sounds like you are looking for a table that would return Payroll Checks transactions directly. If that is the case you will not be able to accomplish that unfortunately, as your assumption is correct. Indeed, the Accounting API does not support this and since our connector is build upon the API we do not support a way to retrieve those transactions either. You can read more here:

https://help.developer.intuit.com/s/question/0D54R00009NYXC3SAP/how-can-we-access-payroll-checks-via-the-api

On the other hand, the TransactionListReport is a view that is created by making use of the CreateTransactionListReport stored procedure which is based on the reporting endpoint and allows you to get a list of all the transactions. The supported transaction types are defined in the help docs section: https://cdn.cdata.com/help/RNK/ado/pg_sp-createtransactionlistreport.htm

In case you are missing any other transactions apart from Payroll Checks, kindly provide more information on those. Feel free to reach out to our support team at [email protected] if you have any other questions or if you need further instance with our products.


Thanks for the reply.