7.2 Payment File Upload – File Template

This topic provides systematic instructions to Payment records can be created in bulk through file upload

User must have valid corporate login credentials.
To create payments in bulk:
  1. From the Dashboard, click the Toggle Menu, then click File Upload, and then File Upload .
    The File Upload screen appears.
  2. Create the file to be uploaded in the format shown below. For more information on the procedure of uploading the file, refer Corporate Bulk File Upload – Receivables Payables Management User Manual.

    Note:

    While uploading a .XLSX / .XLS file, if you do not have the required data for a particular cell, and need to leave it blank, then ensure that the particular empty cell has been formatted to the data type of the expected data of that cell. For example, a cell that is supposed to hold textual content, such as name or description, should be formatted to 'Text'. Similarly, a cell that is supposed to hold a number, should be formatted to 'Number'. Refer this file for the sequence: Bulk Payments Upload Template.

    Table 7-7 Field Description

    Field Name Description
    Payment File Upload – File Template The following fields should be entered in a row for a payment record.
    Payment Type Specify O for outgoing and I for incoming payment. This is a mandatory field.
    Note: If the payment type is incoming, then the Beneficiary ID should be that of the logged-in party.

    If the payment type is outgoing, then the Payment Party ID should be that of the logged-in party.

    Customer Payment Reference Number Specify the customer’s own unique reference number for the payment. This is a mandatory field.
    Payment Currency Specify the currency in which the payment is made. A 3-digit currency code as per ISO standards is acceptable. This is a mandatory field.
    Payment Amount Specify the amount paid. This is a mandatory field.
    Finance Repayment Appropriation Specify the sequence of repayment for principal, interest, and overdue amount. Example: OIP.
    Finance Repayment Specific Appropriation Specify the amounts paid for the repayment appropriation. For example: P:3000.00|I:500.00|O:900.00
    Payment Mode Specify the mode of payment. This is a mandatory field. The acceptable values are:
    • ACT_TRANSFER
    • NEFT
    • CASH
    • CHEQUE
    • RTGS
    Payment Date Specify the date of payment in the DD-MM-YYYY format. This is a mandatory field.
    Payment Party Code Specify the code of the party making the payment. You can either provide a value in this field, or in the Payment Party ID field.
    Counter Party Code Specify the code of the counter party, in the payment transaction. You can either provide a value in this field, or in the Counter Party ID field. A counter party in this context is generally a third party like a bank or any other medium to the transaction.
    Payment to Virtual Account Specify whether the payment is being made to a virtual account or not. Enter Y if the payment is to a virtual account, and N, otherwise. This is a mandatory field.
    Credit Account Number Specify the account number to which the payment is credited to. This field is mandatory if the Payment Type is incoming (I). This can be either the real account number, or the International Bank Account Number (IBAN) based on the configuration set by the bank.
    Auto Reconciliation Specify whether the payment should be auto reconciled, or not. If you enter Y, then the payment is auto reconciled on upload of file. If you enter N, the payment will have to be manually reconciled. This is a mandatory field.
    Is Payment for Cashflow OR Invoice OR Finance Specify E for expected cash flow payment, I for invoice payment, and F for finance payment.
    Cash flow OR Invoice OR Finance Reference Number Specify the reference number of the expected cash flow record / invoice / finance, as applicable. If multiple options are applicable, If the payment is made towards multiple options, then you can enter the reference numbers as follows:

    Invoice Ref No | Finance Ref No | Expected Dr/Cr Ref No
    Remarks Specify any remarks, if applicable. If specific values are not provided in the respective fields, then they can be provided in the Remarks field. Multiple references can be made using a pipe separator as given below:

    N:Narration | E: Expected Dr/Cr Ref No | I: Invoice Ref No| F:Finance Ref No| P:Program code| R: Relationship Code | PPC: Payment Party Code | CPC: Counterparty Code
    Payment Party ID Specify the ID of the party making the payment. You can either provide a value in this field, or in the Payment Party Code field.
    Payment Party Name Specify the name of the party making the payment.
    Counter Party ID Specify the ID of the counter party. You can either provide a value in this field, or in the Counter Party Code field.
    Counter Party Name Specify the name of the counter party.
    Beneficiary ID Specify the ID of the beneficiary of the payment.
    Beneficiary Name Specify the name of the beneficiary of the payment.
    Program Code Specify the program code applicable for the payment.
    Remitter Account Number Specify the account number from which the payment is initiated. This field is mandatory if the Payment Type is outgoing (O). This can be either the real account number, or the International Bank Account Number (IBAN) based on the configuration set by the bank.
    Fund Transfer or Cheque Reference Number Specify the external reference number of the payment, in case of fund transfer or cheque payment.
    Mandate Reference Number Specify the reference number of the mandate.
    Credit Note Reference Number Specify the reference number of the credit note.
    Allocation Required Specify Y if allocation is required, and N, otherwise. This is a mandatory field.
    Payment Under Approval Specify Y if the payment is under approval, and N otherwise. Payment under Approval is a scenario wherein the bank may choose to invoke the insurance claim in the event of a default.
    Indirect Payment Specify Y if the payment is an indirect one, and N, otherwise. Indirect payment is a scenario where the buyer directly makes the payment to the supplier instead of through the factors.
    Instrument Cleared Specify Y if the instrument is cleared, and N, otherwise.
    Bank Charges Specify the charges, if any, that may be levied by the factor.
    Deduction Amount Specify the deduction amount, if any.
    Filler Details This section displays the filler details.
    Filler Fields 1 to 10 Specify the required information in the filler fields.
  3. Select the file identifier, select the file to be uploaded, and click Upload.
The payments are uploaded.

Parent topic: Payments Management