Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Cash Clearing Account ...
Microsoft Dynamics GP (Archived)

Cash Clearing Account for Bank Reconciliation Module

(0) ShareShare
ReportReport
Posted on by radja1856 75

We would like to use the Bank Rec module in GP and are currently doing this manually at this time. Is it a requirement to use a cash clearing account to use the Bank Rec module in Dynamics GP 2010? I have two import files from our revenue system for G/L and BR. G/L brings in data to debit cash clearing and then the BR file credits the same amount to act as a balancing account. Then a J/E is done to move the cash from cash clearing. Couldn't we just avoid using the cash clearing and have things go directly to cash and will that still work with the bank rec module? Any insight/advice would be greatly appreciate.

*This post is locked for comments

  • radja1856 Profile Picture
    radja1856 75 on at
    RE: Cash Clearing Account for Bank Reconciliation Module

    Hi Warren,

    That is similar to how we do it today. We have two SmartConnect map templates (one to GL and one to BR). G/L does DR to cash clearing account and BR does CR to cash clearing. I am thinking we just change the cash clearing account to the cash account in our revenue system then modify our BR map template to DR cash (instead of CR cash clearing) and it should work fine.

  • Warren R. Pease Profile Picture
    Warren R. Pease 730 on at
    RE: Cash Clearing Account for Bank Reconciliation Module

    One more thing

    What is going on at one of my clients is similar to what you are doing.   DR Cash, CR Revenue is done via an integration.   A second integration creates Receipts in BR.   The client then goes in and Deposits the Receipts in BR.   The act of making a deposit from receipts does not create a GL entry.  

    Warren

  • Warren R. Pease Profile Picture
    Warren R. Pease 730 on at
    RE: Cash Clearing Account for Bank Reconciliation Module

    I can only make a bunch of assumptions.   It all really depends on what you are pulling in to BR and the way your are doing deposits.    

    Warren.

  • radja1856 Profile Picture
    radja1856 75 on at
    RE: Cash Clearing Account for Bank Reconciliation Module

    Hi Warren,

    Thanks for the information. I currently have two SmartConnect maps, one that hits BR and one that hits G/L. Ideally, I would like to have only one import file, but can stay with two files if that is the best way to hit BR and GL. I am guessing I can just get rid of the cash clearing, switch directly to cash and that would at least allow BR to work while also hitting the bank rec and GL modules? Would this format work? Unfortunately, our revenue is our A/R system and we do not use Receivables in GP.

  • Warren R. Pease Profile Picture
    Warren R. Pease 730 on at
    RE: Cash Clearing Account for Bank Reconciliation Module

    You can get rid of the clearing account.   Just realize that any entry you make in the GL will NOT show up in Bank Rec.   AP feeds BR, AR feeds BR (via deposits).   But GL does not feed BR.   Anything you do that should impact the Cash GL Account needs to be done via a module outside of the GL.  

    You would need to somehow flow your revenue stream through BR or AR.   Of course how you handle deposits would have a big impact.    One options would be to feed deposits into BR as Increase Adj, with the offset to Revenue in GL.  

    Warren.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,317 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans