Excel Expert Needed for Payment Reconciliation Tool
Budget: £10 – £20 GBP
I'm looking for an Excel wizard to craft a reconciliation tool for two payment datasets - our Genie Ledger and Payment Gateway Data.
Key Tasks:
- Identify critical data fields for reconciliation, focusing on Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details.
- Develop a user-friendly tool that compares both datasets and displays all calculations on a dedicated front cover sheet.
- Spot any discrepancies and highlight them in red on the front cover sheet.
Ideal Candidate Should Have:
- Extensive experience with Microsoft Excel, particularly with macros and VLOOKUP.
- Strong analytical skills and attention to detail.
- Ability to present data clearly and in a list format.
I need a straightforward solution with clear explanations of how discrepancies are identified.
Key Tasks:
- Identify critical data fields for reconciliation, focusing on Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details.
- Develop a user-friendly tool that compares both datasets and displays all calculations on a dedicated front cover sheet.
- Spot any discrepancies and highlight them in red on the front cover sheet.
Ideal Candidate Should Have:
- Extensive experience with Microsoft Excel, particularly with macros and VLOOKUP.
- Strong analytical skills and attention to detail.
- Ability to present data clearly and in a list format.
I need a straightforward solution with clear explanations of how discrepancies are identified.