Portfolio Projects for Accounting Students: Build a GitHub & LinkedIn Portfolio That Gets You Hired

Why Accounting Students Need a Portfolio in 2025

Every year, approximately 450,000 B.Com graduates and thousands of CA, CMA, and ACCA finalists enter the Indian finance job market. The majority of them have similar academic profiles: 65-75% aggregate, basic Excel skills, some internship experience, and a CA or B.Com degree. For a recruiter reviewing 300 applications for 5 analyst positions, a marks sheet alone provides almost no differentiation between candidates.

A portfolio changes this equation entirely. Where a resume tells a recruiter what you studied and where you worked, a portfolio shows them what you can actually build, analyze, and communicate. When a Goldman Sachs analytics team interviewer can open a GitHub link and see a working DCF model with real company data, a Power BI dashboard with Indian listed company financials, or a Python bank reconciliation script — they are looking at proof of skill, not a claim of skill. This is a fundamentally different kind of evidence.

Traditional Resume vs Portfolio-Enhanced Resume

Dimension	Traditional CA/B.Com Resume	Portfolio-Enhanced Resume
Proof of skills	Claimed ("Proficient in Excel")	Demonstrated (GitHub link with Excel model)
Differentiation	Low — similar to hundreds of peers	High — few accounting students have portfolios
Interview quality	Generic questions about coursework	Specific technical discussion of real projects
Recruiter engagement	Scanned in 30-60 seconds	Active review of linked projects — minutes of attention
Online discoverability	None (static PDF)	LinkedIn SEO + GitHub indexed by Google

What to Include in Your Accounting Portfolio

1. Excel Financial Models

An Excel financial model using real data from a listed Indian company is the single most accessible and impactful portfolio project for accounting students. Use Infosys, Reliance Industries, HDFC Bank, or any NSE-listed company with publicly available annual reports. Build a model that includes: a clean income statement, balance sheet, and cash flow statement (5 years of historical data plus 2-3 year projections), ratio analysis dashboard, and at minimum a basic DCF valuation.

The model does not need to be investment-bank quality on day one — it needs to be structured, documented, and reproducible. Label all assumptions clearly. Include a cover sheet that explains what the model does and what data it uses. A well-structured 3-statement model on Infosys will generate more positive recruiter response than a poorly documented complex model on an obscure company.

2. Power BI Dashboards

Power BI is increasingly expected in corporate finance and Big 4 advisory roles. Two high-impact dashboard projects for accounting students:

• P&L Performance Dashboard: Build a dashboard for a hypothetical or real company showing monthly revenue vs budget variance, gross margin trend, top 5 expense categories, and year-to-date performance. Use a sample dataset from your financial model as the data source.
• Working Capital Tracker: A dashboard showing debtor days, creditor days, inventory days, and cash conversion cycle over 12 months for a listed FMCG company. Include slicers for period selection and company comparison.

Export your Power BI dashboards as screenshots (PNG or PDF) and publish the .pbix file to GitHub. If you have a Power BI Service account (free with a student email), publish the dashboard online and include the URL in your LinkedIn profile.

3. Python Projects

Python projects set accounting students apart from the vast majority of their peers. You do not need to be a software developer — two beginner-level Python projects are sufficient and impressive for a finance portfolio:

• Bank Reconciliation Automation: A Python script using Pandas that reads a bank statement CSV and a cash book Excel file, matches transactions by amount and date, and outputs a reconciliation report with unmatched items highlighted. Even 50 lines of working code is impressive if it solves a real problem.
• GST Data Analyzer: A Python script that reads a purchase register CSV, categorizes GST rates (5%, 12%, 18%, 28%), calculates input tax credit by category, and generates a summary report. This demonstrates both Python skill and GST domain knowledge — a rare combination among fresh graduates.

Upload all Python projects to GitHub with a clear README.md that explains what the script does, what input data format it expects, and a sample output. Include sample/mock data files so reviewers can actually run the code.

4. SQL Analysis Projects

SQL is a growing requirement in corporate finance analyst roles. An SQL portfolio project for accountants: create a mock journal entry database in SQLite (free), populate it with 500-1,000 sample transactions, and write SQL queries that detect audit anomalies — round-number entries above threshold, entries after period close, high-value single-sided entries, and transactions by unauthorized users. Document your audit logic in a README.

