web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Warren R. Pease Profile Picture
    Warren R. Pease 730 on at

    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.

  • radja1856 Profile Picture
    radja1856 75 on at

    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

    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.

  • Warren R. Pease Profile Picture
    Warren R. Pease 730 on at

    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

  • radja1856 Profile Picture
    radja1856 75 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans