excel sheets were used for ease of user interaction. I suppose I could have all this in access. I really just need to import the raw data then run the analysis and then provide the user with results which would include an over all summary of the analysis. This summary would include the number of accounts that falls under each category as well as the sum of charges of the accounts in each category.

Attached is the empty database, I havent set up the temp tables yet. Attached also is a template for the summary i have been using.