Posting journal entries from Microsoft Excel.

(0) Share

Report

Posted on by Community Member

Does anyone know how to post journal entries from Microsoft Excel. I use GP2015 and have tried following the online instructions and cannot make this work.

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (1)

Suggested answer

Mike Bufano 1,484 on at

Like (0)

Report

I know that you can import entries from Excel using many tools such as Integration Manager or Eone's Smartconnect. Is that what you are describing.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello, Mike, thanks for your reply. I tried using a copy and paste from Excel into the general transaction entry screen unsuccessfully. I would like to use any method that works rather than data entry of items already in an Excel worksheet. I will look up Integration manager and Eone's Smart connect. Thanks for additional insight on how to do this.

Was this reply helpful? Yes No
Suggested answer

Mike Bufano 1,484 on at

Like (0)

Report

The Excel Copy and paste does not work with the GP web client. But assuming you are in GP (installed on your PC, Terminal Server or Citrix) then it should work.Copy and paste will work but you have to have your spreadsheet in a specific format.

columns must be in the following order

Description

Account

Debit

Credit

Also, when you paste, you have to place your cursor in the first distribution account in the grid prior to clicking the excel button.

Was this reply helpful? Yes No
MattPaulen 6,912 on at

Like (0)

Report

The Excel Copy Paste should be fairly simple to use.

1) Create your entry using 4 columns: Dist Reference, Account, Debit, Credit (see below for an example)

2) Highlight the lines with the data in Excel and hit Ctr+C or right-click and copy.

3) With the Transaction entry window open, Click on the Paste button

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello, Matt,

I have tried the exact instructions you gave several times and cannot get this copy and paste to work. I used the template below and only copied the data starting with account. I tried pasting in via ctrl V and cannot get this to work.

Description Account Debit Credit

Test 1 02-00010-10124 34993.00

Test 2 02-64125-40469 34993.00

Was this reply helpful? Yes No
MattPaulen 6,912 on at

Like (0)

Report

You have to copy the Description (Distribution Reference) field as well, even if it's blank. And I don't believe Ctrl V works, you need to click the Paste button on the Ribbon in GP.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello, Matt, thanks for our ongoing dialogue on this. Here are the string of commands: Transactions, Financial, General. I then move through the various fields to the point of trying to paste the data. I cannot get ctrl V to work and there is no Paste button on this GP screen for Transaction Entry.

I tried this with the description field and without it. I also have tried the account number including dashes and no dashes. I am new to GP and to our org and the productivity improvements will be tremendous if I can find how to make this work.

Was this reply helpful? Yes No
MattPaulen 6,912 on at

Like (0)

Report

Can you take a screenshot of your Transaction Entry screen? There should be a Paste button if you are on GP 2015.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Here's the screenshot.

Was this reply helpful? Yes No
MattPaulen 6,912 on at

Like (0)

Report

It didn't come through. You have to click on the Use Rich Formatting option underneath the text box and then add media and browse out to a saved file.

Was this reply helpful? Yes No