USA - County Code

I was requested to make a sales report by State by County. Currently, our version doesn’t have county information at all. I was thinking to create County table and modify all related tables in order to issue the report. Before doing that, I was wondering if you ever in the same situation and can give me some inputs and solution to simplify the modification.

Thanks a lot!