Use reports to track cash flow in QuickBooks Online

Run a profit and loss report to check your income and expenses for the last three months.

1. Go to Reports (Take me there).
2. From the Business overview, select Profit and Loss.
3. Select a date range from the Report period ▼ dropdown, then select Since 90 days ago, or select Custom dates for dates you want to see.

Open invoices show all unpaid invoices and statement charges with customer totals.

1. Go to Reports (Take me there).
2. From Who owes you, select Open Invoices.
3. Select a date range from the Report period ▼ dropdown. Or select Custom dates for dates you want to see.

See which customers owe you money and when it's due. Focus on payments to keep your business running.

Note: If you’re using QuickBooks Online Advanced, you can find customers who might delay payments. Set up AI enhanced reminders in workflows based on past payment patterns.

Run an open invoices report

The open invoices report will show customers who owe you the most. Increase your cash flow by managing these accounts.

1. Go to Reports (Take me there).
2. From Who owes you, select Open Invoices.
3. Select a date range from the Report period ▼ dropdown, or select Custom dates for dates you want to see.

Run a customer balance detail report

To see customer balances and due dates, run a customer balance detail report.

1. Go to Reports (Take me there).
2. From the Who owes you section, select Customer Balance Detail.
3. Select a date range from the Report period ▼ dropdown, or select Custom and select the day or date you want to see.
4. Select Run report.

Note: To find the right customers to contact, select Sort and use the due date to see the customers with the most overdue invoices.

Your rent and insurance cost a lot of money every month. Lowering costs can boost your company's available cash.

1. Go to Reports (Take me there).
2. From the For my accountant section, select Transaction Detail by Account.
3. Select a date range from the Report period ▼ dropdown, or select Custom dates for dates you want to see.
4. To get the average monthly expenses, select Filter.
   1. Select the Filter by ▼ dropdown, then find and select Account.
   2. Select the Options ▼ dropdown, then select equals.
   3. Select the placeholder ▼ dropdown.
      • For Rent - find and select the appropriate rent accounts.
      • For Insurance - find and select the appropriate insurance accounts.

It helps to start with bills that are due. Some vendors may offer flexible timing or payment plans.

Run an unpaid bills report

View overdue bills and due dates in the unpaid bills report. This helps with your short-term cash flow.

1. Go to Reports (Take me there).
2. From the What you owe section, select Unpaid Bills.
3. Select a date range from the Report period ▼ dropdown, or select Custom dates for dates you want to see.
4. To filter your data, select Filter.
   1. Select the Filter by ▼ dropdown, then select Due date.
   2. Select the Options ▼ dropdown, then select equals.
   3. Select a date. Or enter a specific date.

Run an expenses by vendor summary report

Run an expenses by vendor summary report and sort by expense total. This will help to focus on which vendors to contact.

1. Go to Reports (Take me there).
2. From the Expenses and vendors section, select Expenses by Vendor Summary.
3. Select a date range from the Report period ▼ dropdown, or select Custom and select the day or date you want to see.
4. Select Run report.
5. Select Sort and choose to sort by total in descending order.

Work with vendors, lenders, and governments to change terms and rates to make your money last. Here’s a tip on communicating with vendors.

Identify which lenders to contact

To identify which lenders or noteholders to contact about deferring loan payments, use the transaction detail by account report.

1. Go to Reports (Take me there).
2. From the For my accountant section, select Transaction Detail by Account.
3. Select a date range from the Report period ▼ dropdown. Or select Custom dates for dates you want to see.
4. To filter your data, select Filter.
   1. Select the Filter by ▼ dropdown, then select Account type.
   2. Select the Options ▼ dropdown, then select equals.
   3. Select Long Term Liabilities.

Identify which tax agencies to contact

Run a taxable sales detail report. It'll show your taxable products and services, and how much you owe.

1. Go to Reports (Take me there).
2. In the Sales tax section, select Taxable Sales Detail.
3. Select a time frame from the Report period ▼ dropdown.
4. Select Month from the Group by ▼ dropdown.
5. Select Run report.
6. Find the Settings ⚙️ on the report and select Show More.
7. Find and select the Tax Amount and Tax Name to show how much you owe by month.

Calculate your payroll tax

Use the payroll cost report to calculate your payroll tax.

1. Go to Reports (Take me there).
2. From the Payroll section, select Total Payroll Cost.
3. Select a time period from the date range ▼ dropdown.
4. Select Apply.

Manage your spending. Find things you don't need and cut back on them.

1. Go to Reports (Take me there).
2. From the For my accountant section, select Transaction Detail by Account.
3. Select a date range from the Report period ▼ dropdown. Or select Custom dates for dates you want to see.
4. To get the specific average of discretionary spending, select Filter.
   1. Select the Filter by ▼ dropdown, then select Account.
   2. Select the Options ▼ dropdown, then select equals.
   3. Select the placeholder ▼ dropdown.
      • For other dues and subscription expenses - find and select Memberships & Subscriptions.
      • For other operational expenses - find and select Advertising & Marketing.
      • For subsistence expenses - find and select Meals.