Recommended CAM Expense Tracking Software or spreadsheet?
Anyone can recommend a software to calculate and track tenant CAM expenses? I'm interested to know what is being used. Thanks!
  
If there is a spreadsheet, that would be great as well.
[{"id": "idugaqm", "text": "Excel lol", "replies": [{"id": "idwf2ij", "text": "Usually see it used with an accounting software. Yardi or realpage to name a couple. I have also seen people use Kardin when not tied to the accounting software. \n\nWould likely be cheaper to hire an outsourced accountant and use their licence or a PM with a licence to Kardin or that also provides property accounting services.", "replies": [], "depth": 2}], "depth": 1}, {"id": "idv3hh9", "text": "I have a CAM spreadsheet for Triple Net leases only, no modified gross ones. \n\nI used it until we got on RELEASED software then it kept in true time.\n\nSend me a message here and I will email it to you if you want", "replies": [{"id": "idv66k4", "text": "I am looking for a modified gross lease one, but I'd love to see the spreadsheet. :) Thanks!", "replies": [{"id": "idy8dci", "text": "Do you have a forecast from the start of the year on what the expenses would be that you sent to tenants? Because if you do, and you have thier square footage so can make you one.", "replies": [{"id": "idy9s2l", "text": "I don't want to impose further upon your time so I won't request a spreadsheet created just for me. I already appreciate your time and energy enough as it is! Perhaps if I have quick questions I may ask. Thank you!", "replies": [{"id": "idypvuv", "text": "For sure!\n\nModified Gross calculates the expenses in what they already paid, based on that annual forecast ( which should be provided at the same time as the accounting true up for the year before). \n\nIf you as the land lord go over that budget, you can bill the tenants their proportionate share of the overage according to the lease. (Check it). \n\nMake sure your rents are strong and you know you dollars per square foot operating budget is.", "replies": [], "depth": 5}, {"id": "idypzyj", "text": "And most leases say if you as the land didn\u2019t spend as much as you thought you, there is no credit to tenants in modified gross leases", "replies": [], "depth": 5}], "depth": 4}], "depth": 3}], "depth": 2}, {"id": "idx1rqm", "text": "Hey would you be able to email me that CAM spreadsheet as well?", "replies": [{"id": "idy80lx", "text": "Sure send me your email address privately.", "replies": [], "depth": 3}], "depth": 2}, {"id": "iu02d90", "text": "&gt;realpage  \n&gt;  \n&gt;Hi there- I would love to see this NNN spreadsheet. I'll message you- thanks!", "replies": [], "depth": 2}], "depth": 1}, {"id": "idvnmte", "text": "What size of a portfolio?", "replies": [{"id": "idvxq2e", "text": "Thanks for your reply! One building with four tenants.", "replies": [{"id": "idvydah", "text": "Most software will end up costing you more than just calculating it in excel for that size of a portfolio.  Is this a ground up? Anything from previous owners? How\u2019d you calculate the estimates?\n\nIs it 100% leased or do you have to worry about gross ups? Are they all in the same form lease (ie same structure) and do they call out pro rata share?\n\nIf it\u2019s MG leases at a 100% leases building, CAMs estimates and recs should be cake in excel", "replies": [{"id": "idvz36j", "text": "Previous owners used a property management company track the expenses. (The property is actually two buildings, but only one building has shared tenants.)\n\n As such, I wanted to take over and do the CAM estimates/billing/reconciliation myself, but was looking for software that might be commonly used for tracking.\n\nIt is not 100% leased. Pro rata share is called out on the leases.", "replies": [{"id": "idvzfup", "text": "Appfolio May have a module, but not sure. Have used Karden in the past. Currently in the Yardi web and not getting out anytime soon. \n\nOn a side note, you should be able to ask for PY cam calcs as part of the transaction handover.", "replies": [{"id": "idw08us", "text": "Thanks for those names. I'll check them out. I know most programs are online with subscriptions these days, though I wish there was something like Quicken for commercial property that can track CAM expenses.\n\nWhat does PY stand for? \n\nAppreciate your posts!", "replies": [], "depth": 6}, {"id": "ie49oph", "text": "How much were you paying for Karden?", "replies": [{"id": "iee8cqm", "text": "I remember a couple grand for set up and I think it was a couple K each license. Been awhile though", "replies": [], "depth": 7}], "depth": 6}], "depth": 5}], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "ie4c1iq", "text": "If you follow some general principles - CAM charges are fairly easy to calculate/estimate.\n\nIn your case - there are only 4 tenants, so it's not a complicated property.\n\nI have always used the following approach every time when I took over a property :\n\nSTEP 1:\n\n1) Look at each list individually\n\n2) For each tenant - create a simple checklist with the services that the landlord has to provide as part of the lease (ex: insurance, property taxes, hvac etc.)\n\nSAMPLE\n\n|Expense /Service|LANDLORD to provide|Tenant responsibility|\n|:-|:-|:-|\n|Insurance| YES||\n|Taxes|YES||\n|HVAC||YES|\n|Landscaping|YES||\n\n3) Consolidate all these tables in one file for all the tenants - this will give you the foundation of your CAM charges\n\n&amp;#x200B;\n\nSTEP 2:\n\nNow you have all the information to create your CAM charges /estimates.\n\nA simple excel file would have the following columns:\n\n1) GLs (Expenses)\n\n2) Budget amount for each GL line item\n\n3) Tenant 1 - list all the budgeted amounts for each GL based on the list created at STEP 1\n\n4) Tenant 2 - same as above\n\n5) Tenant 3 - same as above\n\n6) Tenant 4 - same as above\n\n8) For each tenant - add all the lines/expenses and then multiply them by % expense ratio (rented area/ total GLA)\n\n&amp;#x200B;\n\nIf you have multiple tenants you would have to use some cost templates based on the leases from STEP 1\n\nA software is good but it's always better to understand how things work in practice.\n\nOnce you have created the file if you need - PM me and I can review it.", "replies": [], "depth": 1}]