Upload Formats

Payees – Batch Import CSV

RewardPay allows for the batch upload of payees in CSV file format with a format as follows:

Column Name Example Description
1 Payee Number
This field is blank. A number will be allocated by RewardPay.
2 Company Name
Widgets Pty Limited
Legal name of the organisation
3 ABN
53004085616
Australian Business Number. This must be an active registered number.
4 Email
[email protected]
Organisation Email Address
5 Phone
+61 1234567
Organisation Phone Number
6 Address
1 Widget Place
Mailing Address
7 City
Sydney
Mailing City
8 State
NSW
Mailing State
9 Postcode
2000
Mailing Post Code
10 Bank BSB Number
012-003
Australian Bank BSB Number
11 Bank Account Number
123456789
Australian Bank Account Number

The file must be in UTF-8 format and must include the following header:

"Payee Number","Company Name","ABN","Email","Phone","Address","City","State","Postcode","Bank BSB Number","Bank Account Number"

CSV Payee upload header example:

Please note:

  • Spelling and capitals must appear as below
  • No spaces allowed
Payee Number Company Name ABN Email Phone Address City State Postcode Bank BSB Number Bank Account Number

Payments – Batch Import CSV

Payees must exist in your RewardPay customer portal before upload of payments. RewardPay allows for the batch upload of payments in CSV file format with a format as follows:

Column Name Example Description
1 Payee Number
61234567
Payee number is 8 digit RewardPay number starting with the number 6.
2 Reference
Sample Order XYZ
Internal reference number for your records
3 EFT Reference
Pay Invoice XYZ
Up to 18 character reference provided to the supplier to identify you as a payor.
4 Sales Tax
0
How much sales tax (GST) was included in the Total Amount (as cents). OR 0 if you do not require this information.
5 Total
1000
Total payment amount including sales tax (GST)(as cents) to be made to supplier.
6 Currency
AUD
Currency of the payment. Must be AUD at this time.

The file must be in UTF-8 format and must include the following header: 

"Payee Number","Reference","EFT Reference","Sales Tax","Total","Currency"

Batch Number is a unique number for this payment batch. Each batch will only be processed once per unique Batch Number. This allows RewardPay to ensure there are no partial file transmissions, or transmission duplicates. You can enter any random unique 6 digit number. The file must include a footer in the following format.

"Batch Number","123456"

CSV Payment upload header example.

Please note:

  • Spelling and capitals must appear as below
  • No spaces allowed
  • Batch Number header in same column as Payee Number
  • Batch Number headers appears directly under the last row of data (no skipped lines)
Payee Number Reference EFT Reference Sales Tax Tax Currency
Batch Number 123456

Payments – Batch Import ABA File Format

RewardPay allows for the batch upload of payments in ABA file format.

Issued by the Australian Bankers Association (ABA) the ABA or Cemtext file format is a format used by banks to allow for batch transactions.

Further information on the ABA file format can be found at the following website ABA File Format.

All payees must already exist in your customer portal before doing any payment upload. Matching payment to payee is done using the BSB and the bank account number.