Import invoices, bills and credit notes into Xero

Import invoices, bills and credit notes from another accounting system into Xero using Xero's CSV template. If you have invoices or bills in MYOB, you can export them as a CSV and import them directly into Xero. You'll need to import invoices and bills in separate batches. To import credit notes, add them as invoices or bills with negative amounts. If you have the multi-currency option, you can import invoices, bills and credit notes in foreign currency. Your invoices, bills and credit notes come into Xero as drafts, for you to review and approve as normal.

Banking video Video (4.17) Importing sales and purchases

You can't import payslips into Xero. To create payslips and bills associated with payroll, you'll need to do so within Accounts > Pay Run.

To import invoices or bills into Xero go to either Accounts > Sales or Accounts > Purchases and click on Import. All users who have access to invoices or bills can import.

Invoice or bill data imported into Xero is treated in the same way as if you'd manually entered it into Xero - you're using the CSV as a way to quickly import the data into the invoice or bill fields. Please review the rules for the CSV and Xero invoices or bills below. The invoices or bills in Xero may have slightly different totals to ones you've issued your customers before using Xero. You can use a reconciliation adjustment to reconcile the payment received in your bank account when that payment is different to the invoice or bill in Xero.

Import sales invoices or bills to match conversion account balance

You can only import sales invoices or bills into Xero after setup is complete.

  1. In Xero, go to Sales and Purchases to import your invoices or bills as described below, and approve them. The dates for all these items should be before your Conversion Date.
  2. When all items are approved (have a status of Awaiting Payment) the totals of these items on the Awaiting Payment tabs in Sales and Purchases should match the balances you have from your previous system. Enter these totals on the Conversion Balance screen as the Accounts Receivable (Sales) and Accounts Payable (Purchases) balances and save the balances.
    Balances
  3. Enter the period lock date to be the date of your conversion date so that nothing is accidentally entered before this date.

Create & import your invoice or bill file

From any tab in Sales or Purchases, choose the Import button to go to the Import sales invoices or bills screen. The import process is the same for invoices and bills but you must import them from the relevant section in Xero.

Import

If you want to start with Xero's blank template or reformat your invoices or bills exported out of an existing system to match the template, you'll need to go to the Import invoices or bills screen initially to get the template. If you have a CSV file of invoices or bills that you've already exported from MYOB this will import directly into Xero as long as the column headings exported from MYOB exactly match those expected by Xero.

A CSV file is a document that is formatted with Comma Separated Values. The most common software program used to create or edit a CSV file is Microsoft Excel although many other programs will let you save a file in CSV format i.e. somefilename.csv. Xero will also accept comma separated values in a text-based file (created by a program like Notepad or Text Edit) which when saved will have a name like somefilename.txt. You need to save your file in the CSV format, and not just rename a file so that it contains '.csv' or '.txt'. As long as you follow some specific rules below, Xero will understand the data you put into your CSV file and will know how to create your invoices or bills from it.

Invoices and bills in foreign currency

Download template

Template

If you're importing a file from MYOB you don't need to use Xero's template - just choose the MYOB option and import your file.

Use the Xero template

Sales invoice or bill data needs to be imported into Xero in the CSV format from a .csv or .txt file using a template that Xero can use to map values in your file to the relevant invoice or bill fields in Xero.

To open the blank template containing the headings under which you need to enter your invoice or bill details, go to Accounts > Sales or Purchases > Import, then click the Download template file link.

Depending on how your computer is set up, the CSV template provided by Xero will most likely open in Microsoft Excel.

Import template

Import template

Note: whether you use the Xero or MYOB import option, this importing tool allows the simple import of raw invoice data into Xero - any additional fields, formatting, currency symbols, attachments or anything else attached to your invoices in another accounting system will not be imported. Similarly if you add columns or the column headings on the CSV file you're importing into Xero differ from the exact column headings Xero expects, the file will fail to import. If there is anything wrong with the data on an individual invoice (that is, Xero can't interpret the data according to the invoice fields in Xero) then that invoice won't be imported. You will get a chance to see any errors that occurred with the import on the Import Summary screen.

Enter invoice or bill data

If you're importing an MYOB file you don't follow these guidelines for editing the CSV - go straight to importing the MYOB file.

 

Enter or copy your sales invoice or bill data into the CSV file

Whether you started with the blank Xero template or got a file of your sales invoice or bill data from another system, enter or change the data in the columns provided in the CSV file.

