How to get correct suppliers

 
1) Set ABN/GST/VAT number for each of your supplier in Xero.

The ABN/GST/VAT number is the most reliable way to identify a supplier. For Australia, it is ABN number; for New Zealand, it is the GST number; for the United Kingdom, it is VAT number.  Therefore, you shall set ABN/GST/VAT number for your suppliers in Xero.

point1

(screenshot below shows where to put ABN number for Australian customers)

Tax-ABN_short

 
2) For invoices without ABN or ABN unreadable or multiple suppliers having the same ABN, you shall set additional Xero contact data for the supplier.

These additional data including supplier name, bank details, phone number, address, email, and account number.  The key is to have one or two data field matching closely a text string on the invoice.

For supplier names in Xero, you may prefer to use a short name or descriptive name instead of the long one on the invoice. Generally it is not a problem for EzzyBills. If you put ABN for this supplier in the Xero contact data, we will be able to use it to find the right supplier for you. However, what if there is no supplier’s ABN on the invoice? Or what if there are multiple suppliers for this same ABN? No problem. EzzyBills can use other Xero data for your suppliers.

Example 1: use bank details

Add the bank detail, BSB and account number, in your Xero contact, under Financial Details -> Batch Payment.  EzzyBills will extract the bank details from the invoices and find the matching supplier.

2016-11-11-supplier_bank

Example 2: use “Account Number”

Add an alternative name/clue for this supplier, using the field “Account Number” in the Xero Contact. You can copy a unique string from the invoice and put it in there.  More on how to use this

 
3) Add “My ABN/GST No” in your EzzyBills Settings.

With this, we will not identify your company as the supplier, even if it appears on the invoice.  (My ABN/GST No. is the ABN/GST number for your company only. Not that of your suppliers or clients.) It is best to put it in, no space between numbers or in a typical format.

 
4) What to do when the supplier was chosen incorrectly for a specific invoice?

  1. In Xero, edit the supplier that was incorrectly chosen, and make sure it does not contain the ABN/GST/VAT number. If it does, then remove the ABN/GST/VAT.
  2. Make sure the correct supplier contains the ABN/GST/VAT number.
  3. In some cases, (where the ABN/GST/VAT number was not extracted) suppliers are determined via text matching. In these cases it might be necessary to change the supplier name in Xero to more closely match the name on the invoice, or add bank detail (or email, or phone number, or address, or Account Number”) – see section 2) for more details.
  4. You will need to click “Refresh GL” on your EzzyBills setting, so that EzzyBills sees your changes instantly.
  5. Now when you process a new invoice of this supplier, the supplier will be correctly chosen.