Skip to main content

How to track amounts payable to suppliers

Learn about the Supplier Credit Lifetime Report and how to export it to an Excel file.

Updated yesterday

The Supplier Credit Lifetime Report is a comprehensive accounts payable statement for all suppliers added to the platform. It helps you identify the amounts that must be paid to each supplier for partially paid or unpaid purchase invoices.


Accessing the Report

  1. Go to Reports > Stock Control > Supplier Credit Lifetime Report.

  2. Click on the report to view details.

Searching in the Report

You can search using:

  • Supplier name

  • Supplier Tax number

Filtering Report Data

  1. Click Filter.

  2. You can filter results by:

    • Supplier name

    • Supplier Tax number

    • Total purchases

    • Total paid amount

    • Total payable amount

    • Payable amount (by time period)

  3. 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 on the platform.

Supplier Tax Number

The Tax number registered for the supplier on the platform.

Total Purchases

The total value of purchases from the supplier, whether paid or unpaid.

Total Paid Amount

The amounts already paid to the supplier.

Total Payable Amount

The amounts not yet paid to the supplier.

Payable (1–15 days)

Amounts unpaid for 1 to 15 days.

Payable (16–30 days)

Amounts unpaid for 16 to 30 days.

Payable (31–60 days)

Amounts unpaid for 31 to 60 days.

Payable (61–90 days)

Amounts unpaid for 61 to 90 days.

ℹ️ Note: The table contains multiple columns. Use the horizontal scroll bar at the bottom to view all columns.

Exporting the Report

  1. Click Export.

  2. Select xlsx.

  3. The Excel file will be downloaded to your device.


FAQs

  1. How can I search for the payables of a specific supplier?
    Click the filter icon in the Supplier column > enter the supplier name > the payables will appear for that supplier.

  2. How can I find out which suppliers have the highest payable amounts?
    Click on the Sort by field > choose Total Payable: Highest to Lowest > check the Total Payable Amount column.

Did this answer your question?