---
title: Xero – Import Service Provider Bills from Usked
description: "**Import Supplier, Vendor, and Contractor Bills into Xero via Bulk CSV Import** ## **Purpose** This procedure outlines the steps to export payroll bill data from Usked and import supplier, vendor, and contractor bills into Xero using the bulk CSV import…"
url: "https://usked.com/kb/xero-import-service-provider-bills-from-usked/"
updated: "2026-03-12"
category: "How-To Tutorials / Accounting Integrations"
---

# Xero – Import Service Provider Bills from Usked

**Import Supplier, Vendor, and Contractor Bills into Xero via Bulk CSV Import**

## **Purpose**

This procedure outlines the steps to export payroll bill data from Usked and import supplier, vendor, and contractor bills into Xero using the bulk CSV import feature.

## **Prerequisites**

- Active access to Xero
- Access to your Usked account
- Bills exported in CSV format
- Valid Account Codes configured in Xero
- Valid Tax Types configured in Xero
- Spreadsheet editor (Excel or equivalent)

**System Access**

**System:** [XERO](https://login.xero.com/identity/user/login?ReturnUrl=%2Fidentity%2Fconnect%2Fauthorize%2Fcallback%3Fclient_id%3Dxero_business_go%26redirect_uri%3Dhttps%253A%252F%252Fgo.xero.com%252Foidc%252Fcallback.html%26response_type%3Dcode%26scope%3Dopenid%2520profile%2520email%2520xero_frontend-apis%2520xero_frontend-platform-apis%26state%3Dbbea3ad7672a433c9d8e7f6ac862862d%26code_challenge%3DwyLYZxgrRdU4-x3rP52lOWX1_42GLGtHPs2ld_Qjw_I%26code_challenge_method%3DS256%26response_mode%3Dquery)

**Login:** Log in to Xero using your assigned credentials.

Additional: [**How to Import Bills into Xero**](https://www.youtube.com/watch?v=ZJ8uOK-TIVM)

## **Part 1: Export Bill CSV from Usked**

### **Step 1: Access Payroll Reports**

1. Log in to your Usked account.
2. Navigate to:
   **Billing > Invoices & Payroll > Payroll Reports**

![image](https://usked.com/wp-content/uploads/2026/03/image.png)

### **Step 2: Export QuickBooks Bill CSV**

1. Locate the correct payroll report.
2. Click the **QB Bill Export** button.
3. On the next screen:

   - Click **Yes** to simplify the rows and minimize bill details.
   - Click **Search**.
   - Click **Download CSV File**.
4. Save the CSV file to your computer.

![image 1](https://usked.com/wp-content/uploads/2026/03/image-1.png)

![image 3](https://usked.com/wp-content/uploads/2026/03/image-3.png)

**Part 2: Download and Prepare the Xero Import Template**

**Importing bills into XERO: **

### **Step 1: Access the Bill Import Function**

1. Log in to Xero.
2. Navigate to the **Purchases** menu.
3. Click **Bills**.
4. Click the dropdown arrow next to the green **New Bill** button.
5. Select **Import from CSV**.

![image 7](https://usked.com/wp-content/uploads/2026/03/image-7-1024x548.png)

![image 6](https://usked.com/wp-content/uploads/2026/03/image-6-1024x458.png)

### **Step 2: Download the Template**

1. Click **Download the Xero import template**.
2. Open the template using Excel or another spreadsheet editor.

### **Step 3: Copy and Paste Bill Data**

1. Open the Usked QuickBooks Bill Export CSV file.
2. Copy the bill data.
3. Paste the data into the Xero template.
4. Ensure all information matches the column headings exactly.
5. Save the completed file as a CSV.

## **Important Template Guidelines**

- Do NOT modify the column headings in the Xero template.
- All fields marked with an asterisk (*) are required.
- Dates must be in U.S. format:

  - Example: 12/25/2026 or Dec 25 2026
- Contact names must match exactly how they appear in Xero.

  - This prevents duplicate supplier or contractor records.
- Save the file in CSV format before importing.

## **Required Field Mapping**

**InventoryItemCode**

- Use the **LineItem** column from the QuickBooks export file.

**AccountCode**

- Use only valid numeric account codes from Xero’s Chart of Accounts.

**TaxType**

- Use only tax types configured in Xero.

**Tax Exempt Services**

- For independent contractors or tax-exempt services, use:
  **Tax Exempt (0%)**

## **Part 3: Import the Bills into Xero**

### **Step 1: Upload the CSV File**

1. Navigate to the **Import from CSV** screen in Xero.
2. Click **Select File**.
3. Choose your completed Xero template CSV file.
4. Click **Confirm**.
5. Click **Complete Import**.

![image 2](https://usked.com/wp-content/uploads/2026/03/image-2.png)

![image 5](https://usked.com/wp-content/uploads/2026/03/image-5-1024x503.png)

## **Part 4: Review, Edit, and Approve Bills**

After import, bills will appear in draft status.

### **To Review or Edit Bills**

1. Locate the imported bill.
2. Click the **eye icon** to open the bill.
3. Review the information.
4. Make edits if necessary.
5. Click **Save** after making changes.

![image 4](https://usked.com/wp-content/uploads/2026/03/image-4-1024x394.png)

### **To Approve Bills**

Bills must be approved individually.

**Option 1: Approve the Bill**

1. Select the bill.
2. Click **Approve**.

**Option 2: Submit for Approval**

1. Select the bill.
2. Click **Submit for Approval**.

Once approved, bills will move to the appropriate status for payment processing.