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)