CSV import: Standard tasks

Download a template from the Company setup checklist or an object list page.

• Use the latest template, especially following a product release.
• Use the correct template for the area in which you want to upload information. Different templates organize different types of information. Use a template specifically for the information that you need to upload.

• Don’t change the titles in the header row. The header titles correlate to fields in Intacct. Incorrect header titles will cause an upload error. When you download a template from the Company setup checklist, the correct headers are in the template.
• Read the header descriptions in the template. The header description is the cell under the header row that explains what type of information is accepted for each column. If you enter information in the wrong format, or with an incorrect accepted value, it will cause an error in your upload. The header descriptions in the template show you how the information should look. For example, the header in the GL Journal Entries template for JOURNAL shows that allows up to four characters, is required, and has no default values. The header in the Reporting Periods template shows that the STATUS only allows the values 1 or 2, which correlates to True and False, and is not a required field.
• Enter required information. Some data is required, while other data is not. Read the description field to determine which information is required. Required information is necessary for your upload to succeed.

Save the file as a comma-separated value, or CSV, file. If saving from Excel, you could choose the comma-delimited file type.

The file will have the file extension .csv after you save it. Leave the file open until your import is successful. Excel can sometimes reformat the file if you close it before the import is successful.

In Microsoft Excel:

1. Select all cells.
2. Right-click the cells and select Format Cells.
3. On the Number tab, select Text and then select OK.
4. Save the file.

The short date format is formatted like this: 3/15/2021

In Microsoft Excel:

1. Select a column of dates.
2. Right-click the column and select Format Cells.
3. On the Number tab, select Date and select the short date format.
4. Save the file.

While spaces within memo fields are allowed, make sure there are no leading or trailing spaces in any field (not just memos). Leading and trainling spaces may cause import errors. For all other fields, remove unnecessary spaces at the start or end of the data.

In Microsoft Excel:

1. Select a range of cells.
2. On the Home tab, in the Editing group, select Find & Select and select Replace.
3. In the Find what box, press the space bar once. Leave the Replace with box blank.
4. Select Replace All. A prompt opens telling you how many spaces have been removed.
5. Save the file.

Commas are used to separate fields in CSV files.

To prevent data from shifting into the wrong columns, avoid using commas in numeric and text fields.

If you must include a comma in a text field, always surround the field with double quotes, for example "Smith, John".

Headers in your CSV file must match the template exactly, including spelling, capitalization, and spacing. Even small changes (such as adding a space or changing a letter’s case) will cause the import to fail. Always use the official template provided by Sage Intacct.

ID fields must contain exact references to customers or suppliers.

ID fields must match exactly, including capitalization. For example, ven100 and VEN100 do not match.

Enter the ID exactly as it appears in Intacct or you run the risk of matching transactions to the wrong supplier or customer, or having the upload fail.

If you reference a supplier, customer, term, budget, etc., in a CSV file, whatever you’re referencing must already exist in Intacct.

For example, if you’re uploading transactions for a particular supplier, if the supplier does not already exist as a supplier in Intacct before your upload, your upload will fail.

This does not apply when creating new customers or suppliers using the import process.

For more information about to correctly number line items, see CSV import: Line number examples.

For fields with predefined valid entries (such as True/False), use initial capitalization. For example True, not TRUE or true. IDs require exact case matches, while predefined entries require initial capitalization.

If your import template contains a country field, for example for an address, make sure that this field has an entry.

If your company has enabled ISO country codes, you must specify the country code in the country field for each record. If you are unsure whether ISO codes are enabled, check with your administrator or test a sample import to confirm the required format.