Professional Proposal & System Documentation
Client: MyFuel Petroleum Ltd
Date: 10 February 2026
Version: 2.0
This document presents a comprehensive payroll management system specifically designed for MyFuel Petroleum Ltd, a petrol station with diverse employee cadres including CSAs (Customer Service Attendants), ServiceBay technicians, CarWash staff, and Office personnel.
The system handles complex commission structures, multi-tier labour calculations, statutory compliance (KRA, SHA, NSSF, Housing Levy, NITA), and provides complete financial control and reporting.
| # | Module | Description | Key Features |
|---|---|---|---|
| 1 | Staff Registry | Complete employee database with bank details, statutory registrations, and cadre assignments | KRA PIN, NSSF, Bank Info |
| 2 | Earnings Engine | Cadre-specific calculations for commissions, labour, bonuses, and allowances | Auto-calculation by Cadre |
| 3 | Deductions Engine | Statutory (SHA, NSSF, PAYE, Housing Levy, NITA) and other deductions (penalties, advances, shorts) | Progressive PAYE, Capped NSSF |
| 4 | Overtime Manager | Normal (1.5x) and Special (2.0x) overtime tracking and calculation | Hour-based calculation |
| 5 | Leave Manager | Leave requests with approval workflow and allowance calculation for zero-pay staff | Days Approved tracking |
| 6 | Advances & Allowances | Advance payment requests with separate approval amounts and other allowances management | Requested vs Approved |
| 7 | Payroll Processing | Complete payroll cycle: Draft → Process → Approve → Lock | Multi-stage workflow |
| 8 | Bank Schedules | Bank-specific payment letters with account details and professional formatting | PDF generation, Print |
| 9 | Statutory Schedules | SHA, NSSF, PAYE, NITA, and Housing Levy payment schedules for authorities | Excel & PDF exports |
| 10 | Reports & Analytics | Earnings dashboards, deductions analysis, reconciliation, control accounts, complete master roll | 7 comprehensive reports |
| 11 | Payslip Generation | Professional A4 payslips with detailed earnings/deductions breakdown and YTD summary | Individual & bulk print |
| 12 | User Management | Role-based access control with Admin, Manager, and Viewer roles | Audit logging |
Sample Staff: John Kamau - CSA, Basic Pay: KES 25,000
Formula:
Formula:
Ranking System: All CSAs are ranked by total fuel sales. Only top 2 receive commission.
Appraisal System: CSAs earn points from supervisor evaluations. Top 2 get bonuses.
| Basic Pay | KES 25,000.00 |
| Lubes Commission | KES 850.00 |
| Other Categories Commission | KES 2,250.00 |
| Fuel Commission (Rank 2) | KES 3,000.00 |
| Supervisor Appraisal (Rank 1) | KES 5,000.00 |
| GROSS PAY (Before Deductions) | KES 36,100.00 |
Sample Staff: James Omondi - ServiceBay Technician
IMPORTANT: ServiceBay staff have ZERO basic pay. All earnings are commission-based.
How it works: Count invoices where total lubes capacity is between 0 and 5.1 liters
| Basic Pay (ServiceBay = Zero) | KES 0.00 |
| Lubes Commission | KES 600.00 |
| Filters Commission | KES 200.00 |
| CC Change Commission | KES 120.00 |
| Labour Class A (3 invoices) | KES 150.00 |
| Labour Class B (4 invoices) | KES 360.00 |
| Labour Class C (CC Change %) | KES 850.00 |
| Labour Class D (Greasing %) | KES 630.00 |
| Extra Hours (32 hrs) | KES 2,000.00 |
| GROSS PAY | KES 4,910.00 |
Sample Staff: Sarah Achieng - CarWash, Basic Pay: KES 18,000
| Component | Formula | Example |
|---|---|---|
| Labour | Jobs × Labour Rate | 45 jobs × KES 30 = KES 1,350 |
| Collection | Sales × Collection % | KES 12,000 × 5% = KES 600 |
| Additional Hours | Hours × Hour Rate | 8 hrs × KES 100 = KES 800 |
| GROSS PAY | KES 20,750.00 | |
Sample Staff: Grace Njeri - Office A, Basic Pay: KES 35,000
Office staff (Directors, Office A, Office B) receive fixed Basic Pay with optional allowances.
Total Earnings: Basic Pay + Other Allowances (if any) = KES 35,000.00
Base Formula:
Basic Pay: KES 35,000
Days in January: 31
Working hours per day: 11
Total Overtime: 1,847.52 + 1,642.24 = KES 3,489.76
RULE: Leave allowances are ONLY paid to staff with ZERO basic pay (e.g., ServiceBay staff)
| Step | Staff | Days Requested | Days Approved | Calculation | Amount |
|---|---|---|---|---|---|
| 1 | James Omondi (ServiceBay) | 10 days | 7 days | 7 × KES 200 | KES 1,400 |
| 2 | John Kamau (CSA) | 5 days | 5 days | Has basic pay | KES 0 |
Note: Days Requested and Days Approved are tracked separately. Admin can approve fewer days than requested.
Two-Amount System:
Both amounts remain in database for audit trail.
Additional allowances can be added for staff:
Example Staff: John Kamau (CSA) - Gross Pay: KES 36,100
Taxable Income = Gross Pay - NSSF
| Tax Band | Rate | Calculation | Tax |
|---|---|---|---|
| 0 - 24,000 | 10% | 24,000 × 0.10 | KES 2,400 |
| 24,001 - 32,333 | 25% | 8,333 × 0.25 | KES 2,083 |
| 32,334 - 33,940 | 30% | 1,607 × 0.30 | KES 482 |
| Total Tax Before Relief | KES 4,965 | ||
| Less: Personal Relief | (KES 2,400) | ||
| PAYE | KES 2,565 | ||
| SHA | KES 992.75 |
| NSSF | KES 2,160.00 |
| PAYE | KES 2,565.00 |
| Housing Levy | KES 541.50 |
| NITA | KES 50.00 |
| TOTAL STATUTORY | KES 6,309.25 |
Deductions for:
Recovery of approved advances
Cash register shortages
Calculated from clearedshorts, receiveclient, and journal tables
| Basic Pay | 25,000.00 |
| Other Earnings: | |
| Lubes Commission | 850.00 |
| Other Categories | 2,250.00 |
| Fuel Commission (Rank 2) | 3,000.00 |
| Appraisal (Rank 1) | 5,000.00 |
| GROSS PAY | 36,100.00 |
| Statutory: | |
| SHA (2.75%) | 992.75 |
| NSSF (6%) | 2,160.00 |
| PAYE | 2,565.00 |
| Housing Levy (1.5%) | 541.50 |
| NITA | 50.00 |
| Other: | |
| Penalties | 500.00 |
| Advance Recovery | 5,000.00 |
| Shorts | 350.00 |
| TOTAL DEDUCTIONS | 12,159.25 |
Amount payable to employee
Purpose: Ensure mathematical accuracy of payroll calculations
| Component | Amount (KES) | % |
|---|---|---|
| A. EARNINGS | ||
| Basic Pay (30 staff) | 650,000.00 | 70.5% |
| Other Earnings (Commissions) | 185,400.00 | 20.1% |
| Overtime | 45,200.00 | 4.9% |
| Leave Allowances | 2,800.00 | 0.3% |
| Other Allowances | 38,600.00 | 4.2% |
| GROSS PAYROLL | 922,000.00 | 100% |
| B. STATUTORY DEDUCTIONS | ||
| SHA (2.75%) | 25,355.00 | 2.75% |
| NSSF (6% max 2,160) | 52,140.00 | 5.65% |
| PAYE (Progressive) | 68,420.00 | 7.42% |
| Housing Levy (1.5%) | 13,830.00 | 1.50% |
| NITA (KES 50 × 30) | 1,500.00 | 0.16% |
| Total Statutory | 161,245.00 | 17.48% |
| C. OTHER DEDUCTIONS | ||
| Penalties | 3,450.00 | 0.37% |
| Advance Payments | 28,500.00 | 3.09% |
| Shorts | 4,820.00 | 0.52% |
| Total Other Deductions | 36,770.00 | 3.99% |
| TOTAL DEDUCTIONS | 198,015.00 | 21.47% |
| NET PAYROLL | 723,985.00 | 78.53% |
Check: Gross - Total Deductions = Net Pay
922,000.00 - 198,015.00 = 723,985.00 ✓ BALANCED
| Bank | Staff Count | Net Pay (KES) |
|---|---|---|
| Equity Bank Kenya Ltd | 15 | 385,400.00 |
| KCB Bank Kenya Ltd | 10 | 258,250.00 |
| Co-operative Bank | 5 | 80,335.00 |
| TOTAL | 30 | 723,985.00 |
| Basic Pay | 650,000.00 |
| Other Earnings | 185,400.00 |
| Overtime | 45,200.00 |
| Leave Allowances | 2,800.00 |
| Other Allowances | 38,600.00 |
| Total Payroll Expense | 922,000.00 |
| SHA Payable | 25,355.00 |
| NSSF Payable | 52,140.00 |
| PAYE Payable | 68,420.00 |
| Housing Levy Payable | 13,830.00 |
| NITA Payable | 1,500.00 |
| Penalties Recovered | 3,450.00 |
| Advances Recovered | 28,500.00 |
| Shorts Recovered | 4,820.00 |
| Staff Salaries Payable | 723,985.00 |
| Total Liabilities | 922,000.00 |
| Entry | Account | Debit | Credit |
|---|---|---|---|
| 1 | Payroll Expense | 922,000.00 | - |
| SHA Payable | - | 25,355.00 | |
| NSSF Payable | - | 52,140.00 | |
| PAYE Payable | - | 68,420.00 | |
| Housing Levy Payable | - | 13,830.00 | |
| NITA Payable | - | 1,500.00 | |
| Penalties Recovered | - | 3,450.00 | |
| Advances Recovered | - | 28,500.00 | |
| Shorts Recovered | - | 4,820.00 | |
| Staff Salaries Payable | - | 723,985.00 | |
| 2 | Staff Salaries Payable | 723,985.00 | - |
| Cash/Bank | - | 723,985.00 | |
| 3 | Statutory Liabilities (SHA) | 25,355.00 | - |
| Cash/Bank | - | 25,355.00 | |
| Repeat for NSSF, PAYE, Housing Levy, NITA | |||
| Authority | Amount | Due Date | Payment Method |
|---|---|---|---|
| SHA (NHIF) | KES 25,355.00 | 9th of following month | Bank Transfer |
| NSSF | KES 52,140.00 | 15th of following month | Bank Transfer |
| KRA (PAYE) | KES 68,420.00 | 9th of following month | iTax Portal |
| Housing Levy (Treasury) | KES 13,830.00 | 9th of following month | Bank Transfer |
| NITA | KES 1,500.00 | Monthly | Bank Transfer |
Purpose: Generate bank-specific payment instructions with account details
To:
Equity Bank Kenya Ltd
Branch Manager
Embu Branch
Date: 10 February 2026
Ref: PAYROLL/JANUARY/2026
RE: SALARY PAYMENT FOR JANUARY 2026
Dear Sir/Madam,
Please credit the following accounts with salaries for the month of January 2026 as detailed below:
| No. | Employee Name | Account Number | Amount (KES) |
|---|---|---|---|
| 1 | John Kamau | 0123456789 | 23,940.75 |
| 2 | Mary Wanjiku | 0123456790 | 32,150.00 |
| 3 | Grace Njeri | 0123456791 | 38,510.25 |
| TOTAL (15 employees): | KES 385,400.00 | ||
Amount in Words: Three Hundred Eighty-Five Thousand Four Hundred Shillings Only
Kindly debit our account number ___________________________ and credit the above accounts accordingly.
Yours faithfully,
Features:
| Employee | ID Number | Amount |
|---|---|---|
| John Kamau | 12345678 | 992.75 |
| Mary Wanjiku | 87654321 | 1,125.00 |
| TOTAL | 25,355.00 | |
| Employee | NSSF No | Amount |
|---|---|---|
| John Kamau | 123456789 | 2,160.00 |
| Mary Wanjiku | 987654321 | 2,160.00 |
| TOTAL | 52,140.00 | |
Total: KES 68,420.00
Total: KES 13,830.00
Total: KES 1,500.00 (30 staff × 50)
Export Options:
| # | Report Name | Purpose | Key Features |
|---|---|---|---|
| 1 | Earnings Dashboard | Analyze earnings by cadre, identify top performers, track commission trends | Drill-down modals, Sorting, Filtering |
| 2 | Deductions Dashboard | Monitor statutory compliance, track penalties and advances, analyze deduction patterns | Statutory breakdown, Top deductions |
| 3 | Summary Report | Quick overview of payroll totals and key metrics | Cards view, Percentages |
| 4 | Complete Master Roll | Full payroll details with all columns (18 columns) | Excel export, Print, Search |
| 5 | Reconciliation Report | Month-end verification, mathematical accuracy check, cadre breakdown | Variance detection, Bank breakdown |
| 6 | Control Account | Accounting integration, journal entries, liability tracking | T-account format, Payment schedule |
| 7 | Bank Schedules | Generate bank payment letters with employee account details | PDF generation, Professional format |
| 8 | Statutory Schedules | SHA, NSSF, PAYE, Housing Levy, NITA schedules for authorities | Excel & PDF exports |
| 9 | Professional Payslips | Individual or bulk payslip generation with YTD summary | A4 format, Detailed breakdown |
| Stage | Actions | Who | Restrictions |
|---|---|---|---|
| 1. Draft |
• Create new payroll period • Add staff to payroll • Edit data freely |
Admin | Fully editable |
| 2. Process |
• Run calculations • Generate all figures • Review accuracy |
Admin | Can revert to Draft |
| 3. Approve |
• Final review • Generate reports • Create payslips |
Admin/Manager | Can revert to Process |
| 4. Lock |
• Permanent record • Generate all outputs • Audit trail complete |
Admin only | Cannot edit |
| Phase | Activities | Duration | Deliverables | Responsible |
|---|---|---|---|---|
| 1 |
• Requirements gathering • Data migration planning • Settings configuration |
2 days | Requirements document, Migration plan | Comptracks & Client |
| 2 |
• System installation • Database setup • Historical data import |
1 day | Working system with data | Comptracks |
| 3 |
• User training (Admin) • User training (HR/Finance) • Documentation handover |
2 days | Trained users, User manuals | Comptracks |
| 4 |
• Test payroll run • Verification & corrections • Go-live approval |
1 day | Verified test payroll | Client & Comptracks |
| 5 |
• First live payroll • Support & monitoring • Fine-tuning |
1 month | Successful live payroll | Comptracks (Support) |
Total Implementation Time: 6 working days + 1 month support
| Component | Value (KES) |
|---|---|
| Core Payroll System Development | 250,000 |
| Cadre-Specific Calculation Engines (4 types) | 120,000 |
| Statutory Compliance Module (5 authorities) | 80,000 |
| Reporting Suite (9 reports) | 150,000 |
| Bank & Statutory Schedules with PDF | 60,000 |
| Leave, Advances & Allowances Management | 50,000 |
| Professional Payslip Generator | 40,000 |
| User Management & Audit System | 30,000 |
| Installation, Configuration & Data Migration | 50,000 |
| Comprehensive Training (2 sessions) | 40,000 |
| 1 Month Post-Implementation Support | 30,000 |
| Documentation & User Manuals | 20,000 |
| SUBTOTAL | 920,000 |
| Special Package Discount (15%) | (138,000) |
| TOTAL INVESTMENT | KES 782,000 |
| VAT EXCLUSIVE | |
| Plan | Monthly Fee | Coverage |
|---|---|---|
| Basic | KES 5,000 | Email support, Bug fixes |
| Standard | KES 10,000 | Phone + Email, Updates, 2hrs remote support |
| Premium | KES 20,000 | Priority support, Customizations, On-site visits |
| Feature | Manual Process | Generic Software | MyFuel Payroll System |
|---|---|---|---|
| Processing Time | 3-5 days/month | 1-2 days/month | 2-3 hours/month |
| Error Rate | 15-20% | 5-10% | < 0.1% |
| Cadre-Specific Calculations | Manual formulas | Generic only | 4 specialized engines |
| Labour Class System | Not possible | Not available | 4-tier automation |
| Bank Schedules | Manual typing | Basic lists | Professional letters + PDF |
| Statutory Schedules | Manual compilation | Simple reports | 5 authority-ready schedules |
| Control Account | Manual journal entries | Not included | Automatic generation |
| Audit Trail | Paper-based | Basic logging | Complete digital trail |
| Cost (Annual) | Staff time = KES 200k+ | Subscription = KES 150k+ | One-time = KES 782k |
| ROI Period | - | Ongoing cost | 4-5 months |
Years Experience
In business management systems
Clients Served
Across multiple industries
Client Satisfaction
On completed projects
| Step | Action | Required From Client | Timeline |
|---|---|---|---|
| 1 | Proposal Review Review this document and ask questions |
Management review, Questions/clarifications | 1-3 days |
| 2 | Proposal Acceptance Sign acceptance section below |
Signed proposal, 60% deposit payment | 1 day |
| 3 | Requirements Meeting Detailed discussion of your needs |
HR/Finance team availability, Current payroll data | 1 day |
| 4 | System Installation Setup and configuration |
Server/hosting access, Test data | 1-2 days |
| 5 | Training Sessions Admin and user training |
Staff availability (4-6 people, 2 sessions) | 2 days |
| 6 | Test Run Process test payroll for verification |
Sample month data, Verification | 1 day |
| 7 | Go Live First live payroll processing |
Final approval, Full payment | 1 day |
This proposal confirms the agreement between Comptracks Systems and MyFuel Petroleum Ltd for the development, installation, and implementation of the Comprehensive Payroll Management System as described in this document.
Scope of Work:
Total Investment: KES 782,000 (VAT Exclusive)
|
FOR MyFuel PETROLEUM LTD: Name: _______________________________________ Title: _______________________________________ Signature: ___________________________________ Date: ________________________________________ |
FOR COMPTRACKS SYSTEMS: Name: _______________________________________ Title: Technical Director Signature: ___________________________________ Date: ________________________________________ |
Upon acceptance of this proposal:
Address:
Nairobi, Kenya
Phone:
+254 700 000000
Email:
info@comptracks.co.ke
sales@comptracks.co.ke
Working Hours:
Monday - Friday: 8:00 AM - 6:00 PM
Saturday: 9:00 AM - 1:00 PM
M-Pesa (Paybill):
Business Number: 123456
Account: MyFuel
Bank Transfer:
Bank: Equity Bank Kenya Ltd
Account Name: Comptracks Systems
Account Number: 0123456789
Branch: Nairobi
Please email payment confirmation to:
accounts@comptracks.co.ke