Knowledgebase: QODBC Online
[QODBC-Online] How to run a Balance Sheet Detail Report in QODBC Online
Posted by Jack - QODBC Support on 27 November 2015 11:12 AM

Typical Balance Sheet Report in QuickBooks Online

Report Displayed in QODBC Online

Stored Procedure Command

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

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

Predefined DateMacro Options

     All the predefined DateMacro options available to you are:


Display in QODBC

      sp_report BalanceSheetDetail show RowData, Amount_1 as Jan16,Amount_2 as Feb16, Amount_3 as March16      parameters DateMacro = 'ThisYearToDate', SummarizeColumnsBy = 'Month' where RowType='DataRow'

Display in QODBC


Also, Refer

How to use the QuickBooks Reporting Engine with QODBC Online

List of Reports available in QODBC Online

List of Parameters available in BalanceSheetDetail report



Tags: QuickBooks Online, QBO, QODBC Online, report, Balance sheet


(1 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).