Need separate P&L for two people. Tags/Classes fail—shared costs are duplicated. Any way to split expenses (e.g. 50/50) without manual entries?
Dear QuickBooks experts, I am currently facing a challenge with generating separate Profit & Loss reports for two individuals within the same company - the two owners. Our goal is to allocate income and expenses clearly to each person and run individual P&L reports. To achieve this, we have tried using both Classes and Tags, but unfortunately, neither approach works as expected—especially when it comes to shared costs. The main issue is the following: - When using Tags, assigning multiple tags to a transaction results in the full amount being reflected for both individuals, rather than being split proportionally. - "Classes" also do not provide a straightforward solution, particularly when handling shared expenses from bank feeds. Typical examples of shared costs include: * Monthly bank fees * QuickBooks subscription costs * General overhead expenses applicable to both individuals At the moment, the only way to achieve correct allocation is to manually split each transaction into two separate entries, assigning each portion individually. This approach is time-consuming and error-prone. Our questions: 1. Is there a recommended or built-in way in QuickBooks to split a single expense across multiple individuals (e.g. 50/50) while maintaining accurate P&L reporting? 2. Are there any best practices, features, or settings (e.g. improvements in Classes, Tags, Projects, or other tracking methods) that support this use case? 3. Is there a more efficient way to handle shared costs without duplicating transactions manually? We would greatly appreciate your guidance on how to handle this scenario in a scalable and maintainable way. Thank you very much for your support. Kind regards, Rob