Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
In order to generate a profit and loss report from the QuickBooks Desktop Connector, you will need the following tables.
  • Account
  • Custom Profit & Loss Detail
The Account table is a standard table available with the CData connector, while the custom table requires a custom stored procedure run to create the RSD schema file Sisense can use to generate a table.
To generate the RSD use the following query and make sure you enter your own date ranges.
EXEC CreateReportSchema
@ReportName = 'ProfitAndLossDetail',
@DetailLevel = 'ALL',
@ReportPeriod = 'YYYY-MM-DD:YYYY-MM-DD'; 
Use the account numbers from the account tables to group the various line items found in the custom table.
Version history
Last update:
‎02-15-2024 02:36 PM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: