FIBER CONNECT SOLUTIONS, INC.
Unit 201 RCS Sycamore Square, Doña Soledad Ave., Brgy. Better Living, Parañaque City
(02)824-20982 · 0919-099-6707 · info@fiberconnect.one
🔔
⏻ Logout
📊 Dashboard
🔍 WO SEARCH
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 |
|---|
🧠 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
📁 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
| # | 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
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
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 | Del |
|---|
💰 Receivables / Collections
| # | Client | Invoice # | Amount | Invoice Date | Due Date | Age | Status | Notes | Del |
|---|
👥 Payroll Processing
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.
ALLOWANCES (non-taxable up to BIR limits)
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
PETTY CASH FUNDS
REPLENISH A FUND
SUBMIT EXPENSE
All staff can submit expenses. Choose the correct type — it determines how reimbursement works.
⏳ PENDING APPROVAL
0 pending
| # | Date | Type | Category | Description | Amount | Project | Paid By | 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
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.
📋 Project Costing
| # | Project | Item | Category | Budgeted | Actual | Variance | Notes | Del |
|---|
⏱️ Timesheet
STEP 1 — LOG DAILY HOURS
Staff enter their own hours per day. All entries go to pending until approved by a supervisor.
Staff submit their own hours. Admin / Manager / Finance can enter the employee name to log on behalf of others. Monthly staff: log OT hours only — leave regular hours as 0.
STEP 2 — PENDING APPROVAL QUEUE
0 pending
| # | Emp No. | Employee | Position | Date | 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)
Record all material deliveries received on site or warehouse. DR feeds into Materials Reconciliation,
Inventory Received, and Invoice Reconciler matching.
ADD DELIVERY RECEIPT
📋 ITEMS RECEIVED
| # | DR No. | Project | PWO | PO Ref. | Supplier | Date | Site | Received By | Items | Total Value | Status | Remarks | Action |
|---|
📋 Receiving Report (RR)
Formal inspection and acceptance of delivered items. RR is required before invoice approval.
RR feeds into Invoice Reconciler as qty_received reference.
CREATE RECEIVING REPORT
📋 ITEMS INSPECTION (auto-filled from DR)
| # | RR No. | DR Ref. | PWO | Supplier | Inspection Date | Inspected By | Accepted By | Result | Remarks | 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.
| # | Username | Full Name | Role | Del |
|---|
📜 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
Semi-monthly 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 |
|---|
🏛️ 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
📋 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