ATPL Solar EPC full management system prototype with all sub-modules

Rajesh Kumar
RK

Dashboard

System overview — ATPL Solar EPC

Active projects
14
3 started this month
Total PO value
₹4.2Cr
on target
Pending invoices
₹78L
5 overdue
Headcount
62
4 on leave

Active projects

ProjectStage%
Jaipur 50kWInstall68%
Ajmer 200kWEngg32%
Bikaner 100kWHandover94%
Jodhpur 75kWProcure45%

Recent activity

GST invoice raised — Bikaner milestone 3
2 hrs ago
GRN recorded — 120 panels, Jaipur WH
4 hrs ago
Cost overrun — Ajmer 8% over budget
Yesterday

Employee master

Profiles, roles, contacts and documents

Total employees
62
Departments
8
Field staff
34
Office staff
28

Employee list

NameRoleDeptStatus
Amit SharmaSite SupervisorProjectsActive
Priya VermaEngineerEngineeringActive
Ravi GuptaTechnicianFieldOn leave
Sunita PatelAccountantFinanceActive
Deepak JoshiProject ManagerProjectsActive

Add employee

Attendance & leave

Daily attendance, shifts and leave approvals

Present today
54
87%
On leave
4
Leave requests
3
pending approval
Absent
4
unplanned

Today's attendance

NameCheck-inStatus
Amit Sharma08:42Present
Ravi GuptaOn leave
Priya Verma09:05Present
Mohan YadavAbsent

Leave requests

EmployeeDatesAction
Ravi GuptaJun 17–19Pending
Lata MehtaJun 20Approved
Suresh NairJun 22–23Pending

Payroll

Salary calculation, deductions and payslips

Gross payroll
₹18.4L
PF deductions
₹1.6L
ESI deductions
₹48K
Net payable
₹16.3L

June 2026 payroll summary

EmployeeBasicAllowancesDeductionsNet pay
Deepak Joshi₹65,000₹12,000₹8,450₹68,550
Priya Verma₹48,000₹8,000₹6,240₹49,760
Amit Sharma₹35,000₹6,000₹4,550₹36,450
Sunita Patel₹40,000₹7,000₹5,200₹41,800

Recruitment

Job postings, applicants and onboarding

Open positions
3
Applications
18
Interviews
5
this week
Offers made
2

Open positions

PositionDeptApplicantsStatus
Solar TechnicianField8Active
Electrical EngineerEngineering6Active
Site SupervisorProjects4Interviewing

Post new opening

Performance management

Goals, reviews and growth tracking

Performance ratings — Q2 2026

Deepak Joshi★★★★★5.0
Priya Verma★★★★4.2
Amit Sharma★★★★3.9
Ravi Gupta★★★3.2

Set employee goal

Training & development

Safety and skill training programs

Programs active
4
Enrolled staff
28
Completed
14
Certifications due
6
this month

Training schedule

ProgramTypeDateEnrolledStatus
Electrical safetySafetyJun 2012Upcoming
String inverter commissioningTechnicalJun 188In progress
First aidSafetyJun 1020Completed
Height safetySafetyJul 516Upcoming

Documents & compliance

PF, ESI, labour law and employee records

Documents on file
248
PF compliant
62/62
100%
ESI enrolled
38
Renewals due
3
this month

Compliance tracker

EmployeeAadhaarPANPF no.ESI
Amit SharmaOKOKMH/12345OK
Ravi GuptaOKPendingMH/12346OK
Priya VermaOKOKMH/12347OK

Budget planning

Project budgets from client PO values

Total approved budget
₹4.2Cr
Allocated
₹3.8Cr
Reserve
₹40L
Projects budgeted
14

Project budgets

ProjectPO valueBudgetContingencyStatus
Jaipur 50kW₹48L₹44L₹4LApproved
Ajmer 200kW₹1.8Cr₹1.65Cr₹15LApproved
Bikaner 100kW₹92L₹85L₹7LApproved
Jodhpur 75kW₹68L₹62L₹6LDraft

Project P&L

Real-time profitability per project

P&L overview

ProjectRevenueCostsGross profitMargin
Jaipur 50kW₹32L₹27L₹5L15.6%
Ajmer 200kW₹58L₹63L-₹5L-8.6%
Bikaner 100kW₹85L₹71L₹14L16.5%
Jodhpur 75kW₹28L₹22L₹6L21.4%

Cost management

Goods, recurring and pass-through costs

Goods costs
₹1.4Cr
Recurring costs
₹38L
Pass-through costs
₹22L
Total costs
₹2.0Cr

Cost register

