Back to blog

How to Allocate Transactions in NetSuite to Segments and Subsidiaries

Easily split expenses and items between different segments with Shared Transactions by Netgain. Simplify your P&L verification process in NetSuite today!

UI displaying the NetSuite interface and highlighting how to use Netgain's Shared Transactions.

Expenses don’t like to stay in their assigned boxes when it comes to business operations. To verify your P&L is correct, you often need to split expenses. Overhead charges need to be split out by square feet, except for when you break them out by employee headcount. The cost of a repair person needs to be split between the multiple locations they serviced.  

Allocations are a constant part of running a business, so the Shared Transactions app makes applying allocations to your transactions in NetSuite simple. 

In the past, allocations have been pieced together through the use of shared vendor bills in NetSuite, but these are no longer supported. This functionality has been recovered and enhanced through the new NetSuite-embedded app, Shared Transactions by Netgain.

Transaction allocations in NetSuite

Shared Transactions adds a one-button approach to allocating your expenses and items directly from native NetSuite bills. Using an intuitive user interface, simply enter the weights and designated segment information.  

Screenshot of the Oracle NetSuite Shared Transaction Worksheet. It shows transaction lines for overhead allocation, payroll expenses, and advertising, with allocations detailing office locations and weights. User interface elements like Save and Cancel are visible.

With this tool, it's easy to split expenses and items between different subsidiaries, departments, locations, classes, and custom segments .

How to perform an allocation

Shared Transactions by Netgain makes allocations easy.

1. Click Allocate on the bill

A screenshot of a bill management software interface displaying a bill from Alexander Valley Vineyards. The page shows options like Edit, Allocate Expenses, and Make Payment, with transaction details including number, currency, and amount.

2. Select the transaction line

A transaction lines table displaying three entries. The rows show details such as debit, credit, account numbers, allocation template, and memos. Entries include insurance expenses, equipment rental, and payroll expenses. Two boxes are checked under "Is Allocated."

3. Choose weights and allocation selections

Screenshot of an allocations table interface showing dropdown menus for selecting weight, department, class, location, and subsidiary. One entry shows 30 in the weight column for "QA Holdings Inc.: QA Ea." Options to save or cancel are on the right.


4. Click save

Screenshot of a Transaction Allocation Worksheet showing "Transaction" labeled as "Bill 10/05/2022" and "Transaction Date" as "10/05/2022." Options to "Save" or "Cancel" are at the top left.

5. See allocations on the bill

A screenshot of an allocation impact report showing transactions for equipment rental. It includes a reversal entry and two allocations, all dated 10/05/2022, with debits and credits totaling 18,000.

Flexible allocation weights

Our system computes a dynamic weighted breakout, so feel free to enter dollar amounts, the number of employees or percentages in the weighted column. We take the entered number and divide it by the total, making the math easy. The system will run the appropriate journal entry to reverse the GL impact of the original transaction line and create a new journal with the allocation. And don’t worry about intercompany subsidiary allocations, we have that covered too. 

Screenshot of an Oracle Netsuite interface displaying an Advanced Intercompany Journal entry. The screen shows Primary Information and Classification sections, and tabular data with transaction details, subsidiaries, and amounts.

Speed up your workflow with templates

One way Shared Transactions makes allocations as automatic and easy as possible is through templates. Templates allow you to set up a common allocation and then easily apply it to any or all transactions with one selection. 

You can create as many templates as desired and continue to edit them. So if you have five employees in sales and three in marketing, you can apply that template to overhead charges and easily change sales to six when you hire someone new.  

Templates can then be selected from the allocation page, which will immediately break out the selected transaction line into the designated weights and segments. Quickly override the breakout to customize the allocation from the same page.  

You can easily apply a template to an entire bill as well. Imported bills often can have hundreds of lines on them, so we added the ability to select the template from the header and have it applied to every expense.

A shared transaction worksheet displays billing details, including allocation numbers, departments, credit and debit amounts, and a memo section. The table shows entries for advertising, office expenses, and payroll expenses with different costs.

Reporting and management 

Shared Transactions is a fully embedded app, so it posts the new journal entries directly to your GL. The embedded nature of the app means no integrations or imports are needed; your allocations post and flow to all parts of your NetSuite account.  

The most important benefit of being embedded is that your NetSuite reports will be accurate and include these new journals. Easily filter between different subsidiaries and segments to see the effect of the allocations. 

The journals themselves will show in a sub-tab on the bill, making it easy to find the adjustment and understand its origin. No more fumbling through spreadsheets to understand an allocation at close or when asked by the auditors. 

Bottom Line 

Simply put, we know allocations are an everyday occurrence, so you need an everyday solution that is easy to use and track. That’s what Shared Transactions by Netgain does for your bills and, in the near future, what it will do for additional transactions as well. 

Recent Posts

See why Netgain is trusted by thousands of accounting teams

Say goodbye to your insane workload.
Say hello to fearless financials. Meet Netgain.