Importing GL entries from Excel in GL Transaction Entry

Use these procedures to import GL transaction from an Excel spreadsheet using the Import From Excel option in GL Transaction 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.
  2. Save the spreadsheet file to an accessible folder on your local system or a shared network location.
  3. Select General Ledger > Entry > Transaction.
  4. Specify an existing group or select New Group.
  5. Click Import From Excel.
  6. 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.
  7. Click Import File.
  8. 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.
  9. Click Submit when there are no errors in your import file.
  10. The transactions are displayed in the General Ledger Transactions grid. Complete the steps to update the batch file.