Finance Internship Project Ideas: 25 Impressive Projects for B.Com & CA Students

Why Project Quality Sets You Apart in Interviews

Most B.Com and CA articleship students list internship experiences on their resume with vague descriptions like "assisted in audit" or "prepared MIS reports." Recruiters at Big 4 firms, investment banks, and corporate finance teams read hundreds of such resumes every campus season. What stops them in their tracks is a concrete, well-described project with a clear output and a measurable impact.

A high-quality internship project does three things: it proves you can work independently, it demonstrates proficiency with professional tools, and it shows business curiosity beyond the assigned task. When an interviewer at Deloitte or Goldman Sachs asks "tell me about a project you did during your internship," you need an answer that takes them through a real analysis, not a task list.

The 25 projects below are organized by category. Each includes a description, the tools required, the expected deliverable, and a one-line statement of why it matters to employers. You do not need to complete all of them — two or three well-executed projects from different categories are far more powerful than five rushed ones.

Financial Analysis Projects (6 Ideas)

1. Five-Year Ratio Analysis of a NSE-Listed Company

Download five years of annual reports for a company like Titan, Asian Paints, or Infosys from the NSE website. Calculate liquidity, solvency, profitability, and efficiency ratios for each year and build a trend chart in Excel. Write a 500-word commentary explaining what the trends reveal about business health.

• Tools: Microsoft Excel, NSE/BSE annual report PDFs
• Deliverable: Excel workbook with ratio dashboard and written commentary
• Impact: Demonstrates financial statement literacy — the single most tested skill in finance interviews

2. Working Capital Cycle Study of an FMCG Company

Choose an FMCG company such as Hindustan Unilever or Dabur. Calculate inventory days, debtor days, and creditor days across three years using balance sheet and P&L data. Map the cash conversion cycle and identify if the company is improving or deteriorating in working capital efficiency.

• Tools: Excel, company annual reports
• Deliverable: Working capital efficiency report with waterfall chart
• Impact: Working capital is a core topic in treasury, banking, and CA final — this project shows applied understanding

3. DuPont Analysis of Indian Banking Sector

Apply the three-factor or five-factor DuPont model to decompose Return on Equity (ROE) for three Indian banks — one PSU bank (SBI), one large private bank (HDFC Bank), and one small finance bank. Compare what drives their profitability differences.

• Tools: Excel, RBI DBIE data portal, bank annual reports
• Deliverable: Comparative DuPont table with bar charts and 1-page analysis
• Impact: DuPont decomposition is used in equity research and credit risk — this project signals serious analytical intent

4. Comparative P&L Analysis Across Competitors

Pick a sector — cement, IT services, or pharma — and create a side-by-side P&L analysis for three competing companies over two financial years. Normalize revenue to 100 (common-size analysis) to compare cost structures and margin profiles.

• Tools: Excel, Screener.in or Moneycontrol for data
• Deliverable: Common-size P&L comparison table with margin trend chart
• Impact: This mirrors exactly what equity analysts and M&A teams do — recruiters immediately recognize the format

5. Free Cash Flow Model for a Listed Indian Company

Build a simple three-year FCF model using cash flow from operations and capex data from annual reports. Estimate next-year free cash flow based on revenue growth assumptions and present your findings in a one-page summary.

• Tools: Excel, annual reports
• Deliverable: FCF model spreadsheet and executive summary
• Impact: Free cash flow analysis is foundational to valuation — shows you understand cash over earnings

6. Credit Risk Assessment for a Mid-Cap Borrower

Using publicly available financials of a mid-cap listed company (market cap ₹500–5,000 crore), prepare a credit assessment memo evaluating repayment capacity, leverage, and debt service coverage ratio as a bank analyst would.

• Tools: Excel, Screener.in, company filings
• Deliverable: 2-page credit memo in Word/PDF
• Impact: Directly relevant for banking and NBFC roles — shows you can think like a lender

Audit & Compliance Projects (5 Ideas)

7. IFC Testing for a Manufacturing Company

Design a sample Internal Financial Controls (IFC) testing checklist for key business processes — procure-to-pay, order-to-cash, and payroll — of a manufacturing company. Document control objectives, test procedures, and sample findings as per Companies Act 2013 requirements.

• Tools: Word, Excel, ICAI IFC guidance documents
• Deliverable: IFC test workpaper template with simulated test results
• Impact: IFC testing is a core deliverable in Big 4 statutory audit teams — this project shows audit process knowledge

8. GST Reconciliation and ITC Optimization Study

Using a sample dataset (real client data if available, or a realistic mock dataset), reconcile GSTR-2A/2B with purchase register entries. Identify mismatches, potential ITC reversals, and optimization opportunities. Calculate the financial impact of unreconciled ITC.

• Tools: Excel, GST portal (or offline tool), Tally Prime
• Deliverable: Reconciliation report with mismatch summary and ITC recovery estimate
• Impact: GST reconciliation is one of the most in-demand skills in CA firms and tax consulting

9. TDS Compliance Audit

