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

[Debra Rohlik]

We are currently running 2 versions on NAV, 2013 and 2016.  In November of 2016 we brought one of our divisions up on NAV2016 and are struggling with the bank reconciliation process. 

In NAV2013 when starting the reconciliation we are taken to page 10120, bank rec worksheet.  In NAV2016 we go to page 379, Bank Acc. Reconciliation.  It was setup for us to do auto matching which isn’t working at this point.  To make it work we are manually adding the bank statement lines which defeats the purpose of auto matching as it is more time consuming.  After the first reconciliation was completed we were unable to find a bank statement report that prints out in NAV2016 like the report we are printing in 2013 (report #10408 see attachment).  I suspect this has to do with the manner the reconciliations are being created between the 2 versions.  I have a couple of questions:

Is there a report that exist in NAV2016 that will supply me with this information like NAV2013 that I am missing? 

We are not a fan of the auto matching and would like to go back to the manual bank reconciliation like we are currently utilizing in 2013.  How do we do that? 

——————————
Debra Rohlik
Accounting Process Manager
Farmers Union Industries, LLC
Redwood Falls MN
——————————

[Georges Leduc]

Hello Debrah,

To return to the old Bank Rec pages, you just have to uncheck the Auto Bank rec field in the General Ledger Setup page.

——————————
Georges Leduc
Georges Leduc ERP Consultant, S.A.
L’Ile Perrot QC
——————————
——————————————-

[Michelle Berry]

Debra –
1. you can navigate yourself to the Report Selections – Bank Accounts and select the Bank Reconciliation; set the Test and Post Print report to Report 10408 and you will get the same report as your previous version of NAV.
2. to set your bank reconciliation process back to a ‘manual’ state you can navigate to the General Ledger Setup and on the General Fasttab you will uncheck Bank Recon. Set Auto Match.

You should now be able to run a manual bank reconciliation process and print the same report.
M

——————————
Michelle Berry
Advisory NAV Consultant, Director of Sales NA
NAV DNA, LLC
Clearwater FL
——————————
——————————————-

[Amanda Mayer]

I feel like I’m missing something here. I am in NAV 2017 and using the new Bank Reconciliation feature. I like it but now that I’ve posted the Bank Statements, I can’t seem to find a way to print a report similar to the bank reconciliation report. 

I understand the comment about changing for the test report, but can’t find the option to print an already posted Bank Statement. The print option that is available (by customizing the ribbon), will only print the Bank Statement list….

Thanks!

——————————
Amanda Mayer
New View Strategies
Milwaukee WI
——————————
——————————————-

[Jane Bannister]

Amanda

Did you manage to resolve your issue as I also do not know how to do this?

——————————
Jane Bannister
Procurement International Ltd
Finchampstead
——————————
——————————————-

[Tim Metz]

?Good afternoon, we are new to NAV 2016. I was able to reconcile my first bank account today. Learning process. Question how do I get a bank reconciliation report with bank balance, outstanding checks and deposits, and book balance.

I could not find this report in the list. When I posted the bank statement to the general ledger, it printed out a report labeled Bank Account Statement, which shows all the cleared bank account transactions.

Any help in is appreciated. Tim

——————————
Tim Metz
Shin-Etsu MicroSi, Inc
Phoenix AZ
——————————
——————————————-

[Matt Kress]

Hi Tim,

I get that report by selecting “Post and Print” when posting the bank rec.  If it has been posted without printing, you can do a search for posted bank recs and all the posted bank reconciliations should pop up.  

Hope this helps.

——————————
Matt Kress
Rupp Seeds Inc.
Wauseon OH
——————————
——————————————-

[Tim Metz]

?

Good afternoon, thank you all for responding to my bank reconciliation request. Your directions were correct and true. While going through the process we created several new questions.

All of the bank transactions where matched to the correct bank ledger entries and it balanced to zero as required. However, when we posted the bank statement, the posted bank statement does not show up in the posted documents, under posted bank recs. Curious as to why this was not listed as a posted transaction.

Further, when we ran the Bank Account – Reconcile report all of the cleared transactions showed up in the report. In the Bank Account Ledger entries list, all of the items that cleared showed and empty open box (No check mark in the open box). My understanding was if the Open check box was not checked, in Bank Account Ledger Entries then those items would not show up on the Bank Account – Reconcile report. This would provide a true bank reconciliation – Month end bank balance plus or minus uncleared transactions equals book balance.

Question – does the missing posted bank statement have anything to do with erroneous Bank Account – Reconcile report? Is there programming issue which prevents a correct Bank Account – Reconcile report?

We have many checks printed for the same amount and auto matching does not match by check number.

Question 2, can you change the programming to a bank Acc. Reconciliation “Match Automatically” function to match by check number 1^st, and amount second?

Or are you better off reducing the date tolerance to eliminate this issue and perhaps matching the checks manually?

We are learning how this all works in test before we use the production company.

Any suggestions will be helpful.

Tim

——————————
Tim Metz
Shin-Etsu MicroSi, Inc
Phoenix AZ
——————————
——————————————-

[Heather Joseph]

Tim,

Go to Departments – Finance Management – Cash Management – Bank Accounts. Highlight the bank account you want and click on the Navigate tab. In addition to posted reconciliations you can also find your check ledger entries and list of deposits.

——————————
Heather Joseph
Bakery de France
Rockville MD
——————————
——————————————-

[Reg Duncan]

Posted Bank Reconciliations show up as Statements on the Bank account card.

——————————
Reg Duncan
Ed Mirvish Enterprises Limited
Toronto ON
——————————
——————————————-

[Ron Ketterling]

Use the Bank Rec. Test Report before you post the Bank Rec to see the status of each item before you post.  Or, once posted – Departments/Financial Management/Cash Management/Bank Accounts – select the bank account – Navigate/Posted Reconciliations – check Detail to see status at time of posting.

——————————
Ron Ketterling
President
Business Automation Specialists of MN, Inc.
Minneapolis MN
——————————
——————————————-

[Tara Langley]

?Hi ,

We are also looking for a way to print a bank reconciliation with ending book balance & outstanding items. When I follow your instructions to go to “Departments/Financial Management/Cash Management/Bank Accounts – select the bank account – Navigate/Posted Reconciliations”, the list is empty. I can select Report/Bank Reconciliation and check the Print details box (which would appear to provide everything I’m looking for), but how do I get the posted reconciliations to show up there to begin with?

Thanks,

?

——————————
Tara Langley
Accounting Manager
Culver Franchising System, LLC
Prairie du Sac WI
——————————
——————————————-

[Ron Ketterling]

The Bank Reconciliation will appear here if you are using the traditional NAV reconciliation model as shown below.  If you are using the new model, it may appear in Statements – see the Navigation pane below.  Your partner may have done some modifications that do something different than stock NAV.  Your partner should be able to tell you how to get this data.

You can check in Developer on table Posted Bank Rec. List (10129) and new model table Account Statement (275).  

Hope that help.

——————————
Ron Ketterling
President
Business Automation Specialists of MN, Inc.
Minneapolis MN
——————————
——————————————-

[Cynthia Priebe]

There is no “traditional” posted bank reconciliation report if you use the new Bank Rec with Auto Match.

Because of this, I have customers that have chosen to NOT use this potentially great new functionality. Their accountants require that they provide the traditional bank rec report each month including tie out to the GL at the end date of reconciliation, not the date the reconciliation was performed.

——————————
Cynthia Priebe, MCTS, DCP
Senior Business Analyst and Project Manager
Liberty Grove Software
——————————
——————————————-