DescriptionProjectTypeAmountDate
440W panels (240 units)Jaipur 50kWGoods₹12.8LJun 2
Site labour — month 2Ajmer 200kWRecurring₹3.2LJun 1
Net metering feeBikaner 100kWPass-thru₹45KJun 5

Cash flow management

30, 60 and 90-day cash flow projections

Opening balance
₹42L
30-day inflow
₹68L
expected
30-day outflow
₹38L
Projected balance
₹72L
net +₹30L

Cash flow forecast

PeriodInflowsOutflowsNetCumulative
Jun 2026 (30d)₹68L₹38L+₹30L₹72L
Jul 2026 (60d)₹52L₹44L+₹8L₹80L
Aug 2026 (90d)₹85L₹60L+₹25L₹105L

Financial reports

P&L, balance sheet, cash flow and expense summaries

Available reports

Monthly P&L statement
Balance sheet
Cash flow report
Expense summary
Project-wise cost report

Generate report

Cost overrun alerts

Automated notifications when costs exceed budget

Alerts active
2
need action
Projects at risk
1
Projects on track
13
Avg overrun
8.2%

Active overrun alerts

ProjectBudgetSpentOverrunAction
Ajmer 200kW₹1.65Cr₹1.78Cr+8.2%
Jaipur 50kW₹44L₹46.5L+5.7%

Invoice management

GST invoices raised on milestone completion

Total invoiced
₹1.8Cr
Paid
₹1.2Cr
Outstanding
₹78L
Overdue
5

Invoice list

InvoiceClientAmountStatus
INV-0041REIL Bikaner₹14.2LPaid
INV-0042Jaipur Dairy₹8.6LPending
INV-0043Ajmer Mfg₹22.1LOverdue
INV-0044REIL Bikaner₹9.4LDraft

Raise new invoice

Payment receipts

Record client payments and match to invoices

Recent receipts

Receipt no.ClientInvoiceAmountDateMode
RCP-0088REIL BikanerINV-0041₹14.2LJun 10NEFT
RCP-0087Jaipur DairyINV-0039₹6.0LJun 5RTGS
RCP-0086Ajmer MfgINV-0036₹18.5LMay 28Cheque

Ledger management

Client, supplier and vendor ledgers

Ledger — REIL Bikaner

DateDescriptionDebitCreditBalance
May 1Opening balance₹0
May 15INV-0038 raised₹12L₹12L
May 25Payment received₹12L₹0
Jun 5INV-0041 raised₹14.2L₹14.2L
Jun 10Payment received₹14.2L₹0

Payment approvals

Two-level approval for all outgoing payments

Awaiting L1
4
Awaiting L2
3
Approved today
2
Total value
₹8.4L

Pending approvals

Payment toPurposeAmountL1L2
Suraj ElectricalsWiring — Jaipur₹2.4LApprovedPending
Ram Civil WorksCivil — Ajmer M2₹1.8LPendingPending
Heera TransportDelivery — panels₹85KPendingPending

Audit trail

Every transaction logged — fully audit-ready

Transaction log

TimestampUserActionReferenceAmount
Jun 16 09:22Sunita PatelInvoice raisedINV-0044₹9.4L
Jun 16 08:55Rajesh KumarPayment approved L2PAY-0071₹2.4L
Jun 15 17:10Sunita PatelReceipt recordedRCP-0088₹14.2L
Jun 15 14:32Deepak JoshiPayment approved L1PAY-0071₹2.4L

Project setup

New project created instantly from client PO

Create project from PO

Projects list

ProjectClientPO valueStatus
Jaipur 50kWJaipur Dairy₹48LActive
Ajmer 200kWAjmer Mfg₹1.8CrActive
Bikaner 100kWREIL₹92LHandover

Stage tracker

8-stage pipeline: Engineering to Handover

Jaipur Rooftop 50kW

1. Engineering & designDone
2. Permits & approvalsDone
3. ProcurementDone
4. Civil & structureIn progress
5. InstallationIn progress
6. Testing & commissioningPending
7. Net meteringPending
8. Handover & documentationPending

All projects — stage summary

Jaipur 50kW
68%
Ajmer 200kW
32%
Bikaner 100kW
94%
Jodhpur 75kW
45%

Task board

Kanban board with dependency controls

To do
Net metering application
Jaipur 50kW · Priya Verma
Commission inverters
Jaipur 50kW · Amit Sharma
Engineering drawings
Jodhpur 75kW · Priya Verma
In progress
Panel installation — Block A
Jaipur 50kW · Field team
Civil foundation work
Ajmer 200kW · Ram Civil
Done
Site survey
Bikaner 100kW
PO verification
Bikaner 100kW
Material delivery
Jaipur 50kW

Daily progress reports

Site supervisors submit via mobile app

