Data showing who pays a doesnt after manually input receipts

Hello,


Hope im clear on this. Im a bit lost. I have sheet one. This is a spredsheet where we input a secuential number with the name of the student, the date and the amount paid. For example:

date # name amount paid

jan-1-2018 288478 Ricky $300
jan-2-2018 288479 Monica $300
jan-8-2018 288480 Irene $300
feb-2-2018 288481 max $300
feb-4-2018 288482 Monica $300
feb-4-2018 288483 max $300
feb-15-2018 288484 Ricky $300


and so on... manually only entering the name, date and the amont on any random order.
ON sheet 2, i have a table with the name of the student and a full year calendar. Im looking for a way that on January box besides Rickys name, I have $300 or if he did not pay that month, no value. the same for the following months jan-december (1 year) and the same for every other student. Im looking for a simple way of after manually inserting the receipt number with the amount paid, date and name on sheet 1, i can have a full report of all students on a simple JAN-DEC calendar something like this:

JAN FEB MAR APR MAY JUN JULY AGO SEP OCT NOV DEC
RICKY $300 $300
MONICA $300 $300
IRENE $300 $0
MAX $300 $300

I dont need the exact date on the table, only the month they paid.

Was wondering if anyone has a suggestion of how it can be simpler? Any suggestions will be greatly appreciated!