Payments2Us ManualsPayments2Us User Manual BPAYHow to manage BPAY reconciliation using Import Files

How to manage BPAY reconciliation using Import Files

The import file process allows for a CSV file to be uploaded and automatically match payment details with existing Payment Transactions generated by the Payment Schedule processor (invoices), or payments submitted from the Checkout online with the BPAY payment option selected.

The matching process:

  1. The processor searches for Payment Txns with a status "Awaiting Payment" that match the Customer Reference Number (CRN) and the amount.
  2. If there are no Payment Txns with the same Amount for that Customer Reference Number (CRN) , then it will look for other transactions and will start applying the amount from the oldest to the newest. If it is able to allocate all the funds and has funds left over, then it will apply the remainder to the oldest invoice. Alternatively, if the outstanding Payment Txn's amount is greater than the funds amount, then the Payment Txn will be made to the same amount as the funds amount and a new Payment Txn will be generated for the shortfall and will have a status of “Awaiting Payment.”
  3. If there are no Payment Txns on file, then a new Payment Txn will be generated using the contact details that have the Customer Reference Number (CRN)  allocated.
  4. If there are no contacts with the Customer Reference No. on file, then the payment will be uploaded with as much details as possible from the imported file.  This will need to be manually edited before it can be processed.

1. BPAY reconciliation using Import Files overview

  1. A Payer/Donor receives a bill to pay or decides to make an online donation
  2. They pay using their internet banking and select BPAY option
  3. A BPAY CSV file is extracted
  4. The CSV file is uploaded using the Payments2Us Import File process
  5. After checking the import details, the Salesforce user presses the "Process" button to process the import files.
    The Import Files Processor checks to see if there any Payment Txns with the Customer Reference Number matching the Import line CRN and with a status of Awaiting Payment.
    If no Payment Txns can be identified, then the processor looks for Contacts with a matching CRN.  If there is one, a Payment Txn is created for the BPAY amount.
  6. The normal batch processor runs and creates/updates related objects including (7) Accounts, Contacts and optionally Opportunities.

2. Set up Customer Reference Number (CRN)

The import file process matches the imported Customer Reference Number (CRN) with the Customer Reference Number (CRN) on a Payment Txn with "Awaiting Payment" Status, or links the transactions to a Contact with a matching Customer Reference Number (CRN)

Before running this procedure, see How to Setup BPAY Customer Reference Numbers.

2.1. Importing and Processing BPAY Transactions

To process BPAY transactions, follow the steps in How to import CSV files

NOTE, the Import File selected Merchant Facility and Payment Form will need to match the Payment Txn's Merchant Facility and Payment Form in order to be linked.

In addition Payer Name or Last Name will need to be included with the import IF there are no existing Contacts with a match CRN.