RETAINAGE PAYABLES FOREIGN CURRENCY LIMITATIONS
Known Limitations when using Foreign Currency and Retainage
- Unrealized Gain/Loss Not Calculated on Outstanding Retainage
- Residual Balance in the Retainage Control Account
- Recommended Accounting Treatment
Foreign Currency and Retainage Known Limitation
HomeBuilder stores retainage amounts in their original transaction currency. When exchange rates change between the date an invoice is posted and the date retainage is released, the two transactions are treated independently, with currency differences managed by Microsoft Dynamics 365 Business Central's standard foreign currency framework. There are two known limitations to be aware of — one temporary, one permanent — both described below.
Temporary Unrealized Gain/Loss Not Calculated on Outstanding Retainage
Business Central's standard Adjust Exchange Rates routine recalculates open payable balances at the current exchange rate and posts unrealized gain or loss entries to keep the general ledger aligned with period-end rates. However, this routine does not currently process amounts held in the retainage control account.
As a result, if exchange rates fluctuate while retainage is outstanding, the retainage control account balance will not be revalued at period end. This means your balance sheet may understate or overstate the functional currency equivalent of amounts owed back to vendors until the retainage is formally released.
Workaround:
Until this is resolved, your accounting team should monitor outstanding foreign currency retainage balances at period end and consider posting manual journal entries to approximate the unrealized gain or loss if the amounts are material.
Permanent Residual Balance in the Retainage Control Account
When a purchase invoice is posted with retainage, HomeBuilder credits the retainage control account in the functional currency equivalent at the exchange rate in effect on the invoice date. When that retainage is later released, the control account is debited at the exchange rate in effect on the release date. If the rate has changed between those two events, the debit and credit will not be equal, and a residual balance will remain in the retainage control account that will never be automatically cleared.
This is a structural consequence of treating the original invoice and the retainage release as independent transactions — consistent with how Business Central manages foreign currency across all payables — and is considered a permanent characteristic of the application.
Example
The following example illustrates the control account impact using USD as the transaction currency and CAD as the functional (base) currency.
| Event | Transaction (USD) | Rate | Functional Amount (CAD) | Control Account Movement |
|---|---|---|---|---|
| Invoice posted 10% retainage on 1,000 USD |
100.00 USD | 1.28 | 128.00 CAD | Credit 128.00 CAD |
| Retainage released Rate has moved to 1.33 |
100.00 USD | 1.33 | 133.00 CAD | Debit 133.00 CAD |
| Net balance remaining | — | — | 5.00 CAD | Debit (uncleared) |
In this example, the retainage control account carries a 5.00 CAD debit balance after the release is posted. This amount represents the exchange rate difference between the two transaction dates. It will not be cleared by any automated process.
Recommended Accounting Treatment
Your accounting team should periodically review the retainage control account for residual foreign currency balances and clear them with a manual journal entry, posting the difference to a realized foreign exchange gain or loss account. This is consistent with standard practice for transactional FX differences in Business Central.
The recommended journal entry to clear the residual balance is:
| Account | Debit | Credit |
|---|---|---|
| Retainage Control Account (e.g., G/L 21000) | — | 5.00 CAD |
| Realized FX Gain/Loss Account | 5.00 CAD | — |
Debit/credit direction will vary depending on whether the residual is a debit or credit balance.
Notes
Foreign Currency Notice
HomeBuilder stores retainage amounts in their original transaction currency only which means that they are not part of the unrealized loss/gain calculations made on open ledgers. When a retainage release occurs at a different exchange rate than the original invoice, the two transactions are treated independently, with currency gain or loss managed by Microsoft Dynamics 365 Business Central's standard foreign currency revaluation process.
Foreign currency retainage is used at your own risk. We recommend consulting your accounting team to understand the impact of exchange rate fluctuations on retainage balances.
There are two versions available on Microsoft AppSource: