New member — building a lease-to-CAM reconciliation pipeline, here to learn

New Member Introductions
1wFollow

New member — building a lease-to-CAM reconciliation pipeline, here to learn

Nikita Loika
Minsk, Belarus · Member since 2026 · 16 posts · 1 vote

Hi all. Nikita, in Minsk, working US hours.

I'm building a pipeline that reads commercial leases and pulls the recovery rules — tenant share, denominator, cap type, gross-up, exclusions, admin fee, capex — each with a quote and page number, then runs the year-end CAM reconciliation against the owner's expense export.

So far I've only tested it on leases from SEC filings. The most useful thing it's taught me so far wasn't even in the leases — on one property, four amendments signed after the original lease pushed the tenant's share from 15.16% to 58.83%, and there was nothing in the original PDF that would've told you that was coming.

No clients, nothing to sell. I'm here to read the commercial and property management threads, and answer questions on caps and gross-ups with actual numbers where I can.

Question for anyone who's run a few reconciliations: what ate the most time last season — reading the leases themselves, matching GL accounts to recoverable categories, or chasing down amendments that weren't in the folder?

0Reply
252 views

9 Replies

Jump to latestLatest
  • G. Brian DavisPro Member
    Investor · Hatboro, PA · Member since 2016 · 2k+ posts · 842 votes
    1w

    I’d probably say the amendments are where the biggest issues can hide. The original lease might look straightforward, but if amendments changed the tenant’s share that much, you could be working with numbers that are no longer accurate.

    I’d want the complete lease file before doing the reconciliation, the original lease, amendments, renewals, side letters, anything that changes the tenant’s obligations. Then I’d compare that to the actual expenses and make sure the two line up.

    One missing amendment can change the numbers pretty quickly. It’s a good reminder that in commercial real estate, the numbers are only as good as the documents behind them.

    0Reply
    • Nikita Loika
      OP
      Minsk, Belarus · Member since 2026 · 16 posts · 1 vote
      1w

      Thanks, Brian — "the numbers are only as good as the documents behind them" is exactly it.

      Here's the practical bit I'm trying to get a feel for: when you actually ask an owner or seller for the complete lease file — original, amendments, renewals, side letters — how often does it show up complete on the first ask? From the public filings, my guess is that the gap between "the lease" and "the deal" is the rule, not the exception. But I'd rather hear it from someone who's actually asked for the folder.

      0Reply
  • Michael Eskenasy
    Investor · Pacific Northwest · Member since 2026 · 511 posts · 289 votes
    1w

    Amendments, by a mile.

    If the lease file isn’t complete, everything downstream can look “accurate” while still being wrong. The lease read is important, and GL mapping is tedious, but missing amendments blow up the economics because they quietly change share, caps, exclusions, admin, or gross-up logic.

    The way we look at it is: first solve for document completeness and version control, then normalize the recovery rules, then map the GL. Otherwise you can do clean reconciliation work against the wrong governing terms.

    So I think you’re aimed at the right problem. I’ve been building around property/ops intelligence, and this provenance issue shows up everywhere. Happy to connect and compare notes.

    0Reply
    • Nikita Loika
      OP
      Minsk, Belarus · Member since 2026 · 16 posts · 1 vote
      1w

      "clean reconciliation work against the wrong governing terms" nails it better than anything I'd landed on.

      The piece I'm still stuck on is your first step. With a public tenant, the later instruments show up on EDGAR; with a private owner there's no registry, and "send me everything" just gets you the lease plus whatever happened to be on top of the pile. So how do you actually establish completeness in that case — is it a checklist the owner has to sign off on, or do you infer the gaps from the documents themselves (lease references a parking license that's nowhere in the folder, that sort of thing)?

      Happy to connect.

      0Reply
  • Brad SeidBusiness Member
    Lender · Licensed in 28 States · Member since 2026 · 122 posts · 31 votes
    1w

    @Nikita Loika This is really interesting, Nikita. The amendment issue is definitely one that can get overlooked. I’ve worked with data research and document-heavy processes, so if you ever need an extra hand finding, organizing, or validating lease and amendment data, I’d be happy to help.

    [email protected]248-408-3855
    West Capital Lending5122 Reviews
    WebsiteView Page
    0Reply
    • Nikita Loika
      OP
      Minsk, Belarus · Member since 2026 · 16 posts · 1 vote
      1w

      appreciate it, Brad. on the lending side, what do you actually get in the loan file, full amendment history or just the original lease and a rent roll? that's the gap I keep hearing about

      0Reply
  • Diana Khan
    Attorney · 10451 Mill Run Cir #755 Owings Mills, MD 21117 · Member since 2024 · 305 posts · 114 votes
    1w
    Quote from @Nikita Loika:

    Hi all. Nikita, in Minsk, working US hours.

    I'm building a pipeline that reads commercial leases and pulls the recovery rules — tenant share, denominator, cap type, gross-up, exclusions, admin fee, capex — each with a quote and page number, then runs the year-end CAM reconciliation against the owner's expense export.

    So far I've only tested it on leases from SEC filings. The most useful thing it's taught me so far wasn't even in the leases — on one property, four amendments signed after the original lease pushed the tenant's share from 15.16% to 58.83%, and there was nothing in the original PDF that would've told you that was coming.

    No clients, nothing to sell. I'm here to read the commercial and property management threads, and answer questions on caps and gross-ups with actual numbers where I can.

    Question for anyone who's run a few reconciliations: what ate the most time last season — reading the leases themselves, matching GL accounts to recoverable categories, or chasing down amendments that weren't in the folder?

    @Nikita Loika, from the legal side, the biggest time drain I see is usually not reading the lease itself. It is figuring out whether you actually have the full agreement. I never assume the PDF labeled “lease” tells the whole story. I like to go through the lease and make a list of every document it refers to, such as amendments, exhibits, renewals, assignments, guaranties, side letters, parking agreements, or anything else that changes the tenant’s obligations. If something is mentioned but missing, that becomes an open item before I trust the numbers.

    I also like comparing the documents to what is actually happening with the property. If the lease says one thing, but the rent schedule, billing history, or prior reconciliations show something different, that is usually a sign there is another document or change somewhere that needs to be found.

    I’d be glad to stay connected. I like what you’re building because the real problem is often not reading the document. It is knowing whether you have all of them.

    0Reply
    • Nikita Loika
      OP
      Minsk, Belarus · Member since 2026 · 16 posts · 1 vote
      1w

      The step nobody's automating is "compare it to what's actually happening." The referenced-documents list is mechanical, a model handles that fine. But the lease says 15% and last year's reconciliation billed 22%, and nobody wrote down why — that gap is where the missing amendment lives. Do you pull the prior recon statements upfront, or only once something looks off?

      0Reply
  • Evan Polaski
    Cincinnati, OH · Member since 2020 · 4k+ posts · 3k+ votes
    1d

    I have worked in Accounts Receiveable, early in my career for a large retail owner/operator. I have also become friends with many RE admins at major companies that lease space.

    The single biggest issue is "what is reimbursable". Anything lease or amendment related is EASY, because one side always has it. If landlord is pushing for 22%, and I am tenant thinking it is only 15% and argue it, the landlord will quickly point me to the amendment with my signature on it.

    Where things get slippery is in actual expenses being pushed back. Less common, but still slippery is decommissioned space which can change the reimbursement percentages.

    0Reply
Join the conversationCreate a free account to reply, vote on answers and follow this thread.
Log InJoin for Free