Typical Trial Balance Report in QuickBooks Online

Report Displayed in QODBC

Stored Procedure Command

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

     sp_report TrialBalance show RowData as Account, Amount_1 as Debit, Amount_2 as Credit
     parameters DateMacro = 'LastMonth', ReportBasis = 'Accrual'

Display in QODBC

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|

Trail Balance Report (for any Period)

     You can also extract a Trail Balance for any period like the one below (take October 2015 as an example):

Stored Procedure Command

     sp_report TrialBalance show Debit_1_Title as Date, AccountNumber, AccountName, Debit_1 as Debit, Credit_1 as Credit
     parameters DateFrom = {d'2015-10-01'}, DateTo= {d'2015-10-31'}, ReportBasis = 'Accrual'

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 the TrialBalance report

Tags: QuickBooks Online, QBO, QODBC Online, report, Trial balance, sp_report