This project is particularly valuable for students targeting Big 4 Technology Risk, Internal Audit, or Data Analytics roles — all of which are growing practice areas that few freshers have relevant portfolio evidence for.

5. Written Analysis and Research

Not all portfolio projects need to be technical. Written analysis demonstrates the skill that separates good analysts from great ones: the ability to synthesize data into a coherent argument. High-impact written portfolio pieces for accounting students:

• Investment thesis for an NSE-listed company: A structured 2-3 page equity research note covering business model, competitive position, financial analysis, valuation, and buy/hold/sell recommendation. Use a mid-cap company most analysts have not covered extensively.
• Audit risk assessment memo: A 2-page document identifying the top 5 audit risks for a specific listed company (chosen from their annual report risk disclosures) and the corresponding audit procedures you would design to address each risk.
• ICAI mock exam solution: A well-structured, professionally formatted solution to an ICAI CA Final or Intermediate mock exam question — demonstrating not just the answer but the communication quality expected in professional accounting.

Host written analysis as PDF documents on GitHub or Google Drive (public link). These are particularly effective in the LinkedIn Featured section because they are visually impactful and immediately communicate the quality of your thinking.

6. Case Study Solutions

CPA exam study guides, ACCA exam past papers, and ICAI past exam case studies are publicly available. Solving a complex case study and presenting a well-documented solution demonstrates exam-level technical competency and professional communication — both of which are immediately relevant to hiring decisions. Include your solution, the reasoning process, and any alternative treatments you considered.

Setting Up GitHub for Your Accounting Portfolio

Creating and Organizing Your GitHub Account

1. Create a free GitHub account at github.com using your professional email address. Choose a username that is your name or a professional variant — not a gaming handle or nickname.
2. Create a pinned profile repository with the same name as your username. Add a README.md to this repository — it appears on your GitHub profile page. Write 3-4 sentences introducing yourself: who you are, what kind of finance work you do, and what your top skills are. This is your professional GitHub bio.
3. Organize repositories by category: Create separate repositories for each project type, e.g., excel-financial-models, power-bi-dashboards, python-accounting-tools, equity-research-notes, audit-projects. Clear, descriptive repository names help recruiters navigate your work quickly.
4. Make repositories Public: All portfolio repositories should be set to Public. Private repositories are invisible to recruiters clicking your GitHub link.

Writing a Good README.md for Financial Projects

The README.md is the first thing a recruiter sees when they open your repository. A good README for a financial project should include:

• Project title and one-sentence description: "3-Statement Financial Model — Infosys Ltd. (FY2020-FY2025)"
• What the project does: 3-5 sentences explaining the purpose, scope, and key features of the model or analysis
• Data sources: Where you got the data (NSE filings, annual report, Screener.in) — this proves intellectual honesty and saves reviewers time
• Tools and software used: Excel version, Python libraries, Power BI version
• How to use it: For Excel — which file to open and which tabs to review first. For Python — command to run the script and required input file format.
• Key findings or outputs: One paragraph summarizing what the model shows or what you found in your analysis
• Screenshot: Include at least one screenshot of the key output — a dashboard, a chart, or a model summary tab — so it is visible in the README without downloading

Building Your LinkedIn Portfolio

The LinkedIn Featured Section

The Featured section on LinkedIn appears directly under your About section and is one of the most visible parts of your profile. Add 3-5 items to your Featured section:

