Resource Group Blog Resource Group Blog RSS Feed

Read The Resource Group blog to learn about Microsoft Dynamics GP ERP software and Intacct cloud accounting software

Save Time by Copying and Pasting General Ledger Journal Entries and Vendor Transactions from Excel into Microsoft Dynamics GP

Kim Anselmo - Friday, January 31, 2014

By Kim Anselmo, The Resource Group

Our days are filled with endless tasks, projects and deadlines. Every little bit of process improvement can help. For example, consider how often you might be manually re-entering information from spreadsheets into your financial accounting software system.

And if you are manually re-entering that information from one system to another, odds are pretty good that you are going to have a data entry error somewhere. (We’re all human, right?)

The Resource Group has developed two nifty add-on tools for Microsoft Dynamics® GP called the TRG GL Copy/Paste and AP Copy/Paste. The GL Copy/Paste tool allows the creation of a general ledger journal entry by doing a standard copy and paste function from an Excel spreadsheet directly into the Microsoft Dynamics GP financial management system. In addition, the GL Copy/Paste tool validates account numbers and confirms that the Journal Entry is a balanced entry. If any errors are found, the tool will alert the user.

The AP Copy/Paste tool allows users to copy and paste vender transactions from a spreadsheet. This tool features built-in safe guards, which allow users to ensure general ledger accounts exist, document types of invoice and credit memos, confirms the document number is not a duplicate and verifies that the vendor already exists within the Microsoft Dynamics GP system.

By using the GL Copy/Paste and A/P Copy Paste tools in your daily processes, you can reduce the steps and time it would normally take you to re-key this information manually.

Want to see a quick video on how the AP Copy/Paste tool can save you time during your day? Watch now.

2019 Accounting Software & Financial Management Buyer's Guide

2019 Accounting Software & Financial Management Buyer's Guide

Download the Guide