2020-05-08 11:15:44 Cash Flow English From expenses by vendor summary to P and L reports, learn how to run all the QuickBooks reports that you need to create your cash flow... https://quickbooks.intuit.com/ca/resources/ca_qrc/uploads/2020/05/cash-flow-playbook.png https://quickbooks.intuit.com/ca/resources/cash-flow/running-quickbooks-reports/ Running QuickBooks reports

Running QuickBooks reports

3 min read

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 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.

Payroll Summary by Employee report (Temporary Wage Subsidy – 10%)

10% Wage Subsidy amount captured here for eligible employers

  1. Go to Reports.
  2. Select Payroll Summary by Employee in the Payroll section.
  3. Select Wage Subsidy (10%) box.
  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 of 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.

 

<<Back: Cash flow playbook for accounting professionals

Information may be abridged and therefore incomplete. This document/information does not constitute, and should not be considered a substitute for, legal or financial advice. Each financial situation is different, the advice provided is intended to be general. Please contact your financial or legal advisors for information specific to your situation.

Related Articles

Maximizing cash flow

After you analyze the current cash situation and develop a forecast, you…

Read more

Where Do Financial Reports Come From?

Financial reports are a key element in running a business, but where…

Read more

The 5 Ws of Financial Reporting

No matter the size of your business, whether small, medium, or large,…

Read more