Background:


Parakeet automates the reconciliation of inward BPAY invoices based on the BRF (BPAY remittance file) provided by the BPAY provider.



Purpose:


This document outlines how to reconcile invoices that are 'auto-matched' by Parakeet


For transactions that are un-reconciled, please refer to process here.


Reconciliation Steps:


Parakeet


  • Parakeet receives the BRF file from BPAY Provider
  • Parakeet translates the BRF file and allocates the BPAY receipts to the customer's outstanding invoices
  • Parakeet marks the BPAY receipt to the appropriate invoices in Xero
  • Parakeet marks the invoice as paid in Xero
  • Parakeet allocates a Payment reference to the invoice
  • Invoice marked as "paid" and allocate the invoice to the pre-agreed bank account in Xero
  • Email is sent, summarising the payments that has been reconciled (screen shot)



  • Parakeet attaches the BRF as an attachment to the invoice within Xero





  • The Payment reference is recorded in the format of: "CRN | Payment Reference from Payer Bank"




Bank statement reconciliation action:


  • When the BPAY deposit is received from the BPAY provider, go tor the 'Reconcile' tab in Xero
  • Xero will provide the best match based using the  information provided by Parakeet (e.g. CRN | Payment Reference)
  • Click OK and the invoice is reconciled
  • (Option: User can also create 'bank rules' in Xero to automate some of these task)