Open Forum

Bank Reconciliation GL Balance Incorrect

  • 1.  Bank Reconciliation GL Balance Incorrect

    BRONZE CONTRIBUTOR
    Posted 7 days ago
    Have a very strange problem.  The GL Balance on the Bank Reconciliation screen was off by one Cash Manager transaction.  Did some digging and the transaction in question was missing the USD Base Currency ID in GLTran, CATran and Batch.  I added the currency ID, deleted the bank reconciliation and created a new reconciliation but that did not fix the issue.  I verified that the transaction date fell in the correct period.

    Does anyone have any thoughts on where to go next?

    ------------------------------
    Robert Guerriero
    Director of Accounting
    Telephone Electronics Corporation
    Jackson MS
    ------------------------------


  • 2.  RE: Bank Reconciliation GL Balance Incorrect

    SILVER CONTRIBUTOR
    Posted 7 days ago
    Hi Robert,

    Have you tried running CA Integrity Check?  That usually fixes issues like this....

    Thanks,
    Michael

    ------------------------------
    Michael O'Neill
    Controller
    Eastex Telephone Cooperative
    Henderson TX
    ------------------------------



  • 3.  RE: Bank Reconciliation GL Balance Incorrect

    BRONZE CONTRIBUTOR
    Posted 7 days ago
    I had but tried it again just in case and it didn't fix the issue.  Thanks for the reply!!

    ------------------------------
    Robert Guerriero
    Director of Accounting
    Telephone Electronics Corporation
    Jackson MS
    ------------------------------



  • 4.  RE: Bank Reconciliation GL Balance Incorrect

    Posted 7 days ago
    I see this happen from time to time.  You'll also need to evaluate SQL changes to the AcctHist and CuryAcct tables to correct the PTD and YTD totals by CuryID to get the balances corrected.

    ------------------------------
    Mark Ehleben
    President
    QBI Consulting, LLC
    Warminster PA
    ------------------------------



  • 5.  RE: Bank Reconciliation GL Balance Incorrect

    BRONZE CONTRIBUTOR
    Posted 7 days ago
    Thanks Mark!!

    Rob Guerriero
    TEC
    Director of Accounting





  • 6.  RE: Bank Reconciliation GL Balance Incorrect

    Posted 7 days ago
    ​Look in curyacct and accthist.   Curyacct will have a record with a blank curyid.  You will need to delete this one and fix the one with the correct curyid.

    ------------------------------
    Cindy Hall
    Velosio
    Louisville KY
    ------------------------------