Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Adriana Cartagena]

Hello Everyone. I am new to working on Bank Reconciliations. I was wondering if anyone knows if there is a way to have the system match the checks cashed without me having to check each and everyone one off? Can we bring in a file where it can match it up for us? or am i stuck having to check each cashed check one by one?

——————————
Adriana Cartagena
Joseph Cory Holdings, LLC
Secaucus NJ
——————————

[Bert Green]

There is a module called Electronic Bank Reconciliation which depending on what version of GP you are on might be available. It is on the installation media. Once installed and you have access to it. You will setup the mapping for the file that you receive from your bank. It will go through and match the items that it can and then give you a report on the items that it was not able to match.

——————————
Bert Green
GP Developer/GP Administrator
Berger Transfer & Storage, Inc.
Saint Paul MN
GP2015/MR CU11
——————————
——————————————-

[Al Schuette]

I agree with Bert.  GP provides a module/capability specifically for this task and I believe it is available at no charge to most users.  I feel using a structured tool within the package is a better approach than creating a custom integration.

——————————
Al Schuette
Senior Business Consultant
Heartland Business Systems
Little chute WI
——————————
——————————————-

[Ronda Smith]

Have you tried Select Range in the Select Bank Transactions box?  It helps when you have a range of checks with no skips to be cleared in lieu of checking off each check.  Select beginning and ending range then select Mark.  This is not beneficial if you have a lot of skips in your check# range, however.

——————————
Ronda Smith
Arkansas Specialty Orthopaedics
Little Rock AR
——————————
——————————————-

[Barbara Gavron]

If you own Integration Manager you can upload your cleared checks. You must first get a file downloaded from your bank (most online banking systems will let you export a list of cleared checks within a date range). I put the information in the above format. There is an example Bank Reconciliation integration already set up in IM that you can mimic (I recommend not changing the one that is already there just in case something gets messed up. You will always have it to refer to). Let us know if you need additional assistance.

——————————
Barbara Gavron
Atlantic Beach / Jacksonville FL
904-536-0129
——————————
——————————————-

[Thomas Hill]

I found this discussion thread, that addresses exactly what our Accounting Manager wants to do, simplify the clearing of checks each day.  He can get the basic data from the bank, no problem there.  He just needs to add the GP2010 fields.

In the first column of your example you have CHK as the TYPE.  When I look at what our SmartList extracts, it says CHECK.  Is that something that is configured by Customer (me) or designated by Dynamics.  

I did an IM to create a number of new general ledger accounts, and I did not supply the correct information for some of the fields.  So I need to do more research there as well.  

——————————
Thomas Hill
Accounts Payable – Expense Processing
M&A Technology, Inc.
Carrollton TX
——————————
——————————————-

[Barbara Gavron]

Thomas,

Yes, the type should be CHK. If you look at your Bank reconciliation screen you will see that the codes are: CHK, DEP, IAJ, DAJ and WDL.

Happy Reconciling!

——————————
Barbara Gavron
Atlantic Beach / Jacksonville FL
904-536-0129
——————————
——————————————-

[Thomas Hill]

Thanks Barbara.  

Good one… “happy reconciling”.  The Accounting Manager is pulling his hair out for the mess his predecessor made in the month long tenure with us.  

I am going to test clearing checks via IM in our test company so I can help the Accounting Manager do it.

——————————
Thomas Hill
Accounts Payable – Expense Processing
M&A Technology, Inc.
Carrollton TX
——————————
——————————————-

[Theresa Bailey]

OUTSTANDING! THIS IS EXACTLY WHAT I AM LOOKING FOR!! THANKS!

——————————
Theresa Bailey
Accounting Manager
Independence Oilfield Chemicals, LLC
The Woodlands TX
——————————
——————————————-

[Gerald Buenafe]

There is also a product called easy e-bankrec here is the link of their product https://easybankrec.com/

——————————
Gerald Buenafe
Owner/Consultant
BTP Technologies LLC
CHANTILLY VA
——————————
——————————————-