# Rent roll to bank reconciliation

> Rent roll to bank reconciliation: Which receipts pay which tenant's rent Checked: proven by code. Produces arrears, unapplied cash.

Source: https://www.sumarity.ai/library/rent-roll-to-bank-reconciliation/

Real estate 

# Rent roll to bank reconciliation

Reads rent roll, bank receipts. Produces arrears, unapplied cash. Code works out every figure, the Judgement Engine answers the narrow questions, and whatever stays uncertain goes to a person.

Proven by codeReconciliation and matching
Start from this workflowMore for real estate  

What it decides

## Narrow questions, each with a check behind it.

Which receipts pay which tenant's rent
Proven by code. Code proves the answer from the data itself: totals tie, a match is exact, the quote is on the document. Most of these judgements settle without a person.

| Reads | Rent roll, bank receipts 
| Produces | Arrears, unapplied cash 
| Who signs | A person on your team, with every figure traced to its document and every call on record 
| Process | Reconciliation and matching 
| Industry | Real estate    

See it run

## Every line, decided where it's safest.

An example run. Each stage lights up as a line is decided there; pick a stage to see its lines.

ReadsRent roll, bank receiptsCodeReads, matches, ties out and works out every figure.JudgementWhich receipts pay which tenant's rent. Settles only when it clears the cutoff and code proves it.A personGets whatever stays uncertain, with the evidence. Their ruling tunes the next run.ProducesArrears, unapplied cash  
Rent roll to bank reconciliation · example run Example run  

| Date | Receipt | Amount | Decided by  
| 01.09 | MUELLER RENT SEPTTenant and amount match the rent roll | 2,400.00 | Code · matched 
| 01.09 | KELLER AGPays two units · 0.94 · total matches | 7,800.00 | Engine · proven 
| 02.09 | RENTNo tenant name | 1,950.00 | To a person 
| 03.09 | SCHMID PARTIALShort by 300: arrears | 1,800.00 | Code · arrears 
| 05.09 | DEPOSIT TOP-UPDeposit, not rent · 0.92 | 600.00 | Engine · proven  
|  

Settled 4 To a person 1 Settled wrong 0      Illustrative lines. Amber rows are the Judgement Engine's calls; each settles only above its cutoff and when its check agrees.    

What it could save

## Your volumes in. Your hours out.

In our tests, between 24% and 42% of items still went to a person after tuning. Set your own share; a pilot measures it on your data.

Items per run 
Runs per month 
Minutes per item by hand 
Cost per hour

Share of items that still need a person: 30%  

By hand today80 ha month 
With Sumarity24 ha month, for the items people decide 
Saved56 hCHF 53,760 a year    

Related

## Start from what's closest.

### Reconciliation and matching in other work

Finance

### Bank reconciliation

Which ledger entry a bank line is; why a line is unmatched

Proven by codeTestedFinance

### Card and payment-processor settlement reconciliation

Which sales a payout covers; fee and chargeback lines

Proven by codeFinance

### Intercompany reconciliation

Which entries are the two sides of one transaction

Proven by code

### More for real estate

### Lease abstraction

Terms from the lease: rent, breaks, reviews

Proven by code

### Service charge (CAM) reconciliation

Costs recoverable and apportioned

Proven by code

### Tenant referencing

Income and references sufficient

Cross-checked  

Questions

## What buyers ask

What happens when Sumarity isn't sure?

Nothing settles below the cutoff, or when the check disagrees. The item goes to a person in the inbox with what the engine saw, its best answer and the runner-up. The person's ruling is kept and tunes the next run.

How are its judgements checked?

Code proves the answer from the data itself: totals tie, a match is exact, the quote is on the document. Most of these judgements settle without a person.

Can we change it to fit how we work?

Yes. Start from this workflow and describe your differences in plain words. The design assistant revises it, the validator checks it, your expert reviews it on the canvas, and your admin publishes it.

Does it read our files as they are?

Yes: spreadsheets and CSV in any layout, PDFs, bank formats and e-mail attachments. Sumarity suggests how each column maps, proves the mapping on a sample and remembers it once a person confirms it.

Where does our data go?

Sumarity runs in Zurich. Your data, backups and logs are stored in Switzerland.

How does it get better?

Your team's rulings become an answer key. Better questions and cutoffs are proposed, tested on data they haven't seen, and published only when your admin approves. It improves itself, with permission.

## Start from this workflow. Run it on your data.

A pilot runs alongside your own process for a few weeks, at our cost, and ends in a line-by-line comparison.

Talk to usBack to the library