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:
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.
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.
Online Training on CXL functions and how to use them.