Importing transactions from Excel

Use these procedures to import GL transaction from an Excel spreadsheet using the Import From Excel option in Vendor Invoice Center Entry.

  1. In Excel, create a spreadsheet for the transactions to be imported. Verify that the spreadsheet is formatted correctly, otherwise, the import will fail.
    See Excel spreadsheet formatting for GL transactions in Vendor Invoice Center Entry.
  2. Save the spreadsheet to a folder on your computer or to a shared folder on your local network.
  3. Select Vendor > Entry > Invoice Center.
  4. Specify an existing group or select New Group.
  5. Click New Invoice.
  6. Specify these values and click Save:
    • Vendor
    • Transaction Type (GL import is limited to Invoice, Misc Credit, Credit Memo, and Debit Memo transactions)
    • Process Type
    • Invoice #
    • Amount
    • Invoice Date
    • Terms
    • Division
  7. On the General Ledger Distribution view, click Import From Excel.
  8. Specify this information:
    File To Import
    Specify the full location and name of the spreadsheet file, or use the File Open button to search for the spreadsheet you saved in step 2.
    Max Lines
    Specify the maximum number of lines on the spreadsheet to import. You can import up to 999 lines.
  9. Click Import File.
  10. The imported transactions are displayed in the Import From Excel Lines grid. Any errors are noted in the Status Message column.
    Note: You cannot click Submit until there are no errors in the imported file. You can delete transactions from the Lines grid, but you must click Cancel to correct or change transactions in your Excel file and re-import the file.
  11. Click Submit when there are no errors in your import file.
  12. The transactions are displayed in the General Ledger Distribution Accounts grid. Make any edits to the transactions in the grid using the New, Edit, and Delete options. Save your changes.
  13. When you are finished, exit the Invoice Detail window.
  14. To update the transactions for invoices that were entered for a group, follow the instructions to update Vendor group transactions.