Import Transactions

The Accounts Receivable Transaction Import reads an Excel file you specify and imports each row as an unposted transaction.

Note: This option can also be accessed from Manage > Unposted Invoices.

Import accounts receivable transactions

1. Select Import Transactions.
2. File Name: Click Choose File. Browse to the folder where the file is located and select the file to import.
3. Click Import to continue, or Cancel to return.
4. From the Import Preview grid, choose Use Invoice Numbers in Excel file when importing transactions (if invoice numbers are provided in the file), or let the program assign them automatically.

Note: If your file has the same invoice number on multiple lines for the same customer, the import creates one invoice for those lines. However, if Save Invoice Detail as Separate Invoices? is selected in Modify > Company Information, a separate invoice is created for each line.

File layout

The order of the columns does not matter, but the first field in each column must contain the descriptions listed below. Required columns are marked with an asterisk (*).

• CompanyNumber*
• Customer* (duplicate Customer, InvoiceNumber, and RevenueCenter creates one invoice with multiple detail lines)
• InvoiceNumber*
• RevenueCenter*
• InvoiceDate*
• DueDate*
• Item*
• Description*
• UnitPrice*
• Quantity*
• Amount*
• BillTo
• Source
• Note

Note: The header names are case-sensitive. For example, "invoicedate" or "INVOICEDATE" will not work; it must be "InvoiceDate".

Updated June 12, 2026 14:49