web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Journal Entry out of B...
Microsoft Dynamics GP (Archived)

Journal Entry out of Balance after Copy Paste from Excel

(0) ShareShare
ReportReport
Posted on by Community Member

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

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Journal Entry out of Balance after Copy Paste from Excel

    Rounding in excel?  Have you checked the actual numbers?

  • Community Member Profile Picture
    Community Member on at
    RE: Journal Entry out of Balance after Copy Paste from Excel

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

  • Community Member Profile Picture
    Community Member on at
    RE: Journal Entry out of Balance after Copy Paste from Excel

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

  • Community Member Profile Picture
    Community Member on at
    RE: Journal Entry out of Balance after Copy Paste from Excel

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

  • Community Member Profile Picture
    Community Member on at
    RE: Journal Entry out of Balance after Copy Paste from Excel

    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.

  • Community Member Profile Picture
    Community Member on at
    RE: Journal Entry out of Balance after Copy Paste from Excel

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

  • Community Member Profile Picture
    Community Member on at
    RE: Journal Entry out of Balance after Copy Paste from Excel

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Journal Entry out of Balance after Copy Paste from Excel

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

  • Community Member Profile Picture
    Community Member on at
    RE: Journal Entry out of Balance after Copy Paste from Excel

    Lynne stated above that she manually entered the amounts.

  • Community Member Profile Picture
    Community Member on at
    RE: Journal Entry out of Balance after Copy Paste from Excel

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans