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 section, select Profit and Loss.
3. Select a date range from the Report period ▼ dropdown, then select Since 90 Days Ago, or select Custom for dates you want to see.
4. Select Run report.

When you look at income, focus on the top sources of revenue. For expenses, pay attention to things like payroll, rent, insurance, and marketing expenses to see where you may be able to reduce spending.

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

1. Go to Reports (Take me there).
2. From Who owes you section, 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 section, 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 first ▼ dropdown, then find and select Account.
   2. Select the second ▼ dropdown, then select equals.
   3. Select the third ▼ 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 suppliers 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 first ▼ dropdown, then select Due date.
   2. Select the second ▼ dropdown, then select equals.
   3. Select a date or enter a specific date.

Run an expenses by supplier summary report

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

1. Go to Reports (Take me there).
2. From the Expenses and suppliers section, select Expenses by Supplier 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 suppliers, lenders, and governments to change terms and rates to make your money last.

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 first ▼ dropdown, then select Account type.
   2. Select the second ▼ dropdown, then select equals.
   3. Select the third ▼ dropdown, then select Long Term Liabilities.

Identify which tax agencies to contact

Run a Tax 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 Tax Detail Report.
3. Select a time frame from the Report period ▼ dropdown.
4. Select Run report.
5. Find the Settings ⚙️ on the report and select Show More.
6. Find and select the Amount and Tax Name to show how much you owe.

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 first ▼ dropdown, then select Account.
   2. Select the second ▼ dropdown, then select equals.
   3. Select the third ▼ dropdown.
      • For other dues and subscription expenses - find and select Dues And Subscriptions.
      • For other operational expenses - find and select Other Types Of Expenses-Advertising Expenses.
      • For subsistence expenses - find and select Meals And Entertainment.