cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Robert-Peter
Level 1

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

1 Comment 1
jamesjdt
Moderator

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?

Hi, Rob. You can use the Class tracking feature and set it to One to each row in transaction. This allows you to split a single expense across multiple classes (individuals). You can refer to these articles for steps on how to enable and set up the feature: 

 

 

 

When recording an expense, you can use the same category multiple times while assigning different classes. Please see the screenshot below for an example.

 

 

This also applies when handling bank transactions in the Bank transactions page. You can split a single transaction across the same category while assigning multiple classes. Click the bank transaction and select the Split button. You can then apply the same approach as you would with an expense transaction. Just make sure the Difference equals R0.00. An example is shown below.

 

 

This approach is more efficient, reduces errors, and prevents duplicate transactions in your register. It also makes reconciliation easier, as it aligns with your bank statement.

 

Please keep us posted on your situation so we can further assist you. We’re happy to help.