QuickBooks: Query a report — profitandlossdetail query — response body

API reference · Contract 2026-10-20

SDK schema: Query a report — profitandlossdetail query — response body

Field	Type	Presence	Description and constraints
$	object	Root	Additional keys: allowed
account	string	Optional	(source_account_type) Filters report contents to include information for specified accounts. Supported Values: One or more comma separated account IDs as returned in the attribute, Account.Id , of the Account object response code.
account_type	string	Optional	Account type from which transactions are included in the report. Supported Values: AccountsPayable , AccountsReceivable , Bank , CostOfGoodsSold , CreditCard , Equity , Expense , FixedAsset , Income , LongTermLiability , NonPosting , OtherAsset , OtherCurrentAsset , OtherCurrentLiability , OtherExpense , OtherIncome
accounting_method	string	Optional	The accounting method used in the report. Supported Values: Cash , Accrual
adjusted_gain_loss	string	Optional	Specifies whether unrealized gain and losses are included in the report. Supported Values: true , false
class	string	Optional	Filters report contents to include information for specified classes if so configured in the company file. Supported Values: One or more comma separated class IDs as returned in the attribute, Class.Id , of the Class entity response code.
columns	string	Optional	Column types to be shown in the report. Supported Values: create_by, create_date, doc_num*, last_mod_by, last_mod_date, memo*, name*, pmt_mthd, split_acc*, tx_date*, txn_type* Additional columns with tax enabled: tax_code Additional columns with class tracking enabled: klass_name* Additional columns with location tracking enabled: dept_name* Multicurrency is enabled for the company if Preferences.MultiCurrencyEnabled is set to true . Read more about multicurrency support here . NonTracking status is enabled for the company if CompanyInfo.NameValue.Name.NonTracking is set to true . Currently enabled for Canadian company, other locales can be added in the future.
customer	string	Optional	Filters report contents to include information for specified customers. Supported Values: One or more comma separated customer IDs as returned in the attribute, Customer.Id , of the Customer object response code.
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
department	string	Optional	Filters report contents to include information for specified departments if so configured in the company file. Supported Values: One or more comma separated department IDs as returned in the attribute, Department.Id of the Department object response code.
employee	string	Optional	Filters report contents to include information for specified employees. Supported Values: One or more comma separated account IDs as returned in the attribute, Employee.Id , of the Employee entity response code.
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
payment_method	string	Optional	Filters report contents based on payment method. Supported Values: Cash , Check , Dinners Club , American Express , Discover , MasterCard , Visa
sort_by	string	Optional	The column type used in sorting report rows. Specify a column type as defined with the columns query parameter.
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
vendor	string	Optional	Filters report contents to include information for specified vendors. Supported Values: One or more comma separated vendor IDs as returned in the attribute, Vendor.Id , of the Vendor object response code.