FIBER CONNECT SOLUTIONS, INC.
🔔
🔴 Offline
⏻ Logout
📴 You are offline. Changes will sync when you reconnect.
📊 Dashboard
🔍 WO SEARCH
BILLING SUMMARY (from Billing ledger)
RECEIVABLES AGING
PROJECT STATUS
CASH FLOW — 4 WEEK TREND
PENDING APPROVALS
ATTENDANCE SUMMARY — THIS CUT-OFF
LEAVE SUMMARY
OVERTIME SUMMARY
EXPENSE AGING ALERTS
RECENT ACTIVITY
🔍 FINANCIAL HEALTH & LEAKAGE INDICATORS
Real-time detection of financial risks, anomalies, and budget overruns
🧾 Unreported Expenses
—
Checking...
⚠️
📐 BOQ Overruns
—
Checking...
📊
👥 Payroll Anomalies
—
Checking...
🔎
💵 Petty Cash Variance
—
Checking...
💰
🏗️ Project Loss Alerts
—
Checking...
📉
📅 Cut-off Compliance
—
Checking...
🗓️
💰 Owner Funding / Capital Injection
Two types:
Capital Injection — no project link, goes to company equity, does NOT affect project cost. |
Temporary Funding — linked to a project/PWO, appears as "Owner-Funded" in project cost, reimbursable.
ADD FUNDING ENTRY
| # | Partner / Owner | Type | Amount | Date | Project / PWO | Purpose | Reimbursement | Reimburse Date | Remarks | Action |
|---|
🔄 Material Reconciliation
Location: Intelligence → Material Intelligence → Reconciliation (Spec v1.0 Section G)
Read-only view. Aggregates RR (received), DR (issued), Materials Usage (used), Subcon usage, Returns, and As-Built quantities per PWO/material.
Read-only view. Aggregates RR (received), DR (issued), Materials Usage (used), Subcon usage, Returns, and As-Built quantities per PWO/material.
🔍 FILTERS
| # | Material | Code | Unit | Drum ID | Received Qty (RR) |
Issued Qty (DR) |
Used Qty (Usage) |
Subcon Usage | Returns | As-Built Qty | Variance (Used-Issued) |
Subcon Var. | Status | Risk Reason |
|---|
🧠 Brain — PWO Intelligence
Read-only aggregation layer. Brain does not store new data — it computes status flags
from all existing modules and answers key project intelligence questions.
🧠 SELECT PWO:
🏗️ ALL ACTIVE PROJECTS — RISK OVERVIEW
🏢 Client Acceptance Specs
Set each telecom/customer's fiber acceptance limits once. OTDR & Testing then judge pass/fail against the client of that project. A project whose client has no entry uses the Default (fallback) row.
Clients — add or remove anytime
Spec details
💵 Billing Terms
Saved acceptance specs
| Client | Splice | Connector | Refl/ORL | @1310 | @1550 | Link | Wavelengths | Bidir | Notes | Action |
|---|
🔬 OTDR Acceptance Check
Upload OTDR PDF report(s). Each fiber is checked against a client's fiber spec defined above — max splice loss, return loss (ORL), and link loss.
Saved OTDR results
| Date | Cable | Fiber | A→B | λ | Span km | Span loss | Max splice | ORL | Spec | Result | Action |
|---|
🔗 Bidirectional Acceptance (loss budget)
For multi-fiber bidirectional jobs. Upload the OLTS/FasTest summary PDF (loss, ORL, length) and the LS OTDR PDF(s) (event counts). Pass/fail = OLTS loss vs calculated budget (fiber×km + splices + connectors), shown for BOL & EOL.
Event-level checks (each splice, each reflectance, PMD)
Uses the LS PDF(s) above for per-event loss & reflectance. Optionally add the CD+PMD PDF for PMD coefficient. Limits come from the selected spec (splice, reflectance, PMD).
📁 Document Management System (DMS)
Central repository for all project documents. Every file linked to a PWO and/or Site.
Versioning enforced — latest version is always Active.
📤 UPLOAD DOCUMENT
🧠 TAiCOS AI KNOWLEDGE INDEX (RAG)
After uploading documents, rebuild the index so the TAiCOS assistant can read and cite them. The assistant searches this index on every question.
Checking index status…
| # | PWO / Project | Site | Module | Category | Title | Version | Auto-Path | Uploaded By | Date | Active | Remarks | Action |
|---|
📁 Upload History Log
| # | Date/Time | Module | PWO / Project | Description | Uploaded By |
|---|
🏢 Subcontractors
📤 Export
ADD SUBCONTRACTOR
| # | Company | Contact | Phone | Specialization | TIN | Status | Active PWOs | Del |
|---|
🔍 Invoice Reconciler
Auto-matches supplier/subcon invoices against PO, DR, RR, BOQ, Progress, and Contract.
Blocks payment if variances exceed tolerance.
SUBMIT INVOICE FOR RECONCILIATION
📋 INVOICE LINE ITEMS
| # | Invoice No. | Supplier/Subcon | PWO | Type | Invoice Amt | Qty Variance | Price Variance | Status | Date | Action |
|---|
📥 Billing Import — HT/ECWI Progress Billing
Import the PO 2025 PROGRESS BILLING tab. In Excel or Google Sheets, open that tab and use File → Save As / Download → CSV, then upload the .csv here. Each site becomes a project (client = HT/ECWI) with its 50% DP / 30% PB / 20% PAT claims. Re-importing an updated file refreshes the figures — nothing is deleted.
📊 Outstanding & Aging
Live view of what clients still owe — collected vs outstanding, broken down by milestone, client, area and site, with aging by claim date. Figures are computed from your billing records; this screen is read-only.
🔍 Search
Search by PWO number, project/site name, or client to see the full picture in one place — project details, billing, documents, testing, expenses, and receivables.
📥 Project Import (Monitoring Sheet)
Upload your HUAWEI project status / monitoring sheet (exported as CSV) to update projects with real start & end dates, location, progress %, status, and remarks — and to create PAT/FAT test records. Matches by site name; re-importing just refreshes, it never duplicates.
📥 BOQ / PO Import (HUAWEI)
Upload your HUAWEI PO / BOQ sheet (CSV) to load per-site bill-of-quantities line items into the BOQ module. Matches by site name and creates the project if the site is new. Re-importing replaces this imported set — it never touches BOQ you enter manually.
📄 Billing
CREATE BILLING / PROGRESS BILLING
Billing is separate from Receivables. Create a billing entry per milestone or completion stage,
then link to Receivables once the invoice is raised.
| # | Billing No. | Project / PWO | Type | Date | Billing Amt | Retention | Net Billable | Milestone | Status | Remarks | Del |
|---|
📍 Site Master
ADD SITE
📋 SITE ACCESS LOG
SITE REGISTRY
Record every site visit for audit trail.
| # | Site Name | Address | Type | GPS | Access Type | E-Lock ID | Key Holder | RAAWA | Remarks | Del |
|---|
| # | Date/Time | Site | Project/PWO | Accessed By | Access Type | Purpose | Remarks | Del |
|---|
🔬 Testing Module
ADD TEST RECORD
Record PAT and FAT as standalone test records linked to PWO. Independent of the Closeout tab.
| # | Project / PWO | Test Type | Test Date | Certificate No. | Tested By | Client Rep | Result | Remarks | File | Pole Photos | Del |
|---|
💰 Receivables / Collections
| # | Client | Invoice # | Amount | Invoice Date | Due Date | Age | Status | Notes | Del |
|---|
👥 Payroll Processing
📤 Export
EMPLOYEE REGISTRY (set rates & deductions)
Register each employee once. Hourly/Daily staff: payroll auto-computes from approved timesheets via "Push to Payroll". Monthly staff: enter adjustments manually.
👤 Employee Information
📅 Attendance & Hours
💰 Final Computation Summary
➖ Government Contributions & Deductions
ALLOWANCES (non-taxable up to BIR limits)
💵 Allowances
TAX & FINAL
⚡ BATCH PUSH TO PAYROLL
Push all ready employees in one click
| # | Emp No. | Name | Position | Pay Type | Rate | Days/Hrs | OT Hrs | Gross | SSS | PhilHealth | Pag-IBIG | CA/Loan | Other Ded. | Net Pay | Period | Status | Del |
|---|
💳 CA / Loan Management
NEW LOAN / CASH ADVANCE
RECORD REPAYMENT
| # | Employee | Type | Amount | Date | Monthly Ded. | Total Paid | Balance | Status | Remarks | Details |
|---|
🧾 Expense Monitoring
📤 Export
PETTY CASH FUNDS
REPLENISH A FUND
🧾 SUBMIT EXPENSE
📋 Expense Details
Choose the correct type — it determines how reimbursement works.
🏗️ Project Assignment
📎 Attachment & Notes
⏳ PENDING APPROVAL
0 pending
| # | Date | Type | Category | Description | Amount | Project | Paid By | Cut-Off | Receipt | Age | Reimburse Status | Approval | Actions |
|---|
📈 Cash Flow Monitoring
FORECAST — NEXT 4 WEEKS
Based on expected collections (unpaid invoices) and scheduled payroll
🏬 Inventory Management
ADD / RECEIVE STOCK
| # | Code | Description | Category | Unit | Stock On Hand | Reorder Level | Unit Cost | Total Value | Status | Issue |
|---|
🧾 Invoice Generator
INVOICE DETAILS
LINE ITEMS
LINE ITEMS
SAVED INVOICES
| # | Invoice # | Client | Project | Amount | Date | Status | Action |
|---|
🏗️ Project Monitoring
📤 Export
PWO generated when Design Plan is approved.
| # | WO Number | Type | Project | Client | Location | Contract Value | Revised Value | Start | End | Progress | Status | Del |
|---|
📋 VARIATION ORDERS (VO)
FCS-submitted claims for additional work discovered during execution or based on as-built findings.
| # | VO No. | Project | Type | Description | Claim Amount | Net Claim | Approved Amt | Date | Status | Action |
|---|
📝 CHANGE ORDERS (CO)
Track scope additions or deductions. Each CO adjusts the contract value and BOQ.
| # | Project | CO No. | Description | Type | Amount | Date | Approved By | Del |
|---|
📆 PROGRESS BILLING SCHEDULE
Track client billing milestones. Links to Invoice generation.
| # | Project | Milestone | % | Billing Amount | Due Date | Status | Action |
|---|
📋 BOQ TEMPLATES
Save a project BOQ as a reusable template. Load into any new project to pre-fill line items.
📅 Gantt Chart — Project Timeline
LEGEND:
On Track
At Risk
Delayed
Completed
Draft
▼ Milestone
Click any bar to open project
📋 Project Costing
| # | Project | Item | Category | Budgeted | Actual | Variance | Notes | Del |
|---|
⏱️ Timesheet
📤 Export
STEP 2 — PENDING APPROVAL QUEUE
0 pending
| # | Emp No. | Employee | Position | Date | Cut-Off | Day Type | Attendance | Project | In | Out | Reg Hrs | ND Hrs | OT Hrs | Late | UT | Approval | Locked | Action |
|---|
Payroll Link: After approving timesheets, use "Push to Payroll" to auto-generate payroll entries for hourly/daily staff based on approved hours. Monthly staff OT/undertime adjustments are also calculated.
📦 Materials Usage
| # | Project/JO | Code | Description | Unit | Qty | Unit Cost | Total | Date | Issued By | Del |
|---|
🔗 Asset Assignment
Track which assets (tools, equipment, vehicles) are assigned to which PWO.
Asset Registry is independent — Assignment requires a PWO.
ASSIGN ASSET TO PWO
📥 RECORD ASSET RETURN
| # | Asset Type | Asset | Project | PWO | Assigned To | Date Out | Date Returned | Cond. Out | Cond. In | Days | Daily Rate | Total Cost | Status | Remarks | Action |
|---|
🔧 Tools Inventory
ADD TOOL
| # | Tool Name | Category | Brand/Model | Serial No. | Purchase Date | Cost | Condition | Status | Assigned To | Project/PWO | Remarks | Action |
|---|
⚙️ Equipment Inventory
ADD EQUIPMENT
| # | Equipment Name | Category | Brand/Model | Serial No. | Purchase Date | Cost | Condition | Status | Assigned To | Project/PWO | Remarks | Action |
|---|
🚗 Vehicle Inventory
ADD VEHICLE
| # | Plate No. | Type | Brand/Model | Year | Fuel | Status | Assigned Team | Driver | Remarks | Action |
|---|
🔩 Asset Maintenance Log
LOG MAINTENANCE
| # | Asset Type | Asset | Maintenance Type | Date | Cost | Performed By | Next Due | Remarks | Del |
|---|
📐 Design Module
📐 Project / PWO:
📍 SITE SURVEY
Initial site visit to assess scope, access, and conditions.
SURVEY RECORDS
| # | Date | Surveyed By | Site | Status | Findings | GPS | Est. Length | File | Del |
|---|
ACCESS RECORDS
| # | Site | Access Type | E-Lock/Key ID | Key Holder | RAAWA | RAAWA Approver | Schedule | Remarks | Del |
|---|
📦 Delivery Receipt (DR) — Outbound Materials
📤 Export
DR records all outbound materials issued from inventory to a project/PWO.
Requires PWO. Decreases inventory. Feeds Materials Reconciliation and Project Costing.
Mandatory flow: Inventory → DR → Materials Usage → Reconciliation → Costing
ADD DELIVERY RECEIPT
📋 ITEMS ISSUED (at least one required)
| # | DR No. | Project | PWO | Issued To | Subcon | PO Ref. | Date | Site | Received By | Items | Total Value | Status | Del |
|---|
📋 Receiving Report (RR) — Inbound Materials
📤 Export
RR records all inbound materials. Source type determines inventory impact and Invoice Reconciler eligibility.
Mandatory flow: RR → Inventory → DR → Usage → Reconciliation → Costing
CREATE RECEIVING REPORT
📦 ITEMS RECEIVED (at least one required)
| # | RR No. | Source Type | Supplier/Client | DR Ref. | PWO | Date | Inspected By | Accepted By | Items | Total Cost | Result | Invoice Recon | Del |
|---|
📋 Subcon Work Orders
Formal work orders issued to subcontractors per PWO. Required before subcon can begin work.
ISSUE WORK ORDER
| # | WO No. | Project | PWO | Subcontractor | Date Issued | Start | End | WO Value | Status | Scope | Action |
|---|
🔍 Subcon QC Reports
Quality control validation of subcontractor work. Required before billing can be approved.
QC result feeds into Subcon Performance Dashboard.
CREATE QC REPORT
| # | QC No. | PWO | Subcontractor | WO Ref. | Date | Type | Result | Score | Rework | Safety | Findings | Del |
|---|
🗺️ As-Built Records
Record actual installed quantities and as-built drawings per PWO.
Feeds into Materials Reconciliation (as_built_qty) and Brain Module.
ADD AS-BUILT RECORD
📐 AS-BUILT QUANTITIES (for Materials Reconciliation)
| # | AB Ref No. | Project | PWO | Date | Prepared By | Approved By | Status | Items | Description | File | Del |
|---|
🛒 Purchase Orders
Purchase Orders received FROM clients authorizing FCS to proceed with work. Attach the PDF or Excel PO document.
LOG CLIENT PO
📎 ATTACH CLIENT PO DOCUMENT
Upload the PO from your client — PDF or Excel. The file is stored inside the ERP.
For Excel POs: the system will auto-read the PO Number, Amount, and line items.
No file selected
| # | PO Number | Client | Scope / Project | Site | Amount | Received | Completion | Status | File | Contact | Action |
|---|
📝 RFQ Tracker
RFQs received FROM clients (Globe, PLDT, DITO, Converge, etc.) requesting FCS to submit a quotation.
LOG CLIENT RFQ
📎 ATTACH RFQ DOCUMENTS
Upload the client RFQ file (PDF, Word, Excel, image). Stores a copy directly in the system.
No file selected
| # | RFQ # | Client | Scope | Site | Received | Deadline | Est. Value | Status | File | Remarks | Action |
|---|
📐 BOQ / Subcon
BOQ DETAILS
BOQ workflow: Client RFQ → Client BOQ → Quotation → Invoice → Cash Inflow |
Subcon RFQ → Subcon BOQ → Expense → Cash Outflow
⚡ QUICK ADD — Avoid manual entry for each line item
| # | Project | Item No. | Description | UOM | Qty | Mat. Cost | Lab. Cost | Markup% | Unit Total | Line Total | Purpose | Type | Contractor | Status | Paid | Action |
|---|
💲 Price List
| # | Code | Category | Description | Brand/Model | Unit | Unit Cost | Supplier | Remarks | Del |
|---|
📄 Quotation Builder
QUOTE DETAILS
⚡ QUICK ADD — Choose a method to speed up line item entry
📋 Pull from BOQ
Copies all approved BOQ items directly into this quotation. Fastest method if you have a BOQ.
🏷️ Bulk from Price List
Search and tick multiple items from your price list. Set quantities and add all at once.
📂 Import from CSV/Excel
Prepare your items in Excel, save as CSV, upload. All line items added instantly.
📑 Quote Templates
Save current items as a template. Load templates for similar projects — change only qty and price.
✏️ ADD SINGLE ITEM MANUALLY
👥 Staff Master
Central registry — single source of truth. Payroll, Timesheet, Access, and RAAWA all read from here.
ADD STAFF
| # | Emp No. | Full Name | Position | Employment Type | Salary Type | Rate (₱) | Company | Contact | Date Hired | Status | SSS | PhilHealth | Pag-IBIG | TIN | Action |
|---|
👤 User Management
🔧 DATA TOOLS
Use these if your data appears in one tab but not another, or after downloading a new version of the tracker.
👑 Master Admin — Full access + system settings
🔑 Admin — Full access (except Master Reset Code)
💰 Finance — Payroll, Billing, Reports
⚙️ Operations — Projects, DR/RR, Assets
🏢 Subcon — Subcon modules only
👁️ Viewer — Dashboard + Reports (read-only)
🏗️ Site Staff — Own Timesheet + Expenses only
➕ CREATE USER
| # | Username | Full Name | Role | Created By | Actions |
|---|
🔑 Password Reset Requests
⚠️ MASTER ADMIN ONLY — Only the Master Admin account can approve or reject password reset requests.
Approval requires the Master Reset Code set by the system owner.
🛡️ MASTER RESET CODE SETUP
The Master Reset Code is a secret override code set by the system owner. It is never displayed in the UI.
PENDING RESET REQUESTS
| # | Username | Reason | Date Requested | Status | Approve | Reject |
|---|
📜 Audit Trail
| # | Date & Time | User | Module | Action |
|---|
📊 Reports & Analytics
REPORT PARAMETERS
Leave dates empty to show all records
Open this tab to see live data counts.
Report Types — select one or more
📋 Payroll Cut-off Report
CUT-OFF PARAMETERS
Quick presets:
🏖️ Leave Balances
ADD / UPDATE LEAVE CREDITS
| Employee | Year | VL Credits | VL Used | VL Balance | SL Credits | SL Used | SL Balance | EL Credits | EL Used | EL Balance | Del |
|---|
📒 Bookkeeping (Double-Entry)
General journal and chart of accounts. Every entry must balance (total debits = total credits). For management use — have your accountant validate before relying on it for official books or BIR filing.
➕ NEW JOURNAL ENTRY
LINES (debits must equal credits)
📖 GENERAL JOURNAL
🏛️ Government Reports
SELECT REPORT & PERIOD
💹 Project Budget & Profitability
🗑️ Recycle Bin
Deleted records are stored here for 30 days. Admin can restore or permanently delete them.
| # | Type | Description | Deleted By | Deleted At | Action |
|---|
📤 Final Pay / Last Pay
COMPUTE FINAL PAY
For resigned, terminated, or retired employees. Includes: unpaid salary + pro-rated 13th month + unused VL monetization.
FINAL PAY RECORDS
| # | Employee | Last Day | Separation | Unpaid Salary | 13th Month | VL Conversion | Deductions | Net Final Pay | Date Computed |
|---|
✅ Project Closeout
STAGE 1 — IMPLEMENTATION
All work completed. Punch list cleared. Ready for client testing.
STAGE 2 — PAT
Preliminary Acceptance Test. Client inspects and signs off on initial testing.
STAGE 3 — FAT
Final Acceptance Test. Full sign-off. Locks project, triggers final billing and retention tracking.
SELECT PROJECT
Select a project
📄 GENERATE CLOSEOUT DOCUMENTS
Fills the closeout templates (OPM, Completion Report, CNO/PAN, Summary, FTP, BOQ, Topology) and downloads them as a ZIP. Select a project above first — shared fields are pre-filled where available.
Linked PWO: —
(for tracking only — not shown on generated documents)
OPM FIBER READINGS (power meter dBm, A & B side)
📋 STAGE 1 — IMPLEMENTATION COMPLETED
Record that all scope of work has been completed and is ready for client testing.
🔬 STAGE 2 — PAT (Preliminary Acceptance Test)
Client conducts preliminary testing. Record results and client sign-off.
🏁 STAGE 3 — FAT (Final Acceptance Test) — Project Close
Final client sign-off. Closes the project, locks all expenses and timesheets, enables final billing.
PROJECT CLOSEOUT RECORDS
| # | Project | Client | Contract Value | Total Cost | Gross Profit | Margin % | Stage | PAT Date | FAT Date | Retention | Warranty | Acceptance # |
|---|
📅 Attendance Report
🧮 Materials Usage — Actual Consumption
Records actual material consumption per PWO. Separate from Materials Master (stock) and DR (issuance).
Feeds Materials Reconciliation and Project Costing.
LOG MATERIAL CONSUMPTION
| # | Project | PWO | Code | Description | Unit | Qty Used | Unit Cost | Total | Drum ID | Submitted By | Subcon | Issued By | Date | Del |
|---|
🔄 RR Return — Return Materials
Records materials returned from site to warehouse. Must link to original DR.
Increases inventory. Feeds Materials Reconciliation.
CREATE RETURN RECEIPT
📦 ITEMS RETURNED
| # | Return No. | DR Ref. | Project | PWO | Returned By | Date | Items | Total Value | Condition | Del |
|---|
🥁 Fiber Drum Tracking
Tracks each fiber cable drum from receipt to full consumption.
Records cuts, lengths used, and remaining balance per drum.
REGISTER DRUM
✂️ RECORD DRUM CUT
| # | Drum ID | Cable Type | Supplier | Initial (m) | Used (m) | Remaining (m) | % Used | Unit Cost | Location | Status | Cuts |
|---|
💰 Subcon Billing
Standalone subcontractor billing view. All billing records across all subcontractors and PWOs.
Billing must match approved BOQ and accomplished progress.
| # | Billing No. | PWO | Subcontractor | Type | Billing Amt | BOQ Total | Progress | Variance | Status | Date |
|---|
📈 Subcon Performance
Subcontractor scorecard with ranking. Metrics: on-time %, cost variance, rework, quality, safety, billing accuracy.
🔄 Subcon Material Reconciliation
Reconciles materials issued to subcontractors vs materials they actually used vs what was built.
Detects overuse, leakage, and unaccounted materials per subcontractor per PWO.
| # | Subcontractor | Material | Code | Unit | Issued to Subcon (DR) |
Used by Subcon (Usage) |
Returned (RR Return) |
Variance | Status | Risk |
|---|
🧠 Material Intelligence
Material intelligence hub. Access reconciliation, variance alerts, and fiber usage from here.
🔄
Material Reconciliation
Full RR vs DR vs Usage vs As-Built variance table with status and risk flags.
⚠️
Variance Alerts
Automatic alerts for materials where usage exceeds issuance, BOQ overruns, or subcon leakage detected.
🔌
Fiber Usage Intelligence
Drum-level fiber cable analysis. Track consumption per drum, project, and splice point.
⚠️ Material Variance Alerts
Auto-scans all projects for material anomalies. Alerts fire when usage exceeds issuance,
BOQ is overrun, or subcon usage cannot be accounted for.
🔌 Fiber Usage Intelligence
Drum-level fiber cable analysis. Tracks consumption, wastage, and remaining per drum across all projects.
| # | Drum ID | Cable Type | Project / PWO | Initial (m) | Total Used (m) | Remaining (m) | % Consumed | Wastage (m) | Status |
|---|
📋 Variation Orders
Variation Orders module. Alias of the existing VO tab.
📋
Variation Orders
Access through Projects → Variation Orders