Create CAM Reconciliation Reports in Seconds

The exact repairs and maintenance costs are difficult to calculate ahead of time. Common Area Maintenance (CAM) charges are estimated at the beginning of the year and divided into monthly payments for each tenant. Actual CAM charges are calculated at year-end—if the total is more than the tenant paid, the tenant pays the difference. If the total is less, the landlord is responsible for reimbursing the tenant for the difference. 

CAM charges cover the cost of maintaining or repairing common areas shared by commercial tenants. This may include:

• Costs of cleaning lobbies, bathrooms, elevators, etc.
• Landscaping
• Snow removal
• Parking lot repairs and maintenance
• Security systems
• Trash pickup
• Other repairs, maintenance, or janitorial needs in common areas

The CAM reconciliation process starts with identifying the costs associated with your common area maintenance and separating overhead costs from your recovery costs. For example, utility expenses are an overhead expense. While the tenant isn’t responsible for covering the costs directly, the owner/manager should be reimbursed or able to recover those specific expenses from the tenant.

STRATAFOLIO connects to QuickBooks to map your expenses and see how each reimbursable expense tracks against every tenant’s actual expenses. When it’s time to do CAM reconciliations at the end of the year, you can quickly and easily pull a report and share it with your client to recover expenses.

STRATAFOLIO is an online web-based, secure, mobile-friendly software application service made for people who own, manage or lease real estate and use QuickBooks Online or QuickBooks Desktop as their accounting software.

Yes. STRATAFOLIO currently integrates with both QuickBooks Online and QuickBooks Desktop. If you have another integration from another accounting system you would like us to consider, please send us an email so we can add you to our waiting list of future integrations.

Yes and no. Currently, STRATAFOLIO is not set up to do this without some modification. You can use the CAP feature and modify it on the report to make it a base year instead. We would be happy to show you how during Onboarding.

Every lease agreement outlines specific terms for these expenses, but typically, CAM expenses are based on the tenant’s pro-rata share. The CAM Reconciliation Report pulls in the actual amounts from your QuickBooks company file for each expense the tenant owes a share of. We then present this information to you with the share for those tenants. Once you verify the amount they paid for the year, you can easily true-up with the tenant for the year.

We set up your CAM Reconciliation Reports to match what you have already given to your tenants. If you would like, during the Onboarding process, we will review the report and suggest ways to make it more complete or easier for the tenant to understand.

No. We only display all of the transactions and reports on a cash basis across the entire platform.

Yes! We can add CAPs for each CAM subcategory per lease you have set up. We can add a percentage for year-to-year, a percentage over a given amount, a percentage up to a given amount, or a variation of ways. This calculates from year to year, so it is only entered once, and then you’re finished!

Yes! The CAM Reconciliation Report is designed to show the pro-rata share of the tenant based on the rentable square footage of the building.

Yes. We have added additional details so you can find the percentage of the Asset or Entity as well if needed. There are many ways to set this up depending on the structure of your QuickBooks and your portfolio.