has anyone had any issues with currency revaluatio...
# accounting
j
has anyone had any issues with currency revaluations? I'm wondering if there is something wrong with my logic - this is for accounts which are set to revalue, and have a general rate type of current: ▪️ Sum amount (foreign currency) on all account transactions up to and including period in question, grouped by currency. ▪️ Look up the period end exchange rates for all currencies. Multiply each amount (foreign currency) by the exchange rate ▪️ The total of these items should be equal to the total of amount on all transactions (I have set the option consolidated exchange rate on the saved search to None) In most cases and most periods, this has been working fine. But this month my intercompany payables in one subsidiary, and intercompany receivables in a different subsidiary, are not playing ball. They are different by different amounts. If I try to manually revalue just these accounts, I'm not getting any results in the revaluation journal. Strangely, my elimination journals are calculating based on my calculation above. What this means is I end up with a variance between my intercompany receivables and intercompany payables, which normally would eliminate to zero on both sides. I can post a reversing journal to correct it, but just want to make sure that a) my calculation is sound, and b) this isn't going to be an ongoing issue with our revaluations. My auditors are likely to query me posting something directly to unrealised gain/loss