Using excel to generate reports from a Trial Balance

[osaben]

I am looking for some ideas. I am not happy with the reporting features associated with my accounting software. So I would like to instead download a trail balance to excel each month and generate standard reports from that trial balance. Each month, I will want to update the trial balance with the new balances and have the reports update accordingly.

Any suggestion/ideas on the best way to go about this? I assume I would have one worksheet for the trial balance and then a separate worksheet for each report. My trial balance has beginning balance, prior month's YTD activity Current month activity & Ending YTD balance. My reports need to include monthly, quarterly and YTD information.

Thanks in advance you your time and consideration.