Client Database Management (Excel / Google Sheets)
Sample Projects
Product Inventory Tracker
Data Entry & Data Cleaning Template
Order & Payment Control Sheet
Project 1 – Product Inventory Tracking System (Excel)
This Excel file was created to help a small business track its products, stock levels, and movements.
It allows the user to record incoming and outgoing items, avoid stock errors, and keep all inventory organized in one place.
Features:
• Product name and category
• Stock quantity control
• Automatic totals
• Clean and easy-to-use layout
This project demonstrates my ability to organize data accurately and build structured spreadsheets for business use.
Project 2 – Customer Database Management (Excel )
This project is a customer database created to organize and manage client information for a business.
It helps keep contact details, purchase history, and customer status in one structured file.
Features:
• Client name and contact information
• Email and phone records
• Purchase or service tracking
• Easy filtering and sorting
This file shows my ability to structure customer data, keep it clean, and make it easy to use for daily business operations.
Project 3 – Order & Payment Tracking System
This spreadsheet is designed to track customer orders and payment status.
It helps businesses control what has been sold, how clients paid, and whether payments are pending or completed.
The system includes:
- Client name
- Product or service purchased
- Payment method (cash, transfer, card, etc.)
- Payment status (paid, pending, overdue)
- Notes for follow-up
This type of file is commonly used by small businesses to organize sales and avoid missing payments.
Skills used:
- Data Entry
- Excel
- Google Sheets
- Financial tracking
- Data organization
HOMET 