📊 Monthly Overview
💰 Expense Breakdown by Category
🏢 Cost Attribution by Company
—
Total / mo
🔔 Upcoming Alerts Next 180 days
📋 Monthly Expense Sheet Single source of truth — all formulas auto-calculate
⚠ EWA Utilities: Update the yellow cells each month with actual EWA bill amounts.
Currently pre-filled with April 2026 actuals (Workshop Acct 1080753435, Office Acct 1101299343).
Expense Breakdown — Three Companies
| # | Description | Al Hafeed | Marian | Sarathi | Total (BHD) | Notes |
|---|
👥 Employee Register GOSI auto-flips at 3-year tenure
ℹ Automatic calculations:
Service years computed from join date · GOSI rate auto-flips from 8.2% → 12.2% at 3 years ·
Leave provision = actual monthly salary ÷ 12 · LMRA fee tiered (5×7.5 + 6th×12.5)
⓵ GOSI declared salary vs. actual salary: GOSI is calculated on the declared salary on the official contract (Shannon: BHD 250, all others: BHD 100) — not the actual salary paid. Purple-highlighted cells in the GOSI Salary column flag where the two differ.
⓵ GOSI declared salary vs. actual salary: GOSI is calculated on the declared salary on the official contract (Shannon: BHD 250, all others: BHD 100) — not the actual salary paid. Purple-highlighted cells in the GOSI Salary column flag where the two differ.
Full Employee List
| # | Name | LMRA Co. | Salary Co. | Actual Salary | GOSI Salary | Join Date | Service | GOSI % | GOSI/mo | Leave/mo | Status | Notes |
|---|
🚗 Fleet Management Track Fahas (vehicle inspection) & insurance renewals
ℹ Click "Edit" on any vehicle to fill in year of manufacture, plate number,
Fahas (vehicle inspection / passing) date, insurance renewal date, and annual costs.
Provisions auto-calculate: Annual cost ÷ 12 = monthly accrual.
All edits save locally and persist between sessions.
🔔 Compliance & Renewals All upcoming statutory & operational renewals
📅 Set up automatic renewal reminders — free, forever
Click "Export" to download an iCalendar (.ics) file with all your renewals (govt + vehicles) as recurring annual events with built-in reminders 7 days, 1 day, and same-day. Import once into Google Calendar / Apple Calendar / Outlook — they fire forever, no app needed, no fees.
📑 Government Licence Renewals (CR · Activity · BCCI)
🚗 Vehicle Renewals (Fahas · Insurance)
Colour key:
● Overdue / due in <30 days ·
● Due in 30–90 days ·
● Due in >90 days