What information should I include in my Accounts Payable invoice import file?

Invoice records can be imported from a comma-delimited text file into Accounts Payable using the Import Invoices command from the Tools menu.

There are two types of formats you can use when you import invoices. One format is a fixed format and the other is a variable format.

The fixed format stays the same regardless of your Accounts Payable settings. The variable format changes based on your AP Settings. IMPORTANT: See AP Import Invoices Fixed format did not import the values for certain fields for exceptions.

Note: If you need to import invoices with chargebacks for Property Management, use the Variable Format.

Variable Format:

To see your variable import invoice format based on your current Accounts Payable settings, print the Import Invoices Format journal as follows:

In Accounts Payable, from the Tools menu, select Import Invoices.
Click Import Format.
Click Print Preview to preview or click Start to print to a file or printer.

Fixed Format:

Refer to What is the AP Import Invoices Fixed Format?

For more information on both formats, see the Accounts Payable Help topic "Determine text format for importing."