Bank Summary - multiple period

reporting

#1

Hi - would you consider a multiple period version of the Bank Summary report? We need to add these to our reporting transaction listing in order to balance back on the fx movement on bank accounts and to have to do this per reporting period is quite painful.

Thanks!


#2

Hi Richard

Given that the report has multiple columns, it will not be straight forward to have multiple period reports. Maybe you can have separate sheets each pointing to a central sheet where all the periods are defined and they you can refresh together.

Attached please find a sample report of what I have in mind. The first sheet defines the period and each of the other sheets is then getting data from separate periods - you can then have another sheet grouping the results together. Once ready, change the periods sheet to whatever dates you need and click on Refresh > All Sheets

multiple bank summary.xlsx (21.6 KB)


#3

Hi Neville,

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.

Thanks