Cash flow forecast with average days to pay

JuanC · ‎August 23, 2021

I know there's a cash flow forecast report in Quickbooks, but that's based on the invoice terms. Is there a way to get the cash flow forecast to use average days to collect instead?

For example, Company ABC has an invoice out with terms of 30 days. If the invoice was issues on 1/1 then I would expect payment on 1/31. However, historically Company ABC pays me 45 days after the invoice is issued based on average days to pay in Quickbooks. This means I would receive payment on 2/14. Is there a cash flow forecast report or filter that I can utilize to forecast my collections based on average days to pay?

Thanks.

AlexV · ‎August 23, 2021

Hi JuanC!

I understand that you need to filter the Cash Flow Forecast report. Let me assist you.

We're unable to thorough customize the Cash Flow Forecast in QuickBooks Desktop. However, we have an Average Days to Pay report you can use. This can help you to get the data you need.

Follow these steps:

Go to the Reports menu.
Hover over Customers & Receivables, then select Average Days to Pay.
You can click the Customize Report button and proceed to the Filters section if you need to get specific data. From there, you can filter the report such as the dates.

Also, you'll want to check this link: Customize reports in QuickBooks Desktop. This will show you the detailed steps on how to personalize the reports.

If you're balancing your accounts, you can check this article: Learn the reconcile workflow in QuickBooks. This explains how to match your bank and credit card statements to the accounts in QuickBooks Online.

Leave a comment below if you have other concerns. Take care!

View solution in original post

AlexV · ‎August 23, 2021

Hi JuanC!

I understand that you need to filter the Cash Flow Forecast report. Let me assist you.

We're unable to thorough customize the Cash Flow Forecast in QuickBooks Desktop. However, we have an Average Days to Pay report you can use. This can help you to get the data you need.

Follow these steps:

Go to the Reports menu.
Hover over Customers & Receivables, then select Average Days to Pay.
You can click the Customize Report button and proceed to the Filters section if you need to get specific data. From there, you can filter the report such as the dates.

Also, you'll want to check this link: Customize reports in QuickBooks Desktop. This will show you the detailed steps on how to personalize the reports.

If you're balancing your accounts, you can check this article: Learn the reconcile workflow in QuickBooks. This explains how to match your bank and credit card statements to the accounts in QuickBooks Online.

Leave a comment below if you have other concerns. Take care!

Topics

Training

Community

Resources

Cash flow forecast with average days to pay

Cash flow forecast with average days to pay

Cash flow forecast with average days to pay

Need to get in touch?