Age Debt/Forecast Payment Pro
The wizard will create a sheet with a list of Age Debtors and Creditors (Payables and Receivables). In addition, the function provides forecast payment amounts based on the Customer/Vendor average payment days or the company average, if history is not available. These reports and analysis can be customized using this data in your own sheets:
Wizard : Age Debt & Forecast Payments
| 0:00 | Intro | |
| 0:35 | Using the Age Debt Wizard | |
| 1:30 | Forecast Payments from 3 companies | |
| 2:20 | List of Debtors | |
| 2:40 | Change the Aging Intervals | |
| 3:15 | Drill Down & Quick Charts | |
| 4:20 | How do the CXL functions work? | |
| 5:15 | Non-committed figure |
The above video demonstrates how a Consolidated XL wizard can hotlink Xero, Quickbooks and Sage Age Debt & Forecast Payments to an Excel spreadsheet. Updated in seconds when reopened, enabling you to build your own customised cash flow forecasts for your clients or boss. Plus it has Quick charts to visualise your Xero, Quickbooks and Sage financial data, with drill down to the transactions.
Online Training
While not required, it may be helpful to complete the Training on functions and how they are used so that the concepts are more clearly understood.