Commercial Utility & CAM splits + receipt attachment

João Barquinha · 2026-04-19T11:43:49-07:00

Hey everyone, I help manage a few small commercial retail plazas. Doing the monthly pro-rata utility and CAM bill-backs is draining my soul, and I'm trying to figure out if there's a better way to do this. The pro-rata math in Excel is annoying, but the real time-suck is the "proof". My commercial tenants are super nitpicky and demand to see the original city bills so they know they aren't being overcharged. My current workflow is: 1) Calculate the splits in Excel, 2) Generate the individual PDF invoices, 3) Manually stitch/combine the original city water/trash PDFs to the back of every single tenant invoice so they have the proof. It takes hours every month. Migrating our entire accounting setup to a massive ERP like AppFolio or Yardi just to fix this chore is an overkill for our size and budget. Is there a lightweight tool out there that does the math and stitches the receipts together? Would love to hear how you guys optimize this workflow.

Michael K GallagherBusiness Member

Real Estate Agent · Columbus OH · Member since 2018 · 1k+ posts · 1k+ votes

6mo

It sounds like you are splitting month by month the utilities between tenants is that correct? Generally my experience with retail/retail leases is that the tenants generally are responsible for their own untilties to the suite, ie there is a separate meter for each suite, and that there is an annual per sf estimated cost for CAM and that the TT can audit these charges, but generally I've seen it work similar to an escrow account where the TT is paying an estimate and at so many intervals throughout the year or even only annually the charges are "validated" and the PSF payment is adjusted for the next period accordingly.

My point being if you are also splitting utilities, in this way I can see your struggle. Candidly I think the expectation that each specific bill is split precisely each month is a bit much. I'd rather have a quarterly reconciliation or even semi annually, and work off historical data to set the initial rate.

I obviously dont know your location laws or regulations or what is in your leases, but that's what I'd work towards along with separate meters if not already in place.

[email protected]614-362-2231

1 Reply

João Barquinha
OP
Member since 2026 · 2 posts · 2 votes
6mo
Quote from @Michael K Gallagher:

It sounds like you are splitting month by month the utilities between tenants is that correct? Generally my experience with retail/retail leases is that the tenants generally are responsible for their own untilties to the suite, ie there is a separate meter for each suite, and that there is an annual per sf estimated cost for CAM and that the TT can audit these charges, but generally I've seen it work similar to an escrow account where the TT is paying an estimate and at so many intervals throughout the year or even only annually the charges are "validated" and the PSF payment is adjusted for the next period accordingly.
My point being if you are also splitting utilities, in this way I can see your struggle. Candidly I think the expectation that each specific bill is split precisely each month is a bit much. I'd rather have a quarterly reconciliation or even semi annually, and work off historical data to set the initial rate.
I obviously dont know your location laws or regulations or what is in your leases, but that's what I'd work towards along with separate meters if not already in place.
Thanks for the insight Michael! That makes total sense for suite-specific meters. I’m finding that even with separate meters, the 'House' utilities (parking lights, irrigation, trash) are still a manual Excel nightmare for the managers I'm talking to.
If a tool could automate that 'shared' split and instantly staple the original bill as proof so tenants don't push back, do you think that would make the 'monthly struggle' worth it for the cash flow, or is the quarterly/annual estimate still the industry standard for a reason?
0 Reply

J CastroBusiness Member

Lender · Florida · Member since 2025 · 750 posts · 265 votes

5mo

Hi João Barquinha, welcome to BP!
You’re not alone — this is one of the most time-consuming parts of managing smaller retail assets.

At your scale, the pain point is exactly that you’re bridging Excel and enterprise systems. Most people either:

stay in Excel but use a simple document automation tool to auto-attach the backup PDFs, or
move to a lightweight CAM-focused platform that handles both allocation + tenant reporting without going full Yardi/AppFolio.

The big unlock is separating the math from the documentation so you’re not manually rebuilding tenant packets every month. Best of luck!

JCREIG Capital Funding

Website View Page

0 Reply

Ryan Stomel

Property Manager · Calabasas, CA · Member since 2026 · 141 posts · 67 votes

5mo

