Automating month end close in Access

[ISW]

Hi all,

I have been automating reoccurring reporting calculations in Access for the last few months. I am thinking about suggesting that I automate our month end close. This goes from source documents to balance sheet.

This is going to be roughly 21 different workbooks from excel. The importance of this information is substantial.

My question is what should I be careful of before I suggest embarking on such an endeavor. It sounds pretty straight forward but with this much information and the need for it to be accurate and safe I need to cover all my bases.

Any thoughts, suggestions and or warnings would be greatly appreciated.

 

[xenou]

My first thought ... run away run away!!
http://www.youtube.com/watch?v=XcxKIJTb3Hg

Seriously - 21 workbooks suggests the data is not centralized and therefore difficult to manage. I'd probably stay in the shallow end of the pool on this one, unless you really feel ready (and capable) to suggest sweeping changes.