Creating GL entries from an Excel spreadsheet

You can import lines from a Microsoft Excel spreadsheet into GL Transaction Entry to automatically create journal entries. Create and format the spreadsheet, list all the necessary data, and import the spreadsheet. Then, you can update the General Ledger using a batch update.

  1. Verify that the spreadsheet you want to import is formatted correctly; otherwise, the import will fail.
  2. Save the spreadsheet in .csv, comma separated value, format. The file name cannot contain spaces or more than 14 characters.
  3. Save the .csv file to an accessible folder on your system. The path will be specified later in these steps.
  4. Select General Ledger > Entry > GLE Reports > GL Entry Batch Import.
  5. Click New One Time.
  6. Specify the report, schedule, and printing information.
  7. Click Next.
  8. In Batch Name, specify the batch name you want to assign to the transactions created from this spreadsheet.

    You must specify a unique batch name. If you specify a batch name that is already in use in the system, the import fails and a message prints on the report after the report is processed: SAPB Batch Entry XXXX already exists

  9. In Input directory on Server, specify the location of the .csv file. This is the path you made note of in the previous step.
  10. In Input File Name, specify the name of the csv file to import.

    If you specify an invalid path or file name, the import fails and a message prints on the report after the report is processed: File PATH.FILENAME not found

  11. Click Next.
  12. To store the results of this report, specify a job name or number.
  13. Click Finish to process the report.
  14. Follow the instructions to update GL batch transactions.
Related topics