How to Copy & Paste GP Journal Entries

Visit Website View Our Posts

How to Copy & Paste Microsoft Dynamics GP Journal Entries

We’ve been waiting for this for so long! It's finally here, and it’s so simple!!

All you need are the four columns shown in the table below. Even if you don’t populate the "Account Description" field, you still need to include this column in the Excel spreadsheet.


If you use Analytical Accounting, you’ll need to add "Alias" as a column in your Excel spreadsheet; otherwise, "Alias" is not a required field.

Next Step: Highlight the data – NOT the headings – and click on "Paste" in the top ribbon of the GL "Transaction Entry" window.

You can access this window through Transactions > Financial > General:


Copying & pasting your Microsoft Dynamics GP journal entries into an Excel spreadsheet is really that simple! Voilà!

For more information or training on Microsfot Dynamics GP tips and tricks, contact Tidestone Solutions today!  |  PMB 9715-805, Portland, ME 04104  |  207-761-2133


Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Show Buttons
Hide Buttons