GP #LifeHacks 103: Track JE’s in #Excel – Paste into GP

I love Excel!  Who doesn’t, right?  As an accountant, I live in Excel.  This is the easiest place for me to track and create Journal Entries. But after all that work, how do we get it into our accounting system, Microsoft Dynamics GP? Easy, we just ‘Paste’ the entry. Simple, I know.

GP Life Hack #103

Dynamics GP offers the cool functionality of pasting in copied data from Excel.  This includes distribution reference, the GL Account number, Debit Amount and the Credit Amount:

1

A 5th column can be used for Analytical Account Alias.

Simply copy all rows of the entry (do not include the header row) and open a new JE window.  Move your cursor into the account field in the scrolling window and hit the Excel paste button.

103 1

The data copied will now be ‘Pasted’ into the transaction entry window instead of re-keying. Totally awesome!

Keep in mind that when pasting into the transaction entry window, the accounts are validated – if any errors exist, you will get a report showing which accounts need your attention.

103 2.png

That’s it, and you save a TON of keying time. I just tested this and pasted 1000 lines of a Journal Entry and it took under 30 seconds!

Pro Tip! Save the excel file and attach it to the Journal entry so you can reference it at any time.

Thanks for reading!

Shawn

GP Life Hack #103 … click to see original posting

2 thoughts on “GP #LifeHacks 103: Track JE’s in #Excel – Paste into GP”

    1. This feature became available in GP2013 R2 – checkout this blog by my friend Belinda that has a list of all new functionality and the version released. In the GP2013 documentation this is identified but for GP2013 R2.

Leave a Reply

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