Online Account Receivables for Multi-Purpose Cooperative

Online Account Receivables for Multi-Purpose Cooperative
Category

Academic

See live
View on GitHub Back to Projects

Technologies Used

  • MySQL
  • PHP
  • Bootstrap
  • jQuery
  • JavaScript

An individual project Online Account Receivables (OAR) System for a Multi-Purpose Cooperative during my 2nd Year on Web System Technologies subject. This system streamlines the management of cooperative accounts, transactions, and financial records, enhancing efficiency and transparency.


Key Features

  • User-Friendly Interface: Intuitive design for easy navigation.
  • User Management:
    • Admin Panel:
      • Add, update, and remove members.
      • Assign roles (Administrator, Member, Accountant).
      • Reset passwords and manage user credentials.
    • Member Access:
      • View their account balances, invoices, and payment history
      • Submit proof of payment.
  • Accounts Receivable Management
    • Invoice Management:
      • Generate and send invoices to members.
      • Automate recurring invoices for periodic contributions or loans.
      • Track overdue invoices.
    • Payment Tracking:
      • Record payments made by members (manual and auto-reconciled via bank integration).
      • Monitor payment statuses (paid, pending, overdue).
      • Send payment reminders and notifications via email.
  • Financial Reporting
    • Generate reports for:
      • Outstanding receivables by member and total.
      • Payment histories and trends.
      • Monthly, quarterly, and annual financial summaries.
  • Notifications and Alerts
    • Notify members of:
      • Upcoming payment deadlines.
      • Overdue accounts.
    • Alert administrators about overdue accounts, unusual activity, or system errors.
  • Data Security and Backup
    • Role-based access control (RBAC) to restrict access.
    • Encrypt sensitive data (e.g., payment details).
    • Implement daily automated backups of the database.
  • Additional Security
    • Implement CAPTCHA for form submissions to prevent automated submissions.
    • Implement two-factor authentication for account access.
    • Implement a password reset mechanism for lost passwords.

Development Journey

A solo or individual project given by my professor, I developed this system to meet the requirements of the Web System Technologies subject.


Technical Stack

  • Backend: PHP for API development and server-side logic.
  • Frontend: JavaScript and CSS for a responsive and interactive UI.
  • Database: MySQL for structured data storage and efficient retrieval.
  • Deployment: Hosted on a Infinity.

This project refined my skills in full-stack development, particularly in designing efficient database structures and implementing role-based access control.