Dashboard
Clinic summary and patient overview
Total Patients
–
All registered
Active Patients
–
Currently monitored
Pending Doses
–
Upcoming vaccine
Low Stock Items
–
Need restocking
| Patient ID | Name | Age/Sex | Bite Date | Category | Branch | Status |
|---|
Patients
All registered patients
| Patient ID | Name | Age/Sex | Bite Date | Category | Barangay | Branch | Status | Actions |
|---|
Vaccine Schedule
Auto-generated Essen protocol schedule
| Schedule ID | Patient | Bite Date | Dose | Target Date | Status | Date Given | Actions |
|---|
Inventory
Vaccine stock management
Total Items
–
Vaccine types
In Stock
–
Adequate supply
Low Stock
–
Below minimum
Out of Stock
–
Zero quantity
| Item Name | Brand | Batch No. | Unit | Qty (Begin) | Current | Min Stock | Stock Level | Expiry | Branch | Actions |
|---|
Billing
Patient charges and payment records
Total Billed
–
This month
Paid
–
Completed payments
Unpaid
–
Pending collection
| OR Number | Patient | Date | Service | Payment Type | Amount | Paid | Balance | Status | Actions |
|---|
Forms
Leave / Absent, Loan, Overtime
Leave / Absent Forms
| Date Filed | Employee Name | Leave Type | Date From | Date To | Reason | Status | Admin Comment | Actions |
|---|
All Branch Forms
Requests, Leave, and Loan from all branches
| Branch | Date | Details | Status | Admin Comment | Actions |
|---|---|---|---|---|---|
| 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.
| Vaccine | Unit | Received | Used (day) | Used (total) | Remaining | Status |
|---|---|---|---|---|---|---|
| Select a date to view the report. | ||||||
Usage Log — today
| Registry No. | Patient | Vaccine | Dose |
|---|---|---|---|
| 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.
| Date | Particulars | IN | OUT | TOTAL | |
|---|---|---|---|---|---|
| Select a vaccine to view its 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. |