Xero ExportsThe Xero Export report allows BpAllied to connect directly to your Xero account via the Xero API and transfer Invoices, Payments and Refunds that have been created in Bp Allied into Xero. The transfer of these is dependent on the transfer of basic client and Products and Services information. The Xero API transfer can ONLY be Australian practices at this time.
There is some initial information that needs to be set-up in both BpAllied and Xero prior to the export going ahead. Once this is done, then the transfer is done in the following order:
1. Clients (known as Contacts in Xero)
2. Products and Services (known as Items in Xero)
3. Invoices
4. Payments
This Xero export is not compatible with customers using the NDIS report export, as each system requires different GST values to be transferred.
Initial Setup within Bp Allied1: Account Setup
Set up the Xero account connection in Options > Financial Exports > Xero
2: Allocate a Client ID to all Clients
The import sets the Bp Allied Client ID as the Account Number in Xero. Clients without Clients IDs assigned will not be imported.
This step needs to be carried out prior to each import of Sales and Payments under the assumption that your practice continually gets new clients.
3: Update Third Party Billers
Ensure all Third Party Billers have both the Organisation (Last name) and Attention (First name) field filled in. Both fields are required to be able to export to MYOB.
In the Xero Export report in Reports > Exports
Clicking Preview Error Report will display any that do not meet the appropriate criteria. This report can be printed or saved.
4: Update Products and Services
The following fields need to be populated in Bp Allied. Any Products or Services without a Category, Accounting Item Code or GST Code assigned will not be imported. If new Products or Services have been entered or prices have been changes then this will need to be imported prior to the export of Sales and Payment information. Item Descriptions can be a maximum length of 35 characters.
How to update the required fields
5: Creation of Tracking Categories
So that the Invoices and Payments transferred to Xero can be categorised by Practitioner we have utilised the Xero Tracking Category functionality. This was the only way to enable this categorisation as there is no field in Xero for Employee/User/Provider that can be set against an Invoice.
When the initial Client export is created the Practitioner tracking category is created along with category values for each User in BpAllied. This is updated as required each time the Client export is run.
As with the current functionality, any Invoices that include appointments related to multiple practitioners will be attributed to the practitioner related to the first appointment invoiced.
6: Prepend Client ID to Invoice and Payment Numbers
Xero will not allow an invoice or a payment to have a duplicate Invoice Number or Payment Number. There are two situations in BpAllied where these can occur, and hence prepending the Client ID to the Invoice or Payment number has been done to ensure that this number is unique. Read more about that here.
Sending Clients to XeroClients are called 'Contacts' in Xero. Due to the Xero API not allowing duplicate Contact Names, the BpAllied Client ID is appended to the contact name. Read more about that here and the impact on your Xero Invoice templates.
The fields transferred are:
Sending Products and Services to XeroProducts and Services are called 'Items' in Xero. Due to the API requiring that the Item Code field be unique, we require a unique number to be added into the Account Item Code field, as discussed above. However, this is not helpful when view items in the Xero interface, hence the Item Code and Description are concatenated onto this.
The fields transferred are:
Sending Invoices to XeroAfter setting up the Clients and Products and Services above, all the Invoices for the selected period will be able to be sent through to Xero with exception of:
To send Invoices:
What if I have updated or changed an Invoice in BpAllied?
That change will need to be manually replicated within Xero. See details on the Changing Exported Data & Error Messages section.
Sending Payments to XeroAfter sending Invoices, then all the Payments for the selected period will be able to be sent through to Xero with exception of:
· Medicare Bulk Bill and DVA claims that are not at a status of Processed or Completed
Payments are sent through to Xero in the form of Overpayments. Please read the details on the Limitations here about why we chose to do this.
Allocation of payments
As a result of sending the payments as Overpayments, at the end of the payments export, the script allocates the payments sent to Xero to the Invoices in Xero. Occasionally a validation error can occur if the Invoice has already been paid, for example if a payment has been manually added to Xero for the invoice. Read about this in the Changing Exported Data & Error Messages page.
To send Payments:
When a payment has been successfully exported the XeroGUID is written back into the table to stop it being exported again.
|