Today's DPRs

ProjectSubmitted byTimeStatus
Jaipur 50kWAmit Sharma07:45Submitted
Ajmer 200kWSuresh Nair08:10Submitted
Bikaner 100kWMissing
Jodhpur 75kWMohan Yadav08:30Submitted

DPR — Jaipur 50kW (Jun 16)

ItemDetail
Manpower present14
Panels installed today22 units
Cumulative installed108 / 120
Issues reportedNone
WeatherClear, 38°C

Milestones

Billing-linked milestones per project

Milestone tracker

ProjectMilestone% billingDueStatus
Jaipur 50kWM1 — PO advance20%May 1Billed
Jaipur 50kWM2 — Material delivery30%May 20Billed
Jaipur 50kWM3 — Installation complete30%Jun 20Pending
Jaipur 50kWM4 — Handover20%Jul 5Upcoming
Bikaner 100kWM3 — Commissioning30%Jun 22Ready to bill

Document register

Drawings, approvals and reports per project

Project documents — Jaipur 50kW

DocumentTypeUploaded byDateAction
Single line diagramDrawingPriya VermaMay 5
Structural layoutDrawingPriya VermaMay 6
DISCOM approval letterApprovalDeepak JoshiMay 18
Test commissioning reportReportAmit SharmaPending

Change orders

Scope changes with cost impact and client approval

Change orders

CO no.ProjectDescriptionImpactStatus
CO-008Ajmer 200kWAdd 10kW extra capacity+₹4.5LClient review
CO-007Jaipur 50kWUpgrade to bifacial panels+₹1.8LApproved
CO-006Bikaner 100kWAdditional earthing pits+₹45KApproved

Raise change order

Item catalogue

Master list of panels, inverters, cables and parts

Total SKUs
148
Categories
8
Active items
132
Discontinued
16

Item catalogue

Item nameCategoryUnitHSN codeGST %
440W Mono PERC panelPanelsUnit8541401112%
5kW string inverterInvertersUnit8504409018%
DC cable 4mm²CablesMetre8544429018%
MC4 connector pairBOSPair8536909018%
GI mounting structureStructureSet7308909018%

GRN — goods receipt

Record goods received against purchase orders

GRNs this month
12
Value received
₹38L
Pending POs
4
Short deliveries
1

Recent GRNs

GRN no.SupplierItemsDateStatus
GRN-0142Adani Solar120 panelsJun 16Received
GRN-0141Havells4 invertersJun 14Partial
GRN-0140Polycab500m cableJun 12Received

Record GRN

Warehouse stock

Real-time stock across all warehouse locations

Total items
148
Stock value
₹62L
Low stock alerts
3
Out of stock
1

Stock register — Jaipur warehouse

ItemOpeningReceivedDispatchedBalanceStatus
440W panel2201200340OK
5kW inverter160412Low
DC cable 4mm (m)300006002400OK
MC4 connectors250070180Low
GI mounting set8080Out of stock

Site dispatch

Send materials to site with auto transfer challan

Recent dispatches

ChallanTo projectItemsDate
TC-0088Jaipur 50kW40 panels, 200m cableJun 15
TC-0087Ajmer 200kW2 inverters, 50 MC4Jun 12
TC-0086Bikaner 100kW8 mounting setsJun 10

Create dispatch

Consumption log

Site staff log materials used per task

Consumption log — June 2026

ProjectTaskItemQty usedLogged byDate
Jaipur 50kWPanel installation440W panel22 unitsAmit SharmaJun 16
Jaipur 50kWDC wiringDC cable 4mm120mAmit SharmaJun 16
Ajmer 200kWInverter install5kW inverter2 unitsSuresh NairJun 15
Ajmer 200kWDC wiringMC4 connectors40 pairsSuresh NairJun 15

Returns tracker

Return unused materials from site to warehouse

Return requests

Return no.From projectItemQtyConditionStatus
RET-0022Bikaner 100kWDC cable 4mm80mGoodReceived
RET-0023Jaipur 50kWMC4 connectors12 pairsGoodIn transit
RET-0024Ajmer 200kWGI mounting parts4 setsMinor damagePending QC

Annual price contracts

Agreed supplier rates used in all POs

Active price contracts

SupplierItemRateValid tillStatus
Adani Solar440W Mono PERC panel₹18,500/unitMar 2027Active
Havells India5kW string inverter₹38,000/unitDec 2026Active
PolycabDC cable 4mm²₹65/mDec 2026Active
Tata SteelGI mounting structure₹22,000/setJun 2026Expiring

Vendor register

GST, PAN, bank account and category details

Total vendors
34
Approved
28
Pending approval
4
Blacklisted
2

