Background:

  • This article applies to situation where:
    • You are using Parakeet's BPAY CRN Generation and invoicing services; and
    • You have received BPAY payments from your customer and need to manually reconcile


If you are using Parakeet's Automated BPAY reconciliation automation service, then this article is not applicable


Purpose:


This document outlines how to reconcile BPAY payments made on BPAY invoices issued out of Xero 


Reconciliation Steps:


Step 1: Obtain BPAY Reconciliation file (CBA, NAB)


  • Obtain the BPAY file from your BPAY provider 
  • Open the file
  • Each line in the file will show:
    • e.g. Amount paid = $2,200
    • CRN number related to the BPAY Inward payment = 8588888



Step 2: Find the customer 


  • Go to the Contacts and input the CRN into the search field
  • In this example, you will see 8588888 found the customer 'Testing Services Pty Ltd'



Step 3: Find the Invoice 


  • Click into the Customer
  • In this example, you will see the invoice of $2,200 is outstanding
  • Click and allocate payment to this invoice.






Step 4: OPTIONAL - Reconcile bulk entries via PARAKEET AR FINAL ACCOUNT


  • As NAB & CBA deposit payments in 1 batch, we recommend allocating the individual invoice payment to the PARAKEET AR FINAL CLEARING ACCOUNT
  • For example, if you have a Batch deposit of $10,000 consisting of 20 invoices, it would be easier to reconcile.
  • In this case, the steps are:
    • Repeat step 2 & step 3 above for each BPAY payment
    • Allocate the payment for each BPAY invoice to 'PARAKEET AR FINAL CLEARING ACCOUNT'



  • Once all invoices are allocated which totals $10,000 (example), then do a 'TRANSFER' from your Bank statement to the PARAKEET AR FINAL CLEARING ACCOUNT as per below