Property Maintenance Records Log

Maintenance records across a property portfolio: requests by unit and trade, vendors, scheduled dates, costs and who pays.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Log Sheets

Tables

Properties, Maintenance

Fields

27

Views

grid, cards, kanban, calendar, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Properties

10 fields · 3 sample rows

  • Portfolio (Grid)
  • Properties (Cards)
PropertyTextAddressAddressTypeSingle selectUnitsNumberOwnerTextRecordsLink to another tableJobsCountOpen JobsRollupTotal SpendRollupPhotoAttachment
Lakeview Residency12 Lake Road, Bengaluru, Karnataka, 560034, IndiaApartment block24Lakeview RWALeaking kitchen tap, Lift not stopping at 4th floor, Broken wardrobe hinge31₹13,450
Palm Villa 7Villa 7, Palm Meadows, Bengaluru, 560066, IndiaVilla1Mr. & Mrs. IyerAnnual termite treatment11₹6,500
Trade Centre Office5th Floor, Trade Centre, BKC, Mumbai, 400051, IndiaOffice6Horizon RealtyAC not cooling – meeting room, Repaint lobby walls22₹45,000
Field details
Property · Text
Address · Address
Type · Single select
Apartment block, Villa, Office, Retail, Warehouse
Units · Number
Owner · Text
Records · Link to another table
Links to Maintenance
Jobs · Count
Open Jobs · Rollup
sum of Is Open via Records
Total Spend · Rollup
sum of Cost via Records
Photo · Attachment

Maintenance

17 fields · 6 sample rows

  • Records (Grid)
  • Work orders (Kanban)
  • Schedule (Calendar)
  • Maintenance request (Form)
  • Spend (Dashboard)
JobTextPropertyLink to another tableUnitTextTradeSingle selectPrioritySingle selectReported ByTextReported OnDateStatusSingle selectVendorTextScheduled ForDateCompleted OnDateCostCurrencyBilled ToSingle selectIs OpenFormulaDays to CompleteFormulaPhotos / InvoiceAttachmentNotesLong text
Leaking kitchen tapLakeview ResidencyB-302PlumbingNormalTenant – Sneha13 Nov 2026CompletedQuickFix Plumbers15 Nov 202615 Nov 2026₹850Owner02
Lift not stopping at 4th floorLakeview ResidencyCommonElectricalEmergencySecurity18 Nov 2026In progressOtis Service19 Nov 2026₹12,000Society fund1
Annual termite treatmentPalm Villa 7Pest controlLowOwner9 Nov 2026ScheduledPestAway24 Nov 2026₹6,500Owner1
AC not cooling – meeting roomTrade Centre OfficeSuite 502HVACHighTenant – Zenith Ltd16 Nov 2026ScheduledCoolAir20 Nov 2026Warranty1
Repaint lobby wallsTrade Centre OfficeLobbyPaintingLowFacility manager30 Oct 2026Reported₹45,000Owner1
Broken wardrobe hingeLakeview ResidencyA-104CarpentryNormalTenant – Arjun4 Nov 2026CompletedWoodcraft8 Nov 2026₹600Tenant04
Field details
Job · Text
Property · Link to another table
Links to Properties
Unit · Text
Trade · Single select
Plumbing, Electrical, HVAC, Painting, Carpentry, Pest control, Appliances, General
Priority · Single select
Emergency, High, Normal, Low
Reported By · Text
Reported On · Date
Status · Single select
Reported, Scheduled, In progress, Completed, Cancelled
Vendor · Text
Scheduled For · Date
Completed On · Date
Cost · Currency
INR
Billed To · Single select
Owner, Tenant, Insurance, Warranty, Society fund
Is Open · Formula
IF(OR({Status} = 'Completed', {Status} = 'Cancelled'), 0, 1)
Days to Complete · Formula
IF(AND({Reported On}, {Completed On}), DATETIME_DIFF({Completed On}, {Reported On}, 'days'), BLANK())
Photos / Invoice · Attachment
Notes · Long text

Form view “Maintenance request” asks for: Job, Property, Unit, Trade, Priority, Reported By, Reported On, Photos / Invoice, Notes.

Property Maintenance Records Log: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates