A typical Trial Balance Report looks like this:

With QODBC the same report can be generated using stored procedure reports like this:
sp_report TrialBalance show Debit_1_Title as Date, Label as Account, Debit_1 as Debit, Credit_1 as Credit parameters DateMacro = 'LastMonth', ReportBasis = 'Accrual'

Some QuickBooks users prefer to see the actual Account Number and Account Name:
sp_report TrialBalance show Debit_1_Title as Date, AccountNumber, AccountName, Debit_1 as Debit, Credit_1 as Credit parameters DateMacro = 'LastMonth', ReportBasis = 'Accrual'
All the predefined DateMacro options available to you are: |All|Today|ThisWeek|ThisWeekToDate|ThisMonth|ThisMonthToDate|ThisQuarter|ThisQuarterToDate |ThisYear|ThisYearToDate|Yesterday|LastWeek|LastWeekToDate|LastMonth|LastMonthToDate|LastQuarter |LastQuarterToDate|LastYear|LastYearToDate|NextWeek|NextFourWeeks|NextMonth|NextQuarter|NextYear|

However, you can also extract a Trail Balance for any period like this:
For October, 2007:
sp_report TrialBalance show Debit_1_Title as Date, AccountNumber, AccountName, Debit_1 as Debit, Credit_1 as Credit parameters DateFrom = {d'2007-10-01'}, DateTo= {d'2007-10-31'}, ReportBasis = 'Accrual'

For September, 2007:
sp_report TrialBalance show Debit_1_Title as Date, AccountNumber, AccountName, Debit_1 as Debit, Credit_1 as Credit parameters DateFrom = {d'2007-09-01'}, DateTo= {d'2007-09-30'}, ReportBasis = 'Accrual'
 |