We have been on GP now for about 2 years… We have yet to use the Bank Rec Module. We would like to move to Bank Rec at the beginning of 2017.
The question i have is that i see a lot of “stuff” in Bank Rec that i assume will need to be cleared out before we start using the module? Then i would update our Beginning bank balance, based on our Bank Recon. that we do outside of GP?
i would like to start it clean so any suggestions would be helpful for my staff.
—————————— John Stabler Controller ConsultNet LLC South Jordan UT ——————————
Rob Klaproth
Member
December 8, 2016 at 11:48 AM
John,
My recommendation is to start fresh for the new year. You can run a clear data routine on just the bank rec module and then start over with your checkbook. When you do the clear data make sure you have your local GP partner help you with this because it’s dangerous if you select the wrong tables.
Another (safer) option is to create a new checkbook and start using it on Jan 1. Put the beginning balance in when you create it and make sure all your settings in GP are correct.
A few settings you will change:
On the GL account associated with the checkbook uncheck the box that says allow account entry. This will ensure that only tranasactions that came from bank Rec actually hit that cash account and you won’t get out of balance as easily.
If you are on GP2015 or newer go into the company setup window and go to options and scroll down to the last option that says automatically post cash receipts and check it. This will insure that all your cash that you post in AR gets posted into bank Rec. If not then you will have to make sure whenever you post cash in AR that your staff remembers to go post it in bank Rec.
If you are moving to a new checkbook you will need to make sure you set it as the default for all your customers and vendors. You can easily accomplish this by going into customer classes and vendor classes and setting the default checkbook at the class level. When you click save on the class you modify it will ask if you want to roll down and you say yes. This will apply that checkbook to all customers or vendors using that class.
There is a LOT to this bank Rec stuff and I recommend you don’t try to go at it alone but get a solid GP partner with years of experience who knows how to use the module.
Rob Klaproth
Armanino LLP
Sent from my iPhone
——Original Message——
We have been on GP now for about 2 years… We have yet to use the Bank Rec Module. We would like to move to Bank Rec at the beginning of 2017.
The question i have is that i see a lot of “stuff” in Bank Rec that i assume will need to be cleared out before we start using the module? Then i would update our Beginning bank balance, based on our Bank Recon. that we do outside of GP?
i would like to start it clean so any suggestions would be helpful for my staff.
—————————— John Stabler Controller ConsultNet LLC South Jordan UT ——————————
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Report
You have already reported this .
Welcome to our new site!
Here you will find a wealth of information created for people that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!