Development login preview: this page demonstrates roles and permissions locally. Before using real business passwords/data publicly, move authentication and user accounts to the Cloudflare backend.
CENTRAL DATABASE — Sidai Landing v34 + Login & Roles. Portal links remain on the main landing page; Employee Portal opens the staff login.
💧
Water Station Manager
Water sales, truck income, expenses, payroll, analytics and spreadsheet import
Signed in as
—
— · —
Operations Dashboard
Welcome back
Manage station water sales, truck operations, expenses, salaries, analytics and historical spreadsheet imports from one dashboard.
Selected station
Tokens Issued
KSh 0
Completed Income
KSh 0
Total Shorts
KSh 0
Open Tokens
0
Administrator Token Controls
Administrator-only controls for correcting or removing token records.
Issue New Token
Select the employee and enter the token amount. Date and time are automatic unless changed by an Administrator.
Administrator — Adjust Issue Date / Time
Use this when entering a forgotten token.
Active Tokens
Record dated Cash/Digital sales while a token stays open. When closing, enter only the additional sales since the last entry. Overnight-token sales are therefore assigned to the correct day.
Token History
Completed tokens are grouped by employee. Administrator uses a single Edit button to change values or delete the whole entry.
You are viewing only your own token activity. Other employees, business sections, expenses, payroll and company analytics are not available to employee accounts.
My Daily Sales History
Your recorded Cash, Digital and total sales grouped by day.
Date
Cash
Digital
Total
Employees
Truck Income
Mashuuru and Malili truck income are kept separately.
Records
0
Paid Income
KSh 0
Outstanding
KSh 0
Unpaid Records
0
Add Mashuuru Truck Income
Truck Income History
Expenses
Mashuuru and Malili expenses are kept separately.
Total Expenses
KSh 0
General
KSh 0
Water Purchases
KSh 0
Records
0
Add Expense
For a one-day expense, use only this date.
Leave blank for a single-day expense.
Multi-day expenses are stored as one record. Analytics recognizes the amount on the completion/end date.
Expense History
Analytics & Spreadsheet Import
Analyze business performance and import historical Google Sheets / Excel data from this single dashboard tab.
Google Sheets / Excel Import
Upload Excel or CSV records for tokens, expenses, truck income, salaries and employees.
Include unpaid debt in analytics
Includes unpaid truck sales as income where applicable.
Employee Water Sales
KSh 0
Truck Income
KSh 0
Expenses
KSh 0
Profit
KSh 0
Daily Income Tracker
Daily cash, digital and overall income. No token counts or token values are shown here.
DAILY
Daily sales rule: Daily Income is calculated from dated sales entries, not from the token opening or closing date. You can record sales while a token remains open. When an overnight token closes, enter only the additional Cash/Digital earned since the last sales entry; that final amount is posted to the closing date. This lets an old token contribute correctly to the next day without double-counting earlier sales.
Total Cash
KSh 0
Total Digital
KSh 0
Overall Income
KSh 0
Sales Trend
Income vs Expenses / Profit Analysis
Period
Employee Sales
Truck Income
Total Income
General / Water Expenses
Salaries
Total Expenses
Profit / Loss
Payroll / Salary Expenses
Salary can be recorded for any company employee. Assign the salary to a station so it is included in that station's profit analysis.
Salary History
Import Spreadsheet Data
Upload an Excel or CSV export and review detected tokens, expenses, truck income, salaries and employees before importing.
About AI in this preview: this browser-only version uses intelligent header matching and pattern detection locally. It does not send your spreadsheet to an AI model. A future server-backed version can add secure AI interpretation for unusually messy or inconsistent sheets without exposing an API key in public HTML.
1. Upload Workbook
Choose your Google Sheets export / Excel file
Google Sheets: File → Download → Microsoft Excel (.xlsx), then select that file here.
Token Records
0
Expenses
0
Truck Records
0
Salary / Employees
0
Probable Duplicates
0
2. Review Detected Records
Import
Sheet / Row
Detected Type
Station
Date
Name / Description
Amount / Token
Cash
Digital
Confidence
Status
Sync to Google Sheets
Administrator only. This replaces the contents of the 8 operational tabs with the latest data from this browser.
8 tabs: Mashuuru, Malili, Kima, Token Register, Mashuuru Truck Income, Malili Truck Income, Mashuuru Expenses, Malili Expenses. Station tabs are grouped horizontally by employee and show each token on its original issue date.
Manage Logins
Administrator only. Create additional Administrator, Secretary or Employee logins. Employee accounts are linked to one station employee and can see only that employee's token work and daily history. There is no public sign-up.
Create Login
This login will be restricted to the selected employee only.
Existing Logins
Edit Token Record
Administrator or Secretary. Changes update dashboard totals and Analytics automatically.
Cash + DigitalKSh 0
95% MinimumKSh 0
ShortKSh 0
Dated Sales EntriesEdit a row to change its date, Cash or Digital.