With the recent release of GP 2013 R2 comes some exciting new features! One of them gives us the ability to copy data from an Excel file and paste into the GL as a journal entry.

To do this, we may highlight and copy the data from Excel, and then choose the Paste button in the GL Transaction Entry window. A validation report will print to identify any errors in the data copied into the GL.

In the Excel file, there are 4 columns that must be present as follows:

  • Description: This is the Description of the transaction that will appear in the Distribution Reference field when imported. It is not required, but the column must be present within the file.
  • Account: GL account number that we’re posting to.
  • Debit: Enter the debit amount for the account.
  • Credit: Enter the credit amount for the account.