Export Cash Flow Forecast Data to Excel or PDF

You can export cash flow forecast data from the Cash Flow Forecast submodule to Excel, Notepad, or PDF.

To perform this procedure, you must have access to Finance & Administration as defined in the User Access Rights submodule under Settings.

To export cash flow forecast data to Excel or PDF:

1. On the main toolbar, click Finance & Administration .
2. In the left pane of the Finance screen, click General ledger > Cash flow forecast.
3. If you have more than one company in your system, use the drop-down list above the left pane of the Finance & Administration module to select the company that will use the cash flow forecast for which you want to create a cash flow forecast.
4. From the drop-down list next to the grid tabs, select the cash flow forecast whose data you want to export.
5. Click the Summary tab or the Cost Types Setup tab.
6. In the header of the left-most column click, and click Export grid data on the drop-down menu.
7. In the Export data dialog box, select from the following options:
   • Microsoft Excel Open XML Format Spreadsheet (XLSX)
   • Text file (CSV or custom separator)
   • Portable Document Format (PDF)
   By default, WorkBook includes the header row and group data in the export. You can clear the check boxes for these options. The option to include group data is useful only if your system supports data grouping. Otherwise, selecting or clearing this option does not have an impact on the exported file.
8. Click OK.
   WorkBook generates the file and displays the file icon at the bottom of your browser.
9. To open the file, click the file icon.