Bank reconciliations in a consolidated company

I have 8 stores and I maintain separate accounting for each store. I bring the data together in a consolidated file in order to generate my financials. All 8 stores use the same bank account. Up until now, I have been doing the bank reconciliation manually but it is about 60 pages long and I would love for Sage to do it for me. I wonder if I can do the bank rec in Sage through the consolidated file rather than reconciling each store individually and manually. Any words of advice?