The Supplier Debit Lifetime Report is a comprehensive debit statement for all suppliers added to the platform. It helps you track amounts receivable from suppliers due to returns, making it easier to monitor overdue payments and follow up on collections.
Accessing the Report
Go to Reports > Stock Control > Supplier Debit Lifetime Report.
Click on the report to view details.
Searching in the Report
You can search by:
Supplier name
Supplier TAX number
Filtering Report Data
Click Filter.
You can filter results by:
Date range
Supplier name
Supplier TAX number
Total supplier returns
Total received amounts
Total outstanding amounts
Outstanding amounts by period
Click Apply.
Sorting Data
Click on the Sort by field and choose the preferred order to display the data.
Report Data
Supplier Name | The supplier name added to the platform. |
Supplier TAX Number | The supplier’s TAX number as recorded in their data. |
Total Supplier Returns | The total receivable amount from the supplier, whether collected or not. |
Total Received | The amounts already received from the supplier. |
Total Outstanding | The amounts not yet received from the supplier. |
Outstanding 1–15 Days | Amounts outstanding for 1 to 15 days. |
Outstanding 16–30 Days | Amounts outstanding for 16 to 30 days. |
Outstanding 31–60 Days | Amounts outstanding for 31 to 60 days. |
Outstanding 61–90 Days | Amounts outstanding for 61 to 90 days. |
Exporting the Report
Click Export.
Select xlsx.
The Excel file will be downloaded to your device.
FAQs
How can I search for more than one supplier at the same time?
From the filter icon in the Supplier Name column, add the supplier names and click Apply.
Can I identify the supplier with the largest unpaid amount?
Yes, click on Sort by, then select Outstanding Total: Highest to Lowest.
Why can’t I see all the data in the report?
Use the horizontal scroll bar at the bottom of the table to view all data, or click Export to display all data in an Excel file.