CSV import: Import and export supplier information

Using the import and export features on the Suppliers list, you can easily:

• Export your Suppliers list in one of several standard formats (CSV, Excel, Word, PDF) so that you can print or use the information in another application
• Quickly update your Suppliers list by exporting selected data, making changes, and then importing your changes

To display the Suppliers list, go to Accounts Payable > All > Suppliers.

Export supplier information

You can export anything that you can display in the Suppliers list. This allows you to precisely control what gets exported, including the columns of data, display and sort order, and the list of suppliers that's included.

Create a new view

To control what gets exported, you can create a custom view of the Suppliers list that includes just the data you want to see.

1. Go to Accounts Payable > All > Suppliers.

2. Select New from the Manage view dropdown menu at the top of the Suppliers list.
3. In View name, provide the name that you want to appear in the list of views.

4. In Columns, add, remove, and reorder columns to select the data you want to include.

   You can choose from standard supplier fields (such as name and ID), fields from the supplier contact record, as well as any custom fields that you've created for your company.

5. In Filters, select how you want the data to be filtered by default.

   If you're creating the view at the top level, select Include entity records if you want to include suppliers created at the entity level.

6. In Sort, select the default sorting that you want to use.
7. In Shared, either leave the view set to Private or select Shared to make it available to other users.
8. Select Save.

1. Go to Accounts Payable > All > Suppliers.

2. Locate the Manage views dropdown menu at the top of the Suppliers list, and choose Create New View.

3. On Step 1 of the Create New View wizard, select the columns of data you want to include.

   You can choose from standard supplier fields (such as name and ID), fields from the supplier contact record, as well as any custom fields that you've created for your company.

4. Make your changes.

   Using the wizard, you can:

   • Choose the order in which columns appear.
   • Filter the list of suppliers, such as filtering for suppliers who are located in a specific state or territory or suppliers whose preferred payment method is ACH.
   • Choose the sort order for columns; for example, sorting suppliers by last name.

Export the Suppliers list

1. Select the list view that includes the data you want to export, if it is not already selected.

   Intacct exports the data that displays in the list at the time you select Export. Be sure it is sorted and filtered the way you want, and that all necessary columns are included.

   You can also customize the existing view to sort and filter data as you want it, instead of selecting a saved view.

2. Select Export at the top of the page and select an export format from the dropdown.

   Export format option descriptions

   Export format	Description
   CSV	Comma-separated-values (.csv) file that can be opened by most spreadsheet applications.
   Excel	Microsoft Excel (.xls) file.
   Word	Microsoft Word (.doc) file.
   PDF	Adobe PDF file (.pdf).
   CSV for Import	Comma-separated values (.csv) file that includes suppliers and fields in a format that you can use to update your Suppliers list. With CSV for Import, if the current view of the Suppliers list contains any fields that can't be updated through an import process, those fields won't be included in the export file.

1. If you haven't already done so, choose the list view that includes the data you want to export, or customize the columns in the existing view.

   • At the top of the Suppliers list, select the All dropdown menu and then choose the name of the view that you previously created.
   • If you don't select a view before exporting the Suppliers list, your export file will include the list of suppliers and columns that you currently see in the Suppliers list.

2. Select Export at the top of the page and select an export format from the dropdown.

   Export format option descriptions

   Export format	Description
   CSV	Comma-separated-values (.csv) file that can be opened by most spreadsheet applications.
   Excel	Microsoft Excel (.xls) file.
   Word	Microsoft Word (.doc) file.
   PDF	Adobe PDF file (.pdf).
   CSV for Import	Comma-separated values (.csv) file that includes suppliers and fields in a format that you can use to update your Suppliers list. With CSV for Import, if the current view of the Suppliers list contains any fields that can't be updated through an import process, those fields won't be included in the export file.

Use CSV import to update supplier information

You can quickly update information for multiple suppliers at once by exporting supplier data in "CSV for Import" format, editing the resulting spreadsheet, and then importing your changes.

A CSV import works well for:

• Updating information for multiple suppliers at once: Using a CSV import, you can update selected data for multiple suppliers. For example, you can export the Suppliers list with the Email Address field included, add or modify the email addresses in a spreadsheet application, and then import your changes.
• Adding new suppliers to your existing Suppliers list: Using a CSV import, you quickly add new suppliers without having to create the suppliers one at a time. Any spreadsheet row that contains a unique Supplier ID will be added as a new supplier record, provided that you've included all required information.

Export the Suppliers list in "CSV for Import" format

Before starting this process, it's recommended that you create a custom view of your Suppliers list that includes the suppliers and columns you want to update. That way, when you export the Suppliers list, you'll have a spreadsheet that's tailored to the information you want to change.

1. If you haven't already done so, choose the list view that includes the data you want to export.

   • At the top of the Suppliers list, select the All dropdown menu and choose the name of the view that you previously created.
   • If you don't select a view before exporting the Suppliers list, your export file includes the list of suppliers and columns that you currently see in the Suppliers list.
2. Export the Suppliers list in CSV for Import format.

Update the CSV file

1. Open the CSV file in a spreadsheet application.

2. Update the spreadsheet.

   • You can update information for existing suppliers. For example, you might correct supplier addresses or add email addresses for selected suppliers.
   • You can also add new suppliers. If the Supplier ID that you specify doesn't already exist in Intacct, a new supplier record will be created.
3. When you're finished, save the spreadsheet in CSV format.

Import your changes

1. Go to Accounts Payable > All > Suppliers.

2. Select Import at the top right of the Suppliers list.

3. In the Import Company Information dialog, set the following and select Import:

   Import Company Information: options

   Import file option descriptions

   Option	Description
   Browse	Use the Browse button to locate and select the CSV file you want to import.
   Date format	When you select a date format here, Sage Intacct attempts to import your file using the selected date format. If Intacct can’t import your file with the selected date format, it attempts to discover the date format used in your file and import the data using that date format.
   File encoding	Leave this option set to "auto-detect" unless you're unable to import your file. Depending on your operating system, you may need to select a different type of file encoding.
   Process offline	Some imports can take considerable time, depending on their size and how much processing the system must do on the uploaded data. If you're not sure how much time your upload will take, select Process offline. When the system completes the process, it sends an email to the address you provide in the Email results to this address field. The system also sends you any errors that may have occurred in the process. If you prefer to wait until the upload process is complete, don’t select the Process offline checkbox. Transactions and other records that are processed offline show a source of System in the audit trail, instead of CSV import.
   Email results to this address	Email address to which import results and errors should be sent. You can enter multiple email addresses, separated by a semicolon (;) or comma (,). Sage Intacct highly recommends entering an email address.

Guidelines for updating suppliers

The most important thing to remember when updating supplier records through CSV import is that changes you make in the spreadsheet will affect your supplier records.

• If you update spreadsheet data for a supplier, the information you specify will overwrite the data in the existing supplier record.
• If you remove data from the spreadsheet, the corresponding information will be removed from the supplier record.

Tips for adding new suppliers

Required fields for new suppliers

When you're adding new suppliers, include at least the following columns:

• Supplier ID: Be sure to enter a unique supplier ID that hasn't already been used in Intacct.
• Supplier Name: Enter the supplier name.
• Print as: Enter the supplier name as it should appear on payments and reports.
• Country: Enter the supplier country that corresponds to the location of the supplier current account.
• Required custom fields: If you've created any custom fields that are required, include these columns.

Recommended fields for new suppliers

It's also recommended that you include the following columns:

• Supplier Account Number

• Contact Information

  • First Name
  • Last Name
  • Phone
  • Email
  • URL
  • Address
  • City
  • State or territory
  • ZIP or post code
  • Country