Learn how to copy and paste journal entries from Microsoft Excel with new Microsoft Dynamics GP 2013 R2 feature

By - March 31, 2015

One of the new feature released in Microsoft Dynamics GP 2013 R2 is the ability to copy and paste journal entries from an Microsoft Excel spreadsheet to the general ledger financial transaction entry.  First, start by creating a spreadsheet. In the new spreadsheet,  you need to make sure that the excel file contains the following four columns Account Description, Account, Debit and Credit.  The columns need be in the same exact order otherwise you will get errors.

Dynamics GP 2013 R2 Copy and Paste Journal Entries from Excel 1

Copy the data in the excel spreadsheet and make sure that you don’t copy the columns headers otherwise you will receive an error when trying to paste the entries into the general Ledger financial transaction entry window.

Open Dynamics GP General Ledger Financial Transaction Entry window (Financial > Transaction> General)

Dynamics GP 2013 R2 Copy and Paste Journal Entries from Excel 2

Click in the Account field and click on the Paste option at the top of the menu bar.Dynamics GP 2013 R2 Copy and Paste Journal Entries from Excel 3

If any errors are detected in the data you are pasting, then the GL Transactions Paste Validation Report will print and the journal entries will not be copied. You will need to revise the data in the excel spreadsheet then copy and paste the revisions into the General Ledger Transactions Entry again. In the past, I have seen errors appear in the GL Transaction Paste Validation Report due to the General Ledger Accounts not existing in Dynamics GP.

Dynamics GP 2013 R2 Copy and Paste Journal Entries from Excel 4

If no errors are encountered, the journal entries copied from Excel spreadsheet will get pasted into the GL Transaction Entry window.

Dynamics GP 2013 R2 Copy and Paste Journal Entries from Excel 5

If you looking to upgrade to the latest version of Dynamics GP or have other questions about functionality, our Microsoft Dynamics Support Specialists can help.  Our exclusive Rapid Assessment® for Microsoft Dynamics will review your current configurations and identify how an upgrade can help your organization.  Contact our professionals for more details – erp@rsmus.com or by phone at 855.437.7202.

By: Priten Patel – Great Lakes Microsoft Dynamics GP partner

Receive Posts by Email

Subscribe and receive notifications of new posts by email.