This document provides best practices when syncing between Bill.com and Xero.
1. Contacts vs. Vendors/Customers
- Vendors and Customers will connect to the same contacts in Xero, as long as the names match, and they have transactions in Bill.com.
- If Contacts in Xero do not have transactions, assign them to one of the groups that we create: Sync to Bill.com Vendors or Sync to Bill.com Customers. If the Contact exists as both a Customer and a Vendor, add them to both groups.
- If the names of Contacts in Xero do not match the Vendors/Customers in Bill.com, then the Contact will be created as a new Vendor/Customer in Bill.com, and the Vendor/Customer in Bill.com will be created as a new Contact in Xero.
- Newly-created Contacts in Xero won't sync to Bill.com until a transaction is created for them. When a transactions is created, Xero will categorize them and then sync them into Bill.com as either a Vendor or a Customer.
- Newly-created Vendors/Customers in Bill.com will sync over to Xero in either the Sync to Bill.com Vendors group, or Sync to Bill.com Customers group. If a Vendor and Customer in Bill.com have the same name, then they will sync as one Contact in Xero, but will be a part of both Groups.
- In order to sync to Bill.com, the contact address in Xero must be specifically in the "Postal Address" section. Also, the contact phone must be in the dash format (xxx-xx-xxxx) and not be in the "Mobile Phone" field in order to sync to Bill.com.
2. Archive vs. Delete
- Bill.com never truly deletes information. If you choose to Delete something in Bill.com, we will remove it from view and consider it Archived. You can un-delete something you've deleted at any time.
- Xero has the option to delete, which will truly delete records in Xero. If you delete something in Xero, that object will become Archived in Bill.com
3. Tracking Categories
- In Xero, categories named Location and Department must exist. If you don't set up these tracking categories in Xero, then Locations and Departments will never link with Bill.com.
- When initially creating locations and departments, those will sync from Xero to Bill.com and/or Bill.com to Xero. Updates/deletions made to these items, however, will not sync from Xero to Bill.com, and must be done in Bill.com manually.
- Bill.com makes one or two lump-sum withdrawals (depending on when you schedule your payments) for the total amount of bills paid on a given day. This withdrawal(s) are located in your Bill.com Money Out Clearing account in Xero. When reconciling your bank account, you will need to reconcile once for all bills paid on a given day.
5. Chart of Accounts
- To make a Chart of Account type Bank or Credit Card in Bill.com, you need to create a bank account or charge account in Xero, and associate it to the corresponding Chart of Account.
- Items will sync two way between Bill.com and Xero. When entering in Sales Tax, these will only sync one way from Xero to Bill.com.
- Only unpaid bills sync from Xero into Bill.com, so you should always initiate payments in Bill.com. On the Bill.com Pay page you can pay via Bill.com (check or ACH), or record payment made offline. The sync will send to Xero the related payment or check to be printed in Xero.
- $0 bills will sync from Bill.com to Xero as Paid
- You can choose to have only Approved bills sync to Xero. Learn more here
8. Vendor Credits
- Only unapplied vendor credits sync from Xero, so you should apply vendor credits in Bill.com.
- When you make a payment with a vendor credit, we will sync it to Xero, where it gets automatically applied.
- You can choose to have only Approved vendor credits sync to Xero. Learn more here
9. Credit Memos
- Credit Memos don't sync to/from Xero. They need to be manually applied in both Bill.com and Xero.
10. Bills/Invoices using Items
- Always code the bill/invoice with an Account. The integration doesn’t sync the Account associated to an Item.
11. Bill/Invoice numbering
- When numbering invoices/bills, each needs a unique number to avoid the sync number matching to an incorrect invoice/bill.
12. AR Invoice Payments
- AR payments in Bill.com will only sync to Xero if applied to an invoice; overpayments/unapplied payments will not sync to Xero.