⚠️

Are you sure?

This action cannot be undone.

Dashboard
⏳ Loading... 💾 Saving...
🏠

Dashboard

Clinic summary and patient overview

Total Patients
–
All registered
Active Patients
–
Currently monitored
Pending Doses
–
Upcoming vaccine
Low Stock Items
–
Need restocking
Patient IDNameAge/Sex Bite DateCategoryBranchStatus
👤

Patients

All registered patients

🔎
Patient IDNameAge/SexBite Date CategoryBarangayBranchStatusActions
💉

Vaccine Schedule

Auto-generated Essen protocol schedule

🔎
Schedule IDPatientBite DateDoseTarget Date StatusDate GivenActions
📦

Inventory

Vaccine stock management

Total Items
–
Vaccine types
In Stock
–
Adequate supply
Low Stock
–
Below minimum
Out of Stock
–
Zero quantity
🔎
Item NameBrandBatch No.UnitQty (Begin)Current Min StockStock LevelExpiryBranchActions
💳

Billing

Patient charges and payment records

Total Billed
–
This month
Paid
–
Completed payments
Unpaid
–
Pending collection
🔎
OR NumberPatientDateService Payment TypeAmountPaidBalanceStatusActions
📝

Forms

Leave / Absent, Loan, Overtime

Leave / Absent Forms
Date FiledEmployee NameLeave TypeDate FromDate ToReasonStatusAdmin CommentActions
📋

All Branch Forms

Requests, Leave, and Loan from all branches

BranchDateDetailsStatusAdmin CommentActions
Click Refresh to load forms from all branches.
🔧

Setup Sheets

Connect to Google Apps Script backend

Setup Guide

1
Open your Google Spreadsheet → Extensions → Apps Script
2
Paste all code from Code.gs → Save → Run setup() → Authorize
3
Deploy → New Deployment → Web App. Execute as: Me. Access: Anyone
4
Copy the Web App URL and paste it above → Save → Test Connection
5
Click Create / Fix Sheet Headers to initialize all sheet columns
Multi-branch: Each branch can share the same spreadsheet. Patient IDs include branch prefix (e.g., SABC-MAIN-2026-0001).
👑

All Branches Overview

Combined view of all 16 branches

Total Patients
–
All branches combined
Total Sales
–
All branches combined
Pending Forms
–
Requests / Leave / Loan
Branches Online
–
Connected to sheets
🔧

Setup API URLs

Configure Apps Script URLs for all 13 branches

Paste each branch's Apps Script Web App URL below. Each branch needs its own Google Sheet and deployment.

🔴

Overdue Patients

Patients who missed their vaccine schedule

📊

Monthly Summary

Patient statistics per month

Select a month to view the summary.
💉

Vaccine Daily Report

Doses used per day & remaining stock — auto from vaccines given

Paano basahin: Received = total stock na pinasok mo sa Inventory (Quantity). Used = bilang ng doses na binigay (auto, base sa "Date Given" sa schedule). Remaining = Received − Used (total), computed live — hindi ginagalaw ang naka-store. Mag-set ng Quantity sa Inventory bilang kabuuang natanggap para tama ang Remaining.
VaccineUnitReceived Used (day)Used (total)RemainingStatus
Select a date to view the report.

Usage Log — today

Registry No.PatientVaccineDose
No doses given on this date.
📒

Daily Inventory Ledger

Stock card per vaccine — Beginning, Delivery, Used (vials) with running balance

Total IN
–
Deliveries + beginning
Total OUT
–
Used
Current Balance
–
Vials on hand
➕ Add Movement
Vials are fractional: VAXIRAB 0.2/dose · ABHAYRAB 0.4/dose. Pwedeng decimal ang quantity.
DateParticularsBatch No.ExpiryINOUTTOTAL
Select a vaccine to view its ledger.
📒

Branch Inventory Ledgers

Tingnan ang galaw ng stock kada branch — admin lang ang pwedeng mag-delete

Total IN
–
Deliveries + beginning
Total OUT
–
Used
Current Balance
–
Vials on hand
DateParticularsBatch No.ExpiryINOUTTOTAL
Pumili ng branch at vaccine para makita ang ledger.
📦

Supplies Requisition

Submit and track your branch supply requests

My Requisition Requests
Date/Time Email/Number Vaccines Clinic Supplies Office Supplies HQ Status Actions
Click Refresh or New Request to get started.
📊

Supplies & Requisition Matrix

All branches — consolidated view

Click Refresh to load all branch requisitions.