QuickBooks DESKTOP - Generating Tables For Profit & Loss Report

[intapiuser]

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.

This documentation describes how to generate an RSD file for another connector.

To generate the RSD use the following query and make sure you enter your own date ranges.

You can use the "as of" syntax described in the CData documentation.

EXEC CreateReportSchema
@ReportName = 'ProfitAndLossDetail',
@ReportType = 'PROFITANDLOSSDETAIL',
@IncludeColumns = 'ACCOUNT,NAME,DATE, AMOUNT, DEBIT, CREDIT',
@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.