Vendor directory

Vendor nameCategoryGST no.RatingStatus
Suraj ElectricalsWiring08AABCS1234A1Z54.5Approved
Ram Civil WorksCivil08AABCR5678B1Z24.2Approved
Heera TransportLogistics08AABCH9012C1Z83.8Approved
Apex StructuresMounting08AABCA3456D1Z14.6Approved
New Vendor Co.WiringPendingUnder review

Vendor onboarding

Structured checklist before any vendor is approved

Onboarding checklist — New Vendor Co.

Business registration certificateDone
GST registration certificateDone
PAN cardDone
Bank account verificationPending
Work sample / referencesNot submitted
Manager approvalAwaiting

Add new vendor

Work orders

Issue work orders with scope, rates and milestones

Active work orders

WO no.VendorProjectValueStatus
WO-0044Suraj ElectricalsJaipur 50kW₹3.8LActive
WO-0043Ram Civil WorksAjmer 200kW₹8.2LActive
WO-0042Apex StructuresBikaner 100kW₹5.1LCompleted

Issue work order

Daily work tracking

Vendors submit daily progress logs from site

Today's vendor logs — Jun 16

VendorProjectWork done todayManpowerSubmitted
Suraj ElectricalsJaipur 50kWDC wiring — block A complete608:30
Ram Civil WorksAjmer 200kWFoundation piling — 12 pits done1407:55
Heera TransportNot submitted

Milestone payments

Pay vendors based on verified milestone completion

Payments due
₹12.4L
Paid this month
₹8.6L
Pending verification
3
Awaiting approval
2

Vendor milestone payments

VendorWOMilestoneAmountVerifiedStatus
Suraj ElectricalsWO-0044M1 — Wiring 50%₹1.9LYesAwaiting approval
Ram Civil WorksWO-0043M1 — Foundation done₹4.1LPendingVerification pending
Apex StructuresWO-0042M2 — Full completion₹2.55LYesPaid

Performance rating

Rate vendors after each project — builds track record

Vendor ratings

VendorProjectsQualityTimelinessAvg
Suraj Electricals64.64.44.5
Ram Civil Works44.34.14.2
Heera Transport83.93.73.8
Apex Structures54.84.44.6

Submit rating

Client master

Client profiles, payment terms and contacts

Total clients
22
Active projects
14
Revenue this year
₹4.2Cr
New this quarter
4

Client list

ClientTypePayment termsProjects
REIL BikanerGovt PSU30 days3
Jaipur Dairy LtdIndustrial45 days2
Ajmer Mfg Co.Industrial30 days1
Kota Textile MillIndustrial60 days0

Add client

Lead management

First contact to won or lost

Total leads
19
Qualified
11
Won (QTD)
4
₹2.8Cr
Lost
2

Lead pipeline

LeadSizeSegmentStageLast contact
Kota Textile Mill150 kWpIndustrialProposal sentJun 14
Udaipur Hotel Group80 kWpCommercialQuote sentJun 10
Jodhpur Cold Storage200 kWpIndustrialPO receivedJun 12
Sikar Co-op Society30 kWpIndustrialFirst contactJun 16
Bharatpur RREC500 kWpGovtSite visit doneJun 8

Quotation builder

Build detailed quotes from system size in minutes

Build quotation

Recent quotations

Quote no.ClientSizeValueStatus
QT-0088Kota Textile150 kWp₹1.35CrSent
QT-0087Udaipur Hotel80 kWp₹74LSent
QT-0086Jodhpur Cold200 kWp₹1.78CrWon

PO register

Upload and index all client purchase orders

Total POs
31
Total value
₹18.4Cr
Active POs
14
Completed
17

PO register

PO no.ClientDateValueProjectStatus
PO-2026-041REIL BikanerJan 5₹92LBikaner 100kWActive
PO-2026-038Ajmer MfgFeb 12₹1.8CrAjmer 200kWActive
PO-2026-031Jaipur DairyMar 8₹48LJaipur 50kWActive
PO-2026-022Jodhpur HospApr 1₹62LJodhpur 75kWActive

Revenue tracking

Compare revenue targets vs actual invoices

Annual target
₹12Cr
Invoiced YTD
₹4.8Cr
40% of target
Collected YTD
₹3.6Cr
Pipeline value
₹6.2Cr

Monthly revenue vs target

MonthTargetInvoicedCollectedAchievement
January₹80L₹72L₹68L90%
February₹80L₹88L₹80L110%
March₹1Cr₹96L₹88L96%
April₹1Cr₹1.1Cr₹98L110%
May₹1Cr₹92L₹85L92%
June (MTD)₹1Cr₹42L₹38L42%