Importing BPAY Reference Details Into XERO

  1. Log into your XERO account.
  2. Go to CONTACTS tab – ALL CONTACTS.
  3. EXPORT tab - this will export as a .csv file in Excel (for purposes of these instructions; I will refer to this as Form 1). Save this file.
  4. Open a separate blank Excel file (for purposes of these instructions; I will refer to this as Form 2).
  5. Copy company name (column A) from form 1 onto blank excel file (Form 2) into column A - Repeat with email (column C) and phone number (if wanted) ( column X).
  6. Save this as a .csv file (file – save as - .csv) Form 2.

    Once you have taken the initial steps in Xero it is time to log into your Pay Advantage account;

  7. Log into PA.
  8. click on the CUSTOMERS tab (top left).
  9. click on IMPORT FILE (from the dropdown menu).



  10. Choose file “Form 2” from where you saved it to on your computer and click next (right hand side).
  11. Match up the headings with the column eg Ensue that the Name header is sitting over the rows containing Names.



  12. Click next.
  13. IF there are any errors it will be highlight in red – you can amend these and resubmit.
  14. Click on Customers (top right).
  15. Select View Customers from the drop down.
  16. Click on the grey box next to heading NAME to select all records.
  17. Click on create BPAY Refs (blue box, top centre) – you will need to do this once for each page.
  18. Click EXPORT (this will create a .csv file in Excel (for purposes of these instructions; I will save this file as Form 3).



  19. Open “Form 3” excel file ‘Customer Export’.
  20. Copy column N (BPAY Ref) from Form 3 and paste into form 1 (the first excel doc that was exported from XERO) into column B (account Number).


  21. Save this file as a .csv.
  22. Go to your XERO account and select IMPORT.
  23. Upload form 3 (the last excel file saved).
  24. Ignore empty fields.
  25. Import.
  26. Complete import.
  27. Account number will now be BPAY ref number in XERO.
Have more questions? Submit a request

Comments