Review a company's (or mock entity's) TDS deduction and deposit compliance for one financial year. Check applicability of TDS rates, timely deposit (by 7th of following month), Form 26Q/24Q filing compliance, and identify any shortfall in deduction or late filing exposure.

• Tools: Excel, TRACES portal, Income Tax Act reference
• Deliverable: TDS compliance checklist with gap analysis
• Impact: TDS compliance gaps create direct tax liability — this project shows practical tax audit skill

10. Concurrent Audit Sampling Plan for a Bank Branch

Design a concurrent audit program for a bank branch covering loan disbursement verification, KYC compliance, cash transaction reporting, and forex transaction limits. Define sampling methodology and document audit observations in RBI-aligned format.

• Tools: Word, Excel, RBI concurrent audit guidelines
• Deliverable: Concurrent audit program document with sample observations
• Impact: Concurrent audit experience is highly valued by banks hiring CA freshers and articleship candidates

11. Fixed Asset Physical Verification Report

Prepare a fixed asset physical verification plan and reconciliation report for a hypothetical manufacturing entity. Compare asset register entries with physical count results, identify discrepancies, and recommend accounting treatments for missing or damaged assets.

• Tools: Excel, Ind AS 16 / AS 10 reference
• Deliverable: Physical verification report with reconciliation statement
• Impact: Fixed asset verification is a standard statutory audit assignment — this project prepares you for immediate deployment

Taxation Projects (4 Ideas)

12. Advance Tax Planning Model for an HNI Client

Build an Excel model that computes quarterly advance tax installment liability for a high-net-worth individual with multiple income sources: salary, capital gains (LTCG and STCG), rental income, and business income. Factor in available deductions under Chapter VI-A and calculate interest exposure under Section 234B/234C if installments are missed.

• Tools: Excel, Income Tax Act sections 234B/234C, Income Tax portal
• Deliverable: Dynamic advance tax planner with sensitivity analysis
• Impact: Advance tax planning is a core service in CA practice — this model is immediately billable

13. New vs Old Tax Regime Comparison for a 50-Employee Company

Using realistic salary structures across three employee categories (junior, mid-level, senior), compare tax liability under the new regime versus old regime. Build a decision tool that tells each employee which regime saves more tax based on their deduction profile.

• Tools: Excel, Finance Act 2023 / Budget 2024 amendments
• Deliverable: Interactive comparison tool with employee-wise regime recommendation
• Impact: With default new regime effective from FY2024-25, every HR and payroll team needs this analysis

14. Transfer Pricing Documentation for an SME with Related Party Transactions

Prepare a simplified Transfer Pricing documentation file for a hypothetical Indian SME that sells goods to its foreign parent at a price that needs to be benchmarked. Apply the Comparable Uncontrolled Price (CUP) method and document the arm's length analysis as per Section 92C of the Income Tax Act.

• Tools: Word, Excel, CBDT TP regulations, OECD guidelines (reference)
• Deliverable: TP documentation file (Form 3CEB ready format)
• Impact: Transfer pricing is a growing practice area — this project is highly differentiated for CA students

15. MSME Tax Benefits Optimization Study

Analyze available tax benefits for a Micro or Small enterprise registered under the MSMED Act — Section 80IC deductions, presumptive taxation under Section 44AD, and GSTN composition scheme. Build a recommendation document with tax savings estimate under each option.

• Tools: Excel, Income Tax Act, GST Act
• Deliverable: MSME tax optimization report
• Impact: MSMEs are the largest client segment for CA firms — this project shows practical small business advisory skill

Technology & Analytics Projects (5 Ideas)

16. Power BI Dashboard for Month-End Close

Design a Power BI dashboard that visualizes key month-end close metrics for a hypothetical company: trial balance summary, revenue vs budget variance, top 10 expense lines, and days-to-close trend. Use a sample Excel dataset as the data source and publish the dashboard to Power BI Service.

• Tools: Microsoft Power BI Desktop, Excel, Power BI Service (free)
• Deliverable: Published Power BI dashboard with screenshots and documentation
• Impact: Power BI is now expected in Big 4 advisory and corporate finance — this project proves tool proficiency

17. Excel Macro for Invoice Aging Automation

Write a VBA macro in Excel that automatically categorizes accounts receivable invoices into aging buckets (0-30 days, 31-60 days, 61-90 days, 90+ days), highlights overdue amounts in red, and generates a summary pivot table — all with a single button click.

• Tools: Excel VBA
• Deliverable: Excel workbook with macro + documentation of code logic
• Impact: Automation projects signal high productivity potential — recruiters notice candidates who reduce manual work

18. Python Script for Bank Reconciliation Automation

Write a Python script using the Pandas library that reads a bank statement CSV and a cash book Excel file, matches transactions by amount and date (with a tolerance for timing differences), and outputs a reconciliation report listing unmatched items. Even a working prototype demonstrates advanced initiative.

• Tools: Python 3, Pandas, openpyxl, VS Code or Google Colab
• Deliverable: Python script (.py file) with sample data and README on GitHub
• Impact: Python in accounting is an emerging must-have — this project is impressive even for freshers applying to analytics roles

