At Finance/Accounts receivable/Receivables/Date, you can export data to Microsoft Excel to generate a graph that shows the sum of the outstanding amount per date after the accounts receivables have been processed. This graph is useful as it helps the management with decisions such as the amount that should be coming in from debtors.
Note: The menu path differs according to different legislations. For example, the menu path for Exact North America is Finance/Reports/Accounts receivable/Date.
You can filter the data that you want to display. To search for the data, you can define one or more of the following criteria and click Start. The data that matches the search criteria you have entered is then displayed in graph form.
Type or select the debtor range or select the All check box to generate the graph for all debtors.
Type or select the classification range of the debtors or select the All check box to generate the graph for all classifications.
Select the Unprocessed check box to include entries that have yet to be processed.
Select Invoice date, Due date, or Reporting date as the reference date.
Click Start to generate the graph in Microsoft Excel.
Click the Graph, Table and Data tabs found at the bottom of the Microsoft Excel spreadsheet to browse through the information. The data can also be modified to meet your requirements.
If you modify any data in the Table or Data tab, the graph in the Graph tab is updated automatically.
Click Close to exit.