All the Debtors and Creditors related Reports are available under this menu.


 

Under Debtors / Creditors Reports, you will find two types of Reports:

1. Debtors / Creditors Age analysis

2. Debtors / Creditors Due Statement.



1. Debtors / Creditors Age analysis


Debtors / Creditors Age analysis report shows your debtors/receivables or creditors/payables outstanding with length of time for that particular outstanding.


1.1 Debtors Age Analysis Report


This report categorizes a company's accounts receivables according to the length of time an invoice has been outstanding. 
It can be filter as follows:

Date – To select as at date   

Project – To select relevant project

Account – To select debtor account

Address Cat – To select relevant address category

BU – To select relevant business unit

No of Days 1 – To select number of days for 1st column

No of Days 2 – To select number of days for 2nd column, ext.



Clicking the + button and you can expand the heading. After that, it will show the breakdown for each heading. 

Click on the red + button, it will expand the whole report. 

Clicking on the like green + buttons, it will expand one by one record.



1.2 Creditors Age Analysis Report


This report categorizes a company's accounts payables according to the length of time that payable amount has been outstanding. 

It can be filter as follows:

Date – To select as at date   

Project – To select relevant project

Account – To select creditor account

Address Cat – To select relevant address category

BU – To select relevant business unit

No of Days 1 – To select number of days for 1st column

No of Days 2 – To select number of days for 2nd column, ext.



2. Debtors / Creditors Due Statement


Debtors / Creditors Due statement report shows your debtors/receivable or creditors/payable outstanding. You can filter this by Customer/Supplier Account.


2.1 Debtors Age Analysis Report



It can be filter as follows:

Date – To select as at date   

Project – To select relevant project

Account – To select Debtor account

AdvAnalysis – To select debtor address 

Address Cat – To select relevant address category

Tran type - Transaction type (sales/ sales return, ext.)

BU – To select relevant business unit


2.2 Creditors Age Analysis Report



It can be filter as follows:

Date – To select as at date   

Project – To select relevant project

Account – To select Creditor account

AdvAnalysis – To select debtor address 

Address Cat – To select relevant address category

Tran type - Transaction type (sales/ sales return, ext.)

BU – To select relevant business unit