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:
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.
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.
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!