Best way to map and track out CAM charges without software?
We don't have software that tracks our CAM and tenants yet, so we are working a bit old school on this - Excel. I am looking for ideas of the best ways to track CAM charges with several different tenants and each tenant having a little different allowable charges. 

My initial thinking is to create general expense categories for the charges. From there, just go through each tenant and note how each category applies to that lease. Any suggestions?
[{"id": "i9xkhlr", "text": "Take the CAM of the entire building. \n\nAllocate such CAM proportionally to your tenants.", "replies": [], "depth": 1}, {"id": "i9xyjtu", "text": "Excel is fine for this. Start with all your expenses in detail, row by row. Then in separate columns afterwards adjust as necessary for each tenants cost pool. Then in separate tabs, take their pool times their prs, deduct amounts paid, format some, and boom you got a cam statement.", "replies": [{"id": "ia0cw6h", "text": "This right here. In terms of matching up with lease expense language I would not bother. The more clean and simple the statement is the less hassle for tenants and landlords. If there is a major dispute the tenant will likely point it and and then you can adjust from there.", "replies": [{"id": "ia0ejei", "text": "I disagree with intentionally not lining up with the lease language. Don\u2019t be that kind of landlord, treat your tenants right and do right by them.", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "i9yo0r2", "text": "Definitely excel, Pm me if you need any help", "replies": [], "depth": 1}, {"id": "ia4l6n0", "text": "In case it helps I wrote a web app to do this personally as I was trying to track this for one of our strip centers where a tenant would ask for proof every year during reconciliation. Feel free to dm If you want to see what it looks like.", "replies": [], "depth": 1}, {"id": "ibtqmim", "text": "1) First step before creating charges is to look at the leases and see how many types of leases do you have (are all the tenants paying for the same CAM expenses?)\n\n2) Create a budget - multiple GLs\n\n3) Allocate the cost based on the sq.ft. or the usage (if you have tenants who will have a higher usage of resources - for example water/electricity etc.)\n\nIf you need any help send me your excel file and I will take a look.\n\nI used to manage/oversee few million sq.ft. of properties.", "replies": [], "depth": 1}]