Copy/Paste General Journal Entries from Excel

This is an oldie but goodie. Simplify journal entries by copying and pasting into GP from Excel.

1. Set up the Excel Spreadsheet with four columns in this order:

a. Account Description, Account, Debit Amount, Credit Amount
b. Add a row for each line of data entry and create a balanced General Journal entry

2. Select and copy the data from the Excel spreadsheet. Do not copy the column headings.

3. Open the Financial Transaction Entry Window by going Financial > Transaction > General

• Create a Batch ID (Optional)
• Enter the Transaction Type (Standard or Reversing)Enter the Transaction Date
• Source Document Code will default
• Enter Reference
• Currency ID will default

4. Place the cursor in the Account field and click on the Paste option at the top of the menu bar

5. The paste action will populate the journal entry

6. Save the transaction in a batch or Post

Contact us for GP Help

If you need help or support with Dynamics GP, please contact CSSI.