Creditor Reporting

The following article contains information regarding creditor/contractor reports. These reports can help you view creditor activity at a local or global level across your portfolio. 

You will also find more payment reports in our Payment Reporting article.

Creditors Aged Balances

The Creditor Aged Balances report provides the ageing balance for a creditor account. It can be produced from the current year, with options to include the old year, the current year, or both.

1. Search or select Report Set.
2. Search or select the Creditor Aged Balance report.
3. Click the cogwheel, review the Order By and Financial Year settings, and determine whether the template should include the phone numbers.
4. Click Close once set. 
5. This can be saved as a report set with further reports by clicking +Report button and adding further reports. Once all reports are available, click the Save icon. Enter a Report Set name and click OK.
6. To run this across multiple buildings, use the Building selector area and tag the buildings.
7. The default recipient will be the internal user. 
8. Drop the recipient type if required, and select the appropriate type. If for sending to a recipient, tag this contact and click Proceed to preview.
9. In the preview window, click Proceed to finalise the distribution, click the save icon to save the report to a file location, click the email icon to use Communications, or click the DocMax icon to save to DocMax.

Example:

Creditors Info List

This report contains the creditor contacts available in Creditor Maintenance, which uses two templates; each includes additional fields of information. The Creditors Info List is also available in the Master Chart, where all or selected creditors will report.

1. Search or select Report Set.
2. Search or select the Creditor Info List.
3. Click the cogwheel, review the order, tick if Hidden Creditors should be included, and if a specific industry type is required. Review the template which included both the Creditor Info List or Creditors Master List (examples shown below).
4. Click Close once set. 
5. This can be saved as a report set with further reports by clicking the +Report button and adding further reports. Once all reports are available, click the Save icon. Enter a Report Set name and click OK.
6. To run this across multiple buildings, use the Building selector area and tag the buildings.
7. The default recipient will be the internal user. 
8. Drop the recipient type if required, and select the appropriate type. If for sending to a recipient, tag this contact and click Proceed to preview.
9. In the preview window, click Proceed to finalise the distribution, click the save icon to save the report to a file location, click the email icon to use Communications, or click the DocMax icon to save to DocMax.

Example: Creditors Info List

Example: Creditors Master List

Creditor Activity Report

The Creditor Activity Report details the invoice date, creditor account, name, amount, expense code, expense name, details, ref num (D0 reference), invoice number, and whether the invoice is paid.

This report is also available for uploading to the Portal and can be configured from Creditors Management (cogwheel icon) to show the number of invoice days.

1. Search or select Report Set.
2. Click the cogwheel to set the invoice days, and check the Excluding Hidden Transactions tickbox. 
3. Click Close once set. 
4. This can be saved as a report set with additional reports by clicking the +Report button and adding them. Once all reports are available, click the Save icon. Enter a Report Set name and click OK.
5. To run this across multiple buildings, use the Building selector area and tag the buildings.
6. The default recipient will be the internal user. 
7. Drop the recipient type if required, and select the appropriate type. If for sending to a recipient, tag this contact and click Proceed to preview.
8. In the preview window, click Proceed to finalise the distribution, click the save icon to save the report to a file location, click the email icon to use Communications, or click the DocMax icon to save to DocMax.

Example:

Creditors Balance Report

This report contains the balance of a creditor which can be set for the Current Year, Old Year or a combination of both.

1. Search or select Report Set.
2. Click the cogwheel, review the Financial Year settings, and determine which template.
3. Click Close once set. 
4. This can be saved as a report set with additional reports by clicking the +Report button and adding them. Once all reports are available, click the Save icon. Enter a Report Set name and click OK.
5. To run this across multiple buildings, use the Building selector area and tag the buildings.
6. The default recipient will be the internal user. 
7. Drop the recipient type if required, and select the appropriate type. If for sending to a recipient, tag this contact and click Proceed to preview.
8. In the preview window, click Proceed to finalise the distribution, click the save icon to save the report to a file location, click the email icon to use Communications, or click the DocMax icon to save to DocMax.

Example: