I see many companies struggle with manual or semi-automated Cash Forecast solutions which often ends up with exports to Excel. Another option is to use an Excel-based reporting/budgeting/forecasting solution where you automatically pull in AR, AP, GL data into an Excel input form where you then can manually (good if there are any unique cash-related activities you need for adjust/enter) capture certain cash related items or you can have pre-built formulas that drive them.
BI360 offers this type of solution where you are LIVE on your ERP database with the BI360 Excel add-in or connected to the BI360 SQL data warehouse (if you want to STORE the resulting cash forecast) and you can automate the whole process, and it is simply an Excel-based report you run that refreshes the relevant data whenever you need a fresh Cash Flow Forecast.
I have attached a couple of screenshots that may give you some ideas for your own solution.

1 reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply