Generate rent ledger
generate_rent_ledgerRead-onlyIdempotent
Use this when the user wants a rent ledger, tenant ledger, rent ledger template filled in, or proof of rent payments for a tenant: 'make a ledger of my tenant payments this year', 'tenant paid 800 of 1200 rent, what is the balance', amount due as of a date. Takes lease terms (rent, start, due day, late fee rule with grace period) and payments typed or from an attached CSV/Excel file; charges rent monthly with prorated first/last months, applies payments oldest first, adds late fees (flat, percent, daily with cap), carries overpayments forward as credit, and returns a running balance plus PDF statement, Excel and CSV downloads. Does not check state late-fee limits, give legal advice, collect rent, or make rent receipts for proof of address.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| late_fee | No | Late fee rule from the lease, e.g. {"type": "flat", "amount": 75, "grace_days": 5}. Omit for no late fees. | |
| payments | No | Payments received from the tenant, e.g. [{"date": "2026-02-03", "amount": 1450}]. Payments before a due date become a credit. | |
| property | No | Property or unit, e.g. 412 Oak St, Unit 2B, Austin, TX. | |
| lease_end | No | Move-out date (last day charged), YYYY-MM-DD, e.g. 2026-08-10. Omit for an ongoing tenancy. | |
| as_of_date | Yes | Statement date: charges and payments up to and including this day, YYYY-MM-DD, e.g. 2026-10-03. Use the date the user names, otherwise today's date from the conversation (the user's local date). | |
| lease_start | Yes | Lease start or move-in date, YYYY-MM-DD, e.g. 2026-01-17. A mid-month start is prorated when rent is due on the 1st. | |
| tenant_name | No | Tenant name shown on the statement, e.g. Maria Lopez. Do not include a Social Security number. | |
| monthly_rent | Yes | Monthly rent in USD from the lease, e.g. 1450. | |
| rent_changes | No | Rent increases or decreases during the period, e.g. [{"effective_date": "2026-07-01", "monthly_rent": 1525}]. | |
| rent_due_day | No | Day of the month rent is due, 1-28, e.g. 1 (default). | |
| landlord_name | No | Landlord or property manager name for the statement header, e.g. Oak Street Rentals LLC. | |
| other_charges | No | Charges other than rent (utilities, pet rent, repair, returned check fee) and credits (concessions). Do not include the security deposit unless the user asks. | |
| payment_order | No | How payments are applied: oldest_first (default, oldest unpaid charge first, including late fees) or rent_first (rent and other charges before late fees). | |
| payments_file | No | Optional CSV or Excel (.xlsx) list of payments with a date column and an amount column, e.g. payments-2026.csv. | |
| proration_method | No | How a partial first or last month is prorated: actual_days (default, rent / days in month), thirty_day (rent / 30), annual_365 (rent x 12 / 365). | |
| proration_rounding | No | round_total (default, round only the final amount to the cent) or daily_rate_first (round the daily rate to the cent before multiplying). |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| kind | Yes | ||
| aging | Yes | ||
| as_of | Yes | ||
| lease | Yes | ||
| months | Yes | ||
| tenant | Yes | ||
| display | Yes | ||
| summary | Yes | ||
| property | Yes | ||
| warnings | Yes | ||
| downloads | Yes | ||
| open_items | Yes | ||
| prorations | Yes | ||
| rows_total | Yes | ||
| recent_rows | Yes | ||
| months_total | Yes | ||
| payments_file | Yes |