Fixed asset register, depreciation calculation, asset transfers, disposals, GST returns, TDS management, and tax compliance.
Fixed Assets management tracks capitalized assets from acquisition through depreciation to disposal. Depreciation computed using WDV (Written Down Value) or SLM (Straight Line Method) per company policy and Income Tax Act. Asset transfers between projects maintain ownership history. Tax module manages GST return filing (GSTR-1, GSTR-3B), TDS deduction, deposit, and certificate issuance. Tax ledgers reconcile with GL.
| Status | Description | Allowed Actions | Next States |
|---|---|---|---|
| Active | Asset in use, depreciating | Transfer, Maintain, Dispose | Transferred, Disposed |
| Transferred | Asset moved to different project/location | Accept Transfer | Active |
| Under Verification | Physical verification pending | Verify, Report Missing | Active, Missing |
| Disposed | Asset sold, scrapped, or written off | Record Proceeds | — |
| Filed | GST return filed for period | — | — |
| Pending | TDS deposit/certificate pending | Deposit, Issue Certificate | Completed |
asset_id — PKtenant_id, entity_id — FK → organizationasset_code, asset_name — Identificationcategory — land | building | plant | vehicle | furniture | computeracquisition_date, acquisition_cost — Purchase detailsdepreciation_method — wdv | slmuseful_life_years, salvage_value — Depreciation parameterscurrent_wdv, accumulated_depreciation — Running valueslocation_id, project_id — Current deploymentdep_id — PKasset_id — FK → fixed_assets.fixed_assetfiscal_year, period — Year and monthopening_wdv, dep_amount, closing_wdv — Period calculationdep_rate — Applicable rate per IT Act/Company Acttransfer_id — PKasset_id — FK → fixed_assets.fixed_assetfrom_project_id, to_project_id — Transfer pathtransfer_date, reason — Detailsapproved_by — FK → admin.userconfig_id — PKtax_type — gst | tds | tcs | professional_taxsection_code — e.g., 194C, 194J for TDSrate, threshold — Applicable rate and minimum thresholdeffective_from, effective_to — Validity periodreturn_id — PKentity_id — FK → organization.company_entityreturn_type — GSTR1 | GSTR3B | GSTR2A | GSTR9period_month, period_year — Filing periodtotal_taxable, igst, cgst, sgst, cess — Tax amountsfiling_date, arn_number — Filing confirmationstatus — Draft → Filed → Acknowledgedcert_id — PKvendor_id — FK → vendor.vendor_mastersection_code, financial_year, quarter — TDS detailstotal_payment, total_tds — Amountscertificate_number — Form 16A referenceissued_date — Date of issueWhen PO for capital item is received and GRN approved, asset record created in fixed assets register. Acquisition cost includes purchase price + installation + freight.
Monthly depreciation batch job calculates period depreciation for all active assets. WDV method: dep = opening WDV × rate / 12. SLM: dep = (cost - salvage) / life / 12.
When equipment/vehicle moves between projects, asset transfer record created. Depreciation allocation switches to new project from transfer date.
Monthly GSTR-3B aggregates all purchase and sales GST. Quarterly GSTR-1 details all outward supplies. System auto-generates from AP/AR invoice data with manual adjustments.
TDS auto-deducted from vendor payments per applicable section and rate. Quarterly TDS deposited with government. Annual TDS certificates (Form 16A) issued to vendors.
-- Fixed asset register with depreciation status SELECT fa.asset_code, fa.asset_name, fa.category, fa.acquisition_cost, fa.accumulated_depreciation, fa.current_wdv, fa.acquisition_cost - fa.accumulated_depreciation AS net_book_value FROM fixed_assets.fixed_asset fa WHERE fa.entity_id = :entity_id AND fa.status = 'Active' ORDER BY fa.category, fa.acquisition_cost DESC;