What research tools can I use to balance Bank Rec?

I'm doing a manual bank rec (not using Sage bank rec, but doing it on my own using bank statements plus everything I've entered into Sage.)

It's not balancing. 

I have used the General Ledger Detail report to verify each item entered and everything matches. So I don't understand why it's not balanced. 

Which reports can I use to find the problem? I need more detailed info than what the "GE Detail Report" gives. 

The AP check reports and AR deposits have all been verified. The starting balances for the bank account is correct too. So it has to be something that isn't entered correctly. How can I find it?

Parents
  • 0

    The first thing I would do is go to GL>Main>Daily Transaction Register and run it.  If any Daily Transaction Registers from other modules were missed, this one will pick them up and post to the GL to make sure you have everything.

  • 0 in reply to hyanaga

    The month that doesn't balance is a previous month.  So the Daily Trans Reg have been run many times afterwards. 

    The bank recs for following months that I've done afterwards all balance other than that same amount from the month I'm having a problem with. 

    What would your next step be?

  • 0 in reply to SoCal2018

    "So the Daily Trans Reg have been run many times afterward".  From the GL menu itself?  If they were ONLY run from the module themselves, and not from the GL>Main menu, if one was missed, it would not be picked up.  In other words, if you run the  Cash Receipts Journal and update it, and then when it asks you to run the Daily Transaction Journal and you say No, the next time you run the Cash Receipts Journal and Daily Transaction Journal from AR, it will not include the prior one.  I always recommend to my users to run the Daily Transaction Journal from the GL menu at period end, just in case. Maybe you already do, but your response wasn't clear, so I just wanted to make sure.

Reply
  • 0 in reply to SoCal2018

    "So the Daily Trans Reg have been run many times afterward".  From the GL menu itself?  If they were ONLY run from the module themselves, and not from the GL>Main menu, if one was missed, it would not be picked up.  In other words, if you run the  Cash Receipts Journal and update it, and then when it asks you to run the Daily Transaction Journal and you say No, the next time you run the Cash Receipts Journal and Daily Transaction Journal from AR, it will not include the prior one.  I always recommend to my users to run the Daily Transaction Journal from the GL menu at period end, just in case. Maybe you already do, but your response wasn't clear, so I just wanted to make sure.

Children