Bank Reconciliation Missing Transactions

SOLVED

Hello,

I posted two checks directly to GL using AR Cash Receipts Entry, as I normally would for payments of this type, but they are not showing up in Bank Reconciliation. I've confirmed that they are showing in the GL and that I posted them to the correct Bank Code. They should not already be cleared, but I can't check for that since I posted to GL instead of an invoice. I'm stumped. How can I get these to show up in Bank Reconciliation?

Thank you,

Miranda

Parents
  • 0
    SUGGESTED

    Miranda,

    Posting to a GL account instead of an invoice still posts to a Bank Code and should display on the Dep/Adjustment tab in Reconcile Bank.  Is it possible it went to the incorrect bank code from Cash Receipts?  Check the posting date on the GL account entry to make sure you are looking at the correct date.  Check your bank statements to see if the deposit did clear.  Is it possible the integration to Bank Reconciliation was deselected when this transaction was posted to GL?  Lastly, do you remember any error messages on the posting date.  Check the Activity Log under Library Master Reports for errors on that date.

  • 0 in reply to Linda KR

    Thank you for the quick reply, Linda. I have confirmed that it was posted to the correct bank code.

    I don't know how to deselect the integration to Bank Reconciliation. How would I check on that? It seems unlikely, since everything else during the month has posted to Bank Rec just fine.

    According to the journal drill down, it was updated at 8:54 am on 5/13/24. The only line item on the activity log around that time is "System User Access: User successfully authenticated from workstation," which I'm guessing is just logging in.

    Can you think of anything else that could cause this?

Reply
  • 0 in reply to Linda KR

    Thank you for the quick reply, Linda. I have confirmed that it was posted to the correct bank code.

    I don't know how to deselect the integration to Bank Reconciliation. How would I check on that? It seems unlikely, since everything else during the month has posted to Bank Rec just fine.

    According to the journal drill down, it was updated at 8:54 am on 5/13/24. The only line item on the activity log around that time is "System User Access: User successfully authenticated from workstation," which I'm guessing is just logging in.

    Can you think of anything else that could cause this?

Children
  • +1 in reply to mirandah
    verified answer

    A user would need access to Accounts Receivable_Setup_Accounts Receivable Options_Main Tab_Uncheck Bank Reconciliation.   It is a toggle so maybe they were fixing an issue and did not want to send duplicate to update, then forgot to fix flag.  The current version of Sage 100 tracks a lot more activity in the Activity log like someone accessing AR Options.  It is also possible it was accidentally deleted in Bank Reconciliation.  There is no audit trail on this.  

  • 0 in reply to Linda KR

    I'm the only person currently using Sage, and I'd never turned off Bank Reconciliation before. It must've been some kind of glitch. With your instruction, I was able to turn off Bank Reconciliation to reverse the entries and then turn it back on to re-enter them. It worked this time. Thanks for your time and clear explanations!