cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit

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

Know where you stand financially

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

A cash flow forecast helps you determine how long you can maintain business operations. You can then use the forecast as a planning tool to look at different scenarios, based on adjustments to revenue and expenses.

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.
  2. Select Profit and Loss.
  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.
  2. From Who owes you, select Open Invoices.
  3. Select Run report.

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

Optimise your cash flow

After you look at your current cash flow and create a forecast, 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.

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.
  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.
  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.
  2. From the For my accountant section, select Transaction Detail by Account.
  3. Select Customise, and then select Filter.
  4. Choose 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.
  2. From the For my accountant section, select Transaction Detail by Account.
  3. Select Customise, and then select Filter.
  4. Choose a Distribution Account, and then select the appropriate insurance accounts.
  5. Select Run report.


Step 3: See which bills are due

It may be most 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.
  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 report

Use the total expenses for each supplier report to sort by expense total. This will help to focus on which suppliers to contact.

  1. Go to Reports.
  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 note-holders to contact about deferring loan payments, use the transaction detail by account report.

  1. Go to Reports.
  2. From the For my accountant section, select Transaction Detail by Account.
  3. Select Customise, and then select Filter.
  4. Choose Distribution Account, and then select All Liability Accounts from the ▼ dropdown.
  5. Choose 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. If you use autopay for your bills, you may want to turn it off until you prioritise the spending.

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.
  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.
  2. From the For my accountant section, select Transaction Detail by Account.
  3. Select Customise, and then select Filter.
  4. Filter by Dues & 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.
  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 travel, meals, and entertainment.
  5. Select Run report.

Was this helpful?

You must sign in to vote, reply, or post