Excel VBA Developer

Job Description

Job Description: We are seeking a skilled Excel VBA Developer to automate our annual working paper process in Excel. This role involves designing macros and workflows to streamline the import of general ledger (GL) and trial balance (TB) data, automate account reconciliations , and generate financial statements such as the Profit & Loss (P&L) and Balance Sheet . Key Responsibilities: Develop automated Excel templates to: Import GL and TB data from raw files Reconcile trial balances with GL accounts Prepare schedules for control accounts and subledgers Build and auto-populate the Profit & Loss and Balance Sheet based on mapped TB data Generate working paper schedules for audit or review purposes Implement VBA macros to: Run full reconciliation processes Highlight discrepancies or out-of-balance accounts Refresh dashboards and reports with one click Ensure all tools are: Modular and adaptable to changes in chart of accounts Documented and easy to use for non-technical finance staff Required Skills: Advanced Excel skills including VBA/macros , dynamic formulas , and data validation Proven experience automating accounting tasks , especially working papers and reconciliations Ability to generate financial statements (P&L, Balance Sheet) from raw TB/GL data Understanding of financial controls , audit workflows , and reporting logic Excellent debugging, commenting, and versioning practices Preferred Qualifications: Degree or background in Accounting or Finance Experience with CA firms , audit support , or MIS/reporting automation Familiarity with Power Query or Power BI is a bonus Job Types: Full-time, Part-time, Permanent Pay: ₹15,000.00 - ₹20,000.00 per month Schedule: Day shift Monday to Friday Work Location: In person