Thanks for getting back to me.
Apologies, but I am not sure I am following the response. The other multiple period reports also appear to have multiple columns e.g. the Trial Balance report? Is it because the FX gain/loss is added to the report for periods where there is such an amount? Is there not a way around this?
For the moment I have set up the report as you had suggested, but because I need to run this for every month that I am reporting on, I currently have 36 sheets for a single instance just to pick up bank revaluations. If this starts to happen across multiple instances of Xero then this is going to become quite painful to update each year.
Hope this makes sense and please let me know if you would like to discuss.