Deleting a deposit in Bank Rec after its been marked cleared

Sage 100 ERP

Having trouble getting my Bank Rec balance to match up with the GL balance. As far as my eye can see everything seems to match. But obviously there is something off on one of the sides that I cannot locate.  I am starting to think that perhaps it has to do with a transaction that I deleted in the bank Rec after is was marked cleared.  Would that make a difference?

When going through my statement and marking off the cleared deposits & checks I cleared a deposit amount.  Only to notice that the reason my bank rec was not balancing was because I transposed the amount.  I went back in, deleted the incorrect entry by the entire line, then I entered the correct amount.  Would this be the cause of my balances not matching?  Any insight, tips, tricks, or ideas would be greatly appreciated. 

Parents
  • 0
    The bank recap report is designed to look like the General Ledger Detail Report when comparing Bank Rec to GL. This is helpful when reconciling to the GL. You can compare the two reports side by side. Tom is correct, if you see something wrong in Bank Rec, and you correct it there, you must also research the GL side and correct if needed.
  • 0 in reply to GerriOros

    And the other thing I am reminded of (after spending quite a bit of time with a client on this this morning) is to remember that if you are doing a bank reconciliation through 3/31 and you mark an April transaction as being cleared it will be included in the calculated balances of the bank recon printed through 3/31.

    This error is typically detected by printing the bank recon and the bank recap through the same date and seeing that you get two different numbers.

Reply
  • 0 in reply to GerriOros

    And the other thing I am reminded of (after spending quite a bit of time with a client on this this morning) is to remember that if you are doing a bank reconciliation through 3/31 and you mark an April transaction as being cleared it will be included in the calculated balances of the bank recon printed through 3/31.

    This error is typically detected by printing the bank recon and the bank recap through the same date and seeing that you get two different numbers.

Children