BNZ File Transfer Channel & ANZ Fileactive Customers - Your Xero Reconciliations

BNZ File Transfer Channel & ANZ Fileactive Customers - Your Xero Reconciliations

Reconciling your Bank Statement Line in Xero 

Customers using the BNZ File Transfer Channel (BNZ FTC) or the new ANZ Fileactive payment method to pay their employees will only see a single bank statement line in Xero. 

You can now post one combined bill to Xero (instead of three) from iPayroll to make reconciling your bank statement line and bill quick and easy. 

You can continue to post three bills to Xero, you will need to use Find & Match functionality in Xero to reconcile the bank statement line and bills in Xero. 

In iPayroll to post one combined bill to Xero, update your settings

  1. Setup > Interfaces.  
  2. Select > Settings link under the Disable button in the Xero section.
  3. Select > Send Combined Invoice checkbox. 
  4. Click > Save

Setup > Interfaces


Send Combined Invoice 




In Xero to reconcile the three bills on the Bank account reconciliation page

You will have an iPayroll Limited bank statement line for the total amount of your payroll.
  1. Click on > Find & Match
  2. Displayed in Find & select matching transactions – you will see the three unpaid iPayroll bills (Pay, Fees and Tax).
  3. Select each of the three bills by clicking next to the date
  4. If you see Totals match
  5. Click on > Reconcile 

 Find and Match 



Select the bills > Review Totals > Reconcile



    • Related Articles

    • BNZ File Transfer Channel Customers

      BNZ’s File Transfer Channel (BNZ FTC) payment method uses a direct connection between iPayroll and BNZ. It has removed the need for a direct debit authority and a Payroll Letter of Credit.  You will still have up to 3pm or 4pm on payday to confirm ...

    • ANZ Fileactive Service Customers

      The ANZ Fileactive payment method uses a direct connection between iPayroll and ANZ. It has removed the need for a direct debit authority and a Payroll Letter of Credit.  You will still have up to 3pm or 4pm on payday to confirm your payroll.  After ...

    • New Payment Method - BNZ Customers

      BNZ File Transfer Channel BNZ no longer provide payroll letters of credit (PLOC’s) as a result of their move to 7-day payment processing.  Therefore, we now have a new payment method with BNZ customers which uses BNZ’s File Transfer Channel function ...

    • New Payment Method - ANZ Customers

      New Payment Method Coming- ANZ Fileactive Service ANZ will be decommissioning the use of payroll letters of credit (PLOC’s) later this year. Therefore we are creating a new payment method for our ANZ customers which uses ANZ’s Fileactive service.  ...

    • Xero Journal Upload File

      Xero Journal Upload This article is for customers who use Xero Accounting and want to post GL items to Xero using an upload file generated by iPayroll instead of the direct transfer (Xero Interface). You must connect to Xero to complete the Costing ...