Knowledgebase: Sp_commands & Reports
[QODBC-Desktop] How to run a Trial Balance Report in QODBC
Posted by brad waddell on 12 March 2009 05:21 PM

Typical Trial Balance Report in QuickBooks

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 Debit_1_Title as Date, Label as Account, Debit_1 as Debit, Credit_1 as Credit
     parameters DateMacro = 'LastMonth', ReportBasis = 'Accrual'

Display in QODBC

Trial Balance Report (with Actual Account NO and Name)

     Some QuickBooks users prefer to see the actual Account Number and Account Name:

Stored Procedure Command

     sp_report TrialBalance show Debit_1_Title as Date, AccountNumber, AccountName, Debit_1 as Debit, Credit_1 as Credit
     parameters DateMacro = 'LastMonth', ReportBasis = 'Accrual'

Predefined DateMacro Options

     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|

Display in QODBC

Trial Balance Report (for any Period)

     You can also extract a Trail Balance for any period like below (take October 2007 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'2007-10-01'}, DateTo= {d'2007-10-31'}, ReportBasis = 'Accrual'

Display in QODBC

     Another example for September 2007:

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'2007-09-01'}, DateTo= {d'2007-09-30'}, ReportBasis = 'Accrual'

Display in QODBC

(285 vote(s))
Helpful
Not helpful

Comments (4)
Ralph Wahlert
11 June 2014 01:47 PM
This was very helpful in determining how I can get data out.
Jack
07 July 2014 12:26 PM
Hi Ralph,

I would like to suggest you to please refer below mentioned article for exporting report in MS Excel:

http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2405/57/how-to-create-sp_reports-using-microsoft-excel-2007
AW FRance
06 November 2015 04:00 PM
Hello,
How to run a Trial Balance Report in QODBC with class?
Thank you
Jack
07 November 2015 07:24 AM
Hi,

You can use TrialBalance report parameter & filter data by class.

For Example:
sp_report TrialBalance parameters DateMacro='LastMonth', ClassFilterFullNames='Automatic Pool Systems'

For multiple class filter:
sp_report TrialBalance parameters DateMacro='LastMonth', ClassFilterFullNames='Automatic Pool Systems','Manual Pool Systems',’etc’

If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

I kindly request you to share more information about the issue you’re facing, so that we can locate the problem quickly.

We may need following information, I kindly request you to attach below listed files when replying to the ticket.

1) Screenshot of QODBC Setup Screen -- > About (Start>>All Programs>> QODBC Driver for use with QuickBooks>> QODBC Setup Screen >> About Tab )
2) Screenshot of the issue you’re facing.
3) Share the SQL statement you’re using.
Share Entire Log Files as an attachment in text format from
4) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
5) QODBC Setup Screen -- > Messages -- > Review SDK Messages
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).