You will get Smart Excel automation for Payroll, HR, reports, and XML data integration
Project details
I specialize in building Excel-based tools to optimize HR, Payroll, and administrative workflows — reducing manual effort, improving accuracy, and delivering structured reports.
This project is perfect for:
✔️ Payroll or HR professionals needing reliable Excel automation
✔️ Consultants who manage Brazilian eSocial or other structured returns
✔️ Teams looking to convert data into clean Excel reports
✔️ Anyone who wants a smart spreadsheet with real logic behind it
What I can offer:
• Custom formulas with LET(), LAMBDA, SCAN(), FILTER(), etc.
• Vectorized logic for efficient spreadsheet design
• Data extraction from XML, JSON or flat files
• Integration with external data via Python if needed (e.g. SOAP/XML with digital certificates)
Deliverables:
• Clean, dynamic Excel workbook (.xlsx)
• Optionally: script or documentation (when needed)
• Screenshots or video guide (on request)
• Limited support for minor adjustments after delivery
🧪 Real project reference: a tool to process Brazil’s eSocial returns in batch, extract XML values and generate consolidated Excel reports — used in production environments.
This project is perfect for:
✔️ Payroll or HR professionals needing reliable Excel automation
✔️ Consultants who manage Brazilian eSocial or other structured returns
✔️ Teams looking to convert data into clean Excel reports
✔️ Anyone who wants a smart spreadsheet with real logic behind it
What I can offer:
• Custom formulas with LET(), LAMBDA, SCAN(), FILTER(), etc.
• Vectorized logic for efficient spreadsheet design
• Data extraction from XML, JSON or flat files
• Integration with external data via Python if needed (e.g. SOAP/XML with digital certificates)
Deliverables:
• Clean, dynamic Excel workbook (.xlsx)
• Optionally: script or documentation (when needed)
• Screenshots or video guide (on request)
• Limited support for minor adjustments after delivery
🧪 Real project reference: a tool to process Brazil’s eSocial returns in batch, extract XML values and generate consolidated Excel reports — used in production environments.
What's included $80
These options are included with the project scope.
$80
- Delivery Time 5 days
- Number of Revisions 0
About Leonardo
Excel Automation & Python Dev | HR/Payroll Tools | eSocial Integration
Niteroi, Brazil - 11:44 am local time
With over 10 years of experience in Payroll and Brazilian eSocial compliance, I develop smart tools that save time, reduce errors, and ensure accurate reporting.
Key skills:
✅ Excel automation & macros
✅ XML parsing & SOAP API (eSocial)
✅ GUI apps with Tkinter
✅ Smart spreadsheet dashboards
✅ HR/Payroll workflow optimization
Let’s simplify your process and deliver real results.
Steps for completing your project
After purchasing the project, send requirements so Leonardo can start the project.
Delivery time starts when Leonardo receives requirements from you.
Leonardo works on your project following the steps below.
Revisions may occur after the delivery date.
Revisions & Refinement
I make edits based on feedback (up to [3] rounds of revisions included). Client approves the final version before final delivery.