Using excel to generate reports from a Trial Balance

osaben

Board Regular
Joined
Mar 17, 2010
Messages
51
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.
 

Forum statistics

Threads
1,085,408
Messages
5,383,482
Members
401,832
Latest member
Davezilla

Some videos you may like

This Week's Hot Topics

Top