Browse categories
Explore
Fiverr Pro
English
$
USD
I will automate excel reconciliation with vba macros
Automation Developer, Excel VBA, Web Development and Data Solutions
Professional Reconciliation Officer and Automation Developer with 3+ years cross-referencing broker statements against internal ledgers. I turn time-consuming manual processes into fast, automated wor...
About this Gig
Drowning in manual spreadsheet work? Spending hours matching transactions or hunting discrepancies between two systems? Let's make that disappear.
I am a professional Reconciliation Officer who builds Excel automation tools for a living. Most Excel "experts" can write a formula, but far fewer understand why a number has to tie out to the penny, or how messy real-world data exports actually behave. I bring finance-grade rigor to your spreadsheets.
What I can build for you:
- Reconciliation Tools: Match two data sets and flag every discrepancy automatically
- VBA Macros: Automate repetitive tasks one click instead of an hour
- Data Cleaning: Standardize messy exports and remove duplicates
- UserForms and Dashboards: Turn your workbook into an app anyone can run
Why work with me:
- 3+ years real finance industry experience
- Clean commented VBA code with error handling
- Happy to work with anonymized or dummy data
Message me before ordering with your task description and a sample file. Let's automate the boring stuff!
Platform:
Excel
•
VBA
•
Microsoft Office
Development technology:
VBA
•
Python
•
Excel
Expertise:
Functions
•
Macros
•
Power Query
•
Cleaning
•
Data validation
FAQ
Can you build a tool that compares two systems and finds the differences?
Yes - this is my specialty. As a Reconciliation Officer I build tools daily that match two data sets (e.g., bank vs. ledger, broker vs. internal) and automatically flag mismatches, duplicates and missing items. Just send me a sample of both files.
I'm not technical can you build something my whole team can use?
Absolutely. I build workbooks with simple buttons and forms so anyone can run the automation with one click - no Excel skills needed. Every delivery includes a short instructions file.
Will the macro break when I add new data?
No. I build with dynamic ranges and error handling so your tool keeps working as your data grows. Tell me how your data changes month to month and I'll design for it.
Is my financial data safe?
Completely. All communication and files stay inside Fiverr's secure system, and for sensitive data I'm happy to work with anonymized or dummy figures that mirror your real structure.
What do you need from me to start?
A sample file (real or dummy), a description of the task you do manually today, and what you want the final output to look like. The clearer the brief, the better the first delivery
What if my bank or broker changes the format of their export file later?
The macro is hard-coded to the specific column headers and data structure provided in your initial sample file. If your broker completely changes their export layout in the future, the code will require an update, which I can gladly provide for a small maintenance fee.
What happens if the macro produces an error after delivery?
I build, test against unusual inputs, and deliver with documentation to prevent this. However, if a genuine bug occurs within the exact scope and data structure we originally agreed upon, I will fix it to ensure your tool runs flawlessly.
