Exact Globe+

Creditor graph - Overview per date

Introduction

At Finance/Accounts payable/Payables/Date, you can generate a graph in Microsoft Excel that shows the sum of outstanding amount per date after the accounts payables have been processed. This graph is useful as it helps the management with decisions such as the amount needed to pay creditors at certain periods.

Note: The menu path differs according to the different legislations. For example, the menu path for Exact North America is Finance/Reports/Accounts payable/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.

Creditors

Type or select the creditor range or select the All check box to generate the graph for all creditors.

Classification

Type or select the classification range of the creditors 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.

Type

Select the type of creditor to be generated in the graph. A creditor can be a supplier/vendor or an employee. Choose from Supplier, Payroll data (in case of employees), or All.

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.