Each month our Accounting department produces financial files for the firm.
These files always have the same name and various individuals contribute the
files.

Do I need to have them name the files differently each month? Currently,
Sharepoint overwrites the old file - and if I uncheck the Overwrite option - the
library will not accept the new file. We are using meta data for the files but
again the file names are the same.