Computer Science Project Reports:E-Billing & Invoicing System
What is E-Billing?
E-Billing s a method of sending bills and collecting electronic payments in which invoice are given over the Internet and customers can pay electronically. E-Billing involves integrating multiple systems including a billing system, banking system, a customer’s bank bill pay system, and an online interface for the billing system.
E-Billing is most helpful for businesses that send recurring bills to customers.
What is an E-Bill?
Electronic bills, or E-Bills, are a paperless option for delivering a bill. Bills can be presented either on a website or as an electronic document, such as a PDF file. This gives customers the ability to review proposals before sending payment.
Alternately, customers can set up automated payments to pay without even touching a button.
E-Bills offer benefits to both Client and customers. Some of the numerous advantages from E-Billing include:
• Low cost to deliver bills to customers
• Better security than paper and snail mail
• Option for automatic payments
• Fast payment delivery via ACH
E-Bills offer a win-win for customers and businesses. Because they are faster, convenient, less expensive, and more secure, everyone involved benefits from electronic billing.
What is an electronic billing system?
Electronic billing systems are computer systems that assist with generating and delivering invoices and accepting customer payments. The flow of an invoice through an automated billing system typically follows this path:
1. Customer billing data is aggregated in a billing system
2. Billing system generates customer bill
3. Billing is passed to electronic billing system
4. Bills are totaled and sent to customer online
5. Customer receives new bill notification email
There are two main types of electronic billing systems used for billing: biller-direct systems and bank-aggregator systems.
As already noted, most utility companies allow customers to log in to the utility website to view and pay bills.
Some bills can be merged into a bank’s bill pay system. In this case, users can log in to their bank website and pay bills for several billers through the same interface. This is an example of bank-aggregator systems.
Biller-direct and bank-aggregator are also known as electronic billing formats.
What is the difference between E-Billing and E-Invoicing?
E-Billing and E-Invoicing have many similar aspects but are not entirely the same thing. E-Invoicing is just sending invoices digitally, but the payment feature is not integrated as it is with E-Billing.
True E-Billing also includes the ability to pay as well. On a utility or bank website, you can both view the invoice and submit an electronic payment.
Who can use this project?
The commercial visual primary application developer can use this project as a whole or part of it as required.
Who want to learn database programming in visual basic.
Who wants to know how to develop a commercial application from project requirement to implementation and final documentation.
The client uses MS Excel and maintains their product list, customer list, and prints the invoice. However it is not possible them to share the data from multiple systems in a multi-user environment, there is a lot of duplicate work, and the chance of mistake. When the product price is adjusted, they need to update every excel file. There is no option to find and print the previous saved invoice. There is no security; anybody can access any report and sensitive data, also no reports to find out the sales volume, stock list, and summary report. This E-Billing and invoicing system is used to overcome the entire problem which they are facing currently, and making complete customization of manual billing and invoicing system.
From an end-user perspective, the E-Billing and Invoicing Project consists of two functional elements: an enhanced searchable database for customer, products, billing generation system and a report generation system.
Customer, Products, Billing Generation
- An enhanced atomized system is developed to maintain Customer, Product, order, order details data and produce Bill and invoice with following features.
- The system operator will be able to Add, Edit and search the product. Also, the operator can delete the product; update the cost of the product as per the rights are given to the operator by the administrator.
- By using their account, sales staff will be able to place orders through the system. Also, sales staff will be able to apply discounts in accord with the current sales policy.
- Improved search capabilities of product information will be available; It will display all the details of the particular product with current stock quantity.
- Prices and order information will be expressible in international currency and date/time formats.
- After placing the order system automatically print the invoice with per-printed stationary with all the details.
- Searching of the previously generated invoice is also available; Operator can search the already saved invoice by system generated unique invoice no.
- Importing the old stock into the system, it introduces the old stock from predefined MS Excel file.
- Maintain the user master and security features.
Report Generation System
A Report Generation system will be developed for the user and management of billing and Invoicing System. This MIS system will have both details, and summary type reports for analysis the sales volume, sales trend, available stock, The Windows-based MIS application will include the following features:
- Billing summary report, it has the selection criteria for the date range.
- Stock Details and stock summary reports, It shows every detail of the stock and can be used to monitor the sales pattern.
- All reports can be exported in different format includes Text File, CSV File, MS Excel, MS Word File.
- All report can be printed from any printer.
- Bill and invoice can be printed on per-printed stationery.
E-Billing and Invoicing System Version 1.0 will address the following use cases. The whole usage scenarios will be completed during the information-gathering process. Use cases will be organized and prioritized. Selected use cases will be expanded into usage scenarios and features that are derived from both use cases and the usage scenarios,
as represented in the following diagram
- After analysis the requirement we decide that we need to create
- Product master module, where we import all product data from MS Excel.
- Company Master to maintain company details.
- Client master to maintain client name address.
- Bill master where we maintain bill details like bill no, bill date, client details, etc.
- Bill Details where we maintain details transaction like product, quantity, rate etc.
- Reports in Crystal Reports for easy print and export options.
- Front End: Visual Basic 6
For fast development, easy to deploy and maintain.
- Back End: MS Access 2003
The client already has MS Office installed on their system, nos of the user are three only.
- Report: Crystal Report 8.5
Easy to create, ability to print and select the printer, can export the report in different format including MS Excel, easily integrate with Visual Basic 6.