Uploading Invoices into Xero

Overview

Avionté now integrates with cloud-based accounting software, Xero. Below are instructions on how to get your invoices from Avionté to Xero.

  • Integrated BOLD clients: The data comes from the Front Office timesheet totals that are sent to Back Office (and not the Back Office invoices).

 

Pin Report
Filters
Terms
Import and Approve

 

 

Pin Report

To locate the Xero Invoice Report, click into the “Reports” tab and simply type “Xero” into the search bar. We recommend you pin it to the top for easy access, as highlighted below:

 

 

Filters

Under the “Report Filters”, select the appropriate invoice by pay date.  Note: there might be multiple invoices listed by the same date—make sure to select the company’s invoice by time created.

 

 

Make sure to double check the data displayed in the columns is correct.  You can re-arrange the order of the columns by clicking and dragging.

When you’re ready to import into Xero, navigate to the bottom right and click “Export to Excel”.  This is the file you will be importing into Xero so make sure to save it as a CSV file.

 

 

Terms

Here is a list of terms

  • Description = contractor’s name
  • Quantity = hours worked
  • Unit = bill rate
  • Account code = tax type

 

 

Import and Approve

Once you’ve saved your file, log into Xero.  Under the “Accounts” tab, select “Sales” from the drop-down.

 

 

Click the Import button

 

 

 

Navigate to “Step 3” and select “Browse” to open your saved CSV file from Avionté. Once selected, click “Import” at the bottom.

Note: you will NOT need to download the invoices template in Step 1, as the Avionté report is already configured to the correct column headings required by Xero.

 

 

You will see a notification alerting you to the number of invoices being imported.  If this number does not match with the number of invoices you’re trying to import, click “Go Back” to re-upload another CSV.

 

 

Once imported, the invoice will appear as a draft.  You can make any last-minute edits before approving.

To approve multiple invoices simultaneously, select the checkbox on the left side, next to the invoice number.

 

 

 

Alternatively, you can drill into an invoice by clicking into the company name (the “To” column).

 

 

Once approved, you’re all set!

 

Back to Top

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share