Running QuickBooks reports

These reports give you the key data you need to create a forecast and recommend steps your clients can take to maximize their cash flow.

Customer balance detail report

Accounts receivable by customer. You can sort by due date to help prioritize which customers to contact.

1. Go to Reports.
2. Select Customer Balance Detail in the Who owes you section.
3. Select Run report.
4. Select Sort and choose to sort by due date in descending order

Dues and subscriptions QuickReport

Transactions summary for the dues and subscriptions account.

1. Go to Accounting and select Chart of Accounts.
2. Filter by Dues & subscriptions.
3. Select Run report.

Expenses by vendor summary

Total expenses for each vendor. You can sort by expense total to help prioritize which vendors to contact.

1. Go to Reports.
2. Select Expenses by Vendor Summary in the Expenses and vendors section.
3. Select a report period from the dropdown.
4. Select Run report.
5. Select Sort and choose to sort by total in descending order.

Open invoices report

Unpaid invoices and statement charges, with totals for each customer.

1. Go to Reports.
2. Select Open Invoices in the Who owes you section.
3. Select Run report.

Profit and loss report

Income, expenses, and net income.

1. Go to Reports.
2. Select Profit and Loss.
3. Select Since 90 days ago from the Report period dropdown. Or select Custom and enter a three-month date range.
4. In the Display columns by dropdown, select Months.
5. Select Run report.

Rent/lease QuickReport

Transaction summary for rent/lease expenses.

1. Go to Accounting and select Chart of Accounts.
2. Filter by Rent or Lease.
3. Select Run report.

Taxable sales detail report

Sales of taxable products and services.

1. Go to Reports.
2. Select Taxable Sales Detail in the Sales tax section.
3. Select a time frame from the Report period dropdown.
4. Select Month from the Group by dropdown.
5. Select Run report.
6. Go to Settings [add icon] on the report and select Show More.
7. Choose Tax Amount and Tax Name to display the tax agency and how much the client owes by month.

Total payroll cost report

Costs associated with paying employees, including taxes.

1. Go to Reports.
2. Select Total Payroll Cost in the Payroll section.
3. Select a time period from the Date Range dropdown.
4. Select Run report.

Transaction detail by account report (insurance)

Transactions and totals for the accounts in your chart of accounts. Focus on the insurance accounts to see average monthly insurance expenses.

1. Go to Reports.
2. Select Transaction Detail by Account in the For my accountant section.
3. Select Customize, and then select Filter.
4. Choose Distribution Account, and then select the appropriate insurance accounts.
5. Select Run report.

Transaction detail by account report (marketing and advertising)

Transactions and totals for the accounts in your chart of accounts. Focus on the marketing and accounts accounts to see related expenses.

1. Go to Reports.
2. Select Transaction Detail by Account in the For my accountant section.
3. Select Customize, and then select Filter.
4. Choose Distribution Account, and then select the accounts designated for marketing and advertising.
5. Select Run report.

Transaction detail by account report (meals and entertainment)

Transactions and totals for the accounts in your chart of accounts. Focus on the meals and entertainment accounts to see related expenses.

1. Go to Reports.
2. Select Transaction Detail by Account in the For my accountant section.
3. Select Customize, and then select Filter.
4. Choose Distribution Account, and then select the accounts designated for travel, meals, and entertainment.
5. Select Run report.

Transaction detail by account report (liabilities)

Transactions and totals for the accounts in your chart of accounts. Focus on the liability accounts to identify lenders.

1. Go to Reports.
2. Select Transaction Detail by Account in the For my accountant section.
3. Select Customize, and then select Filter.
4. Choose Distribution Account, and then select All Liability Accounts from the dropdown.
5. Choose Vendor, and then select the appropriate vendors from the dropdown.
6. Select Run report.

Transaction list by vendor

Transactions for a period a time, grouped by vendor. Focus on the last several months to see recurring trends.

1. Go to Reports.
2. Select Transaction List by Vendor in the Expenses and vendors section.
3. Select a report period from the dropdown.
4. Select Run report.

Unpaid bills report

Unpaid bills, with due dates and days past due.

1. Go to Reports.
2. Select Unpaid Bills in the What you owe section.
3. Select a report period from the dropdown.
4. Enter your due date.
5. Select Run report.

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Intuit Inc. does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Intuit Inc. does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers should verify statements before relying on them.