0
DAYS
0
HOURS
0
MINS
0
SECS
Over 4.5 million customers use QuickBooks.
Sign up for a free trial!
2020-04-28 21:03:13COVID-19EnglishThese reports give you the key data you need to create a forecast and maximise your cash flow.https://quickbooks.intuit.com/au/resources/au_qrc/uploads/2020/04/SMBIllustration.pnghttps://quickbooks.intuit.com/au/resources/small-business-accounting/running-quickbooks-reports-2/3. Running QuickBooks reports

3. Running QuickBooks reports

4 min read

These reports give you the key data you need to create a forecast and maximise your cash flow.

Customer balance detail report

Accounts receivable by customer. You can sort by due date to help prioritise 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 supplier summary

Total expenses for each vendor. You can sort by expense total to help prioritise 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. 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 Customise, 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 Customise, 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 Customise, 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 Customise, 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.

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 Australia Pty Ltd. 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 Australia Pty Ltd. 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.

We provide third party links as a convenience and for informational purposes only. Intuit Australia Pty Ltd does not endorse or approve these products and services, or the opinions of these corporations or organisations or individuals. Intuit Australia Pty Ltd accepts no responsibility for the accuracy, legality or content on these sites.

Rate This Article

This article currently has 1 ratings with an average of 1.0 stars

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.

Help Your Business Thrive

Sign up for our newsletter

Thanks for signing up!

Check your inbox for a confirmation email.*

*Check your spam folder if you don’t see a confirmation email.

Related Articles

The ultimate end of financial year payroll checklist

The end of financial year process is much more efficient with the…

Read more

Choosing the ideal business report - QuickBooks Online

Wondering what the ideal business report format looks like? If so, look…

Read more

3. Maximising cash flow

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

Read more