Importing transactions from Excel

Use these procedures to import GL transaction from an Excel spreadsheet using the Import From Excel option in Customer 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 to a folder on your computer or to a shared folder on your local network.
  3. Select Customer > Entry > Transaction.
  4. Specify the Customer and select the transaction type from the Type field.
    Note: You can import GL transactions for Invoice, Service Charge, COD, Misc Credit, Credit Memo, Debit Memo, and Reversal transaction types.
  5. Click Next.
  6. Specify these values:
    • Invoice
    • Amount
    • Ship To (optional)
    • Division
  7. Click Next.
  8. Click Import From Excel.
  9. 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.
  10. Click Import File.
  11. 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.
  12. Click Submit when there are no errors in your import file.
  13. The transactions are displayed in the GL Distributions grid. If the Proof amount is 0, click Save.
  14. Close the journal if you are finished, or continue creating transactions.