Month end snapshots

My financial management community would like reports showing pipeline progress from month to month. Can I get a month end snap shot of our on-line database and or selected tables? I can do it with Excel data exports - I guess - just looking for something a little more automated.

The following wikis might be useful to your scenario
Feel free to create a new topic if you still face challenges.