Typical Profit and Loss Standard Report in QuickBooks Online

Report Displayed in QODBC

Stored Procedure Command

       With QODBC Online, the same report can be generated using stored procedure reports like this:

       sp_report ProfitAndLossStandard show RowData, Amount_1 as Amount
       parameters DateMacro = 'ThisYearToDate'

Predefined DateMacro Options

      All the predefined DateMacro options available to you are:

|All|Today|Yesterday|ThisWeek|ThisWeekToDate|LastWeek|LastWeekToDate|NextWeek|NextFourWeeks
|ThisMonth|ThisMonthToDate|LastMonth|LastMonthToDate|NextMonth|ThisQuarter|ThisQuarterToDate|LastQuarter
|LastQuarterToDate|NextQuarter|ThisYear|ThisYearToDate|LastYear|LastYearToDate|NextYear|

Display in QODBC

Change report to use "Cash" reporting

Stored Procedure Command

      To change these reports to use "Cash" reporting, add the ReportBasis parameter:

      sp_report ProfitAndLossStandard show RowData, Amount_1 as Amount
      parameters DateMacro = 'ThisYearToDate', ReportBasis='Cash'

ReportBasis Options

      The options are: |Cash|Accrual|None|

Typical Profit and Loss Detail Report in QuickBooks Online

Report Displayed in QODBC

Stored Procedure Command

       With QODBC Online, the same report can be generated using stored procedure reports like this:

       sp_report ProfitAndLossDetail show RowData, TransactionType, DocumentNumber, Name, Memo, Split, Amount, Balance
       parameters DateMacro = 'ThisYearToDate'

Predefined DateMacro Options

      All the predefined DateMacro options available to you are:

|All|Today|Yesterday|ThisWeek|ThisWeekToDate|LastWeek|LastWeekToDate|NextWeek|NextFourWeeks
|ThisMonth|ThisMonthToDate|LastMonth|LastMonthToDate|NextMonth|ThisQuarter|ThisQuarterToDate|LastQuarter
|LastQuarterToDate|NextQuarter|ThisYear|ThisYearToDate|LastYear|LastYearToDate|NextYear|

Display in QODBC

Change report to use "Cash" reporting

Stored Procedure Command

      To change these reports to use "Cash" reporting, add the ReportBasis parameter:

      sp_report ProfitAndLossDetail show RowData, TransactionType, DocumentNumber, Name, Memo, Split, Amount, Balance
      parameters DateMacro = 'ThisYearToDate', ReportBasis='Cash'

ReportBasis Options

      The options are: |Cash|Accrual|None| 

Also, Refer

How to use the QuickBooks Reporting Engine with QODBC Online

List of Reports available in QODBC Online

List of Parameters available in ProfitAndLossStandard report

List of Parameters available in ProfitAndLossDetail report

Tags: QuickBooks Online, QBO, QODBC Online, online report, Profit and loss report