Desarrollar software

Its simple, I work for a moneylender. We have a datasheet (excel) with all the clients info (name, adress, etc). We recibe every day an excel with bank basic information. The important info in that sheet is the day that we charge the client, the name and the amount of the charge. We need a macro that automatize that bank list, dropping the total amount of every client in the column of the date.