ChatGPT Prompt for Spreadsheet Comparison

I'm in need of an innovative ChatGPT prompt that can effectively compare two spreadsheets for outliers or anomalies. For a hospitality business the supplier sends a transaction report but the invoice they apply the payment to is not the same one as we make the payment for, as due to cash flow we have to sometimes split payments up. They may apply it to the oldest invoice. There is however sometimes errors where they have not applied our payment and we need a way to quickly spot these, without intensive labour. We need a chatgpt (or google) prompt that will take these two sheets and return a list of possible errors, it may be easier to provide a sheet that links our payment to whichever invoice the supplier has applied it to by checking the amount, note the supplier will list the same invoice ID multiple times as it's per item and our total is for the total. I think a solution is just to take anything that is type "Payment" in column B of the Supplier Transaction report and allocate this payment amount (if it matches) to the amount we pay in column C on ours-wally, since this is generally the indication that they have applied our payment to whatever invoice they have. We need a short output that will list any payment that was not allocated or if it couldn't guess an invoice. In general almost all our payments will be applied within a few days which will help identify. We needs this to be a reusable prompt as we will have other spreadsheets in the same format. The goal is to vastly reduce the amount of time we have to spend comparing to find errors with the primary issue being our payments get applied to differnet invoices or multiple invoices. We need to make sure they have received all the payments we have noted (in the ours-wally sheet) and have a note of them at their end and any payment that is NOT present or amounts are vastly different highlight them. If a prompt cannot be made, will accept a python script but would prefer some sort of prompt. Note I do not have time to go back and fourth, your job is to provide a prompt or script and sample output that solves this issue and use case and makes it much easier to spot problems. So simply do the job and provide a sample/screenshot/output data. I will not reply to any auto bids or bids saying you can do it - I don't have time to engage on that level, as I would be faster just doing it myself if that is the case. Note In this case there is a difference between our totals and the suppliers. Tip will be provided. The sample sheets Supplier: [login to view URL] Our system (Wally): [login to view URL]