AR Bank Reconciliation - How To Organize?

 1 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Garth Gerwing
Basic Member
Posts: 27
Basic Member
    I would very much appreciate to hear from anyone who has had experience setting-up CB/AR in support of reconciling bank account deposits to AR-sourced payment entries in CBTRANS.

    I've looked extensively at the "Bank Reconciliation" functionality in the Cash Management (CB) module - and it would appear to be more slanted to AP-related reconciliation. I'm kind of leaning to using the "Enhanced" reconciliation constructs (CB185-Run option "R", CB81, CB82).

    AR submits records to CB upon the release of a batch of payments - one record per batch, with the batch number populating the CBTRANS.TRNS-NBR field (AR-000001, AR-000002, etc) We batch our payments specifically by source/type - for which we use the "Pay Code" (bank inst code).

    CB185 appears (for the most part) to attempt to match bank deposits to CBTRANS entries on a "Transaction Number" basis - but I am not convinced that I can co-ordinate and qualify all deposits from various sources - with the TRNS-NBR generated in CBTRANS by AR payment batch release.

    My only other thought here - is to attempt to organize my deposits by the relevant 'Pay Code" value - and use CB82 to reconcile on that basis.

    Any words of experience would be most helpful
    jjcyeshua
    Veteran Member
    Posts: 49
    Veteran Member
      You can use CB25 if you want to do it manually or individually, or utilize ms addins to reconcile multiple entries...