• A link to your best GitHub repository (your financial model or Python project)
• A PDF of your equity research note or audit memo (uploaded directly to LinkedIn)
• A screenshot of your Power BI dashboard (uploaded as an image with a description)
• A Forage completion certificate (link from Forage's verification page)
• A link to your Notion or GitHub Pages portfolio landing page (if you create one)

LinkedIn Posts About Projects — Thought Leadership

One of the most effective but underused strategies for accounting students is posting about their portfolio projects on LinkedIn. A 150-word post describing what you built, what you found, and what you learned generates engagement from finance professionals in your network — and often results in connection requests from recruiters, hiring managers, and professionals at firms you want to work at.

Example post structure: "I spent this weekend building a DuPont analysis comparing ROE decomposition across SBI, HDFC Bank, and Bandhan Bank using 5 years of annual report data. Here is the most surprising finding: [key insight]. I've published the Excel model on GitHub — link in comments. Would be glad to discuss with anyone working in banking or credit analysis." A post like this consistently receives 200-500 impressions and 20-50 engagements for a profile with even 200-300 connections — levels well within reach for any serious B.Com or CA student.

Presenting Portfolio Projects in Interviews

The STAR Method for Finance Interviews

STAR stands for Situation, Task, Action, Result. It is the most widely used structure for behavioral and project-based interview answers. For portfolio projects:

• Situation: What was the context? ("I wanted to understand what drives the profitability difference between PSU and private banks in India.")
• Task: What did you set out to do? ("I decided to build a DuPont analysis model comparing three banks over five years.")
• Action: Exactly what did you do? ("I downloaded five annual reports each from NSE, entered ROE, net profit margin, asset turnover, and leverage data into Excel, and built a comparison dashboard with trend charts.")
• Result: What did you find or produce? ("The model showed that HDFC Bank's ROE advantage is driven primarily by its higher asset turnover — not higher margins or leverage, as I had expected. The model is on my GitHub profile.")

Practice each STAR answer for your 3-4 key portfolio projects until you can deliver them naturally in under 90 seconds. The specificity of the Action and Result components is what impresses interviewers — generic summaries ("I did some analysis") do not create a lasting impression.

Sharing Your Portfolio in an Interview

Before any campus interview or job interview, do three things: print a single-page summary of your top 3 portfolio projects (with thumbnail screenshots) to hand to the interviewer if appropriate, have your GitHub profile open on your phone so you can pull up the actual project in 10 seconds if asked, and prepare a 2-3 sentence teaser for each project that you can drop naturally into answers — not as a rehearsed pitch, but as a genuine reference ("I actually built a model on this during my internship — let me show you the structure I used").

Portfolio Checklist, Free Hosting, and the 10-Item Standard

Free Portfolio Hosting Options

• GitHub: Host Excel files, Python scripts, SQL files, PDF reports, and Power BI screenshots. Free, indexed by Google, trusted by technical recruiters.
• GitHub Pages: Convert a GitHub repository into a free website (yourname.github.io). Requires basic HTML knowledge but can host a professional portfolio landing page at zero cost.
• Notion Public Page: Create a well-organized Notion page with your project descriptions, links to GitHub repositories, and embedded screenshots. Share as a public page. Notion is free and produces clean, professional-looking portfolio pages with no design skill required.
• LinkedIn Featured Section: The simplest option — no separate website needed. Upload PDFs directly and link to GitHub repositories from your LinkedIn profile.

10-Item Portfolio Checklist Before Sharing with Recruiters

1. At least one complete Excel financial model (3-statement or ratio analysis) using real NSE/BSE-listed company data
2. At least one Power BI or Excel dashboard with charts, slicers, and a summary section
3. At least one Python or SQL project uploaded to GitHub with sample data and README
4. At least one written analysis — equity research note, audit memo, or case study solution — in PDF format
5. All GitHub repositories have descriptive names and README.md files with screenshots
6. GitHub profile has a pinned personal README describing who you are and what you work on
7. LinkedIn Featured section has at least 3 items linking to your best work
8. Resume includes a "Projects" section with one-line descriptions of each portfolio project plus the GitHub link
9. STAR answers prepared and practiced for each major portfolio project
10. No confidential client data or sensitive personal information is included in any publicly shared file

Building a Niche Blog or Notion Page

Accounting students who write regularly about finance topics — even 200-word reflections on what a financial model revealed or what an audit concept means in practice — build a searchable online presence that compounds over time. A Notion public page or a free WordPress blog with 10-15 posts of original financial commentary is a portfolio differentiator that almost no B.Com or CA student has. It signals intellectual engagement with the profession beyond coursework — exactly what recruiting managers at Goldman Sachs, EY, and Deloitte describe as "genuine passion for the field."