Skip to content

Read a landlord's ledger and record an entry

The landlord ledger is the running account of the money you hold for one landlord: rent received, your commission and fees, maintenance costs, adjustments and payouts. You read it on the Financials tab of the landlord’s page.

  • Open Lettings > Landlords, then click the landlord. The tabs are Overview, Financials and Statements & Payments. The tabs share the landlord’s page address, so there is no separate link for the ledger.
  • Anyone who can view the landlord’s money can read the ledger. To record an entry, mark an entry’s tax category or pay the landlord you need permission to manage that landlord’s money (the owner, admins, Full Agents, Lettings Agents, Finance and the landlord’s assigned agent have it; Read Only can only view). With a view-only role the buttons are greyed out with the message “Your role can see this landlord’s money but not change it. Ask an admin if you need to.”
  • A ledger is created automatically with the first money recorded for the landlord: usually the first rent payment, but also a completed maintenance cost or deposit money kept for them. Until then the tab says No ledger yet.

The top of the tab shows Balance held for landlord: funds collected, net of fees and payouts. A negative balance means the landlord owes the agency money, and you cannot pay them out.

Below it, the table lists every entry with these columns: Date, Type, Tax (SA105), Description, Credit, Debit and Balance (the balance after that entry). The entry types are:

Type What it is
Rent Received Rent paid by a tenant for this landlord’s properties
Commission Your management commission, taken from rent
Fee Any other fee charged to the landlord
Maintenance Cost The cost of a completed maintenance job
Disbursement A payout to the landlord
Opening balance brought forward Only after an import from another system: the balance you held for the landlord (or they owed you) on the switch-over date. Not income, no commission. Rent a tenant later pays towards arrears brought over from the old system also shows under this label, with commission as usual.
Adjustment A manual entry, a correction or reversal, a one-off tenant payment passed to the landlord (for example an additional charge), or deposit money kept for the landlord

Where an entry relates to a property, its description is a link to that property.

A line on a landlord’s ledger is never rewritten, so LintelCRM adds a short explanation where later events changed what a line means:

  • A grey note under a line, for example “Rent changed to £950.00 from 1 Oct 2026: this payment now pays…”, means a later rent change re-spread that payment across the rent periods. The line itself still shows what was received on the day.
  • Sale apportionment lines (“Rent apportioned to the new owner…” and “Rent apportioned from the previous owner…”) say which payment they came from.
  • “[backfilled]” in a description marks rent the ledger booked by replaying payments that were already recorded, for example rent you recorded today for past dates, or rent recorded before the landlord was assigned to the property. It is not an error.
  • “(agreement dates changed)” marks commission credited back to the landlord because their management agreement was ended on an earlier day. See Management agreements and commission.

Some tenant money never reaches the landlord’s ledger at all, because it was never the landlord’s:

  • rent marked Paid in previous system (your old system already accounted for it);
  • a tenant’s repayment of credit refunded from a payment that was reversed (it puts back money your client account paid out);
  • tenant credit, until it pays rent on a due date;
  • deposits, until money is kept for the landlord.

A refund of rent appears once on the landlord’s ledger, linked to the rent it gives back, whatever order the refund and the payment were recorded in.

Use this for adjustments, refunds or corrections that the system does not capture automatically.

  1. On the Financials tab, click Record entry.
  2. Choose Direction: Credit (increase balance) or Debit (decrease balance).
  3. Enter the Amount in pounds and the Date. The date cannot be in the future, because money is recorded on the day it moved.
  4. Enter a Description, for example “Manual adjustment” or “Refund”.
  5. Click Record.

The entry appears in the table straight away. If it falls in a month you have already issued a statement for, that statement is voided and reissued with the new figures. Later statements already issued are reissued too if their opening balance changed (see Landlord statements).

A ledger entry cannot be edited or deleted: a mistake is put right with a reversal or an adjustment, and the original stays. See Money is never deleted. To move a whole property’s money to another landlord, see Change a property’s landlord.

Click Export CSV on the Financials tab to download the landlord’s full ledger as a spreadsheet file. The columns are entry_date, entry_type, description, property_address, tenancy_uuid, reference_type, reference_id, debit, credit, balance_after and currency.

To export every landlord’s ledger in one file, open Lettings > Landlords and click Export all landlord ledgers. It is offered to anyone with financial dashboard access (the owner, admins, Full Agents, Lettings Agents and Finance). The CSV has one row per ledger entry, with the landlord’s name.

For a year-end set of files for an accountant, use an accountant pack instead.

Problem: “Pay landlord” and “Record entry” are greyed out. Your role can view but not change this landlord’s money. Ask an Admin or Owner. If the landlord is archived, these buttons are not offered at all.

Problem: the balance is negative. Costs or fees have been charged that are larger than the rent collected. You cannot record a payout until the balance is above zero.

Problem: “No ledger yet”. No money has been recorded for this landlord yet. Record a rent payment on one of their tenancies first.