BCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
---> Take Hector's QuickBooks Online - Custom Reports Master Class for $200
2
Report GroupReport Name (with Hyperlink)AdvancedPlusEssentials Simple StartDescriptionTo purchase my Google Chrome shortcuts that include all these reports, go to: https://hectorgarcia.teachable.com/p/qboshortcuts
Y= Available in the Reports Menu
N= Not Available, but can be accessed via the link
N/A = The feature is not included in the QBO version
Y* = Available when you turn on Payroll service
3
Business OverviewAudit LogYYYY
Shows everything that has happened in your company file so you always know who's been in QuickBooks and what they've done.
https://app.qbo.intuit.com/app/auditlog
4
Business OverviewBalance Sheet ComparisonYYYN
What you own (assets), what you owe (liabilities), and what you invested (equity) compared to last year.
https://app.qbo.intuit.com/app/reportv2?rptId=BAL_SHEET_COMP&
5
Business OverviewBalance Sheet DetailYYYY
A detailed view of what you own (assets), what you owe (liabilities), and what you invested (equity).
https://app.qbo.intuit.com/app/reportv2?rptId=BAL_SHEET_DET&
6
Business OverviewBalance Sheet SummaryYYYN
A summary of what you own (assets), what you owe (liabilities), and what you invested (equity).
https://app.qbo.intuit.com/app/reportv2?rptId=BAL_SHEET_SUM&
9
Business OverviewBalance SheetYYYYWhat you own (assets), what you owe (liabilities), and what you invested (equity).https://app.qbo.intuit.com/app/reportv2?rptId=BAL_SHEET&
10
Business OverviewBusiness SnapshotYYYNCharts and graphs of your income and expenses and how they've change over time.https://app.qbo.intuit.com/app/report?rptId=COMP_SNAPSHOT&
11
Business OverviewProfit and Loss as % of total incomeYYYYYour expenses as a percentage of your total income.https://app.qbo.intuit.com/app/reportv2?rptId=PANDL_PCT_TOT_INC&
12
Business OverviewProfit and Loss ComparisonYYYNYour income, expenses, and net income (profit or loss) compared to last year.https://app.qbo.intuit.com/app/reportv2?rptId=PANDL_COMP&
13
Business OverviewProfit and Loss DetailYYYN
A detailed view of your income, expenses, and net income (profit or loss). Shows individual transactions.
https://app.qbo.intuit.com/app/reportv2?rptId=PANDL_DET&
14
Business OverviewProfit and Loss year-to-date comparisonYYYYYour income, expenses, and net income (profit or loss) compared to this year so far.https://app.qbo.intuit.com/app/reportv2?rptId=PANDL_YTD_COMP&
16
Business OverviewProfit and Loss by CustomerYYYYYour income, expenses, and net income (profit or loss) by customer.https://app.qbo.intuit.com/app/reportv2?rptId=PANDL_BYCUST&
18
Business OverviewProfit and Loss by MonthYYYYYour income, expenses, and net income (profit or loss) by month.https://app.qbo.intuit.com/app/reportv2?rptId=PANDL_BY_MONTH&
19
Business OverviewProfit and Loss by Tag GroupYYYYYour income, expenses, and net income listed by tag group.https://app.qbo.intuit.com/app/reportv2?rptId=PANDL_BY_TAG_TYPE&
20
Business OverviewProfit and LossYYYYYour income, expenses, and net income (profit or loss). Also called an income statement.https://app.qbo.intuit.com/app/reportv2?rptId=PANDL&
21
Business OverviewQuarterly Profit and Loss SummaryYYYYA summary of your income, expenses, and net income (profit or loss) by quarter.https://app.qbo.intuit.com/app/reportv2?rptId=QRTR_PANDL&
22
Business OverviewStatement of Cash FlowsYYYY
Cash flowing in and out from sales and expenses (operating activities), investments, and financing.
https://app.qbo.intuit.com/app/reportv2?rptId=CASH_FLOW&
23
Who Owes YouAccounts receivable aging detailYYYNUnpaid invoices, grouped by days past due.https://app.qbo.intuit.com/app/reportv2?rptId=AR_AGING_DET&
24
Who Owes YouAccounts receivable aging summaryYYYYUnpaid balances for each customer, grouped by days past due.https://app.qbo.intuit.com/app/reportv2?rptId=AR_AGING&
25
Who Owes YouCollections ReportYYYYOverdue invoices with due dates, days past due, and totals for each customer.https://app.qbo.intuit.com/app/reportv2?rptId=COLLECTIONS&
26
Who Owes YouCustomer Balance DetailYYYNHow much each customer owes you. Shows individual invoices.https://app.qbo.intuit.com/app/reportv2?rptId=CUST_BAL_DET&
27
Who Owes YouCustomer Balance SummaryYYYYHow much each customer owes you.https://app.qbo.intuit.com/app/reportv2?rptId=CUST_BAL&
28
Who Owes YouInvoice ListYYYYYour invoices, ordered by date.https://app.qbo.intuit.com/app/reportv2?rptId=INVOICE_LIST&
29
Who Owes YouInvoices and Received PaymentsYYYYPayments you’ve received and the invoices that go with them.https://app.qbo.intuit.com/app/reportv2?rptId=INVOICE_PAYMENT&
30
Who Owes YouOpen InvoicesYYYYUnpaid invoices and statement charges, with totals for each customer.https://app.qbo.intuit.com/app/reportv2?rptId=OPEN_INVOICES&
31
Who Owes YouStatement ListYYYYYour statements, ordered by date.https://app.qbo.intuit.com/app/reportv2?rptId=STATEMENT_INVOICE&
32
Who Owes YouTerms ListYYYNYour terms for payment due dates and discounts for early payment.
https://app.qbo.intuit.com/app/reportv2?rptId=TERM_LIST&&orderby=OrderName
35
Sales and CustomersCustomer Contact ListYYYYPhone number, email, billing address, and other contact info for each customer.https://app.qbo.intuit.com/app/reportv2?rptId=CUST_CONTACT&
36
Sales and CustomersDeposit DetailYYYYYour deposits, with the date, customer or vendor, and amount.https://app.qbo.intuit.com/app/reportv2?rptId=DEPOSIT_DETAIL&
37
Sales and CustomersEstimates & Progress Invoicing Summary by CustomerYYYYEstimates by customer, invoiced amounts, and remaining amounts to invoice.
https://app.qbo.intuit.com/app/reportv2?token=CUSTOM_DETAIL_REPORT&SubToken=EST_VS_PI
38
Sales and CustomersEstimates by CustomerYYYYYour estimates, grouped by customer. Shows whether they're accepted and invoiced.https://app.qbo.intuit.com/app/reportv2?rptId=ESTIMATE_LIST&
39
Sales and CustomersIncome by Customer SummaryYYYNYour income minus your expenses (net income) for each customer.https://app.qbo.intuit.com/app/reportv2?rptId=CUST_INC&
42
Sales and CustomersPayment Method ListYYYNThe payment methods (cash, check, card, and so on) you accept from customers.
https://app.qbo.intuit.com/app/reportv2?rptId=PAYMENTMETHOD_LIST&&orderby=OrderName
44
Sales and CustomersProduct/Service ListYYYY
Your products and services, with the sales price, name, description, and (optionally) purchase cost and quantity on hand.
https://app.qbo.intuit.com/app/reportv2?rptId=ITEM_PRICE&
47
Sales and CustomersSales by Customer DetailYYYNYour sales, grouped by customer. Includes the date, type, amount, and total.https://app.qbo.intuit.com/app/reportv2?rptId=CUST_SALES_DET&
48
Sales and CustomersSales by Customer SummaryYYYYYour total sales for each customer.https://app.qbo.intuit.com/app/reportv2?rptId=CUST_SALES&
52
Sales and CustomersSales by Product/Service DetailYYYN
Your sales, grouped by product or service. Includes the date, transaction type, quantity, rate, amount, and total.
https://app.qbo.intuit.com/app/reportv2?rptId=ITEM_SALES_DET&
53
Sales and CustomersSales by Product/Service SummaryYYYY
Your total sales for each product or service. Includes the quantity, amount, % of sales, and average price.
https://app.qbo.intuit.com/app/reportv2?rptId=ITEM_SALES&
55
Sales and CustomersTransaction List by CustomerYYYNYour transactions (income and expenses), grouped by customer.https://app.qbo.intuit.com/app/reportv2?rptId=TX_LIST_BY_CUST&
56
Sales and CustomersTransaction List by Tag GroupYYYYYour tagged transactions (income and expenses), listed by tag group.https://app.qbo.intuit.com/app/reportv2?rptId=TX_LIST_BY_TAG_TYPE&
57
What you owe1099 Contractor Balance DetailYYNNLists all the bills that make up the total amount you owe each contractor (balance).
https://app.qbo.intuit.com/app/reportv2?token=CUSTOM_DETAIL_REPORT&SubToken=contractorBalanceDetail
58
What you owe1099 Contractor Balance SummaryYYNNShows the total amount you owe each contractor.
https://app.qbo.intuit.com/app/reportv2?token=CUSTOM_SUMMARY_REPORT&SubToken=contractorBalanceSummary
66
Expenses and vendors
1099 Transaction Detail ReportYYYYTransactions and total for each contractor and their account number, tax ID, with splits.
https://app.qbo.intuit.com/app/reportv2?token=CUSTOM_DETAIL_REPORT&SubToken=1099DetailReport
67
Expenses and vendors
Check DetailYYYYThe checks you've written, with the date, payee, and amount.https://app.qbo.intuit.com/app/reportv2?rptId=CHECK_DETAIL&
68
Expenses and vendors
Expenses by Vendor SummaryYYYNYour total expenses for each vendor.https://app.qbo.intuit.com/app/reportv2?rptId=VEND_EXP&
75
Expenses and vendors
Transaction List by VendorYYYYYour transactions, grouped by vendor.https://app.qbo.intuit.com/app/reportv2?rptId=TX_LIST_BY_VENDOR&
76
Expenses and vendors
Vendor Contact ListYYYY
Name, company, phone number, email, mailing address, and account number for each vendor.
https://app.qbo.intuit.com/app/reportv2?rptId=VEND_CONTACT&&list=Vendors&orderby=OrderName
77
Sales TaxSales Tax Liability ReportYYYYHow much sales tax you've collected and how much you owe to tax agencies.https://app.qbo.intuit.com/app/reportv2?rptId=INDIRECT_TAX_DET_AST
78
Sales TaxTaxable Sales DetailYYYY
Your sales of taxable products and services. Includes the date, transaction type, customer, quantity, rate, amount, and balance.
https://app.qbo.intuit.com/app/reportv2?rptId=TAXABLE_SALES_DET&
79
Sales TaxTaxable Sales SummaryYYYYYour total sales of taxable products and services.https://app.qbo.intuit.com/app/reportv2?rptId=TAXABLE_SALES&
80
EmployeesEmployee Contact ListYYYYList of all your employees with their phone numbers, email, and addresseshttps://app.qbo.intuit.com/app/reportv2?rptId=EMP_CONTACT&
83
For my AccountantAccount ListYYYYThe name, type, and balance for each account in your chart of accounts.
https://app.qbo.intuit.com/app/reportv2?rptId=ACCT_LIST&&orderby=$MACRO.ACCT_LIST_ORDERBY$
84
For my AccountantBalance Sheet ComparisonYYYY
What you own (assets), what you owe (liabilities), and what you invested (equity) compared to last year.
https://app.qbo.intuit.com/app/reportv2?rptId=BAL_SHEET_COMP&
85
For my AccountantBalance SheetYYYYWhat you own (assets), what you owe (liabilities), and what you invested (equity).https://app.qbo.intuit.com/app/reportv2?rptId=BAL_SHEET&
87
For my AccountantExceptions to Closing DateYYYYTransactions dated before the closing date that you changed after closing the books.https://app.qbo.intuit.com/app/audithistory?view=auditexception
88
For my AccountantGeneral LedgerYYYYThe beginning balance, transactions, and total for each account in your chart of accounts.https://app.qbo.intuit.com/app/reportv2?rptId=GEN_LEDGER&
89
For my AccountantJournalYYYYThe debits and credits for each transaction, listed by date.https://app.qbo.intuit.com/app/reportv2?rptId=JOURNAL&
91
For my AccountantProfit and Loss ComparisonYYYYYour income, expenses, and net income (profit or loss) compared to last year.https://app.qbo.intuit.com/app/reportv2?rptId=PANDL_COMP&
92
For my AccountantProfit and Loss by Tag GroupYYYYYour income, expenses, and net income listed by tag group.https://app.qbo.intuit.com/app/reportv2?rptId=PANDL_BY_TAG_TYPE&
93
For my AccountantProfit and LossYYYYYour income, expenses, and net income (profit or loss). Also called an income statement.https://app.qbo.intuit.com/app/reportv2?rptId=PANDL&
94
For my AccountantRecent TransactionsYYYYTransactions you created or edited in the last 4 days.https://app.qbo.intuit.com/app/reportv2?rptId=RECENT_TX&
95
For my AccountantReconciliation ReportsYYYYA list of your reconciliations, with links to individual reconcilation reports.https://app.qbo.intuit.com/app/reconcile?showHistory=true
97
For my AccountantStatement of Cash FlowsYYYY
Cash flowing in and out from sales and expenses (operating activities), investments, and financing.
https://app.qbo.intuit.com/app/reportv2?rptId=CASH_FLOW&
98
For my AccountantTransaction Detail by AccountYYYNTransactions and total for each account in your chart of accounts.https://app.qbo.intuit.com/app/reportv2?rptId=TX_DET_BY_ACCT&
99
For my AccountantTransaction List by DateYYYYA list of all your transactions, ordered by date.https://app.qbo.intuit.com/app/reportv2?rptId=TX_LIST_BY_DATE&
100
For my AccountantTransaction List with SplitsYYYNAll your transactions, with splits.https://app.qbo.intuit.com/app/reportv2?rptId=TX_LIST_WITH_SPLITS&
101
For my AccountantTrial BalanceYYYY
This report summarizes the debit and credit balances of each account on your chart of accounts during a period of time.
https://app.qbo.intuit.com/app/reportv2?rptId=TRIAL_BAL&
102
PayrollEmployee DetailsYYYYA snapshot of each employee, including pay rate, deductions, and tax withholding.https://app.qbo.intuit.com/app/report?rptId=PC_EMPLOYEE_DETAILS&
103
PayrollEmployee DirectoryYYYYWork location, phone number, email, and other contact info for each employee.https://app.qbo.intuit.com/app/payroll/reports/employee-directory
104
PayrollFFCRA CARES Act ReportY*Y*Y*Y*A comprehensive report of wages and credits pertaining to COVID-19 pay types.https://app.qbo.intuit.com/app/payrollreport?h=reports&arg1=desktopFFCRA
105
PayrollMultiple WorksitesY*Y*Y*Y*
Provides information you can use to complete your Multiple Worksites Report (if required by your state).
https://app.qbo.intuit.com/app/report?rptId=PC_MULTI_WORKSITES&
106
PayrollPaycheck HistoryY*Y*Y*Y*An overview of past paychecks, including payment method and paycheck status.https://app.qbo.intuit.com/app/payroll/reports/paycheck-history
107
PayrollPayroll Billing SummaryY*Y*Y*Y*Charges billed to your QuickBooks Payroll account.https://app.qbo.intuit.com/app/report?rptId=PC_BILLING&
108
PayrollPayroll Deductions/ContributionsY*Y*Y*Y*Your total employee deductions and company contributions.https://app.qbo.intuit.com/app/report?rptId=PC_DEDUCTIONS&
109
PayrollPayroll DetailsY*Y*Y*Y*The pay checks you've created, including the amount, taxes, and deductions.https://app.qbo.intuit.com/app/payroll/reports/payroll-summary?name=details
110
PayrollPayroll Summary by EmployeeY*Y*Y*Y*A comprehensive report of wages, deductions, and tax info, totaled by employee or period.https://app.qbo.intuit.com/app/payroll/reports/payroll-summary?name=pse
111
PayrollPayroll SummaryY*Y*Y*Y*The pay checks you’ve created, including total wages, taxes, and deductions.https://app.qbo.intuit.com/app/payroll/reports/payroll-summary
112
PayrollPayroll Tax LiabilityY*Y*Y*Y*How much payroll tax you need to pay and how much you’ve already paid.https://app.qbo.intuit.com/app/report?rptId=PC_TAX_LIABILITY&
113
PayrollPayroll Tax PaymentsY*Y*Y*Y*The payroll tax payments you’ve made.https://app.qbo.intuit.com/app/report?rptId=PC_TAX_PAYMENTS&
114
PayrollPayroll Tax and Wage SummaryY*Y*Y*Y*
Shows total and taxable wages that are subject to federal and province/region/state withholding.
https://app.qbo.intuit.com/app/report?rptId=PC_WAGE_REPORT&
116
PayrollRetirement PlansY*Y*Y*Y*Employee and company contributions to your retirement plans.https://app.qbo.intuit.com/app/report?rptId=PC_RETIRMENT_PLANS&
117
PayrollState Mandated Retirement PlansY*Y*Y*Y*State Mandated Retirement Plans
https://app.qbo.intuit.com/app/payrollreport?h=reports&arg1=statemandretplans
119
PayrollTotal PayY*Y*Y*Y*Each employee’s total pay by type (example: salary or hourly).https://app.qbo.intuit.com/app/payroll/reports/total-pay
120
PayrollTotal Payroll CostY*Y*Y*Y*
All costs associated with paying your employees, including total pay, net pay, deductions, and taxes.
https://app.qbo.intuit.com/app/report?rptId=PC_TOTAL_COST&
121
PayrollVacation and Sick LeaveY*Y*Y*Y*The vacation time and sick leave your employees used so far and how much they have left.https://app.qbo.intuit.com/app/report?rptId=PC_PTO&
122
PayrollWorkers' CompensationY*Y*Y*Y*
Wages paid for each Workers’ Comp class. You can use this to prepare forms for state agencies or insurance companies.
https://app.qbo.intuit.com/app/report?rptId=PC_WORKERS_COMP&
123
HIDDENAccount Quick ReportYYYY"To Date" approach to a detailed report (NO PRODUCT/SERVICE)https://qbo.intuit.com/app/reportv2?token=ACCTL_QUICKREPORT
124
HIDDENGeneric Transaction List ReportYYYYA list of all transactions, can be filtered and groups by several dimensionshttps://app.qbo.intuit.com/app/reportv2?token=GENERIC_QZREPORT
125
HIDDENCustom Summary ReportYYYYReport with Customizable Rows and Columns summarizing the tractions in that crossreferencehttps://app.qbo.intuit.com/app/reportv2?token=CustomSummary
126
HIDDENVoided/Deleted TransactionsYYYYAudit log with list all transactions that have benn voided and/or deletedhttps://qbo.intuit.com/app/auditlog?activityType=2&txnType=deletedVoided
127
HIDDENAll Posting TransactionsYYYYShows all the transactions that affect the general ledger with ALL fields including debits and credits
https://app.qbo.intuit.com/app/reportv2?token=GENERIC_QZREPORT&show_logo=false&date_macro=all&low_date=&high_date=&customized=yes&groupby=none&columns=~date%3ATxDate%2C~txn_type_label%3ATxTypeID%2C~doc_num%3ATxHeader%2FDocNum%2C~name_label%3ATxHeader%2FNameID%2C~memo_desc_label%3AMemoText%2C~account_id_label%3AAccountID%2C~split_label%3AOtherAccountID%2C-~amount_label%3ANaturalAmount%2C%3D~balance_label%3ANaturalAmount%2C~product_service_label%3AItemID%2C~ls_qty_col_header%3AQuantity%2C~rate_label%3ARate%2C~adjusting_text%3ATxHeader%2FIsAdjusting%2C~last_modified%3ALastModifyDate%2C~cs_customer_label%3ACustomerID%2C~location_dept%3ADeptID%2C~ar_paid%3AIsARPaid%2C~check_printed%3ATxHeader%2FCheckPrintState%2C!~debit_label%3AAmount%2C~tax_code%3ATaxCode%2FTaxCodeName%2C-~tax_amount%3ANaturalTaxAmount%2C!~credit_label%3AAmount%2C~ap_paid%3AIsAPPaid%2C~ls_class_col_header%3AKlassID%2C~vendor_name_id%3AVendorID%2C%7B~last_modified_by%2CModifyUser%2FFirstName%2CModifyUser%2FLastName%7D%2C~create_date_label%3ACreateDate%2C%7B~created_by%2CCreateUser%2FFirstName%2CCreateUser%2FLastName%7D%2C~employee_label%3AEmployeeID%2C~invoice_date%3AInvoiceDate%2C~is_cleared%3AIsCleared%2C~olb_label%3AOlbMatchMode%2C-~net_amount%3ANaturalNetAmount%2C&collapsed_rows=&edited_sections=false&divideby1000=false&hidecents=false&negativenums=1&negativered=false&show_header_title=false&show_header_range=true&show_footer_custom_message=true&show_footer_date=true&show_footer_time=true&header_alignment=Left&footer_alignment=Center&show_header_company=false
128
CUSTOM
Custom Transaction Detail Report with Debit/Credit
YYYYSame as "Generic Transaction list" but limited fields (including Debits and Credits) grouped by Account
https://app.qbo.intuit.com/app/reportv2?token=GENERIC_QZREPORT&show_logo=false&date_macro=today&sort_mode=ascend&sort_order=ascend&customized=yes&groupby=(Account/AccountTypeID,Account/OrderName&columns=~date%3ATxDate%2C~txn_type_label%3ATxTypeID%2C~doc_num%3ATxHeader%2FDocNum%2C~adjusting_text%3ATxHeader%2FIsAdjusting%2C~name_label%3ATxHeader%2FNameID%2C~memo_desc_label%3AMemoText%2C~account_id_label%3AAccountID%2C~split_label%3AOtherAccountID%2C!~credit_label%3AAmount%2C!~debit_label%3AAmount%2C-~amount_label%3ANaturalAmount%2C%3D~balance_label%3ANaturalAmount%2C&collapsed_rows=&edited_sections=false&divideby1000=false&hidecents=false&negativenums=1&negativered=false&show_header_title=true&show_header_range=true&show_footer_custom_message=true&show_footer_date=true&show_footer_time=true&header_alignment=Center&footer_alignment=Center&show_header_company=true&title=Custom%20Transaction%20Detail%20Report
129
HIDDEN
Estimates vs. Actuals by Product/Service Detail
YNNN
Report available in the Projects section, and is for a specific Project only (there is no version of this report where you see ALL the projects compared)
130
131
132
133
134
135