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:

|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 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))
Helpful
Not helpful

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