Handling a CAM dispute well comes down to documentation discipline more than anything else. When you send the year-end reconciliation, your tenant has a finite window (usually 90-180 days depending on the lease) to dispute or request an audit, so the trail you build during the year is what determines whether the dispute gets resolved or escalates. A few things I've learned managing NNN retail: 1. Keep CAM-eligible expenses in their own GL accounts in your accounting system. Don't lump them with non-CAM operating expenses. When a tenant requests backup, you want to hand over a clean expense register that maps directly to the CAM definition in the lease, not an extracted subset of a larger ledger. 2. Memorialize allocation methodology in writing each year. If you allocate CAM by leasable square footage, document the building's total RSF and each tenant's pro-rata share at the start of the lease year. If RSF changes mid-year (vacancy, build-out), document the methodology for handling that. Disputes often turn on whether the allocation was applied consistently. 3. Cap items separately. A lot of CAM caps run on a per-category basis — controllable expenses are capped, non-controllable (taxes, insurance, snow) often aren't. Make sure your reconciliation breaks out controllable vs non-controllable explicitly. 4. Don't try to recover prior-year underbillings without legal review. The lease usually has a lookback limit (often the same 90-180 days that runs against the tenant). If you missed including an expense last year, your right to bill it now may already be gone. Most CAM disputes I've seen escalate from operational sloppiness, not bad faith. Tighten the documentation upstream and most reconciliations go through clean.

0 Reply

Simon W.Business Member

Real Estate Consultant · Lehigh Valley PA & New York City · Member since 2013 · 1k+ posts · 685 votes

5mo

Oh how I remember the pain of doing CAM recs for multiple commercial plazas from strip malls to big malls.

The best way to do all of this is in excel and read every lease and understand how the CAM expenses are being allocated. Honestly, it doesn't matter how perfect you try to make it. Multiple times I tried to tell my old boss that it doesn't matter if I make it perfect, tenants will always come back and fight it. I was 1000% right. Always comes back and tenants argue and the company will give in.

Also Retail tenants will have their own "auditor" when the time comes.

I was using Yardi Voyager 7s at the time when working on CAM, but I always end up using Excel because you can customize it more and once finalized, you just manually enter them in the system.

Unfortunately, there really isn't any easier way to do this.

Just be happy that this is one of the most painstaking work in real estate accounting but great on the resume.

Accounting Properties LLC

View Page

CFO LLC

View Page

0 Reply

Nyron Isaac

Member since 2024 · 144 posts · 28 votes

4mo

Your frustration is completely justified—forcing a QuickBooks-and-Excel stack to handle commercial CAM reconciliations and RUBS utility bill-backs is an absolute drain on capital velocity. Mainstream residential apps like AppFolio or Buildium are completely broken for this workflow because they lack the underlying multi-variable contract logic needed to automate pro-rata expense recoveries.

Stop manually stitching PDFs; check out PigJet. It was built specifically for this small-to-midsize commercial segment. The platform natively handles your pro-rata math by linking tenant square footage to your global bills. You simply upload the city water or trash PDF, and the software automatically calculates the tenant splits, generates the individual invoices, and natively appends the original city bills to the back of every single digital tenant ledger packet automatically.

Remember, if your manual Excel workflow causes you to miss or under-recover just $500 a month in CAM bill-backs, you are leaking $6,000 in annual Net Operating Income (NOI). In a local 7.5% retail cap rate market, that small administrative leakage actively costs you $80,000 in forced property equity value. Moving onto a streamlined commercial platform protects your time, silences nitpicky tenants with transparent digital audit logs, and instantly maximizes the value of your commercial real estate portfolio.

0 Reply

Daniel Clas

Specialist · San Francisco, CA · Member since 2025 · 8 posts · 2 votes

2mo

The "proof" part is the real killer, not the math. I build property management software and this exact loop comes up constantly for small commercial shops: split the bill, generate the invoice, then manually staple the original city PDFs to the back of every tenant invoice.

To Michael's point, if your leases let you move to estimated CAM with a periodic true-up instead of splitting the exact bill every month, that alone removes most of the monthly grind. The tenants who want to audit will still audit, but you're doing it once a quarter or once a year instead of monthly.

On Simon's "no easier way" point, there's a reason for it. City water and trash bills basically don't exist as data anywhere. There's no API for municipal water. So every tool either makes you switch your whole accounting setup (the AppFolio or Yardi problem you mentioned) or skips the receipt stitching entirely. The gap is real.

Joao, out of curiosity, are your tenants on NNN leases where they just audit CAM, or are you splitting metered utilities unit by unit? That changes which of these is worth doing.

0 Reply

Commercial Utility & CAM splits + receipt attachment

Commercial Utility & CAM splits + receipt attachment

Most Popular Reply

8 Replies