PO spending tracking for different vendors with similar payments

Hello, I'm new here, so hoping you can help. I searched but couldn't find anything similar to what I am looking for.

I am trying to create a spreadsheet that has vendor name; PO number; how much the PO started with, payment amount & date, which month it is for, how much is remaining. I'd like to keep it all on 1 tab, if possible so that the workbook doesn't get too ungainly.

Ideally, it would be set up with monthly columns/rows so that all that I have to enter is the date and amount paid for each vendor and move on. There are about 30 vendors.

I am slightly familiar with formulas (comfortable-ish) but know nothing about pivot tables.

I hope I included enough information. Thank you for any helpful guidance!