Using excel to generate reports from a Trial Balance

osaben

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

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,098,971
Messages
5,465,747
Members
406,448
Latest member
IrishDMan

This Week's Hot Topics

Top