Property Books and rent

Properties and rent

If a company owns rentals, switch on property tracking and a Properties area appears beside its books: the portfolio, the tenants, the rent, and the paper trail, all riding the same ledger as everything else. No second system. Choosing the rental property chart when you set up the books switches it on for you.

The Registry

One row per property: address, the name your manager's statement uses, class, management fee, manager, occupancy and status. Search by anything, filter by manager or occupancy, and stack attribute filters ("pool, in an HOA, at least 1,200 sf"). Each property's profile carries its parcel number, key dates, valuations, financing, and the recurring obligations you expect to pay (water, trash, HOA, insurance), so a missing bill is noticed, not discovered.

Each property carries a class, so its rent and its costs stand apart on the reports. Leave the class empty on a new property and one with the property's name is made for you when you save (or the class of that name is linked, if it exists). Rent invoices carry it on every line and name the property in their memo; tag a repair bill with it to put the cost on the same property.

The setup for statements from a property manager sits folded at the top of the Registry: open it only if a manager collects the rent and sends you a monthly statement to post.

Leases and tenants

The Rent tab is the working board: every tenancy with its scheduled rent, deposits held, and what needs attention next. A lease holds the schedule (rent, recurring extras), the tenant contact, and its deposit history. Nothing about a lease is mandatory, so a half-known tenancy can be recorded today and completed as you learn more. A new tenant typed into the lease is added to Contacts as a Tenant. A deposit is held in a liability account (the chart's tenant deposit account is chosen for you; Accounts Payable and card accounts are not offered).

Rent, two ways

  • You collect the rent: the charge engine turns each lease's schedule into that month's invoices, on time, with a permanent record per charge. Auto-invoicing is per tenant's choice; months that need a decision wait in a queue instead of guessing.
  • A manager collects for you: kBooks watches instead of billing. Mark who is behind, record notices, and track each case; the manager's statements reconcile against what the books expect, and the owed management fee (a percent of rent or a flat monthly amount) is checked against what was actually taken. Rent, late fees and prepaid rent count as one rent figure for the month, and the fee is priced on all of it.

Deposits, move-outs and notices

Deposits are real accounting: received into a held liability, applied to the final month or itemized at move-out, with the itemization doubling as the letter you send. Once a deposit is received its amount, date and holding account stay fixed (void the receipt and record it again to change them), and voiding a last month's rent payment gives the deposit back as held. The days you have to return a deposit after move-out come from your state's rule (Rentals setup, Notice periods), with the law it comes from. "Your state" is the state the property sits in: give a property its own State in the property window when it differs from the company's (a Nevada company with a California rental), and every rule for it follows that state; where no rule for your state is on file yet, Coming up says so and you can add one. Notice periods and eviction steps follow your state's rules for the tenancy (including assistance programmes with their own longer notices), and the Coming up tab surfaces every deadline while it can still be met.

A state's limit on late fees is a rule too (Late fee limit: the fewest grace days, and a cap as a percent of rent or in dollars). When a late fee is proposed, it waits at least the state's grace and is held to its cap, and the proposal says so. Nevada's limit is on file (no fee until 3 days after rent is due, at most 5% of the rent); add your state's if it is not.

Reading your manager's statement, and mapping rules

Upload the monthly statement your manager sends and kBooks reads it, proves it against the totals printed on its own last page, and drafts the entries. Each line has to land in one of YOUR accounts, and a mapping rule is what decides which one.

A rule has two halves:

  • What it matches. The words on your manager's statement, not anything from your books. The one that does most of the work is the manager's category: the statement has a single Description column, and each line starts with the manager's own account for it, then a dash, then what they typed ("Parts - Smoke Detectors"). The part before the first dash is the manager's category, so Manager's category is exactly Parts catches every line they filed under Parts, whatever the details say, while Description tests the whole text, details included. A line with no dash is all category, and a leading "tenant:" or "Maintenance:" is dropped, so "Maintenance: Parts" is Parts too. The rule window takes the line you opened it from apart the same way, so you can see which part is which. You can also match on the payee, the reference or check number, and the type, and combine conditions with all or any.
  • Where it posts. The account in your books that matching lines go to, shown with its full path so "Maintenance:Parts" is plainly the Parts account underneath Maintenance.

One condition can accept several values. Pick contains any of (or is any of) and the box turns into a list you add to: Manager's category is exactly Repair AND Payee contains any of Gary Elmore or Ricardo Franco is one rule, and either name satisfies it. The negative versions read the way you would say them out loud: contains none of wants neither. This is how you say "these two vendors, for this category" without writing the rule twice.

Brackets, when one rule needs an "either". Press Add a bracket ( ) and you get a group with its own All / Any, drawn inside real parentheses. That is how you write a rule that is otherwise impossible:

Payee contains Oasis AND ( Manager's category is exactly Commissions Paid OR Description contains Lease Fee )

The All / Any at the top combines the top-level entries; each bracket carries its own. The sentence under the rule always reads back with its brackets, so what you built is what you can check.

Type each value in full and press Enter. A name with spaces goes in exactly as it is written - no quotation marks, no commas, nothing to separate them yourself. Each one becomes its own chip, and the x on a chip removes it. The difference between contains and contains any of is only how many values it will accept: one, or as many as you add. The ? beside the operator explains all eight with an example.

To change where a rule posts, click Edit rule beside a line and pick a different account under Posts to. Changing a rule only affects the next statement kBooks reads; entries already posted stay exactly as they are. If you would rather fix one line without touching the rule, change its account on the line itself and choose Save entry only.

A green "Rule set" chip means a rule claimed that line. If instead you see an amber Rule did not fit, a rule exists for that category but its other conditions do not match this particular line - a different payee, say - so it left the line alone and the account is still yours to pick. Open it and the rule window ticks off which conditions fit and which did not, and says what this line has instead. A blue Apply this rule button means the rule fits but was made after these entries were generated, so nothing was filled in yet: press it and the account the rule posts to drops into the line. The button goes away once the line has an account.

No account fits? Make one without leaving the page. Type the name you want into the account box and pick Add account at the bottom of the list. It joins your chart straight away, on the right side of the books for that line (an expense on money going out, income on money coming in), and the line is filled in with it. The same Add account sits in the rule window's Posts to picker.

One condition, several names. When a rule already tests a field and you press the suggestion chip for that same field, the value joins the existing condition rather than adding a second one. That matters: two separate Payee conditions under all could never both be true, so the rule would quietly match nothing. Adding to the list is what you meant.

A property will not post while any of its lines has no account. The Post button stays greyed with a note saying how many are still waiting, because a half-mapped property is not something to post and find out about later.

Posted, and matching the statement

With every property collapsed, each one still says where it stands: a blue to post chip with a count while this statement's entries for it are waiting, and a green Posted chip once they are all in your books.

On the right, Books is the property's balance in your books next to the statement's ending. Both are read at the statement's own date, so an entry you make after it, such as the owner distribution at month end, does not make a matching property read "off". That later amount sits beside the comparison in a grey chip with the date it starts from ("-$813.00 after 09/24"), and the Statements vs books card shows the same total as "Entered after", until the next statement brings it in.

Who paid rent this month

When a statement is uploaded, the property list under By property also shows how the month's rent came in, read straight off the statement. A band above the properties sums it up: how much rent was collected against what the properties usually bring in, and a count for each kind of property. Click a count to show only those properties; click it again for all. The counts belong to the series on screen, so picking another series starts them fresh, and a count you picked always stays visible while it is on, even when no property has it.

Each property carries its own chip:

  • Rent with the amount, green: the month is paid, at least the property's usual rent. A small sparkle means it arrived early, before the month began.
  • Partial, amber: some rent came in, but less than usual.
  • Behind, orange: nothing for this month, but the tenant paid toward an earlier month during it. Someone lives there and is catching up.
  • Not in yet, blue: last month was paid and this month's has not arrived by the statement's date. It may simply come later in the month.
  • Last paid, red, with the day the tenant last paid anything, how much, and the months it covered ("Last paid Aug 5 - $1,300 for May, Jun"): nothing has come in for this month or the ones before it, so the unit may be empty, or the tenant stopped paying. Hover the chip for the months still unpaid.

A payment counts for the month the statement says it pays, so rent paid on the 28th for next month counts for next month. A payment that names no month counts for the month it was paid in, unless that month was already paid, in which case a payment in its last days is taken as next month's rent paid early. "Usual rent" is the property's own recent months, so a change of rent needs no setting anywhere.

A new tenant sets a new rent. The statement names who paid each rent. When the rent starts coming from a new name and the previous payers never pay again, that is a new tenant, so the usual rent starts over: their first rent reads New rent (never "Partial" against the last tenant's rent), and from then on only their own months count. A tenant who skips months and then catches up is the same name, so it still reads behind or partial; roommates who take turns paying are one tenancy. A move-in month is often prorated or carries extras, so once the new tenant has two more months it no longer counts toward the usual rent. Hover the chip to see when the new tenant started and what the last tenant paid.

Beside the chip, in violet, is what came in on this statement since the previous one, whatever month it paid for: Rent (prepaid rent included) and Reimb. for reimbursements such as utilities, repairs, parts and the eviction fees a tenant pays back, plus Late fees when there were any, and Other fees (application or lease fees) on the rare statement that has them. The chip answers "is this month paid"; the violet figures answer "what did they actually pay since last time", so an underpayment or a tenant catching up on older months shows even when the month itself reads paid or behind. The band totals the same figures for the whole list, and the hover lists the reimbursements by kind. Deposits received are shown in the hover only, since they pay nothing off.

Hover a chip to see twelve months of rent for the property as bars, green for a full month, amber for a short one, and a stub for a month with nothing, with the payments behind this month's figure listed below. The printed and downloaded property list carries the same words on a line of its own for each property.

Owner statements

For any property or the whole portfolio, generate an owner statement: the money by property, the rent roll, what is outstanding and what is held. Print it or save it as PDF for partners, lenders or your own records.