Texas Distribution Co. needed an efficient system to track purchases from various suppliers, manage product inventories, and generate accurate tax invoices. The existing manual processes were prone to errors, time-consuming, and lacked real-time data insights, impacting the company's operational efficiency and customer satisfaction.

The development of a web-based Billing Management System was crucial to:

Streamline purchase tracking and supplier management.

Automate tax invoice generation to reduce errors and ensure compliance.

Enhance data organization for better decision-making.

Improve operational efficiency by replacing manual processes with automated solutions.

Provide real-time insights and reporting capabilities to support strategic planning.

The project was successfully completed by:

Designing and implementing modules for Suppliers, Products, and Billing.

Creating a robust online PostgreSQL database for data management.

Developing a user-friendly web application using Streamlit.

Ensuring seamless functionality through iterative testing and bug fixes.

Deploying the application on AWS, providing a scalable solution for the company.

Database Setup: PostgreSQL

Web Application Development: Python3, Streamlit

Tax Invoice Generation: HTML, PDF conversion libraries

Testing and Deployment: AWS

Project Management: Flowcharts, Design Documents

Database Design: ER Diagram