Knowledgebase: Tutorials
[QODBC-Online] How to run a Trial Balance Report in QODBC Online
Posted by Jack - QODBC Support on 24 November 2015 11:30 AM

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:


Trail Balance Report (for any Period)

     You can also extract a Trail Balance for any period like 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 TrialBalance report



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


(0 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).