Exact Globe+

Debtor graph - Overview per date

Introduction

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.

Description

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.

Debtors

Type or select the debtor range or select the All check box to generate the graph for all debtors.

Classification

Type or select the classification range of the debtors or select the All check box to generate the graph for all classifications.

Unprocessed

Select the Unprocessed check box to include entries that have yet to be processed.

Reference date

Select Invoice date, Due date, or Reporting date as the reference date.

Buttons

Start

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.

Close

Click Close to exit.