Out of Balance Journal Entry POSTED

  • Out of Balance Journal Entry POSTED

    Posted by Thomas Hill on September 9, 2025 at 12:36 pm

    In January 2025, after just upgrading to GP2018 (18.6.1695) I posted a batch of invoices (processed against the purchase order). Since using a computerized accounting system (many ages ago) I balance the input. I check that invoice numbers, dates and amounts are correct. Then POST.

    This is the first time for me to see a system (any system) actually post an out-of-balance journal entry. I have had such entry post to a suspense account if it did not balance. But never to post out-of-balance.

    Weird so I thought I would share it.

    Thomas Hill replied 1 week, 6 days ago 3 Members · 4 Replies
  • 4 Replies
  • Ven Sharma

    Member
    September 12, 2025 at 4:38 pm
    Up
    0
    Down
    ::

    Interesting, Thomas – Out of curiosity, if you pull this JE from Journal Entry Inquiry, what do you see?

    • Thomas Hill

      Member
      September 19, 2025 at 4:14 pm
      Up
      0
      Down
      ::

      Exactly as it shows on this printed report. To fix it the GP Administrator had to delete the exactly transactions, and then enter the Journal entry manually.

      It was also strange that this originated as a batch in Payables. But when it posted GP2018 split it into two journal entries, with the larger one missing a part to be out of balance.

      I thought it strange. I have imported a journal entry that I had not balanced in my off-system app. GP2015 always caught me. I have not done this since migrating to GP2018.

      We do not print the various posting reports to paper. But to a file.

  • Chris Donnelly

    Member
    October 12, 2025 at 7:07 am
    Up
    0
    Down
    ::

    Thomas,

    I’ve never seen an unbalanced entry in GP. I would suspect someone manipulating the SQL tables.

    Chris

    • Thomas Hill

      Member
      October 21, 2025 at 2:50 pm
      Up
      0
      Down Accepted answer
      ::

      I think you might be correct, accidently of course. It happened in Jan2025, the first month we went live with GP2018, upgrading from GP2015. Mid-month of January some of the settings were changed from posting all detail to the balance sheet accounts for AP Trade and AP Accrual, to posting in summary.

      When I post, the various reports post to a text file, not to paper. In all of the years, never any posting issues. I was the one posting. The posting to the general ledger should have been held as out of balance and not posted. But it went through. I received no warnings of being out of balance.

      I have seen (in other software programs) posting the out of balance difference to a SUSPENSE ACCOUNT to be cleared from there. It was a strange event. Fixing it was stranger as well.

      Running the Financial Trial balance now may give unusual totals for the accounts that were used in the original journal entry.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!