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.