📊 Finance Assistant

College Project

Simplify financial statement preparation and ratio analysis for students. Upload your financial data and get instant insights with professional reports and comprehensive ratio analysis.

Key Features

Data Upload

Upload CSV files containing Trial Balance and Payments & Receipts data

Auto Reports

Generate Balance Sheet and P&L statements automatically from your data

Ratio Analysis

Calculate liquidity, profitability, efficiency, and solvency ratios instantly

AI Chatbot

Ask questions about your financial data and get instant answers

Upload Financial Data

Upload your CSV files containing Trial Balance and Payments & Receipts data

Trial Balance

Payments & Receipts

Sample Data Format

Your CSV files should follow this format:

Trial Balance Format:

Account Name, Debit, Credit
Cash, 50000, 0
Accounts Receivable, 25000, 0
Inventory, 30000, 0
Accounts Payable, 0, 15000

Payments & Receipts Format:

Description, Amount, Type
Sales Revenue, 100000, Receipt
Office Rent, 12000, Payment
Utilities, 3000, Payment

Financial Reports

Auto-generated Balance Sheet and Profit & Loss Statement

Balance Sheet

Please upload Trial Balance data to generate Balance Sheet

Profit & Loss Statement

Please upload Payments & Receipts data to generate P&L Statement

Financial Ratio Analysis

Comprehensive ratio analysis based on your uploaded data

Liquidity Ratios

Current Ratio
-
Current Assets ÷ Current Liabilities
Quick Ratio
-
(Current Assets - Inventory) ÷ Current Liabilities

Profitability Ratios

Net Profit Margin
-
Net Profit ÷ Revenue × 100
ROE
-
Net Income ÷ Shareholders' Equity × 100

Efficiency Ratios

Inventory Turnover
-
COGS ÷ Average Inventory
Asset Turnover
-
Revenue ÷ Total Assets

Solvency Ratios

Debt-to-Equity
-
Total Debt ÷ Total Equity
P/E Ratio
-
Market Price per Share ÷ EPS

Finance Assistant Chatbot

Ask questions about your financial data and ratios

Hello! I'm your Finance Assistant. I can help you understand your financial data and ratios. Try asking me questions like:

  • "What is my current ratio?"
  • "Show me the profit margin"
  • "How is my liquidity?"
  • "Explain debt-to-equity ratio"

About Finance Assistant

Project Purpose

Finance Assistant is a comprehensive MBA project designed to simplify financial statement preparation and ratio analysis for students. This web application demonstrates practical application of financial concepts while providing a user-friendly interface for financial data analysis.

Technology Stack

HTML5
CSS3
JavaScript

Key Features

CSV file upload for Trial Balance and Payments & Receipts
Auto-generation of Balance Sheet and P&L Statement
Comprehensive financial ratio analysis
Interactive chatbot for financial queries
Responsive design for desktop and mobile

Development

Made with AI + Human Collaboration

This project represents the perfect blend of artificial intelligence assistance and human creativity, showcasing how modern technology can enhance educational projects and learning outcomes.