Payee Master data requirements

What data is required for the Master File and how to Upload

Payee Master File Submission

Submit an extract of your Payee Master File with the mandatory fields listed below. Including optional fields improves data quality and helps identify potential issues.

  • Any issues found will be returned in an Excel workbook for correction via the Secure Upload in OK2Pay.
  • Up to two iterations of data cleansing are included in the standard process.

Master File Data Validation Checks

OK2Pay will perform the following checks on the Payee Master File:

  1. Verification of all mandatory fields.
  2. ABN Validation – Ensuring ABNs are valid and active.
  3. Detection of valid ABNs not on the register.
  4. Verification of BSB numbers.
  5. Detection of duplicate ABNs.
  6. Detection of duplicates in BSB + Bank Account Number combinations.
  7. Detection of duplicates in contact details.
  8. Verification of GST status.
  9. Validation of bank details – Registered Name, BSB, and Bank Account Number.

File Format Requirements

  • Provide the Payee Master File in a delimited text format (e.g., CSV ,, pipe |).
  • This can be submitting as TXT, CSV or Excel formats.
  • Include field names in the first row.

Example Format:

ABN,Company Name,BSB,Bank Account Number,Bank Account Name  
12345678911,XDF Company Pty Ltd,034123,6457324,XDF Company

πŸ“₯ A template file can be downloaded here.


Required Payee Fields

Field NameTypeDescription
ABN*Mandatory11-digit Australian Business Number uniquely identifying each company.
ACN^Optional9-digit Australian Company Number.
Company Name*MandatoryRegistered company name from the ABN and Business Register.
BSB*Mandatory6-digit Bank and Branch Number (e.g., 032099).
Bank Account Number*MandatoryPayee's bank account number.
Bank Account Name*MandatoryName linked to the account. If blank, the Registered Company Name is used.
Payee ID^OptionalInternal ID used in your ERP system.

Optional Payee Fields (Recommended for Data Quality)

Field NameDescription
Payee Address - Number & StreetPhysical address (street and number).
Payee Address - SuburbSuburb of the payee.
Payee Address - CityCity of the payee.
Payee Address - StateState/territory of the payee.
Payee Address - Postal CodePostal/ZIP code.
Payee Contact - Full NameContact person's full name.
Payee Contact - EmailContact email address.
Payee Contact - Phone NumberContact phone number.
Payee StatusStatus of the payee (Only Active recommended).
Payee Last Updated DateLast updated date of payee data.

Secure Upload Master File


Once the Master file is ready, you can uploaded it via OK2Pay.  This will let OK2Pay know the file is ready for processing.  The typical turnaround is 2-3 days.  If any errors, this will be avaialbe in the same place and you can then download to review and correct.  The process will then be repeated until the master file is correct.

Typically only 2 rounds of verification are included in the Dtaawash fee quoted, thereafter extra charges may apply.  Please discuss this with your account manager or email satorisupport@satoriassured.com

Once logged into OK2Pay, navigate to Secure Upload

Any issues/corrections will be uploaded in the same area below.  These can then be downloaded to correct and be re-uploaded

 

Was this article helpful?