Lochana K

Technical Team Lead (Trainee Technician)

COMPUTER WAREHOUSE • Full-time

Jan 2025 - Jul 2025 • 6 mos

After I I joinning the Creative Computers. In my first days in the company, I noticed that our invoicing system was entirely manual. The staff created invoices using a Word document and then entered the same again into a database. The process consumed time, caused human error, and lacked traceability. I decided to take on the challenge of creating an automated invoice system. Within one week, I designed and built a complete Excel-based solution that now generates invoices, stores financial records, and reduces manual work. Objectives • Remove repeated manual typing • Automatically generate invoice numbers • Automatically calculate totals and VAT • Save invoices directly to the computer • Enable fast printing for customers • Track unpaid invoices and highlight outstanding credit How the System Works 1. When a data entry officer selects a new row in the database sheet, the current date fills in automatically. The user selects whether it is a Sale or Repair (S or R). 2. The customer name is entered only once. 3. On the VAT_Invoice sheet, a Generate button creates the next invoice number, resets old data, and brings the customer information forward. 4. enters item descriptions, quantities, and rates. Totals and VAT are calculated automatically. 5. When the Add button is clicked, the total and VAT values are pushed into the database. 6. The Save button stores a PDF invoice to the required directory. 7. The Print button produces a physical printout immediately. 8. Credit status is visually tracked. Rows turn green when payment is pending. Once payment is received and the credit is set to zero, the row turns white again. Impact The system has reduced daily workload, increased accuracy, and introduced proper structure to invoice handling. Staff now issue invoices faster and management can review monthly sales and credit balances without manual checking. This project proved to me that small improvements can create a big change inside an organization.