Is there a way you can get to this info off of a Currency Reval? The Unrealized FX Gains & Losses Report has pretty much all this info....except the individual currencies, which is annoying. As far as I can tell, you can't add the currency to that report. I can't get that info on a Saved Search or Analytics WB. Am I missing something?

so…. on what accounts are these balances posting? can you give one example? but essentially you will have to write these balances off specific accounts using these currencies, this is the hard way, but the cleanest and the only way really. to find details for these balances you need to run transaction search for all revaluing accounts using one currency as a filter at a time (easier this way) from day one

It's a liability account, similar to a payables account where balances will eventually "clear" out. I already built a search that has all the relevant information and once you pivot it into Excel and pull the ME FX rate, I can match the info from the currency reval (below). But while it's not all that time-consuming, it's certainly annoying and our volume is such that pulling into a pivot table isn't a long-term option since FX revals are based on cumulative activity. We'd outgrow Excel's limit pretty quickly. Even if we wouldn't, it's odd you can't just run a report with info. Super irritating that the Unrealized FX report has all of this information except basically the most important piece of info-the trxn currencies.

if this annoys you this much in your shoes I would clear these pennies every period, just put is as a standard ME journal. There isn’t a way to impact the calcs so that these pennies would go away on their own. AI is not there just yet but perhaps you can write a WF that puts these balances in separate journals.

I'm confused. My annoyance isn't the GL impact of the currency reval. It's that I can't get to a breakdown of the detail that makes up the total reval amount. Will that ever be relevant? Maybe, maybe not. But it would be nice to be able to get to.

you said you had a saved search for your details, no? Or you are not having a saved search per each penny balance you are showing?

We're not connecting at all..lol. Friday afternoon. Though I realize I'm using "detail" in a way that's probably confusing. I have no problem with the currency reval generating and I don't doubt its accuracy. I don't want to journal its impact out nor do I want to calculate and post a JE in lieu of running the Currency Reval. Theoretically if an auditor comes asking, I could show them this currency reval with all the detail. By "detail" in this context, I mean the line by line summary of the FX Balance, Base Currency Balance, FX Rate, Net Gain/Loss by currency that's on that's on the face of the currency reval in the screenshot I posted. Which is "summarized" by currency from the beginning of time through the month you're closing. I just want to be able to get to the exact information on the face of the currency reval, which is summarized information by currency. It appears that's not possible, outside of running my own summarized saved search, which isn't feasible because it would have to be from the beginning of time.