Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here