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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / LOCAL CURRENCY IS CDN ...
Small and medium business | Business Central, N...
Suggested Answer

LOCAL CURRENCY IS CDN US BANK ACCOUNT G/L NOT BALANCING

(1) ShareShare
ReportReport
Posted on by MG-09051727-0 2
Our US bank account is not in balance with the us g/l (in cdn)
G/L ($) on Bank rec is $331.22 (should be Cdn equivialent )= g/l Balance is $607.9 (US dollars)
How can I adjust the G/L balance only  without touching the bank accounts?
Thankyou
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,331 Super User 2025 Season 2 on at
    Hi, just select G/L Account (Account Type) in the General Journal to adjust the amount.
    For example, SAVING -> 18200
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 8,200 Super User 2025 Season 2 on at
    you need to first find out what is causing the imbalance. There are a few things to investigate
     
    It could be incorrect currency conversion rate. Go to currency page for cdn if your local currency is usd. Or the other way. check the exchange rates.
    It could be postings made directly to the gl account without going through the bank subledger. To find out you need to go to g/l ledger entries and filter for the g/l account to find out what is causing the imbalance.
     
    I won't recommend you to adjust gl account without finding out what the issue is.
     
    if you are certain you just want to adjust the gl account, you could go to general journal and choose a balancing account which is not the bank account.
     
    Jun Wang

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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans