QuickBooks: Query a report — trialbalance query Variant0 Fr — request body — query

API reference · Contract 2026-10-20

SDK schema: Query a report — trialbalance query Variant0 Fr — request body — query

Field	Type	Presence	Description and constraints
$	object	Root	Additional keys: not allowed
accounting_method	string	Optional	The accounting method used in the report. Supported Values: Cash , Accrual
date_macro	string	Optional	Predefined date range. Use if you want the report to cover a standard report date range; otherwise, use the start_date and end_date to cover an explicit report date range. Supported Values: Today, Yesterday, This Week, Last Week, This Week-to-date, Last Week-to-date, Next Week, Next 4 Weeks, This Month, Last Month, This Month-to-date, Last Month-to-date, Next Month, This Fiscal Quarter, Last Fiscal Quarter, This Fiscal Quarter-to-date, Last Fiscal Quarter-to-date, Next Fiscal Quarter, This Fiscal Year, Last Fiscal Year, This Fiscal Year-to-date, Last Fiscal Year-to-date, Next Fiscal Year
end_date	string	Optional	The end date of the report, in the format YYYY-MM-DD . start_date must be less than end_date . Use if you want the report to cover an explicit date range; otherwise, use date_macro to cover a standard report date range. If not specified value of date_macro is used
sort_order	string	Optional	The sort order. Supported Values: ascend , descend
start_date	string	Optional	The start date of the report, in the format YYYY-MM-DD . start_date must be less than end_date . Use if you want the report to cover an explicit date range; otherwise, use date_macro to cover a standard report date range. If not specified value of date_macro is used
summarize_column_by	string	Optional	The criteria by which to group the report results. Supported Values: Total, Month, Week, Days, Quarter, Year, Customers, Vendors, Classes, Departments, Employees, ProductsAndServices
minorversion	integer	Optional	Must equal: 75
requestid	string	Optional	Minimum length: 1