Does Netsuite have an elegant way to handle elimin...
# accounting
j
Does Netsuite have an elegant way to handle elimination within the same subsidiary? I've got revenue + expense transactions being coded intra-department. I need to reverese these out for stat reporting - All the elimination reading i've done expects the internal transactions are intra-subsidiary. I've thought abut creating an elimination department, or alternatively using the elimination subsidiary to record the intra-department reversals manually. Can anyone point me in the right direction?
m
These intra-department transactions should not appear in your financial reports at subsidiary level and/or consolidated level?
k
this must be a manual process, NS is not designed to accomodate it
l
We have the same issue. Can I use an adjustment book to record the intrasubsidiary transactions, so when I run the primary book excluding the adjustment book, it won't include these intrasubsidiary transactions?
k
@Luis but if you think they are there, the transactions it is. Meaning all you do is shovel money from one pocket to another but money does not disappear, right? it only impacts you when you use this money to buy something. it is possible to do at the sub level because of the elim journal, but not possible in other manner, at least, not within NS
j
@Marc - they need to be removed for consolidated level; ie. Dr Expense | Dept 1 | subsid 1 Cr Revenue | Dept 2 | subsid 1 For consolidated i need to back out the expense and revenue between the two departments also operating within the same subsidiary.
@Karina - thanks for your input. Have you done this in the past? Any insight wheather i'm going to break things or cause future headaches if i manually adjust via the elimination subsidiaries? Thinking about having a contra transaction for each flagged internal transaction: ie. Dr Expense | Dept 1 | subsid 1 Cr Revenue | Dept 2 | subsid 1 Dr Revenue | Dept 2 | Elim Subsid Cr Expense | Dept 1 | Elim Subsid
k
@Jono - I advise my clients not to do it and I do not do it either. I am not sure of the purpose of this activity, seems unnecessary from my 50,000 feet.
👍 1
m
@Jono ok if you need to create an elimination journal entries , create a script to automate that if you use such accounts with such segment ( for i.e) the script create an elimination JE that will link via a custom field