How to Import Bills to Xero

Goal:

• The following article details how to export Bills from Procurify and Import Bills into Xero. A note on taxes before we begin, Xero calculates sales tax/GST/VAT after the fact, on a line-item basis. You, therefore, don't worry about taxes at all in Procurify: don't add them as line items on requests, PO's, or Bills. Let Xero add taxes when it imports Bills. The Xero template example provide are general guidelines and do not account for unique customizations. 

Steps:

#1) Click the following link to create a Procurify Template for Export: This step will only need to be completed once. After you've created the template, you'll be able to easily access and export this template every time you wish to import Bills into Xero. 

#2) Export your Bills from Procurify: Note: be sure to include an invoice number, when creating bills, otherwise, Xero will think everything on the export is all one bill and won't differentiate between bills.

1. In Procurify's Application select SETTINGS → Export Data
2. Select PREPARE CSV next to Bills
3. Select the Xero from the dropdown Default Format
4. Enter the appropriate Invoice Date  
5. Select Export CSV 

#3) Import your CSV to Xero 

1. Open your Xero account
2. From the Accounts tab, choose Purchases
3. Click the Import button at the top
4. Browse and select your file
5. Choose whether these bills are tax exclusive or inclusive
6. Click the Import button
7. You'll be taken to a page titled Import your bills, where you find out if your CSV worked; it will tell you how many bills you're importing and if there are any errors
8. If everything looks good, click Complete Import. You're now at the Draft Bills page, where you can edit bills as seen here: