REPORTS (sp_reports)
QB REPORT NAME | QB CATEGORY | SP_REPORT NAME | COLUMNS | PARAMETERS | EXAMPLE |
---|---|---|---|---|---|
Vendors & Payables->A/P Aging Detail | Vendors & Payables | APAgingDetail | Columns | Parameters | Example |
Vendors & Payables->A/P Aging Summary | Vendors & Payables | APAgingSummary | Columns | Parameters | Example |
Customers & Receivables->A/R Aging Detail | Customers & Receivables | ARAgingDetail | Columns | Parameters | Example |
Customers & Receivables->A/R Aging Summary | Customers & Receivables | ARAgingSummary | Columns | Parameters | Example |
Accountant & Taxes->Audit Trail | Accounting & Taxes | AuditTrail | Columns | Parameters | Example |
Budgets->Budget Overview | Budgets | BalanceSheetBudgetOverview | Columns | Parameters | Example |
Budgets->Budget vs. Actual | Budgets | BalanceSheetBudgetVsActual | Columns | Parameters | Example |
Company & Finanical->Balance Sheet ByClass | Company & Financial | BalanceSheetByClass | Columns | Parameters | Example |
Company & Finanical->Balance Sheet Detail | Company & Financial | BalanceSheetDetail | Columns | Parameters | Example |
Company & Finanical->Balance Sheet Prev Year Comparison | Company & Financial | BalanceSheetPrevYearComp | Columns | Parameters | Example |
Company & Finanical->Balance Sheet Standard | Company & Financial | BalanceSheetStandard | Columns | Parameters | Example |
Company & Finanical->Balance Sheet Summary | Company & Financial | BalanceSheetSummary | Columns | Parameters | Example |
Banking->Check Detail | Banking | CheckDetail | Columns | Parameters | Example |
Customers & Receivables->Collections Report | Customers & Receivables | CollectionsReport | Columns | Parameters | Example |
Customers & Receivables->Customer Balance Detail | Customers & Receivables | CustomerBalanceDetail | Columns | Parameters | Example |
Customers & Receivables->Customer Balance Summary | Customers & Receivables | CustomerBalanceSummary | Columns | Parameters | Example |
Custom Summary Report->Custom Summary Report | Transactions | CustomSummary | Columns | Parameters | Example |
Custom Transaction Detail Report->Custom Transaction Detail Report | Transactions | CustomTxnDetail | Columns | Parameters | Example |
Banking->Deposit Detail | Banking | DepositDetail | Columns | Parameters | Example |
Vendors & Payables->1099 Detail | Vendors & Payables | Detail1099 | Columns | Parameters | Example |
Employees & Payroll->Employee Earnings Summary | Employees & Payroll | EmployeeEarningsSummary | Columns | Parameters | Example |
Employees & Payroll->Employee State Taxes Detail | Employees & Payroll | EmployeeStateTaxesDetail | Columns | Parameters | Example |
Jobs, Time & Mileage->Estimates by Job | Jobs, Time & Mileage | EstimatesByJob | Columns | Parameters | Example |
Company & Finanical->Expenses by Vendor Detail | Company & Financial | ExpenseByVendorDetail | Columns | Parameters | Example |
Company & Finanical->Expense by Vendor Summary | Company & Financial | ExpenseByVendorSummary | Columns | Parameters | Example |
Accountant & Taxes->General Ledger | Accounting & Taxes | GeneralLedger | Columns | Parameters | Example |
Company & Finanical->Income by Customer Detail | Company & Financial | IncomeByCustomerDetail | Columns | Parameters | Example |
Company & Finanical->Income by Customer Summary | Company & Financial | IncomeByCustomerSummary | Columns | Parameters | Example |
Accountant & Taxes->Income Tax Detail | Accounting & Taxes | IncomeTaxDetail | Columns | Parameters | Example |
Accountant & Taxes->Income Tax Summary | Accounting & Taxes | IncomeTaxSummary | Columns | Parameters | Example |
Inventory->Inventory Stock Status by Item | Inventory | InventoryStockStatusByItem | Columns | Parameters | Example |
Inventory->Inventory Stock Status by Vendor | Inventory | InventoryStockStatusByVendor | Columns | Parameters | Example |
Inventory->Inventory Valuation Detail | Inventory | InventoryValuationDetail | Columns | Parameters | Example |
Inventory->Inventory Valuation Summary | Inventory | InventoryValuationSummary | Columns | Parameters | Example |
Inventory->Inventory Valuation Summary By Site | Inventory | InventoryValuationSummaryBySite | Columns | Parameters | Example |
Jobs, Time & Mileage->Item Estimates vs. Actuals | Jobs, Time & Mileage | ItemEstimatesVsActuals | Columns | Parameters | Example |
Jobs, Time & Mileage->Item Profitability | Jobs, Time & Mileage | ItemProfitability | Columns | Parameters | Example |
Jobs, Time & Mileage->Job Estimates vs. Actuals Detail | Jobs, Time & Mileage | JobEstimatesVsActualsDetail | Columns | Parameters | Example |
Jobs, Time & Mileage->Job Estimates vs. Actuals Summary | Jobs, Time & Mileage | JobEstimatesVsActualsSummary | Columns | Parameters | Example |
Jobs, Time & Mileage->Job Profitability Detail | Jobs, Time & Mileage | JobProfitabilityDetail | Columns | Parameters | Example |
Jobs, Time & Mileage->Job Profitability Summary | Jobs, Time & Mileage | JobProfitabilitySummary | Columns | Parameters | Example |
Jobs, Time & Mileage->Job Progress Invoices vs. Estimates | Jobs, Time & Mileage | JobProgressInvoicesVsEstimates | Columns | Parameters | Example |
Accountant & Taxes->Journal | Accounting & Taxes | Journal | Columns | Parameters | Example |
Inventory->Inventory LotNumber | Inventory | LotNumberInStockBySite | Columns | Parameters | Example |
Banking->Missing Checks | Banking | MissingChecks | Columns | Parameters | Example |
Customers & Receivables->Open Invoices | Customers & Receivables | OpenInvoices | Columns | Parameters | Example |
Purchases->Open Purchase Orders | Purchases | OpenPOs | Columns | Parameters | Example |
Jobs, Time & Mileage->Open Purchase Orders by Job | Jobs, Time & Mileage | OpenPOsByJob | Columns | Parameters | Example |
Customers & Receivables->OpenSales Order By Customer | Customers & Receivables | OpenSalesOrderByCustomer | Columns | Parameters | Example |
Customers & Receivables->OpenSales Order By Item | Customers & Receivables | OpenSalesOrderByItem | Columns | Parameters | Example |
Employees & Payroll->Payroll Item Detail | Employees & Payroll | PayrollItemDetail | Columns | Parameters | Example |
Employees & Payroll->Payroll Liability Balances | Employees & Payroll | PayrollLiabilityBalances | Columns | Parameters | Example |
Employees & Payroll->Payroll Review Detail | Employees & Payroll | PayrollReviewDetail | Columns | Parameters | Example |
Employees & Payroll->Payroll Summary | Employees & Payroll | PayrollSummary | Columns | Parameters | Example |
Employees & Payroll->Payroll Transaction Detail | Employees & Payroll | PayrollTransactionDetail | Columns | Parameters | Example |
Employees & Payroll->Payroll Transactions by Payee | Employees & Payroll | PayrollTransactionsByPayee | Columns | Parameters | Example |
Sales->Pending Sales | Sales | PendingSales | Columns | Parameters | Example |
Inventory->Physical Inventory Worksheet | Inventory | PhysicalInventoryWorksheet | Columns | Parameters | Example |
Budgets->Budget Overview | Budgets | ProfitAndLossBudgetOverview | Columns | Parameters | Example |
Budgets->Profit & Loss Budget Performance | Budgets | ProfitAndLossBudgetPerformance | Columns | Parameters | Example |
Budgets->Budget vs. Actual | Budgets | ProfitAndLossBudgetVsActual | Columns | Parameters | Example |
Company & Finanical->Profit & Loss by Class | Company & Financial | ProfitAndLossByClass | Columns | Parameters | Example |
Company & Finanical->Profit & Loss by Job | Company & Financial | ProfitAndLossByJob | Columns | Parameters | Example |
Company & Finanical->Profit & Loss Detail | Company & Financial | ProfitAndLossDetail | Columns | Parameters | Example |
Company & Finanical->Profit & Loss Prev Year Comparison | Company & Financial | ProfitAndLossPrevYearComp | Columns | Parameters | Example |
Company & Finanical->Profit & Loss Standard | Company & Financial | ProfitAndLossStandard | Columns | Parameters | Example |
Company & Finanical->Profit & Loss YTD Comparison | Company & Financial | ProfitAndLossYTDComp | Columns | Parameters | Example |
Purchases->Purchase by Item Detail | Purchases | PurchaseByItemDetail | Columns | Parameters | Example |
Purchases->Purchase by Item Summary | Purchases | PurchaseByItemSummary | Columns | Parameters | Example |
Purchases->Purchase by Vendor Detail | Purchases | PurchaseByVendorDetail | Columns | Parameters | Example |
Purchases->Purchase by Vendor Summary | Purchases | PurchaseByVendorSummary | Columns | Parameters | Example |
Sales->Sales by Customer Detail | Sales | SalesByCustomerDetail | Columns | Parameters | Example |
Sales->Sales by Customer Summary | Sales | SalesByCustomerSummary | Columns | Parameters | Example |
Sales->Sales by Item Detail | Sales | SalesByItemDetail | Columns | Parameters | Example |
Sales->Sales by Item Summary | Sales | SalesByItemSummary | Columns | Parameters | Example |
Sales->Sales by Rep Detail | Sales | SalesByRepDetail | Columns | Parameters | Example |
Sales->Sales by Rep Summary | Sales | SalesByRepSummary | Columns | Parameters | Example |
Vendors & Payables->Sales Tax Liability | Vendors & Payables | SalesTaxLiability | Columns | Parameters | Example |
Vendors & Payables->Sales Tax Revenue Summary | Vendors & Payables | SalesTaxRevenueSummary | Columns | Parameters | Example |
Inventory->Inventory SerialNumber | Inventory | SerialNumberInStockBySite | Columns | Parameters | Example |
Jobs, Time & Mileage->Time by Item | Jobs, Time & Mileage | TimeByItem | Columns | Parameters | Example |
Jobs, Time & Mileage->Time by Job Detail | Jobs, Time & Mileage | TimeByJobDetail | Columns | Parameters | Example |
Jobs, Time & Mileage->Time by Job Summary | Jobs, Time & Mileage | TimeByJobSummary | Columns | Parameters | Example |
Jobs, Time & Mileage->Time by Name | Jobs, Time & Mileage | TimeByName | Columns | Parameters | Example |
Accountant & Taxes->Trial Balance | Accounting & Taxes | TrialBalance | Columns | Parameters | Example |
Accountant & Taxes->Transaction Detail by Account | Accounting & Taxes | TxnDetailByAccount | Columns | Parameters | Example |
Customers & Receivables->Transaction List by Customer | Customers & Receivables | TxnListByCustomer | Columns | Parameters | Example |
Accountant & Taxes->Transaction List by Date | Accounting & Taxes | TxnListByDate | Columns | Parameters | Example |
Vendors & Payables->Transaction List by Vendor | Vendors & Payables | TxnListByVendor | Columns | Parameters | Example |
Customers & Receivables->Unbilled Costs by Job | Customers & Receivables | UnbilledCostsByJob | Columns | Parameters | Example |
Vendors & Payables->UnpaidBillsDetail | Vendors & Payables | UnpaidBillsDetail | Columns | Parameters | Example |
Vendors & Payables->Vendor Balance Detail | Vendors & Payables | VendorBalanceDetail | Columns | Parameters | Example |
Vendors & Payables->Vendor Balance Summary | Vendors & Payables | VendorBalanceSummary | Columns | Parameters | Example |