Journal Entry out of Balance after Copy Paste from Excel

Question Status

Unanswered
Lynne Navis asked a question on 24 Jun 2016 11:09 AM

Hi,

I have an Excel spreadsheet that I entered my debits and credits information into.

When I copy and pasted into the General Journal Entry screen in GP all the line fill in, but the totals on the bottom of the screen don't add up.

Any suggestions?

Lynne

Reply
micki responded on 24 Jun 2016 11:49 AM

Rounding in excel?  Have you checked the actual numbers?

Reply
harrywilm responded on 24 Jun 2016 1:16 PM

Use the rounding feature in Excel, that should solve your problem.

Reply
Lynne Navis responded on 27 Jun 2016 8:28 AM

There was nothing to round. I typed the numbers into the cells in Excel.

Reply
micki responded on 27 Jun 2016 8:41 AM

How much is it off?  Can you tie the numbers out?

Reply
Lynne Navis responded on 27 Jun 2016 9:25 AM

The entry was:

Debit 599.00

Credit 99.00

Credit 200.00

Credit 75.00

Credit 75.00

Credit 75.00

Credit 75.00

The total of debits = 599.00

The total of credits = 249.00

Even though all the lines are there.

Reply
micki responded on 27 Jun 2016 9:44 AM

Can you print an edit list for this journal entry?  Are all the accounts active?

Reply
Lynne Navis responded on 27 Jun 2016 10:02 AM

All accounts are active. I was able to print an edit list and that looked fine.

The journal entry screen is still out of balance for the totals.

30604-503488 1000-000-000-0000-20010-00000 599.00

30604-503488 9999-000-000-0000-24016-00000 99.00

30604-503488 9999-000-000-0000-24010-00000 200.00

30604-503488 1000-000-000-0000-24015-M1100 75.00

30604-503488 3000-000-000-0000-24015-M1300 75.00

30604-503488 9999-000-000-0000-24015-M1400 75.00

30604-503488 2000-000-000-0000-24015-M1200 75.00

Reply
Richard Wheeler responded on 27 Jun 2016 10:09 AM

My guess is that this is because of a decimal place issue. Try rounding in Excel first and then do the paste again.

Reply
micki responded on 27 Jun 2016 10:12 AM

Lynne stated above that she manually entered the amounts.

Reply
Lynne Navis responded on 27 Jun 2016 10:29 AM

I also tried to round in Excel and it didn't help.

Reply
Richard Wheeler responded on 27 Jun 2016 10:46 AM

I would delete this transaction and the batch it is in. Also, go into SSMS and make sure this batch does not exist in the SY00500 table. Another simple test would be to create a new batch and a new journal entry.

Reply