Job Costing

Job Costing for Project Alpha - Site A

A snapshot of budget vs. actuals for the project.

Total Budget

₹25,00,000

Actual Costs

₹12,90,000

Variance

₹12,10,000

Under Budget

Cost Breakdown

Invoices

Vendor	Amount
Cement Corp	₹4,50,000
Steel Beams Ltd	₹7,20,000

Purchase Orders

Vendor	Amount
Hardware Solutions	₹85,000
Safety Gear Inc.	₹35,000

Bill of Quantities (BOQ) - Budget

Item Description	Budgeted Amount
Excavation & Earthwork	₹1,50,000
Concrete Work	₹6,00,000
Masonry Work	₹3,50,000
Steel Reinforcement	₹4,50,000
Total BOQ Budget	₹15,50,000

Technical Details & Export Schema

Schema definitions for data aggregation and export.

Budget vs. Actuals View (SQL/BigQuery)


CREATE OR REPLACE VIEW project_cost_summary AS
SELECT
  p.id AS project_id,
  p.name AS project_name,
  p.budget AS total_budget,
  (
    SELECT SUM(amount) FROM `invoices` WHERE projectId = p.id
  )
  +
  (
    SELECT SUM(totalAmount) FROM `purchase_orders` WHERE projectId = p.id
  ) AS actual_costs,
  p.budget - (
    (SELECT SUM(amount) FROM `invoices` WHERE projectId = p.id) +
    (SELECT SUM(totalAmount) FROM `purchase_orders` WHERE projectId = p.id)
  ) AS variance
FROM
  `projects` AS p;

Tally CSV Export Layout

The following format would be generated for import into Tally or other accounting software.

Date	Voucher Type	Voucher No.	Debit Ledger	Debit Amount	Credit Ledger
2024-07-20	Purchase	inv-001	Cement Corp Expenses	450000	Cement Corp
2024-07-22	Purchase	inv-002	Steel Beams Ltd Expenses	720000	Steel Beams Ltd
2024-07-15	Purchase Order	po-101	Hardware Solutions PO	85000	Hardware Solutions
2024-07-18	Purchase Order	po-102	Safety Gear Inc. PO	35000	Safety Gear Inc.