Use reports to track cash flow in QuickBooks Online

Learn how to track your cash flow in QuickBooks Online.

Your cash flow is the amount of money moving in and out of your business and bank account. In QuickBooks Online, you can use different reports and projections to get a clear look at your current and future businesses finances. Here’s what to do.

Step 1: Make sure your data is accurate

When it comes to cash flow reporting, the first thing to do is make sure your books are accurate. All reports will use your data in QuickBooks, so you want to make sure you have a clean starting point.

1. Make sure you’ve entered all your transactions into QuickBooks.
2. Reconcile your accounts in QuickBooks and make sure they match your real-life bank and credit card statements. If you need help reconciling your account, it’s a good idea to reach out to your accountant.

If your reconciliation report matches your bank statement, you’re ready to start running reports. If they don’t match, here’s how to fix beginning balance issues in QuickBooks.

Step 2: Understand your cash flow using reports

You can understand your cash flow based on the following reports:

Run a Profit and Loss report

Run a Profit and Loss report for the past three months to get an understanding of your average income and expenses for each month.

1. Go to Reports (Take me there).
2. Search for and select Profit and Loss report.
3. From the Report period ▼ dropdown, select Since 90 days ago. Or select Custom and enter a three-month date range.
4. Select Run report.

When you look at the 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.

Run an Open Invoices report

The Open Invoices report will show you all unpaid invoices and statement charges, with totals for each customer.

1. Go to Reports (Take me there).
2. From Who owes you, select Open Invoices.
3. Select Run report.

Optimise your cash flow

After you look at your current cash flow using reports, you can focus on finding the best ways to manage cash flow. You’ll likely need to use a mix of approaches to both increase money coming in and decrease what you spend. You can use the data from key QuickBooks reports.

Step 1: See which customers owe you

See which customers owe you and the due dates. Focusing on making sure you get paid can result in an increase of cash that you can use to continue running the business.

Run an Open Invoices report

The Open Invoices report will show you which customers owe you the most, then you can choose how to manage these accounts to increase cash on hand.

1. Go to Reports (Take me there).
2. From the Who owes you section, select Open Invoices.
3. Select Run report.

Run a Customer Balance Detail report

To see a detailed breakdown of how much each customer owes and the 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 Run report.

To help focus on which customers to contact, select Sort and use the due date to see the customers with the most overdue invoices.

Step 2: Reduce fixed expenses

Large monthly expenses are the easiest to identify. Lowering them can have a substantial impact on available cash for the business.

Rent: Use the Transaction Detail by Account Report to get average monthly rent expenses.

1. Go to Reports (Take me there).
2. From the For my accountant section, select Transaction Detail by Account.
3. Select Customise, and then select Filter.
4. Select a Distribution Account, and then select the appropriate rent accounts.
5. Select Run report.

Insurance: Use the Transaction Detail by Account Report to see monthly insurance expenses.

1. Go to Reports (Take me there).
2. From the For my accountant section, select Transaction Detail by Account.
3. Select Customise, and then select Filter.
4. Select a Distribution Account, and then select the appropriate insurance accounts.
5. Select Run report.

Step 3: See which bills are due

It may be helpful to start with the bills that are already due. Suppliers may be flexible on timing or be able to offer payment plans.

Run an Unpaid Bills report

The Unpaid Bills Report will show you unpaid bills along with the due dates and days past due. This will help show 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 report period from the ▼ dropdown.
4. Enter your due date.
5. Select Run report.

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 report period from the ▼ dropdown.
4. Select Run report.
5. Select Sort and choose to sort by total in descending order.

Step 4: Reduce your money out

The less money you spend, the longer your cash reserves will last. Work with suppliers, lenders, and government agencies to explore options for deferring payments or restructuring terms and rates. Use report data from QuickBooks to help prioritise who to contact.

Identify which lenders to contact

To identify 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 Customise, and then select Filter.
4. Select Distribution Account, and then select All Liability Accounts from the ▼ dropdown.
5. Select Supplier, and then select the appropriate suppliers from the ▼ dropdown.
6. Select Run report.

Step 5: Cut back on discretionary spending

There’s a wide range of expenses that you can control. Identifying items that aren’t necessary—either in the short-term or at all—can reduce some of the stress around cash flow.

Marketing and advertising

Marketing budgets typically have some flexibility, and you should be able to adjust them for the next few months. To see average spending, 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 Customise, and then select Filter.
4. Select Distribution Account, and then select the accounts you use for marketing and advertising.
5. Select Run report.

Subscriptions and memberships

You may have subscriptions or memberships that aren’t necessary in the short term. Cancelling or suspending them can result in immediate savings. To track dues or ongoing subscription expenses, 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 Customise, and then select Filter.
4. Select Distribution Account, then select the accounts you use for dues and subscriptions.
5. Select Run report.

Meals and entertainment

Try to cut spending in this area for the next few months. Use the Transaction Detail by Account Report to see average meal expenses.

1. Go to Reports (Take me there).
2. From the For my accountant section, select Transaction Detail by Account.
3. Select Customise, and then select Filter.
4. Select Distribution Account, then select the accounts you use for travel, meals, and entertainment.
5. Select Run report.