REPORTS (sp_reports)
QB REPORT NAME QB CATEGORY SP_REPORT NAME COLUMNS PARAMETERS EXAMPLE
Vendors & Payables->A/P Aging DetailVendors & PayablesAPAgingDetailColumns Parameters Example
Vendors & Payables->A/P Aging SummaryVendors & PayablesAPAgingSummaryColumns Parameters Example
Customers & Receivables->A/R Aging DetailCustomers & ReceivablesARAgingDetailColumns Parameters Example
Customers & Receivables->A/R Aging SummaryCustomers & ReceivablesARAgingSummaryColumns Parameters Example
Accountant & Taxes->Audit TrailAccounting & TaxesAuditTrailColumns Parameters Example
Budgets->Budget OverviewBudgetsBalanceSheetBudgetOverviewColumns Parameters Example
Budgets->Budget vs. ActualBudgetsBalanceSheetBudgetVsActualColumns Parameters Example
Company & Finanical->Balance Sheet ByClassCompany & FinancialBalanceSheetByClassColumns Parameters Example
Company & Finanical->Balance Sheet DetailCompany & FinancialBalanceSheetDetailColumns Parameters Example
Company & Finanical->Balance Sheet Prev Year ComparisonCompany & FinancialBalanceSheetPrevYearCompColumns Parameters Example
Company & Finanical->Balance Sheet StandardCompany & FinancialBalanceSheetStandardColumns Parameters Example
Company & Finanical->Balance Sheet SummaryCompany & FinancialBalanceSheetSummaryColumns Parameters Example
Banking->Check DetailBankingCheckDetailColumns Parameters Example
Customers & Receivables->Collections ReportCustomers & ReceivablesCollectionsReportColumns Parameters Example
Customers & Receivables->Customer Balance DetailCustomers & ReceivablesCustomerBalanceDetailColumns Parameters Example
Customers & Receivables->Customer Balance SummaryCustomers & ReceivablesCustomerBalanceSummaryColumns Parameters Example
Custom Summary Report->Custom Summary ReportTransactionsCustomSummaryColumns Parameters Example
Custom Transaction Detail Report->Custom Transaction Detail ReportTransactionsCustomTxnDetailColumns Parameters Example
Banking->Deposit DetailBankingDepositDetailColumns Parameters Example
Vendors & Payables->1099 DetailVendors & PayablesDetail1099Columns Parameters Example
Employees & Payroll->Employee Earnings SummaryEmployees & PayrollEmployeeEarningsSummaryColumns Parameters Example
Employees & Payroll->Employee State Taxes DetailEmployees & PayrollEmployeeStateTaxesDetailColumns Parameters Example
Jobs, Time & Mileage->Estimates by JobJobs, Time & MileageEstimatesByJobColumns Parameters Example
Company & Finanical->Expenses by Vendor DetailCompany & FinancialExpenseByVendorDetailColumns Parameters Example
Company & Finanical->Expense by Vendor SummaryCompany & FinancialExpenseByVendorSummaryColumns Parameters Example
Accountant & Taxes->General LedgerAccounting & TaxesGeneralLedgerColumns Parameters Example
Company & Finanical->Income by Customer DetailCompany & FinancialIncomeByCustomerDetailColumns Parameters Example
Company & Finanical->Income by Customer SummaryCompany & FinancialIncomeByCustomerSummaryColumns Parameters Example
Accountant & Taxes->Income Tax DetailAccounting & TaxesIncomeTaxDetailColumns Parameters Example
Accountant & Taxes->Income Tax SummaryAccounting & TaxesIncomeTaxSummaryColumns Parameters Example
Inventory->Inventory Stock Status by ItemInventoryInventoryStockStatusByItemColumns Parameters Example
Inventory->Inventory Stock Status by VendorInventoryInventoryStockStatusByVendorColumns Parameters Example
Inventory->Inventory Valuation DetailInventoryInventoryValuationDetailColumns Parameters Example
Inventory->Inventory Valuation SummaryInventoryInventoryValuationSummaryColumns Parameters Example
Inventory->Inventory Valuation Summary By SiteInventoryInventoryValuationSummaryBySiteColumns Parameters Example
Jobs, Time & Mileage->Item Estimates vs. ActualsJobs, Time & MileageItemEstimatesVsActualsColumns Parameters Example
Jobs, Time & Mileage->Item ProfitabilityJobs, Time & MileageItemProfitabilityColumns Parameters Example
Jobs, Time & Mileage->Job Estimates vs. Actuals DetailJobs, Time & MileageJobEstimatesVsActualsDetailColumns Parameters Example
Jobs, Time & Mileage->Job Estimates vs. Actuals SummaryJobs, Time & MileageJobEstimatesVsActualsSummaryColumns Parameters Example
Jobs, Time & Mileage->Job Profitability DetailJobs, Time & MileageJobProfitabilityDetailColumns Parameters Example
Jobs, Time & Mileage->Job Profitability SummaryJobs, Time & MileageJobProfitabilitySummaryColumns Parameters Example
Jobs, Time & Mileage->Job Progress Invoices vs. EstimatesJobs, Time & MileageJobProgressInvoicesVsEstimatesColumns Parameters Example
Accountant & Taxes->JournalAccounting & TaxesJournalColumns Parameters Example
Inventory->Inventory LotNumberInventoryLotNumberInStockBySiteColumns Parameters Example
Banking->Missing ChecksBankingMissingChecksColumns Parameters Example
Customers & Receivables->Open InvoicesCustomers & ReceivablesOpenInvoicesColumns Parameters Example
Purchases->Open Purchase OrdersPurchasesOpenPOsColumns Parameters Example
Jobs, Time & Mileage->Open Purchase Orders by JobJobs, Time & MileageOpenPOsByJobColumns Parameters Example
Customers & Receivables->OpenSales Order By CustomerCustomers & ReceivablesOpenSalesOrderByCustomerColumns Parameters Example
Customers & Receivables->OpenSales Order By ItemCustomers & ReceivablesOpenSalesOrderByItemColumns Parameters Example
Employees & Payroll->Payroll Item DetailEmployees & PayrollPayrollItemDetailColumns Parameters Example
Employees & Payroll->Payroll Liability BalancesEmployees & PayrollPayrollLiabilityBalancesColumns Parameters Example
Employees & Payroll->Payroll Review DetailEmployees & PayrollPayrollReviewDetailColumns Parameters Example
Employees & Payroll->Payroll SummaryEmployees & PayrollPayrollSummaryColumns Parameters Example
Employees & Payroll->Payroll Transaction DetailEmployees & PayrollPayrollTransactionDetailColumns Parameters Example
Employees & Payroll->Payroll Transactions by PayeeEmployees & PayrollPayrollTransactionsByPayeeColumns Parameters Example
Sales->Pending SalesSalesPendingSalesColumns Parameters Example
Inventory->Physical Inventory WorksheetInventoryPhysicalInventoryWorksheetColumns Parameters Example
Budgets->Budget OverviewBudgetsProfitAndLossBudgetOverviewColumns Parameters Example
Budgets->Profit & Loss Budget PerformanceBudgetsProfitAndLossBudgetPerformanceColumns Parameters Example
Budgets->Budget vs. ActualBudgetsProfitAndLossBudgetVsActualColumns Parameters Example
Company & Finanical->Profit & Loss by ClassCompany & FinancialProfitAndLossByClassColumns Parameters Example
Company & Finanical->Profit & Loss by JobCompany & FinancialProfitAndLossByJobColumns Parameters Example
Company & Finanical->Profit & Loss DetailCompany & FinancialProfitAndLossDetailColumns Parameters Example
Company & Finanical->Profit & Loss Prev Year ComparisonCompany & FinancialProfitAndLossPrevYearCompColumns Parameters Example
Company & Finanical->Profit & Loss StandardCompany & FinancialProfitAndLossStandardColumns Parameters Example
Company & Finanical->Profit & Loss YTD ComparisonCompany & FinancialProfitAndLossYTDCompColumns Parameters Example
Purchases->Purchase by Item DetailPurchasesPurchaseByItemDetailColumns Parameters Example
Purchases->Purchase by Item SummaryPurchasesPurchaseByItemSummaryColumns Parameters Example
Purchases->Purchase by Vendor DetailPurchasesPurchaseByVendorDetailColumns Parameters Example
Purchases->Purchase by Vendor SummaryPurchasesPurchaseByVendorSummaryColumns Parameters Example
Sales->Sales by Customer DetailSalesSalesByCustomerDetailColumns Parameters Example
Sales->Sales by Customer SummarySalesSalesByCustomerSummaryColumns Parameters Example
Sales->Sales by Item DetailSalesSalesByItemDetailColumns Parameters Example
Sales->Sales by Item SummarySalesSalesByItemSummaryColumns Parameters Example
Sales->Sales by Rep DetailSalesSalesByRepDetailColumns Parameters Example
Sales->Sales by Rep SummarySalesSalesByRepSummaryColumns Parameters Example
Vendors & Payables->Sales Tax LiabilityVendors & PayablesSalesTaxLiabilityColumns Parameters Example
Vendors & Payables->Sales Tax Revenue SummaryVendors & PayablesSalesTaxRevenueSummaryColumns Parameters Example
Inventory->Inventory SerialNumberInventorySerialNumberInStockBySiteColumns Parameters Example
Jobs, Time & Mileage->Time by ItemJobs, Time & MileageTimeByItemColumns Parameters Example
Jobs, Time & Mileage->Time by Job DetailJobs, Time & MileageTimeByJobDetailColumns Parameters Example
Jobs, Time & Mileage->Time by Job SummaryJobs, Time & MileageTimeByJobSummaryColumns Parameters Example
Jobs, Time & Mileage->Time by NameJobs, Time & MileageTimeByNameColumns Parameters Example
Accountant & Taxes->Trial BalanceAccounting & TaxesTrialBalanceColumns Parameters Example
Accountant & Taxes->Transaction Detail by AccountAccounting & TaxesTxnDetailByAccountColumns Parameters Example
Customers & Receivables->Transaction List by CustomerCustomers & ReceivablesTxnListByCustomerColumns Parameters Example
Accountant & Taxes->Transaction List by DateAccounting & TaxesTxnListByDateColumns Parameters Example
Vendors & Payables->Transaction List by VendorVendors & PayablesTxnListByVendorColumns Parameters Example
Customers & Receivables->Unbilled Costs by JobCustomers & ReceivablesUnbilledCostsByJobColumns Parameters Example
Vendors & Payables->UnpaidBillsDetailVendors & PayablesUnpaidBillsDetailColumns Parameters Example
Vendors & Payables->Vendor Balance DetailVendors & PayablesVendorBalanceDetailColumns Parameters Example
Vendors & Payables->Vendor Balance SummaryVendors & PayablesVendorBalanceSummaryColumns Parameters Example