The Xero template contains column headings under which you should enter or copy your invoice or bill data. The CSV file contains all the invoice or bill fields in the Xero database. Some of these are editable in Xero and some not. This means that there are columns in the CSV file that you should not use. Just enter data into the columns that you would normally use if you were entering an invoice or a bill in Xero. To create credit notes, enter negative amounts.

CSV import template

If you're not familiar with the Xero invoice or bill entry screen, you might like to take a look at one first so that the columns make some sense. The CSV file essentially 'maps' columns to invoice or bill fields in Xero so by completing the information column by column, you're essentially 'filling in' the fields in Xero automatically. The columns to use and rules for the data entered into them are explained below.

AR invoice

If you're not familiar working with CSV files, you'll probably find it easier to use Microsoft Excel because you can work with your data in columns rather than in a straight line separated by commas as with a text editing program.

Blank TXT

Columns & rules for entering invoice or bill data

Enter your invoice or bill data into the CSV file, one invoice or bill per row, under the column headings provided (one column for each field on the invoice or bill) - or one invoice or bill line item per row if it has multiple line items (below). The header row is mandatory and some columns may be deleted if not used - full details below in the section Tips for ensuring a successful import.

If you're working with a CSV file from another source and have opened it in Microsoft Excel, make sure the comma separated data is spread across the columns under each relevant heading rather than all data displaying in the first column of the spreadsheet. Sometimes this happens by default if you open the CSV using Microsoft Excel. To ensure the data displays correctly, you might need to open Microsoft Excel first then use the import feature in Microsoft Excel to import the CSV data. If all your data appears as comma separated in the first column of the spreadsheet it will fail to import into Xero.

Convert TXT data into columns

Once imported, data will be entered and saved as a draft invoice or bill. You'll need to check and enter mandatory data in the draft invoice or bill before you can approve it. In some cases you might be able to import data into Xero that isn't valid when it comes time to approve the invoice or bill e.g. the date entered is in a locked period or a field has been left blank. Your CSV needs to comply with these same rules as if entering a draft invoice or bill directly in Xero. Refer to the help for fields and validation when entering an invoice or bill in Xero normally - Add a sales invoice or Add a bill.

Use the following columns on the CSV template file for your sales invoice or bill data

