Hello,
We currently use NetSuite Payroll.
Payroll Items in NetSuite allow one primary account for mapping. So, every time payroll processes, the paycheck transaction line detail is applied to that specific account.
After each payroll run, our finance team spends 10-20 hours per month creating many journal entries to move wages, salaries, and other expenses into the various payroll GL accounts. We use four different Payroll GL accounts to break out payroll expenses and liabilities. After the JE are entered, we can't view the transaction detail on these GL accounts.
the account hierarchy looks something like this
- XXXX Administrative - Expense
- wages
- taxes
- salaries
- bonus
- etc.
- XXXX Sales/Marketing - Expense
- XXXX Operations - COGS
- XXXX Software Development - Expense
Without creating 100's of payroll items that all map to different GL accounts, does anyone have any ideas on how we automatically have the paycheck transaction lines apply the details to multiple GL accounts based on a field located on the employee record?