Import Invoices

Note: Don’t see this yet? Importing invoices through Payables is currently in Limited Availability (LA) for some of our customers.

To save time and increase efficiency around data entry, select Import to create new invoice records using a .csv or .txt file. You can download initial templates, add invoice details, upload, and import.

Note: In a future release, look for the ability to add and edit invoice records in bulk (including 1099 distributions and interfund sets) as well as support for purchase orders, invoice bypass approval based on business rules, and invoices paid by credit card.

During the upload and import process, detailed validation and error messages help you understand supported file types, required fields, and processing requirements. If errors occur, you can view a list of import exceptions, correct any issues, and import again.

To ensure a successful import, take note of the following:

• Since distributions default to new invoice records, vendors included in your import file must be associated with valid distributions.

• You can’t import new invoices for vendors that are on hold or inactive.

• The Post status field for new invoice records defaults to "Not yet posted."

• The Invoice date (from the import) and the Post date (in General ledger) will be the same.

• Vendors must be associated with a default payment method other than credit card.

• The import process does not check if imported invoices exceed budgets or credit limits.

After reviewing, select Import. If errors occur, you can view a list of import exceptions, correct any issues, and import again.