A system, method and computer program are provided for generating error and summary reports for a data load. A plurality of records to be loaded in a database are received. The records may include medical records. A data management template corresponding to the records is chosen. It is verified that all records to be loaded match the data management template. The records are sent to a database for loading in the database upon validation that the records match the data management template. A report of records that match the data management template and records that do not match the data management template is compiled.