W4Y Operational Platform - Enterprise Guide & Database Manual

What is W4Y & Owner Value?

Product Overview & Business Value

W4Y Operational Platform acts as the central operational nervous system of your enterprise. It combines employee GPS tracking, milestone project pipelines, client accounts, vendor lists, and monthly close ledger locking into a single secure platform.

1

"Are employees logging hours outside the job site?"

W4Y checks GPS positions and boundary limits. Staff can only clock in when physically present in the strict geofence radius.

2

"Are unbilled project milestones causing payment delay?"

Invoicing is tied directly to project milestones. Once a stage tasks is complete, accounts gets auto-alerts to issue GST bills.

Interactive Savings & ROI Calculator

Staff Count: 15

Avg. Monthly Salary per employee: ₹ 25,000

Estimated Monthly Savings with W4Y

₹ 33,750

*Calculated at 9% savings based on attendance leakage prevention, ledger audit safety, and auto-payroll deductions.

Leave Management & Holidays

Staff Leave Requests & Payroll Integrations

Manual leave registers are prone to tracking errors. W4Y links leave requests directly to monthly payroll deductions:

Auto-Leave Accumulator: Employees accrue 1.5 days of paid leave per month. Unused leaves are tracked automatically inside their profile.
Deduction Workflows: Unpaid leaves are calculated during the monthly close process. The system reads approved leave summaries and automatically deducts the calculated amount from the base salary.
Paid Holidays Catalog: Paid organization holidays can be defined inside the system database to ensure correct attendance flags for all team members.

🛠️ Database Schema: Leaves & Holidays

-- 1. Leave Requests Table CREATE TABLE leave_requests ( id SERIAL PRIMARY KEY, user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE, start_date DATE NOT NULL, end_date DATE NOT NULL, type VARCHAR(50) NOT NULL, -- Earned, Casual, Unpaid, Sick status VARCHAR(20) DEFAULT 'pending', -- pending, approved, rejected remarks TEXT, reviewed_by INTEGER REFERENCES users(id) ); -- 2. Employee Monthly Leave Summary CREATE TABLE employee_leave_summary ( id SERIAL PRIMARY KEY, user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE, month INTEGER NOT NULL, year INTEGER NOT NULL, unpaid_leaves DECIMAL(5, 2) DEFAULT 0, UNIQUE(user_id, month, year) );

Daily Employee Lifecycle

Daily Staff Workflow Cycle

Staff can manage their daily work via the W4Y mobile interface in 5 simple steps:

Client Locations & Banking Details

Multi-Address and Direct Payment Coordinates

W4Y holds a rich client directory structure. Each client record is linked to multiple site locations and primary payment coordinates to avoid billing errors:

Multi-Type Addresses: Clients can have separate 'Billing', 'Site', and 'Office' address records containing details like City, State, and Pincode.
Secured Banking Data: Tracks Bank account names, numbers, IFSC codes, branches, and UPI IDs for refunding or verifying incoming milestone transactions.
Compliance Auditing: Stores company GST and PAN numbers for generating legally compliant tax invoices automatically.

🛠 ️Database Schema: Client Addressing & Banking

-- 1. Client Addresses Table CREATE TABLE client_addresses ( id SERIAL PRIMARY KEY, client_id INTEGER REFERENCES clients(id) ON DELETE CASCADE, type VARCHAR(50), -- Billing, Site, Office address TEXT, city VARCHAR(100), state VARCHAR(100), pincode VARCHAR(20) ); -- 2. Client Banking Table CREATE TABLE client_banking ( id SERIAL PRIMARY KEY, client_id INTEGER REFERENCES clients(id) ON DELETE CASCADE, account_name VARCHAR(200), account_number VARCHAR(100), ifsc VARCHAR(50), bank_name VARCHAR(200), upi_id VARCHAR(100), is_primary BOOLEAN DEFAULT FALSE );

Project Milestones & Billing

Custom Stages & Automatic Tax Invoicing

W4Y projects move through structured phases. Billing is linked directly to milestone completion:

W4Y Workspace Solutions

Senapati Bapat Road, Pune - 411 016

TAX INVOICE

Invoice No: W4Y-2026-004 | Date: 06 June 2026

✓ PAID

Description (Work Stage Description)	Rate	Amount
Project Stage 3: Interior Design Sanction Stage Advance	₹ 1,50,000.00	₹ 1,50,000.00

Subtotal:	₹ 1,50,000.00
CGST (9%):	₹ 13,500.00
SGST (9%):	₹ 13,500.00
Grand Total:	₹ 1,77,000.00

Stakeholders & Task Mentions

Multi-User Project Scope & Threaded Comments

Projects are complex networks involving multiple external coordinators. W4Y integrates client contacts, third-party specialists, and team task logs in one place:

External Stakeholders Registry: Tracks specialists associated with each project (e.g., Structural Engineers, Municipal Liaisons, Client Leads) directly inside the project file.
Multi-User Task Assignees: Tasks are linked to specific users (`assigned_to`). System restricts employee views to their assigned tasks only, preventing database confusion.
Threaded Task Comments & @Mentions: Enables threaded message logs per task with `@mention` indicators, notifying key members and replacing unstructured WhatsApp groups.

🛠️ Database Schema: Project Stakeholders & Tasking

-- 1. Project Stakeholders Table CREATE TABLE project_stakeholders ( id SERIAL PRIMARY KEY, project_id INTEGER NOT NULL REFERENCES projects(id) ON DELETE CASCADE, name VARCHAR(200) NOT NULL, role VARCHAR(100), -- Structural Engineer, Client Lead, Liaison Officer phone VARCHAR(20) ); -- 2. Tasks Table CREATE TABLE tasks ( id SERIAL PRIMARY KEY, project_id INTEGER NOT NULL REFERENCES projects(id) ON DELETE CASCADE, stage VARCHAR(50) NOT NULL DEFAULT 'proposal', title VARCHAR(255) NOT NULL, assigned_to INTEGER REFERENCES users(id), status VARCHAR(30) DEFAULT 'pending' CHECK (status IN ('pending', 'in_progress', 'review', 'done', 'passed')) );

