QuickBooksHelpIntuit

Use reports to track cash flow in QuickBooks Online

by Intuit•37• Updated 2 months ago

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.

For a better experience, open this article in QuickBooks Online. Launch side-by-side view

Know where you stand financially

Chapters:

0:00 - How to use the cash flow planner

0:22 - what the cash flow planner does

0:51 - using the cash flow planner to plan for your business

To watch more how-to videos, visit our video section.

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.

Make sure you’ve entered all your transactions into QuickBooks.
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: Generate a cash flow forecast

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.

Download the forecasting worksheet

Download the forecasting worksheet and use it as a planning tool to evaluate “what-if” scenarios, based on potential adjustments to revenue and expenses. Set a goal to create a three-month plan to keep your cash positive.

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.

Go to Reports (Take me there).
Search for and select Profit and Loss report.
From the Report period ▼ dropdown, select Since 90 days ago. Or select Custom and enter a three-month date range.
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.

Go to Reports (Take me there).
From Who owes you, select Open Invoices.
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.

Go to Reports (Take me there).
From the What you owe section, select Unpaid Bills.
Select a report period from the ▼ dropdown.
Enter your due date.
Select Run report.

Optimize 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. Like you did with your forecast, 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.

Go to Reports (Take me there).
From the Who owes you section, select Open Invoices.
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.

Go to Reports (Take me there).
From the Who owes you section, select Customer Balance Detail.
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.

Note: If you’re using QuickBooks Online Advanced, you can see which customers are more likely to delay paying you. To set it up, select the AI powered option when creating automated payment due reminder emails in the Workflows section. The system will then send reminder emails to customers who are likely to pay late, based on their previous payment patterns.

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.

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

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

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

Step 3: See which bills are due

It may be helpful to start with the bills that are already due. Vendors 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.

Go to Reports (Take me there).
From the What you owe section, select Unpaid Bills.
Select a report period from the ▼ dropdown.
Enter your due date.
Select Run report.

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.

Go to Reports (Take me there).
From the Expenses and vendors section, select Expenses by Vendor Summary.
Select a report period from the ▼ dropdown.
Select Run report.
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 vendors, lenders, and government agencies to explore options for deferring payments or restructuring terms and rates. Use report data from QuickBooks to help prioritize who to contact. When you’re ready, here’s some tips on communicating with vendors.

Identify which lenders to contact

To identify lenders or noteholders to contact about deferring loan payments, use the Transaction Detail by Account Report.

Go to Reports (Take me there).
From the For my accountant section, select Transaction Detail by Account.
Select Customize, and then select Filter.
Select Distribution Account, and then select All Liability Accounts from the ▼ dropdown.
Select Vendor, and then select the appropriate vendors from the ▼ dropdown.
Select Run report.

Identify which tax agencies to contact

To see which tax agencies you pay, run a taxable sales detail report. This will show you a list of your taxable products and services, along with the amount you owe.

Go to Reports (Take me there).
In the Sales tax section, select Taxable Sales Detail Summary.
Select a time frame from the Report period ▼ dropdown.
Select Month from the Group by ▼ dropdown.
Select Run report.
Go to Settings ⚙️ on the report and select Show More.
Choose Tax Amount and Tax Name to display the tax agency and how much you owe by month.

Calculate your payroll tax

To calculate how much payroll tax you should pay, use the total payroll cost report. This will show you the costs associated with paying employees, including taxes.

Go to Reports (Take me there).
From the Payroll section, select Total Payroll Cost.
Select a time period from the date range ▼ dropdown.
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 prioritize 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.

Go to Reports (Take me there).
From the Accounting reports section, select Transaction Detail by Account.
Select Customize, and then select Filter.
Select Distribution Account, and then select the accounts you use for marketing and advertising.
Select Run report.

Subscriptions and memberships

You may have subscriptions or memberships that aren’t necessary in the short term. Canceling or suspending them can result in immediate savings. To track dues or ongoing subscription expenses, use the Transaction Detail by Account Report.

Go to Reports (Take me there).
From the For my accountant section, select Transaction Detail by Account.
Select Customize, and then select Filter.
Filter by Dues & subscriptions.
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.

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

QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.