Finance | Project Operations, Human Resources, ...

Bank Revaluation on Zero Balance

(0) Share

Report

Posted on by macruick

Hello,

I have a bank account that is in a different currency than my accounting and reporting currency. At the end of the month, I have reconciled my bank to zero because the account closed. I have also ran revaluation but the balance in transaction and reporting currency still remains. Shouldn't the revaluation be done based on the bank balance of zero?

Anyone else experiencing this? Any insights?

Thanks,

All responses (8)

Answers (0)

Jeremy Driscoll on at

Like (0)

Report

RE: Bank Revaluation on Zero Balance

Hi MA,

Without knowing what version or build you are currently on, I would suggest you take a look at issue 401224. If you do a search for that in LCS, you will see two issues come up. One is considered a duplicate of the other. The one that is considered a duplicate sounds like the issue you are seeing. It looks like this issue is resolved in version 10.0.11.

Jeremy Driscoll

Microsoft Support Engineer
André Arnaud de Cal... 294,157 Super User 2025 Season 1 on at

Like (0)

Report

RE: Bank Revaluation on Zero Balance

Hi MA,

Or ensure there is a balance, or you would need a customization here. You can ask a developer for the options and the impact.
macruick 5 on at

Like (0)

Report

RE: Bank Revaluation on Zero Balance

This is exactly....it skips the zero bank balance accounts so it doesnt run the reval to zero out the accounting and reporting. How do we change this?
macruick 5 on at

Like (0)

Report

RE: Bank Revaluation on Zero Balance

We run the reval in the bank module and have the main account marked to not allow for GL reval. The bank to ledger reconciliation agrees.
macruick 5 on at

Like (0)

Report

RE: Bank Revaluation on Zero Balance

It is marked to not allow for reval at the GL level as we reval the bank accounts in the SL.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Bank Revaluation on Zero Balance

Hi MA,

Where have you run the revaluation (GL or bank module)?

Do you see a difference in the bank to ledger reconciliation report?

Best regards,

Ludwig
Suggested answer

Maverick Blogger 60 on at

Like (0)

Report

RE: Bank Revaluation on Zero Balance

Hi,

May be obvoious but have you enabled the "Foreign currency revaluation" flag on the ledger account linked to bank account.

If bank balance is zero but ledger balance is showing, it might not be enabled for reval.
André Arnaud de Cal... 294,157 Super User 2025 Season 1 on at

Like (0)

Report

RE: Bank Revaluation on Zero Balance

Hi MA,

Not completely sure, but it might be the case that a zero balance will be skipped for revaluations. Can you possibly try in a test environment what happens if you have e.g. the original balance, then revaluate and after the revaluation reconcile to zero?