Does anyone have a sample of an Excel template they use to translate non reporting currency companies in a consolidation report. I have heard people describe doing this on various boards, but no one provides an example of what the Excel worksheet looks like or how they reference it in the Column Set. I would really appreciate some help with this.
My big issue is that I need different accounts to translate at different historical rates, i.e. Inter-company, Equity, etc. I inherited a poorly designed GP implementation that never had FX setup correctly, and now, 5 years later, the effort to go back and try to tie out all of the rate issues is massive. This would be easier if I could use an Excel worksheet and Management Reporter.