19. Power Query Data Consolidation for Multi-Branch Company

Using Power Query in Excel, consolidate monthly sales data from 10 simulated branch files (with slightly different column names and formats) into a single master report. Apply data cleaning transformations and create a branch-wise monthly summary table automatically refreshable when source files are updated.

• Tools: Excel Power Query
• Deliverable: Excel workbook with documented Power Query steps and consolidated report
• Impact: Multi-branch consolidation is a real pain point in every corporate finance team — solving it demonstrates immediate value

20. SQL Journal Entry Anomaly Detection

Using a mock journal entry database (create in SQLite or use a sample dataset), write SQL queries to flag potential anomalies: entries posted after period close, round-number entries above threshold, entries by terminated employees, and unusual debit-credit combinations. Document your audit logic.

• Tools: SQL (SQLite, PostgreSQL, or MySQL), DB Browser for SQLite (free)
• Deliverable: SQL query file with annotated audit logic and anomaly report
• Impact: Data analytics in audit (DAAT) is a fast-growing CA/CPA skill — this project is ahead of most peers by 2 years

ESG, FinTech & Other Projects (5 Ideas)

21. ESG Reporting Readiness Assessment for an Indian Company

Choose a mid-cap NSE-listed company not in the top 1,000 by market cap. Review their latest annual report and BRSR (Business Responsibility and Sustainability Report) disclosure under SEBI's mandate. Score them against SEBI's BRSR Core indicators and write a gap assessment with recommendations to improve their ESG disclosure quality.

• Tools: Word, SEBI BRSR framework (SEBI circular May 2021), company annual report
• Deliverable: BRSR gap assessment report (3-5 pages)
• Impact: ESG/sustainability reporting is a fast-growing practice area — early movers in this skill are commanding premiums in hiring

22. Carbon Footprint Estimation for a Manufacturing Unit

Using publicly available emission factors and energy consumption data from a company's BRSR report, estimate Scope 1 and Scope 2 GHG emissions for one financial year. Compare against their disclosed targets and industry benchmarks.

• Tools: Excel, GHG Protocol calculation tools (free), company BRSR
• Deliverable: Carbon accounting worksheet and 1-page summary
• Impact: Sustainability accounting is a CPA/ACCA exam topic and a growing Indian compliance requirement

23. GST Filing Optimization Using ClearTax vs Government Portal

For a simulated business with 50 monthly invoices, document the complete GSTR-1 filing workflow using both the government GST portal and ClearTax. Compare time taken, error detection capability, ITC matching automation, and cost. Prepare a recommendation for a CA firm advising clients on tool selection.

• Tools: GST portal (demo environment), ClearTax free trial, Word/Excel
• Deliverable: Comparative analysis report with recommendation
• Impact: Technology tool advisory is increasingly part of CA firm services — this project positions you as a tech-aware professional

24. Digital Payment Reconciliation for a Retail Client

Create an Excel reconciliation framework that matches daily POS machine settlements, UPI payments (PhonePe/GPay merchant), and Razorpay gateway collections with the bank statement and Tally entries. Calculate any unexplained variance and suggest an internal control improvement.

• Tools: Excel, Tally Prime (or simulated data), bank statement format
• Deliverable: Reconciliation template with variance analysis
• Impact: Digital payment reconciliation is a real problem for every retail business in India — immediate practical value

25. Investment Thesis for an NSE-Listed Mid-Cap Stock

Write a structured 2-page equity research note on a mid-cap NSE company. Cover business model, key revenue drivers, competitive position, recent financial performance (last 3 quarters), key risks, and a simple price-to-earnings based valuation with a buy/hold/sell recommendation.

• Tools: Word, Screener.in, Moneycontrol, NSE filings
• Deliverable: Equity research note in professional format
• Impact: Equity research writing is the gold standard for investment banking and portfolio management roles — a polished note gets noticed

How to Present Projects on Your Resume and in Interviews

Resume Format

Every project should appear as a bullet point under your internship or academic projects section. Use this formula:

[Action verb] + [tool] + [company/context] + [output] + [quantified impact if available]

Example: "Built a 5-year DuPont analysis model in Excel comparing ROE decomposition of SBI, HDFC Bank, and Bandhan Bank; identified 340-basis-point net interest margin advantage for HDFC Bank."

Avoid: "Helped with ratio analysis during internship." This tells the recruiter nothing concrete.

Interview Presentation

When asked about your project, structure your answer in 90 seconds using this sequence: context (what was the business problem), your approach (what data you used and how), your output (what you produced), and what you learned or would improve. Recruiters want to hear that you took initiative beyond what was assigned.

Project Portfolio Hosting

Upload your Excel models, Python scripts, and Power BI screenshots to a GitHub repository. Even a basic repository with a clear README.md showing what the project does and how to use it dramatically increases your credibility. Add the GitHub link to your LinkedIn profile and resume. Many B.Com and CA students ignore this — doing it puts you in a small, visible minority.