On the CSV file, complete the columns that are mandatory - these are marked with an asterisk (*). Choose whether to complete the others (you'll be required to edit and complete the missing fields directly on the sales invoice or bill in Xero before approving it) and ignore columns not listed below.

Template file heading

Invoice or bill field in Xero

Rules/Notes

ContactName To or From

Mandatory for import.

If customer or supplier doesn't already exist (with this name) in Xero they will be created as a new Contact. See tip below for more information.

EmailAddress Email address

Decide if you want Xero to update your contacts' email addresses.

If you decide to update contact address details, Xero overrides your existing contact email addresses.

Image showing csv import screen

Your contacts' email addresses don't appear on invoices or bills. However, Xero includes email addresses in your contacts' records.

POAddressLine1
POAddressLine2
POAddressLine3
POAddressLine4
POCity
PORegion
POPostalCode/
POZipCode
POCountry

Street or PO Box address lines, town/city, state/region, postal or zip code and country fields

Decide if you want Xero to update your contacts' address details.

If you decide to update contact address details, Xero overrides your existing contact address details.

Image showing csv import screen

Your contacts' address details don't appear on draft invoices or bills. However, they appear on approved invoices and bills.

InvoiceNumber

Invoice # (Sales)

Reference (Purchases)

Mandatory for import (Sales invoices) & unique.

This is the unique number mandatory on sales invoices. There is no invoice number field on bills, so the number entered will be displayed in the Reference field.

See tip below for more information on using invoice numbers, including using them to import invoices or bills with multiple lines

Reference (Sales CSV only) Reference (Sales)

Sales invoices can have an additional reference number. (This column does not display on the Purchases CSV template downloaded.)

InvoiceDate Date

Mandatory for import.

Must be entered as dd/mm/yyyy mm/dd/yyyy or as written out in full

DueDate Due Date

Mandatory for import.

Must be entered as dd/mm/yyyy mm/dd/yyyy or as written out in full

See tip below for more information on date entry.

Total  

This is a field used for checking your transactions totals.

This field does not display on the invoice or bill in Xero - and should not be completed on the CSV file. This field is typically for UK customers only.

See tip below for more information on tax and price calculation.

Inventory Item Code Item

Inventory item codes that you want to import.
Find out more about inventory items

Check the tips for a successful import

Description Description

Mandatory for import.

Description for the sales invoice or bill, or for the line item on it if more than one item.

Find out more about inventory items

Quantity Qty

Mandatory for import.

Number of items for the sales invoice or bill, or for the line item on it if more than one item.

You can leave this blank and it will default to '1' on the invoice or bill in Xero as it does if you're entering it manually.

UnitAmount Unit Price

Mandatory for import.

The tax exclusive price for the sales invoice or bill, or for the line item on it if more than one item.

Xero will use the unit amount with the quantity and tax rate to calculate the overall invoice or bill total for you. (There is no need to enter the total on the CSV.) See tip below for more information on tax and price calculation.

Special currency formats are expected for organisations based in France or Germany.

Discount (Sales CSV only) Disc %

The discount percentage you want to apply to the sales invoice line item. Enter the number to 2 d.p. without the % sign.

AccountCode Account

Mandatory for import.

The account in your Chart of Accounts you want the sales invoice or bill, or line item if more than one item, to be coded to. Enter the Chart of Accounts code only e.g. 200 - Sales, enter 200 only.

TaxType Tax Rate

Mandatory for import.

The sales tax rate to be applied to the invoice or bill, or line item if more than one item. Enter the name of the tax rate as it is set up in Xero, whether it is a default rate or one you have set up yourself. If the tax rate name contains words and a percentage, enter it in full as it appears in Xero e.g. 15% GST on IncomeGST on Income20% (VAT on Expenses)Tax on Purchases (8.25%).

See tip below for more information on correctly importing account, tax and tracking information.

TaxAmount  

This field does not display on the invoice or bill in Xero - and should not be completed on the CSV file. Only use it if you want to make a tax adjustment on your sales invoice or bill (typically UK users).

This column doesn't appear on our template CSV file. However, you can add it to the CSV file if you want to make a tax adjustment on your invoice or bill.

See tip below for more information on tax and price calculation.

TrackingName1 [Category name]

The name of the first (or only) tracking category as it appears on the sales invoice or bill in Xero.

TrackingOption1 [Category option]

The name of one of the options that belong to the first tracking category.

TrackingName2 [Category name]

The name of the second tracking category as it appears on the sales invoice or bill in Xero.

TrackingOption2 [Category option]

The name of one of the options that belong to the second tracking category.

See tip below for more information on tax and price calculation.

Currency Currency

The three letter currency code if the amount is not in your base currency.

See tip below for more information on entering foreign currency invoices and bills.

Branding Theme Branding

The branding theme you want to apply to each of your sales invoices. (This field isn't used for bills.)

Find out more about branding themes

Tips for ensuring a successful import:

  • You must leave the first row in place as the header row and all mandatory columns must be present on the template file. If you're copying data from another system, make sure you use these same column headings. If you delete the header row, Xero will not import your file.
  • You can delete any columns that aren't mandatory although there's no harm in leaving them empty.
  • If you are using Microsoft Excel to create your CSV file take care not to enter figures and symbols which could be automatically reconfigured by Microsoft Excel to read as dates or numbers or some other formula as this may prevent the file from being successfully imported.
  • Special currency formats are required for organisations based in France or Germany. If the following formats are not used, amounts may import incorrectly, or your import may fail:
    • France: 1100,00
    • Germany: 1.000,00
    This applies to inventory item formats too. This is based on your location in Organisation Settings, not on the currency for each invoice or bill (if you have multi-currency). In all other regions the decimal place is marked with '.' (a period) as usual, and a comma will not be accepted.

Contact details (customer or supplier names)

  • The rules Xero uses for determining whether the Contact (customer or supplier) already exists in Xero are the same as if you entered the invoice or bill manually in Xero i.e. if the name isn't spelled the same or doesn't already exist, Xero will assume it's a new Contact.
  • You don't have to have Contacts set up in Xero first, but if you do, and you want to retain the names you have already used, make sure the Contact names on your CSV are the same as those already in Xero.
  • If the email and street/PO Box fields are left blank, Xero will assume you want to leave the corresponding fields as they are (i.e. retain any existing information already in Xero for this Contact).

Invoice numbers

  • Sales invoices in Xero have an automatic number sequence. The invoices you import don't have to use the same numbering sequence and won't affect the invoice number sequence in Xero (whether you've used it for invoices or not) unless invoice numbers on the CSV are the same as those already used by invoices in Xero.
  • If you want to keep the same invoice number sequence on the CSV, make sure you enter the invoice number in the same format as it is in Xero e.g. INV-0001 (or whatever combination of letters and/or numbers you've set up).
  • Sales invoice numbers can't be used on the CSV if an invoice with the same number already exists in Xero. You will be prompted on the import summary screen if an invoice will fail to import because it has the same invoice number as an invoice already in Xero so that you have a chance to change it. Only if an invoice has been deleted, can you use the same number again.
  • Bills do not have a mandatory number in Xero, but if you want to include a bill number as a reference, enter it in the InvoiceNumber column on the CSV. The number will be put into the Reference field on the draft bill in Xero. The number must be unique within the CSV but you can remove it from the draft bill or change it as required after the import.
  • All invoice numbers or bill reference numbers used on the CSV must be unique because this is what distinguishes one invoice from the next - this is especially important if you want to import invoices or bills that have more than one line item. Each line item is given the same number in order to identify it as being part of the same transaction.

Invoice date and Due date

  • For bills, use the 'Invoice date' column for the date of the bill.
  • Formats must be dd/mm/yyyy mm/dd/yyyy or as written out in full. Double-check these because your regionalised computer settings may override the date formats. If you find this happens, you'll need to reformat the date cells in Microsoft Excel.
  • Xero doesn't apply default due dates (in other words, payment terms for the organisation or individual contacts) to invoices or bills you import. If you want to import due dates, enter these into the import template.

Inventory items

  • When you import an invoice or a bill, you can include inventory items. Download the CSV template file and enter the inventory item codes you want to import into Xero.
  • If you import an inventory item code that's already in Xero, but use a different unit amount, the unique unit amount will import with your invoice or bill. This won't change the inventory item's unit amount under Settings > Inventory Items.
  • If you import an inventory item code that isn't in Xero, a new inventory item code will be created.
    Check the tips for a successful import
  • CSV import template

Chart of Accounts, Tax & Tracking

  • Enter only accounts in the Chart of Accounts, Tax Rates and Tracking options and categories that already exist in Xero. These need to be entered correctly (i.e. spelled and formatted the same as in Xero) otherwise what you enter on the CSV will not be recognised and therefore not imported into Xero. The exception to this is the Tax Rate - if you enter the tax rate name incorrectly or enter a rate that doesn't exist in Xero, the field on the invoice or bill will come through as blank.
  • If a tax rate you're using is made up of several components in Xero, you don't need to worry about this on the CSV. Just enter the overall tax rate name in the TaxType field and Xero will calculate the correct tax amounts for each component percentage when the invoice or bill is approved, and record these amounts against the relevant component and tax rate in your reports.

Tax amounts & totals

  • Invoice, credit note or bill totals - Xero will calculate the overall invoice or bill total for you based on the UnitAmount and TaxType entered on your CSV. You should review and adjust your figures as necessary on the draft invoice or bill once it's imported to make sure the final total and tax calculation is correct. This is important so that you can ensure the right tax rate has been used and tax adjustments (see below) have applied or removed as necessary.
  • Tax is calculated on each line of an invoice or bill in Xero behind the scenes and displayed as a total tax amount for each tax rate used in the subtotal for the invoice or bill. This means that sometimes, often because of multiple lines or tax rates, that the final invoice or bill amount calculated by Xero and displayed on the draft might be slightly different to the total on your original one. You can edit the invoice or bill or leave a small amount as rounding when it displays as such on it.
  • The TaxAmount field can be used for tax adjustments - you can force a particular tax amount for your line item that is different to the tax that will be calculated by Xero based on the tax rate you've entered in the TaxType column. This is mostly for those in the UK who want to apply a VAT adjustment on an invoice or bill. Make sure you've completed both the TaxType field and your specific amount of tax - Xero will display the difference in a tax adjustments box on the invoice or bill once imported. The tax adjustments box will appear on any invoice or bill where an amount of tax has been entered in the TaxAmount column that doesn't match Xero's calculation. If your country doesn't allow the adjustment of tax on an invoice or bill you shouldn't use this column. However, if an adjustment amount does make its way onto your invoice or bill, you can edit it to remove it (enter 0.00 in the adjustments box to revert the tax amount to match the tax rate).
  • If you want to use this field, you will need to manually add it to our template CSV file.

Invoices or bills with more than one line item

You can use the invoice number on your CSV to group several rows together to be a multi-line invoice or bill in Xero. All line items for the same invoice or bill must have the same invoice number and currency (if you have the multi-currency option enabled).

CSV template file with one detailed line and two less detailed below it, for a multi-line invoice.

In the first row, enter the main information including the total and the first line of the invoice or bill. On the lines underneath, complete only those fields relevant to each line item. There is no need to repeat the contact name each time.

Draft multi-line invoice with three lines highlighted.

MYOB

Import an MYOB file

If you have a file of sales invoices or bills that you've exported from MYOB, you can import the file directly into Xero as long as it is a CSV or TXT file, and the column headings match those which Xero expects to find, as shown in the table below.

  • Using the 'Export Data' option in MYOB, choose to export your invoice or bill data as sales or purchases and within that, items or services. Make sure the file you've exported from MYOB is in a comma delimited format, and is saved as .csv or .txt

MYOB export

  • Choose from corresponding type of file to import into Xero i.e. Sales by Item or Sales by Services (for importing sales invoices) or Purchase by Item or Purchase by Services (for importing bills).

MYOB

  • Xero understands the column headings exported by MYOB (as shown in the table below) so you shouldn't need to open the CSV file to change them.
  • Xero allows for some frequently used slight variations on some column heading names (e.g. "Invoice No." can be imported successfully with either a single or double space between the words and "Invoice #" will also be imported successfully). If you're in doubt, or if there is a problem with the import, check that the headings in your CSV file match those shown under 'MYOB file column heading' in the table below.
  • It's likely that the file exported from MYOB will have far more columns in it than is allowed by Xero and these extra columns will be ignored during the import e.g. notes, journal memo, discount, ship via etc.
  • The following columns on the file you export from MYOB will be imported into Xero. The invoice or bill data imported in the MYOB file follows the same rules as if you were populating the Xero CSV template yourself so if you want to know anything specific about any of the columns being imported, refer to the Xero CSV template information above.

MYOB file column heading

Sales invoice or bill field in Xero

Rules/Notes

Service Sales or Item Sales

Sales invoices

 

Co./Last Name

To or From (Contact)

Mandatory.

If customer doesn't already exist (with this name) in Xero, they will be created as a new Contact.

Invoice  No./Invoice # Invoice #

Mandatory.

This is the unique invoice number mandatory on sales (customer) invoices.

Invoice number is unique in the CSV file and is repeated on several rows if an invoice has several line items (one line item per row).

Customer PO

Reference

Sales invoices can have an additional reference number.

Date

Date

Due Date

There's only one date exported from MYOB so this date will be imported into both the Date and Due Date fields on the Xero draft invoice. You can edit the draft invoice to change the Due Date if you want it to be different.

Must be dd/mm/yyyy or written out in full

Quantity (Item Sales only)

Qty

Number of items for the invoice, or for the line item on the invoice if more than one item.

Item Number Inventory Item Code Inventory item code for the invoice.

Description

Description

Description for the invoice, or for the line item on the invoice if more than one item.

Price (Item Sales) Unit Price The tax exclusive price for the invoice, or for the line item on the invoice if more than one item.

Amount (Service Sales)

Unit Price

The tax exclusive price for the invoice, or for the line item on the invoice if more than one item.

Account  No./ Account #

Account

The account in your Chart of Accounts you want the invoice, or line item if more than one item, to be coded to. Enter the Chart of Accounts code only e.g. 200 - Sales, enter 200 only.

GST Code

Tax Rate

The sales tax rate to be applied to the invoice, or line item if more than one item.

Xero understands MYOB GST codes and will convert these to Xero Tax Rates when imported and displayed on the draft invoice. If you want to know how MYOB GST codes are mapped to Xero GST Tax Rates, refer to the mapping rules that are used for importing a Chart of Accounts from MYOB.

GST Amount

-

Does not appear on the invoice in Xero, however it will be imported to make up the TaxTotal above.

Service Purchases/Item Purchases

Purchases

 

Co./Last Name

To or From (Contact)

Mandatory.

If supplier doesn't already exist (with this name) in Xero, they will be created as a new Contact.

Purchase No./Purchase # -

This number will not appear on the bill in Xero.

Supplier Invoice No./Supplier Invoice # Reference

There is no invoice number field in bill but the number entered will be displayed in the Reference field.

Date

Date

Due Date

There's only one date exported from MYOB so this date will be imported into both the Date and Due Date fields on the Xero draft bill. You can edit the draft bill to change the Due Date if you want it to be different.

Must be dd/mm/yyyy or written out in full

Quantity Qty Number of items for the bill, or for the line item on the bill if more than one item.
Item Number Inventory Item Code Inventory item code for the bill.

Description

Description

Description for the bill, or for the line item on the bill if more than one item.

Amount (Service Purchases)/Price (Item Purchases) Unit Price The tax exclusive price for the bill, or for the line item on the bill if more than one item.

Account  No./Account #

Account

The account in your Chart of Accounts you want the bill, or line item if more than one item, to be coded to. Enter the Chart of Accounts code only e.g. 453 - Office Expenses, enter 453 only.

GST Code/Tax Code

Tax Rate

The sales tax rate to be applied to the bill, or line item if more than one item.

Xero understands MYOB GST codes and will convert these to Xero Tax Rates when imported and displayed on the draft bill. If you want to know how MYOB GST codes are mapped to Xero GST Tax Rates, refer to the mapping rules that are used for importing a Chart of Accounts from MYOB.

GST Amount

-

Does not appear on the bill in Xero, however it will be imported to make up the TaxTotal above.

  • Each overall invoice, bill or credit note total will be calculated by Xero when the data is imported using the Quantity, Amount and GST Code data supplied from MYOB.
  • There is more data that you can import on the Xero CSV template than in the MYOB file so if you want to use the additional columns available, copy the data from your MYOB file onto the Xero CSV e.g. customer address information, tracking options/categories.
  • Select the file to import and review the confirm the import on the summary screen (same steps as if you were importing a Xero CSV template).

In the same way as if you were using the Xero CSV template, this importing tool allows the simple import of raw invoice or bill data into Xero. Any additional fields, formatting, currency symbols, attachments or anything else attached to your invoices or bills in MYOB will not be imported. Similarly if you add columns on the MYOB file you're importing into Xero, the file will fail to import. If there is anything wrong with the data on an individual invoice or bill (i.e. Xero can't interpret the data according to the fields in Xero) then that invoice or bill won't be imported. You will get a chance to see any errors that occurred with the import on the Import Summary screen.

Import

Browse

Import

button - cancel-61225426.png

 

Locate and select the file to import

Click the Browse button to locate the CSV or TXT file you want to import into Xero.

Select file

Browse your computer's file system to find the CSV file you've saved on your computer.

Browse

  • Make sure you have saved the file you want to import.
  • Xero will only accept a file with the suffix .csv or .txt.
  • You can import a large number of sales invoices or bills at once (as long as the overall file size is less than 2MB) however for speed purposes we suggest that you import no more than 500 at one time. If you have more than this you can just keep on importing files of invoices or bill in groups of 500 and these will be added to those already imported into Xero.

Click the Update button to bring the invoice or bill data from the file into Xero where you will be asked to Confirm the import before finally importing the data as invoices or bills into Xero.

Import file

Click the Cancel button if you want to stop the import process for now.

Confirm the import

Confirm

Complete

Go back

Review the sales invoices or bills to be imported

Once you have created or downloaded your invoice or bill file and selected it as a .csv or .txt to import into Xero, you can review what's going to be imported before finally completing the process.

  • As long as you have followed the guidelines for entering invoices or bills on the CSV, or your MYOB file contains data Xero expects, you'll see that Xero will import the same number of invoices or bills into Xero as you have on your CSV.
  • If there is something wrong with the structure of your file i.e. missing or incorrectly labelled columns, missing header row, incorrect format, line totals not correct (only if you've used them) Xero will not import the file.
  • If individual invoices or bills on your CSV cannot be imported, the reasons why will be listed so that you can stop the import process to fix your CSV and try again.
  • Use the line item numbers given in the list of errors to identify where, on your CSV, the invoices or bills that need to be fixed are.

Import errors

  • In Microsoft Excel the line numbers correspond to the row number.
  • If you're working with a text (TXT) file in the Notepad program, line numbers will be displayed if you have the program set up to show the status bar (do this from the 'View' menu).

Text file error

  • If you want to address the errors on your CSV file, use the Go Back button to stop the import process to make corrections on your CSV before importing it again.
  • If you want to proceed without importing the problem invoices or bills, click the Complete Import button. You can manually add the missing invoices or bills in Xero or import another CSV containing those that weren't imported.

View & process the imported sales invoices or bills

View

Once imported, your sales invoices and bills will display on the Sales or Purchases Draft tab depending on the section of Xero you were in when you chose to import. From there you can process the draft invoices or bills in the normal way.