Payment Advice Report

Introduction

The Payment Advice Report serves as a tool for suppliers to reconcile their transactions. The report provides detailed information regarding invoice values, discounts applied, actual payments made, and Unique Transaction Reference (UTR) details for each payment.


Data Dictionary

  1. Expected Payment Date - Date when the invoice payment was expected to be made.

  2. Actual Payment Date - Date when the invoice payment was actually made.

  3. Invoice Amount - The total amount specified in the invoice.

  4. Adjustments (Financed Transaction) - Any adjustments made for financed transactions. Refer to the Adjustments sheet in the report for details.

  5. Invoice Net Amount Post Adjustment - The net amount of the invoice after adjustments.

  6. Financed Type - Indicates whether the financing covers 100% of the invoice net amount or a certain percentage.

  7. Eligible Amount (1) - The amount eligible for financing, either 100% of the invoice net amount or a specific percentage.

  8. Adjustments (Non-Financed Transaction) (2) - Adjustments for non-financed transactions, also known as pass-through transactions.

What is Non-financed Transaction?

A non-financed transaction occurs when no discount is charged on invoices of the supplier by the buyer. For instance, if an invoice is uploaded with a due date of today or a due date that has already passed, it implies there is no acceleration or early payment occurring for the supplier regarding that invoice. In such cases, the invoice amount is disbursed to the supplier without any adjustments or discounts. These transactions are termed as Non-financed Transactions.

  1. Supplier Discount % - Annualized percentage discount applied to acceleration days. For example, see the table for clarification.

CalculationResult

Supplier Discount % (Annual-basis)

Supplier Discount % (Per day)

Due Date

Payment Date

Acceleration Days

Supplier Discount % (For Acceleration Days)

Note

The Supplier Discount is charged to a supplier on Eligible Amount.

  1. Absolute Discount Amount (3) - Calculated as the product of the eligible amount and the supplier discount percentage.

  2. Vendor Net Payable - Net amount payable to the supplier after adjustments and discounts. It is computed as:

    Vendor Net Payable = Eligible Amount - Adjustments (Non-Financed Transaction) - Absolute Discount Amount

  3. Vendor Net Disbursed - Amount disbursed to the supplier by the bank. Usually identical to Vendor Net Payable unless there are delays.

  4. UTR Number - Unique Transaction Reference generated by the bank and sent back to the platform in reverse feed.

Note

Vendor Net Payable and Vendor Net Disbursed should typically match. Any discrepancies may be due to technical delays in payment processing by the bank.

Last updated