Vendor Catalogs & Material Costs

Trade Classification & Direct Transaction Records

W4Y categorizes material suppliers and sub-contractors, recording transactions directly against the project ledger:

Supplier Trade Grouping: Vendors are categorized by trade (e.g., Civil, HVAC, Electrical, Plumbing) for easy selection and quotation comparisons.
Direct Expense Recording: Allows site managers to record material purchases and upload purchase receipts (`receipt_url`) directly to the project file.

General Ledger & Auditing Logs

Category Expense Audits & Monthly Close Safety

Operational safety is critical to prevent fraud. W4Y logs every income/expense transaction and locks them monthly:

Classified Ledger Book: Tracks transactions tagged as `income` or `expense`, categorized by code (e.g., office expense, material cost, employee payroll) and linked to projects.
Expense Audit Verification: Accounts must verify category expenses per month and year (`is_verified=true`) before the period is officially locked.
Backdate Protection: Once closed, the period-locking engine prevents any user from adding, editing, or deleting historical transaction logs.

🛠 ️Database Schema: Financial Ledger & Audits

-- 1. General Ledger Transactions Table CREATE TABLE transactions ( id SERIAL PRIMARY KEY, type VARCHAR(10) CHECK (type IN ('income', 'expense')), category VARCHAR(50) NOT NULL, -- office expense, material cost, payroll amount DECIMAL(15, 2) NOT NULL, date DATE DEFAULT CURRENT_DATE, project_id INTEGER REFERENCES projects(id), vendor_id INTEGER REFERENCES vendors(id), employee_id INTEGER REFERENCES users(id), receipt_url TEXT ); -- 2. Expense Audits Table CREATE TABLE expense_audits ( category VARCHAR(100) NOT NULL, month INTEGER NOT NULL, year INTEGER NOT NULL, is_verified BOOLEAN DEFAULT FALSE, verified_by INTEGER REFERENCES users(id), PRIMARY KEY (category, month, year) );

Geofenced Attendance Zones

GPS Geofencing Verification Gate

Staff check-ins are validated using concentric zone rings and a GPS accuracy shield:

🛠️ Database Schema: Geofenced Attendance Table

CREATE TABLE attendance ( id SERIAL PRIMARY KEY, user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE, check_in TIMESTAMPTZ, check_out TIMESTAMPTZ, lat DECIMAL(10, 8), lng DECIMAL(11, 8), date DATE NOT NULL DEFAULT CURRENT_DATE, status VARCHAR(20) DEFAULT 'working', is_late BOOLEAN DEFAULT FALSE, late_minutes INTEGER DEFAULT 0, checkin_accuracy DECIMAL(10, 2), checkin_distance DECIMAL(10, 2), checkin_zone VARCHAR(20), -- strict, buffer, outside hours_worked DECIMAL(10, 2) DEFAULT 0 );

Monthly Close Ledger Lock

Ledger Freeze and Temporary Unlock Audit Log

At month close, the admin locks the ledger to compute payroll. Edits to past dates require permission:

System Access & Dashboard Previews

Role Restrictions & Live Interface Views

Restrict access to sensitive financial metrics while granting staff check-in capabilities:

Owner / Admin Dashboard (Admin View)

Business financial and progress metrics are displayed in the charts below:

Monthly Billing (Billing):

85%

Expense Limits (Expenses):

45%

Active Staff (Attendance):

90%

Design Head Dashboard (Milestone & Task Supervisor View)

Review project designs, assign tasks, and approve deliverables:

Project	Task Deliverable	Assigned To	Status
Patil Residential Site	Interior Elevation 3D Renderings	Rahul S. (Senior Designer)	Review Pending
Sutar Commercial Plaza	Lobby False Ceiling Layout	Pooja M. (Junior Architect)	Approved
Kulkarni Villa	Electrical Layout & Lighting Plan	Unassigned	Pending Assignment

Employee Mobile View (Employee Simulator)

Simple attendance screen displayed on the employee's phone:

W4Y Attendance App

📍 Location: Senapati Bapat Road Site

✓ Zone: Strict Zone (within 25 meters)

Accountant Ledger View (Accounts General Ledger)

Classified transaction records are displayed in the table below:

Date	Transaction Details	Type	Amount
06 June 2026	Sunil Cement Supplier Payment (Cement Purchase)	Expense	₹ 45,000.00
05 June 2026	Patil Site Stage 3 Advance (Milestone Income)	Income	₹ 1,77,000.00

Owner Frequently Asked Questions

Frequently Asked Questions

1. Can employees spoof their GPS location to check in from home?

No. The system is equipped with a Fake GPS Blocker and a strict geofencing gate. Employees cannot use location spoofing or cloned apps to check in from outside their designated work zone.

2. How does attendance work if there is no mobile network or internet coverage on site?

The app stores the geographic coordinates offline when the user checks in. As soon as internet connectivity is restored, all offline data is automatically synchronized with the server database.

3. Can past transactions or payroll details be changed once the monthly period is closed?

No. Once the monthly ledger lock is active, standard employees and accountants cannot modify closed logs, bills, or payroll details. Only the system Admin can unlock the period, and any such action is permanently logged in the audit book.

4. Is the app easy to use for supervisors or site laborers?

Yes, the app features a highly intuitive user interface with simple icons and large buttons. Daily tasks are limited to basic actions like checking in and uploading site photos, which takes less than a minute.