Rental Payment Log Template

Log each month’s rent per tenant, spot late or partial payments and see what every tenant still owes.

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

Real Estate

Tables

Tenants, Payments

Fields

22

Views

grid, kanban, calendar, 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.

Tenants

9 fields · 3 sample rows

  • Grid (Grid)
TenantTextUnitTextPhonePhoneMonthly rentCurrencyLease startDatePaymentsLink to another tableMonths loggedCountTotal paidRollupOutstandingRollup
Neha SharmaBandra 2BHK+91 98201 45678₹65,0003 May 2026Neha Sharma – Oct, Neha Sharma – Nov2₹1,30,000₹0
Daniel BrooksIndiranagar Studio+91 99720 33445₹28,00016 Aug 2026Daniel Brooks – Oct, Daniel Brooks – Nov2₹44,000₹13,000
Kiran PatelSalt Lake 3BHK+91 98300 66778₹32,00015 Oct 2025Kiran Patel – Oct, Kiran Patel – Nov2₹32,000₹32,500
Field details
Tenant · Text
Unit · Text
Phone · Phone
Monthly rent · Currency
INR
Lease start · Date
Payments · Link to another table
Links to Payments
Months logged · Count
Total paid · Rollup
sum of Amount paid via Payments
Outstanding · Rollup
sum of Balance via Payments

Payments

13 fields · 6 sample rows

  • Ledger (Grid)
  • By status (Kanban)
  • Due dates (Calendar)
  • Collections (Dashboard)
PaymentTextTenantLink to another tableDue dateDatePaid onDateAmount dueCurrencyLate feeCurrencyAmount paidCurrencyBalanceFormulaDays lateFormulaMethodSingle selectStatusSingle selectReceiptAttachmentNotesLong text
Neha Sharma – OctNeha Sharma5 Oct 20264 Oct 2026₹65,000₹65,000₹00Bank transferPaid
Neha Sharma – NovNeha Sharma5 Nov 20266 Nov 2026₹65,000₹65,000₹01UPIPaid
Daniel Brooks – OctDaniel Brooks5 Oct 202612 Oct 2026₹28,000₹1,000₹29,000₹07UPILate
Daniel Brooks – NovDaniel Brooks5 Nov 20269 Nov 2026₹28,000₹15,000₹13,0004UPIPartialBalance promised by month end.
Kiran Patel – OctKiran Patel5 Oct 20265 Oct 2026₹32,000₹32,000₹00ChequePaid
Kiran Patel – NovKiran Patel5 Nov 2026₹32,000₹500₹0₹32,50014Unpaid
Field details
Payment · Text
Tenant · Link to another table
Links to Tenants
Due date · Date
Paid on · Date
Amount due · Currency
INR
Late fee · Currency
INR
Amount paid · Currency
INR
Balance · Formula
{Amount due} + {Late fee} - {Amount paid}
Days late · Formula
IF(AND({Paid on}, {Due date}), MAX(0, DATETIME_DIFF({Paid on}, {Due date}, 'days')), IF({Due date}, MAX(0, DATETIME_DIFF(TODAY(), {Due date}, 'days')), BLANK()))
Method · Single select
UPI, Bank transfer, Cheque, Cash, Card
Status · Single select
Paid, Partial, Late, Unpaid
Receipt · Attachment
Notes · Long text

Rental Payment Log Template: 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