I am a property manager overseeing 4 different buildings right next to each other. We are one company, so I need one set of books, but we also want to be able to see how our profits look for each building separately. So for example, we have an expense for 'trash removal' for $500. What is the best way (or is there even a way) for me to track that $300 was for building A, $100 for building B, $75 for building C and $25 for building D? My old accounting system was designed for real estate, so when I categorized a transaction, I could itemize, not just by account, but also by property.
If I use report tagging, I can only select one building at a time, so that doesn't help when a single expense is split. The only way I can think of right now is to have separate accounts for 'trash removal' at each building and itemize that way, but that means I'm going to have four of almost every line item in my account which would be very overwhelming, and makes it very tricky to pull all those reports together.
Anyone have any good ideas?