Software, Implementation, Training & Support.
One monthly fee.

Build Your Subscription

Mastering the Month End Blog Series: Bank Reconciliation & Foreign Exchange

As with other ERP solutions, the month end close process in Microsoft Dynamics NAV is unique. This series leverages what is unique to NAV in order to help you draft your own period-end checklists and covers the following areas:

As part of our Mastering the Month End Close Process with NAV series, this post covers how to tackle bank reconciliation and re-evaluating foreign exchange balances as part of month end in Microsoft Dynamics NAV.

In this post I’ll outline how to perform how to tackle bank reconciliation and re-evaluating foreign exchange balances as part of month end in Microsoft Dynamics NAV.

Bank Management

Month-end bank reconciliation fees / adjustments

While the bank account is typically reconciled throughout the month, when it comes to the month end close process, there are special adjustments and fees that are often posted to the last day of the previous month. With these transactions, you can enter them directly on your bank reconciliation in the ‘adjustment lines’ worksheet area of the bank reconciliation.

To enter your adjustments:

  • Scroll to the bottom of your bank rec. and expand the Adjustments tab;
  • Enter the Posting Date (typically the statement date) of the line item;
  • Select the relevant G/L account (e.g. “Bank Fees”, “Interest Expense”, etc.);
  • Select the balancing bank account;
  • These will post when you post your bank rec.

NAV Bank Reconciliation Adjustments


[button style=”btn-primary btn-lg” icon=”glyphicon glyphicon-chevron-right” align=”left” iconcolor=”#34b233″ type=”link” target=”true” title=”Like What You’ve Read? Subscribe to Our Newsletter!” link=””]

Foreign Currency Rates

Some clients will allow their customers and vendors to invoice / be invoiced in foreign currencies and, therefore, require tracking and posting of realized and unrealized gains and losses on foreign currency exchange.

This multicurrency management functionality inherently exists in NAV and can be accomplished by following the steps below:

  • Go to Currencies by either using the search function or navigating to Departments > Administration > Application Setup > Financial Management > Finance > Currencies;
  • Select the currency you would like to adjust and click on Exch. Rates in the ribbon;


Currencies Dynamics NAV


  • Change the exchange rate in the window that pops up as necessary and click OK;


Change Exchange Rate Dynamics NAV


  • Click on the Adjust Exchange Rate button in the ribbon;


Adjust Exchange Rate NAV


  • Enter the applicable fields and ranges and click OK to run the routine;

Additional Questions about Bank Reconciliation & Foreign Exchange?

If you have additional comments or questions send us an email or leave a comment below. Also, don’t forget to check out the other posts in our Mastering the Month End Close with Dynamics NAV series:

Leave a Comment

Your email address will not be published. Required fields are marked *




Register to recieve the latest ERP & CRM insights