Bank Reconciliation/Auto Check Reconciliation

SUGGESTED

Hi 

We are looking into switching banks from Wells Fargo to a smaller institution that is aligned with our values.

The bank we are looking at does not provide custom designed files for use with Sage 100's Auto Check Reconciliation. Can someone tell me what our options are? 

I assume we could format files ourselves for what is needed. If so, where do I find current info on what is needed? Does a VI Job work? It looks like the only thing BR_Transaction does is pull in check/deposit data

thank you in advance

Parents Reply
  • 0 in reply to blorf

    I was able to have it work successfully when adding the ClearedBank field on the FIRST line of data in my test file. the other two lines were imported as new checks and marked as cleared, leaving the original check "un-checked" in Bank Rec. I wonder if you'd be willing to share a VI job Data screenshot with me? 

Children