The Cash Flow Forecast live data report provides visibility into the current and future cash position of your company by leveraging the information within Q360 as it pertains to bank account balances and expected receivables and payables over a given period.
- Navigate to Live Data Main Menu > Accounting > Cash Flow Forecast Detail
- Use grid filters to narrow results if necessary. Filter options include Company, Branch, # of Periods, Time Unit, Base Currency, Age By, Periods to Collect, Fixed Periods to Avg, Fixed Adjustment %, and three checkboxes that allow inclusion of Project Invoices, Project Cost and / or Service Contract Invoices
- Note: if Cash Flow Forecast is not reflecting what you expect, consider revisiting your GL Accounts (Accounting Main Menu > Admin > GL Admin > GL Accounts). Make sure your Fixed accounts are flagged as such – these will impact your “Fixed Periods to Average” and “Fixed Adjustment %.”
Cash Flow Forecast Sections:
- Bank
- AR w Overdue
- AR Current/Estimated
- UnInvoiced Project
- UnInvoiced Serv Cont
- AP
- Overhead
For additional information on Cash Flow Forecast usage and sections, see KB article Cash Flow Forecast