In order to generate a profit and loss report from the QuickBooks Desktop Connector, you will need the following tables.
- 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.
@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.
Please sign in to leave a comment.