The role supports the Finance team in maintaining accurate financial data, handling banking and Bank Guarantee (BG) records, preparing stock statements and MIS reports, and ensuring timely statutory compliance across the parent company and its project SPVs (HAM road, solar and real estate).

Key Responsibilities1. Excel and Data Maintenance

- Maintain finance trackers, registers and working files in Excel with accurate, up-to-date data.
- Prepare reconciliations, schedules and summaries using formulas, Pivot Tables and lookups.
- Keep master data (vendors, sites, projects, bank accounts, loans) clean and consistent across files.
- Follow version control and file-naming standards so records are easy to trace.

2. Document Handling
- Collect, verify, file and retrieve finance documents: invoices, agreements, sanction letters, bank and lender correspondence.
- Maintain physical and digital files for each entity and SPV, with an index for quick retrieval.
- Prepare and organise documents for lenders, auditors and government authorities on request.
- Track document expiry and renewal dates (BGs, insurance, licences, registrations).

3. Bank Guarantee (BG) and Bank Statement Review
- Maintain the BG register: issue date, amount, beneficiary, expiry, claim period, margin/FD lien and commission.
- Track BG renewals, extensions, reductions and releases, and flag upcoming expiries in advance.
- Review bank account statements regularly; identify unusual debits, charges, interest and unreconciled entries.
- Prepare bank reconciliation statements (BRS) and follow up on pending items with banks.
- Monitor FDs, OD/CC limits, interest rates and TRA/escrow account movements.

4. Stock Statement Preparation
- Prepare monthly stock and book-debt statements for banks within the due date.
- Compile inventory,



receivables (age-wise) and payables data from books and site records.
- Compute Drawing Power (DP) as per sanction terms and reconcile with books.
- Respond to bank queries and stock audit observations.

5. MIS Reporting
- Prepare monthly MIS for management: fund position, group liability, bank balances, BG and FD summary, receivables and payables.
- Prepare project and SPV-wise reports, budget vs actual and cash-flow statements.
- Present data in clear summary formats with key variances highlighted.
- Support lender-facing reports and data requests.

- Required Skills and Knowledge

Area

Expected level

MS Excel

Advanced: VLOOKUP/XLOOKUP, SUMIFS, Pivot Tables, data validation, conditional formatting; basic charts

Accounting software

Working knowledge of Tally ERP / Tally Prime

Banking

BG, LC, FD, OD/CC operations; bank statement review and BRS

Stock statement

Inventory and book-debt statements, Drawing Power calculation

MIS

Monthly management reports, cash flow, budget vs actual

Compliance

GST, TDS/TCS, EPF/ESI basics; awareness of ROC filings

Documentation

Filing systems, record keeping, document tracking

Communication

Explicit written and spoken English and Tamil; email drafting with banks and vendors

Qualification, Experience and Attributes

Qualification: B.Com / M.Com / MBA (Finance);

Experience: 2–4 years in accounts and finance, Infrastructure or project company. Exposure to bank documentation, BG handling and stock statements is an advantage.

Personal attributes:

- Accuracy and attention to detail
- Ability to meet monthly and statutory deadlines
- Organised, with good follow-up discipline
- Confidentiality with financial and banking information
- Willingness to learn and coordinate with sites, banks and auditors

📌 Executive (Erode)
🏢 Ramalingam construction company private
📍 Erode