Sage 100

 View Only

  • 1.  Bank Reconciliation Calculated Balance

    Posted 03-24-2020 09:59
    I am having a senior moment....new customer is doing their firts bank reconciliation.  After entering all outstanding transactions and entering bank code balance...the out of balance amount is ZERO...but the calculated book value does not reconcile with GL for the reconciled period.  I cannot remember the transaction and/or process needed to reconcile with GL without getting the out of balance amount screwed up....

    ------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ------------------------------


  • 2.  RE: Bank Reconciliation Calculated Balance

    Posted 03-24-2020 11:38
    Rebuild your BR sort file to flush out bad data.  This will usually change the BR OOB and then you can go from there.  I usually have to change the calculated GL value in bank code set up the first couple of times.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Bank Reconciliation Calculated Balance

    Posted 03-24-2020 12:02
    Check for a blank bank code before rebuilding sort files for BR.  (Remove if found).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 4.  RE: Bank Reconciliation Calculated Balance

    Posted 03-24-2020 12:58

    See if the client has a check date different than the date the check run was posted to the General Ledger (typically a manual check in my experience).  Since Bank Rec is sorted by Check Date (not posting date), if a check that was dated in February was posted to March, the GL balance for February is going to be different than the Bank Rec shows since the Bank Rec will show that check as a February check. 

     

    Sue Bennett | President

    P. 503 620 3484 | F. 503 620 2765

    12559 SW 69th Ave | Portland, OR  97223

    sue@benpor.com   www.benpor.com
    Bennett/Porter Blogs | facebook | twitter

    image003.png@01D5FE09.5956A8F0

     

     

     

     



    ------Original Message------

    I am having a senior moment....new customer is doing their firts bank reconciliation.  After entering all outstanding transactions and entering bank code balance...the out of balance amount is ZERO...but the calculated book value does not reconcile with GL for the reconciled period.  I cannot remember the transaction and/or process needed to reconcile with GL without getting the out of balance amount screwed up....

    ------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ------------------------------


Related Content