- The report lists all transactions affecting the AR/AP balance by sorting them by due date. These transactions are:
- Invoices issued on the Purchasing and Sales and Distribution sections, except for Proforma invoices,
- All slips issued on the AR/AP module, except for Special Slips,
- Checks / P. Notes Received and Issued (To AR/AP) slips issued on the Check/ P. Note module,
- Money order slips issued on the Bank module,
- AR/AP Collection and Payment slips issued on the Safe Deposit module, and Invoices issued on the Safe Deposit module.
- Proforma invoices are not reflected on this report. Purchase proforma invoices are processed as purchases, and Sales Proforma invoices are processed as wholesale when billed. AR/AP special slips are not listed on this report.
- Invoices issued from the Safe Deposit and cancelled invoices are displayed as two lines on the debt tracking report. The Transaction Type field of the second line displays "The Account of Slip Value" message for invoices issued from the safe deposit, and the "Slip Cancellation" message for cancelled invoices. One of the lines is written on the credit and the other on the debit side in order to prevent a change on the AR/AP balance.
- Purchase Due Date Diff. Invoices and Sales Due Date Diff. Invoices are displayed as two lines on this report.
In the Sales Due Date Diff. Invoice:
1. Line
Sales Due Date Diff. Invoice should be entered on the Transaction Type column, and Amount (VAT incl.) on the Debit column.
2. Line
Due Date Difference Transaction should be entered on the Transaction Type column, and the amount (VAT excl.) should affect the Due Date Difference column as a credit.
Purchase Due Date Diff. Invoice:
1. Line
Purchase Due Date Diff. Invoice should be entered on the Transaction Type column, and Amount (VAT incl.) on the Credit column.
2. Line
Due Date Difference Transaction should be entered on the Transaction Type column, and the amount (VAT excl.) should affect the Due Date Difference column as a debit.
- Transfer checks and P. Notes are not listed on this report. Because amounts debited/credited by checks and P. Notes can be seen on the opening slip.
- In due date calculations, the due date of the check or P. Note, or the average due date of the slip is processed depending on the parameter. The collection date of the checks and P. Notes does not affect the due date difference calculation of the debt tracking report. Invoices and AR/AP transactions are divided according to the payment plan they are connected to, and are displayed on the report depending on their due dates. Closing transactions and due date difference calculations always process the due date.
- The debt tracking report performs FIFO closing assuming that invoices will first be closed using AR/AP transactions and checks/P. Notes.
How is the Due Date Difference Calculated?
The due date difference amount of report lines with closing operations is calculated as follows:
Due Date Difference = Closed Amount * Interest Rate * (Number of prepayment or delay days/ 30)