
Reconcile/ payment match formula & guidance on how to
- or -
Post a project like this- Posted:
- Proposals: 28
- Remote
- #4467001
- Awarded




Description
Kiaran B.
100% (7)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-

Hello, Can you please available now to talk?
Regards, -

Hi Kiaran, are all the payments with unique amounts, so there is 1-on-1 entry for comparison? Please confirm, or share a sample dataset for reference.
Kiaran B.23 Jan 2026Hello - our clienst pay beweetn £5 to £29.95 a month
I dont have a sample as I have not create dthis yetr
Master sheet would have
columns as followes
Payee name
Website
Payment
Month
- then would need something toupdate on the master sheet so the payment date got pulled across to confirm payment was made that month
- matching document would have
columns
Payee name
Amount
Date
Does that make sense?
I am need payee name to match with a payment on both sheets
but also need proof that was paid that month to be highlighte din someway
A formula would need created so the matching could be done once a monthShahbaz A.23 Jan 2026Ok, this is helpful, thanks.