I have two sheets, one with data about events and then other with financial transactions.
The events are added as they are reserved, possibly months in advance.
The transactions are copied from our accounting system each month and have a lot of data but primarily, some descriptive details (to ID which event it was for), date, amount and a transaction code.
I would like to reconcile these together to confirm, after an event is held, that payment has been received.
I have done other reconciliations of transactions but those were related to ongoing projects with many transactions per project so I could just add the project name to the transactions and work from there.
Any suggestions about how to link the transactions to events in the most simple and automated way?
