GL Transaction Entry - Import from Excel overview

General Ledger > Entry > Transaction

Use the Import from Excel page to import GL transactions from an Excel spreadsheet file on your system.

In GL Transaction Entry, select the Import from Excel option after you select a group. Your Excel file can be formatted to include these fields:

  • Account
  • Amount
  • Reference
  • Vendor
  • AP Invoice Number
  • Customer
  • Invoice Number
  • Check Number
  • Extended Reference

All fields are optional, with the exception of Account and Amount. The account number must be the full GL account number, without asterisks, and must match an existing GL Account Setup record for the current year.

Note: The order of the fields, or columns, does not matter. The columns can be in any order, but the column headings must be specified exactly as shown in the list.

The import file is validated against your existing GL account codes, and vendor and customer records, if applicable, during the import. You must be authorized to update GL accounts, including entries for allowable divisions based on your SA Operator Setup-Other Options settings. You must also be authorized to make manual GL postings based on the GL Manual Posting and GL Account authorization points.

Any errors in the imported data are noted in the Status Message column. You cannot click Submit until all errors are resolved. In addition, no editing can be performed in the Import lines grid, with the exception of deleting records. Any corrections or changes to transactions must be made in your Excel file and the file re-imported.

Note: The Import from Excel option is an alternative to using GL Entry Batch Import Report. The Import from Excel process is performed directly in the GL Transaction Entry grid, as if you are manually creating GL transactions, and does not require that you transfer your Excel file to a cloud server before importing it.