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