I did figure out the formatting issue appending from carryover file to file1. So that seems to have helped some. I still do not match up because merging of the two files requires the company name be identical - however I must know which records were from the carryover file in the final output...any help is appreciated, thanks