Import invoices

You can save time and import invoices by uploading a CSV file.

The enhanced list for this area of Intacct supports CSV and Import service imports. Open the Import dropdown to choose the option that best fits your needs.

Prepare a CSV file for import

When you download a template, the correct headers are in the template already. All you have to do is fill in the columns with your data, save it as a CSV file, and upload the file.

The header titles in the template you download correlate to fields in Intacct. Incorrect header titles will cause an upload error.

For more information about the CSV upload process, including best practices, common errors, and how to upload your CSV file, see Prepare your file for CSV import.

  1. Go to Company > Setup > Configuration > Import data.

    The Company Setup Checklist opens. You’ll find a list of areas that you can import information into Intacct.

  2. Decide on a type of information to upload, and select the Template link associated with that information.
If you do not see the template that you want on the Company Setup Checklist, go to Download a CSV import template. Some templates are not kept on the Company Setup Checklist.
The CSV file contains a line for each invoice line item. For multi-line invoices, you only need to provide invoice header information for the first line.

Import invoices

Subscription Accounts Receivable
Regional availability

All regions
User type Business
Permissions Invoices: List, View, Add, Edit
  1. Select Import.

    The Accounts Receivable Invoices Import page appears.

  2. Find the file that you want to import by selecting Choose file.

    The file you import must be in CSV format.

  3. If your csv file contains dates, you can set the date format to match the format in the csv file.
  4. You can allow Intacct to auto-detect the type of CSV file, or you can select a specific csv file format, like Mac OSx or Windows-1252.
  5. Select the mode for importing:
    • Historical: imported transactions have no effect on the general ledger.
    • General ledger: imported transactions are posted live to the general ledger.
    Note the rules listed on the page for importing to the general ledger.
  6. If you select Historical, you can choose to process the import offline.

    This option is useful if your import file is large. When the import is finished, you receive an email to the address you specify.

  7. To be notified by email when an offline import is finished or if errors occur in the import process, enter your email address.
  8. Select Import.

For information on the actual fields required in the CSV import file, see CSV import: Accounts Receivable invoices.