web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Bank Reconciliations in GP for multiple years and parent-subsidary companies?

(1) ShareShare
ReportReport
Posted on by 5

Hello,

What is the best way of doing bank reconciliations for a company that has been using GP for several years but has only doing bank recs OUTSIDE of GP. There are many years and many transactions, it would be impossible to do each bank rec to catch up. Additionally, there is a Parent and several subsidiaries.

Is there a way to "catch-up" GP recs? They were done in Excel outside of GP. 

Your help is much appreciated! Thanks!

Categories:
I have the same question (0)
  • Suggested answer
    Hokuminaria Profile Picture
    2,950 on at

    Hello Rover123,

    I believe what you are looking for is the KB below. How to start using an existing checkbook to reconcile in Bank Reconciliation.

    docs.microsoft.com/.../how-to-start-using-existing-checkbook-to-reconcile

    If that does not work, the other options would be to create a new checkbook and start using that going forward.

    I hope this helps!

    Thank you!

    Brandon | Microsoft Support Engineer.

  • Rover123 Profile Picture
    5 on at

    Thank you! I will try this. Not sure if creating a new checkbook will work for me unless the GL code stays the same.

    Do you know if bank reconciliations are possible with 1 parent and several subsidiaries? For example, 3 bank accounts where activity for parent and subsidiaries are all blended but they have different companies in GP.

    I appreciate your help!

  • Suggested answer
    Isaac Olson Profile Picture
    on at

    With GP I can't think of a way that you could do this without adding a 3rd party application.  There are some add-on products that would get more advanced with the bank rec module that could probably handle the scenario above.

    I hope this helps!

    Isaac Olson

    Microsoft Support

  • Mike Bufano Profile Picture
    1,484 on at

    One would need to know more about your banking transactions between companies and whether each company is setup as a separate database or if all companies are combined into one database.

    If security isn't a concern, and the Chart of accounts are standardized between all companies, then placing all companies in one GP database makes sense.  You would use a segment in your COA as a company identifier.  You could then use GP inter-fund setup to automatically create balancing intercompany  entries when recording entries across companies.

    If your companies are in a separate database, you might consider the Nolan Intercompany because it supports bank transactions between checkbooks.  

    This isn't really a question that we can easily answer on the forum.   If you are a partner, then I probably gave you enough to get started.  If you are a GP end user, then you should contact your reseller so that they can evaluate your requirements and properly advise on a solution.  

    If you would like more information, send me a separate email and we can discuss your issue...mbufano@intellitecsolutions.com

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

News and Announcements

Season of Giving Solutions is Here!

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 679 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 429 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 264 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans