Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi there,
Anyone know how I can generate a Cash Flow Projection report from QBO?
I need to know from my current cash flow position + AR + AP what would my future cash position look like.
Any help would be helpful.
We're glad to have you here, Leslieb Sia.
I can help you run a Cash Flow Projection report in QuickBooks Online (QBO).
Statement of Cash Flows report is available in QBO. This shows the in and out flow of cash from sales and expenses, investments, and financing of your business. To generate this report, please follow the steps provided below:
Fill me in if you have additional questions about Statement Cash Flow report or other QuickBooks reports. I'll do my best to help you out.
Hi,
Yes I am aware of this Cash Flow report, but this provides actual Cash Flow for the date range period.
What would be good is to have the cash flow also have the ability to show the AR collections base on the customer aging and factor in the AP with the aging as well.
Can this be done? Has anyone done this in excel? If not possible to have this feature in and make QB the best product ever....
Can this be done?
Cash Flow Projection is not possible in QBO.
Has anyone done this in excel?
You can google "How do you do a cash flow projection in Excel?"
You will find all kinds of answers. You can use Statement of Cash Flow report in QBO as your data if you want.
Will this be added to the future product road map?
OR can we have an excel plugin / api to achieve this in the future road map?
Hi,
You can use Cash Flow Frog to create cash flow projections
Cash Flow Frog automatically generates a cash flow forecast based on data imported from your QuickBooks Online account.
The generated forecast is comprised of the following types of transactions:
All forecast transactions can be edited (date, amount and details) or deleted.
https://apps.intuit.com/app/apps/appdetails?shortName=cash_flow_frog&locale=en-us
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here