Establishment Billing Management System using PHP/MySQL with Source Code

Language

Project: Establishment Billing System using PHP/MySQL

About

The Establishment Billing Management System is a simple project that will help certain establishment tenants with monthly billing. This system stores all the commercial blocks of the establishment such as malls along with the rates of each block. This billing system generates the tenant's monthly rental, electricity, and water wages. The main purpose of this project is to automate the billing process of the establishment and with the help of this system, the management of a certain establishment will no longer to track the previous consumption of the electricity and water of their tenants to calculate the reading every month that the tenants used. The management can simply set the rate of electricity per kilowatts (kW) and water cubic meter (m3), and by this, the system will automatically calculate the payable amount of the tenants every month for the monthly rental, electricity bill, water bill, and the overall total of the tenant. The system also has a simple payment feature to update the billing status of a certain tenant to the system. In this billing system, the bill can be only be managed if the tenant's bill record is the most updated to the system, which means the system user can not update the billing information anymore if the bill information has already used as the previous record for the newer record unless the system user will delete the newer billing record of the tenant. The tenant billing information each month is ready to print in this system. This billing system allows or handle also if ever the tenant will rent multiple blocks in the establishment.

Features:

  • Login Page
    • The page where the system users will submit their system credentials in order to access the data of the system.
  • Home Page
    • The welcome page of the system after the system user login to the system.
  • Block List
    • The page where all establishment's commercial blocks are listed and can be managed.
  • Tenant List
    • The page where all establishment's tenants are listed and can be managed.
  • Billing Page
    • The page where can system user manages the monthly billing of the tenants.
  • User List
    • The page where all system users are listed and can be managed only by the system admin.
  • System Configuration
    • The page where can admin updated the system information along with the electricity and water rates.

How to Run

  1. Download the source code and extract the zip file.
  2. Download or set up any local web server that runs PHP script.
  3. Open the web-server database and create a new database name it billing_db.
  4. Import the SQL file located in the database folder of the source code.
  5. Copy and paste the source code to the location where your local web server accessing your local projects. Example for XAMPP('C:\xampp\htdocs')
  6. Open a web browser and browse the project. E.g [http://localhost/billing-management-system]

Admin Default Access

Username: admin

Password: admin123

That's it, you can now explore the functionalities of the Establishment Billing Management System.

I hope this project will help you with what you are looking for. Feel free to download the source code and modify the project in the way you wanted.

Explore more on this website for more source code and tutorials.

Enjoy!

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted byxtianedu (not verified)on Sun, 10/11/2020 - 10:57

Error on uploading the database
Submitted byoretnom23on Mon, 10/12/2020 - 08:19

In reply to by xtianedu (not verified)

Hi, uploading the SQL file is fine with me, can you try to import the SQL file again and please make sure you import the billing_db.sql from the database folder of the source code or you may download the zip file again. Thank you

Submitted bybugdebug (not verified)on Mon, 03/08/2021 - 17:26

i m getting an error Error SQL query: -- -- Database: `billing_db` -- -- -------------------------------------------------------- -- -- Table structure for table `billing` -- CREATE TABLE `billing` ( `id` int(30) NOT NULL, `billing_date` date NOT NULL DEFAULT current_timestamp(), `tenant_id` int(30) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=pending,1=paid', `total_amount` double NOT NULL, `amount_tendered` double NOT NULL, `amount_change` double NOT NULL, `invoice` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 MySQL said: Documentation #1067 - Invalid default value for 'billing_date
Submitted byEllington (not verified)on Mon, 05/29/2023 - 12:03

In reply to by bugdebug (not verified)

Same problem here...

Add new comment