Small insurance agencies sell life, term, health, motor, home and travel policies of many insurance companies, but they still track premium due dates, renewals and claims in diaries and Excel sheets. As a result premiums are missed, policies lapse after the grace period, one year policies are not renewed on time and customers have to phone the agent for every receipt or due date.
PolicyBook – Insurance Agent Policy Renewal Portal Java project is a Java web portal (JSP / Servlet on Apache Tomcat with MySQL) for such an agency. The office manages insurers, plans with premium rules, agents and reports; agents issue policies with automatic premium calculation, collect premiums with numbered receipts, verify online payments, renew policies and check claims; customers see their policies and dues, pay online with the UTR number, download receipts, raise claims and request renewals.
How it works
- Visitor sends quote -> office assigns lead to agent -> agent adds customer and issues policy (server calculates premium, first installment created) -> premium collected by agent or paid online and verified -> receipt generated, next installment created -> unpaid installment after grace period lapses the policy, payment revives it -> one year policy appears in renewal list and is renewed with new premium -> claim submitted by customer, forwarded by agent, approved and settled by office -> reports and dashboards show business, collection, commission and dues
Users
- Visitor – Home, plans with filter, plan detail, premium calculator, quote request, registration
- Customer – Dashboard, my policies, premium dues, online payment, receipts, claims with bill upload, renewals, KYC documents, notifications
- Agent – Dashboard with target, customers, issue policy, nominees, collections, payment verification, renewals, claim check, leads, reports, WhatsApp reminder text
- Office Admin – Dashboard, agents, customers, insurers, categories, plans, policies, payments, claim approval, enquiries, 7 reports, notices, users, settings, backup, CSV import, activity log
Highlights
- A working portal with 56 pages, 44 servlets, 17 tables, 7 reports, PDF receipts and schedules and 82 passed test cases that an agency can use on its office computer.
- No missed premium or renewal: due, overdue and renewal lists with days left
- Correct premium every time; office changes rates in one place
- Customers get self service and instant receipts
- Two level claim approval with clear status
- Sample data and demo logins so every screen has data on the first run
What you get
- Complete Java web source code (Eclipse Dynamic Web Project for Tomcat 10.1)
- MySQL database SQL file with sample data
- Project report (55 pages) with all diagrams, abstract, project explanation with viva questions
- Setup guide and README with a 10-minute demo script
- Setup help from Ananda Technologies
Who can use this project
BCA and BSc (CS / IT) final year students who want a JSP Servlet MySQL project with source code that is easy to explain in viva and has enough content for 3 students and 3 college demos.
Frequently asked questions
- Which server is needed? Apache Tomcat 10.1 with JDK 17; the setup guide shows every step in Eclipse.
- Can I run it on XAMPP MySQL? Yes, import the SQL file in phpMyAdmin or MySQL Workbench.
- Can 3 students share this project? Yes, the README gives a 3-student split and a 3-demo plan.
- Is the report editable? Yes, the report is given in Word and PDF.