x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 5 replies
  • Subscribers 112 subscribers
  • Views 3464 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
91
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
962
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
mandiccpl

Deleting a deposit in Bank Rec after its been marked cleared

Posted By

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.

  • 0 in reply to TomTarget

    This sounds like something I could of done.  Is there a way to print past recap reports even though I've done my monthly period ends? I believe I possibly made my mistake in Jan or Feb. There is something missing on my GL report, and I cannot for the life of me locate this (or these) transactions that aren't allowing my Rec & GL match up.

    I've matched my Bank statement with my Bank rec and all looks well, so I'm lead to believe an entry is missing on the GL since all of our entries (aside from checks) are manual.

Reply
  • 0 in reply to TomTarget

    This sounds like something I could of done.  Is there a way to print past recap reports even though I've done my monthly period ends? I believe I possibly made my mistake in Jan or Feb. There is something missing on my GL report, and I cannot for the life of me locate this (or these) transactions that aren't allowing my Rec & GL match up.

    I've matched my Bank statement with my Bank rec and all looks well, so I'm lead to believe an entry is missing on the GL since all of our entries (aside from checks) are manual.

Children

*Community Hub is the new name for Sage City