REPORTS (sp_reports)
QB REPORT NAME
QB CATEGORY
SP_REPORT NAME
COLUMNS
PARAMETERS
SQL
A/P Aging Detail
VENDORS & PAYABLES
APAgingDetail
Columns
Parameters
Example
A/P Aging Summary
VENDORS & PAYABLES
APAgingSummary
Columns
Parameters
Example
A/R Aging Summary
CUSTOMERS & RECEIVABLES
ARAgingSummary
Columns
Parameters
Example
ARAgingDetail
CUSTOMERS & RECEIVABLES
ARAgingDetail
Columns
Parameters
Example
Audit Trail
ACCOUNTANT & TAXES
AuditTrail
Columns
Parameters
Example
Balance Sheet Detail
COMPANY & FINANCIAL
BalanceSheetDetail
Columns
Parameters
Example
Balance Sheet Prev Year Comparison
COMPANY & FINANCIAL
BalanceSheetPrevYearComp
Columns
Parameters
Example
Balance Sheet Standard
COMPANY & FINANCIAL
BalanceSheetStandard
Columns
Parameters
Example
Balance Sheet Summary
COMPANY & FINANCIAL
BalanceSheetSummary
Columns
Parameters
Example
Budget Overview (Bal Sheet)
BUDGETS & FORECASTS
BalanceSheetBudgetOverview
Columns
Parameters
Example
Budget Overview (P&L)
BUDGETS & FORECASTS
ProfitAndLossBudgetOverview
Columns
Parameters
Example
Budget vs. Actual (Bal Sheet)
BUDGETS & FORECASTS
BalanceSheetBudgetvsActual
Columns
Parameters
Example
Budget vs. Actual (P&L)
BUDGETS & FORECASTS
ProfitAndLossBudgetVsActual
Columns
Parameters
Example
Check Detail
BANKING
CheckDetail
Columns
Parameters
Example
Collections Report
CUSTOMERS & RECEIVABLES
CollectionsReport
Columns
Parameters
Example
Custom Summary
CUSTOM/TRANSACTION
CustomSummary
Columns
Parameters
Example
Custom Txn Detail
CUSTOM/TRANSACTION
CustomTxnDetail
Columns
Parameters
Example
Customer Balance Detail
CUSTOMERS & RECEIVABLES
CustomerBalanceDetail
Columns
Parameters
Example
Customer Balance Summary
CUSTOMERS & RECEIVABLES
CustomerBalanceSummary
Columns
Parameters
Example
Deposit Detail
BANKING
DepositDetail
Columns
Parameters
Example
Detail 1099
VENDORS & PAYABLES
Detail1099
Columns
Parameters
Example
Employee Earnings Summary
EMPLOYEES & PAYROLL
EmployeeEarningsSummary
Columns
Parameters
Example
Employee State Taxes Detail
EMPLOYEES & PAYROLL
EmployeeStateTaxesDetail
Columns
Parameters
Example
Estimates By Job
JOBS & TIME
EstimatesByJob
Columns
Parameters
Example
Expense By Vendor Detail
COMPANY & FINANCIAL
ExpenseByVendorDetail
Columns
Parameters
Example
Expense By Vendor Summary
COMPANY & FINANCIAL
ExpenseByVendorSummary
Columns
Parameters
Example
General Ledger
ACCOUNTANT & TAXES
GeneralLedger
Columns
Parameters
Example
Income By Customer Detail
COMPANY & FINANCIAL
IncomeByCustomerDetail
Columns
Parameters
Example
Income By Customer Summary
COMPANY & FINANCIAL
IncomeByCustomerSummary
Columns
Parameters
Example
Income Tax Detail
ACCOUNTANT & TAXES
IncomeTaxDetail
Columns
Parameters
Example
Income Tax Summary
ACCOUNTANT & TAXES
IncomeTaxSummary
Columns
Parameters
Example
Inventory Stock Status By Item
INVENTORY
InventoryStockStatusByItem
Columns
Parameters
Example
Inventory Stock Status By Vendor
INVENTORY
InventoryStockStatusByVendor
Columns
Parameters
Example
Inventory Valuation Detail
INVENTORY
InventoryValuationDetail
Columns
Parameters
Example
Inventory Valuation Summary
INVENTORY
InventoryValuationSummary
Columns
Parameters
Example
Item Estimates Vs Actuals
JOBS & TIME
ItemEstimatesVsActuals
Columns
Parameters
Example
Item Profitability
JOBS & TIME
ItemProfitability
Columns
Parameters
Example
Job Estimates Vs Actuals Detail
JOBS & TIME
JobEstimatesVsActualsDetail
Columns
Parameters
Example
Job Estimates Vs Actuals Summary
JOBS & TIME
JobEstimatesVsActualsSummary
Columns
Parameters
Example
Job Profitability Detail
JOBS & TIME
JobProfitabilityDetail
Columns
Parameters
Example
Job Profitability Summary
JOBS & TIME
JobProfitabilitySummary
Columns
Parameters
Example
Job Progress Invoices Vs Estimates
JOBS & TIME
JobProgressInvoicesVsEstimates
Columns
Parameters
Example
Journal
ACCOUNTANT & TAXES
Journal
Columns
Parameters
Example
Missing Checks
BANKING
MissingChecks
Columns
Parameters
Example
Open Invoices
CUSTOMERS & RECEIVABLES
OpenInvoices
Columns
Parameters
Example
Open Pos
PURCHASES
OpenPOs
Columns
Parameters
Example
Open POs By Job
JOBS & TIME
OpenPOsByJob
Columns
Parameters
Example
Open POs By Job
PURCHASES
OpenPOsByJob
Columns
Parameters
Example
Payroll Item Detail
EMPLOYEES & PAYROLL
PayrollItemDetail
Columns
Parameters
Example
Payroll Liability Balances
EMPLOYEES & PAYROLL
PayrollLiabilityBalances
Columns
Parameters
Example
Payroll Review Detail
EMPLOYEES & PAYROLL
PayrollReviewDetail
Columns
Parameters
Example
Payroll Summary
EMPLOYEES & PAYROLL
PayrollSummary
Columns
Parameters
Example
Payroll Transaction Detail
EMPLOYEES & PAYROLL
PayrollTransactionDetail
Columns
Parameters
Example
Payroll Transactions By Payee
EMPLOYEES & PAYROLL
PayrollTransactionsByPayee
Columns
Parameters
Example
Pending Sales
SALES
PendingSales
Columns
Parameters
Example
Physical Inventory Worksheet
INVENTORY
PhysicalInventoryWorksheet
Columns
Parameters
Example
Profit & Loss Budget Performance
BUDGETS & FORECASTS
ProfitAndLossBudgetPerformance
Columns
Parameters
Example
Profit And Loss By Class
COMPANY & FINANCIAL
ProfitAndLossByClass
Columns
Parameters
Example
Profit And Loss By Job
COMPANY & FINANCIAL
ProfitAndLossByJob
Columns
Parameters
Example
Profit And Loss By Job
JOBS & TIME
ProfitAndLossByJob
Columns
Parameters
Example
Profit And Loss Detail
COMPANY & FINANCIAL
ProfitAndLossDetail
Columns
Parameters
Example
Profit And Loss Prev Year Comp
COMPANY & FINANCIAL
ProfitAndLossPrevYearComp
Columns
Parameters
Example
Profit And Loss Standard
COMPANY & FINANCIAL
ProfitAndLossStandard
Columns
Parameters
Example
Profit And Loss YTD Comp
COMPANY & FINANCIAL
ProfitAndLossYTDComp
Columns
Parameters
Example
Purchase By Item Detail
PURCHASES
PurchaseByItemDetail
Columns
Parameters
Example
Purchase By Item Summary
PURCHASES
PurchaseByItemSummary
Columns
Parameters
Example
Purchase By Vendor Detail
PURCHASES
PurchaseByVendorDetail
Columns
Parameters
Example
Purchase By Vendor Summary
PURCHASES
PurchaseByVendorSummary
Columns
Parameters
Example
Sales By Customer Detail
SALES
SalesByCustomerDetail
Columns
Parameters
Example
Sales By Customer Summary
SALES
SalesByCustomerSummary
Columns
Parameters
Example
Sales By Item Detail
SALES
SalesByItemDetail
Columns
Parameters
Example
Sales By Item Summary
SALES
SalesByItemSummary
Columns
Parameters
Example
Sales By Rep Detail
SALES
SalesByRepDetail
Columns
Parameters
Example
Sales By Rep Summary
SALES
SalesByRepSummary
Columns
Parameters
Example
Sales Tax Liability
VENDORS & PAYABLES
SalesTaxLiability
Columns
Parameters
Example
Sales Tax Revenue Summary
VENDORS & PAYABLES
SalesTaxRevenueSummary
Columns
Parameters
Example
Time By Item
JOBS & TIME
TimeByItem
Columns
Parameters
Example
Time By Job Detail
JOBS & TIME
TimeByJobDetail
Columns
Parameters
Example
Time By Job Summary
JOBS & TIME
TimeByJobSummary
Columns
Parameters
Example
Time By Name
JOBS & TIME
TimeByName
Columns
Parameters
Example
Trial Balance
ACCOUNTANT & TAXES
TrialBalance
Columns
Parameters
Example
Txn Detail By Account
ACCOUNTANT & TAXES
TxnDetailByAccount
Columns
Parameters
Example
Txn List By Customer
CUSTOMERS & RECEIVABLES
TxnListByCustomer
Columns
Parameters
Example
Txn List By Date
ACCOUNTANT & TAXES
TxnListByDate
Columns
Parameters
Example
Txn List By Vendor
VENDORS & PAYABLES
TxnListByVendor
Columns
Parameters
Example
Unbilled Costs By Job
CUSTOMERS & RECEIVABLES
UnbilledCostsByJob
Columns
Parameters
Example
Unpaid Bills Detail
VENDORS & PAYABLES
UnpaidBillsDetail
Columns
Parameters
Example
Vendor Balance Detail
VENDORS & PAYABLES
VendorBalanceDetail
Columns
Parameters
Example
Vendor Balance Summary
VENDORS & PAYABLES
VendorBalanceSummary
Columns
Parameters
Example