Any best practice on Bank Accounts that are shared...
# accounting
a
Any best practice on Bank Accounts that are shared by subsidiaries given that NetSuite will not allow this?
k
I've accomplished this in an account before. It was painful
Granted, part of the pain was the fact that 1) not all vendors were available to all subs 2) they used an AP integration
If neither of those are true - then I'm just doing ICJE's to move the values to whatever sub the bank account belongs to.
a
okay, that sounds fair. It may be a none issue here but want to know if the alternative is 1) possible but not pleasant or 2) not possible, don't even consider this route
Curious, what was the broad process you used to make a bank account type work between subs?
k
We created a "payables" subsidiary. Then the bills were recorded in that subsidiary. We used the "Shared Vendor BIll" functionality with 100% allocations to the sub it belonged in. We had to have some scripts written to make the GL legible/understandable to folks who didn't have access to subs other than the one they operated out of.
The bank account belong to the AP subsidiary.
They were using AvidXchange.
Learned quite a bit from it, while it was painful to get set up, I'd probably be willing to go that path again if there was enough benefit to the client.
We had to use some M/R scripts to handle aspects of it.
I mean, easy answer is to say "is there any way you can't split up banking between subs? because man, it makes life much easier mentally
a
Ha right, certainly seems like a better alternative but good to know it has been done. They are also using AP integration so that is a good consideration
a
we just solutioned this recently - in our case, every vendor could be in every sub, and there are some legal requirements where bills have to be entered in the actual recipient subsidiary. what we did was create dummy bank accounts representing e.g. "Dummy SUB2 account for Primary Bank 1", where the Bank 1 is in one sub and Sub2 is where we need to receive the bill. Repeat x every combination of subsidiary and bank account. Then the user pays the bill in the Sub2 using the dummy bank account, and upon creation of a payment with a dummy bank account, a script creates an ICJE to move it out of that dummy bank account and into A/P in the sub with the primary bank account. If you don't use electronic bank payments then at this point you could also have the script create a bill payment record where it pays using the actual bank account to clear out the A/P now at the other sub. since we're using EBP we left it there and the user has to either create a standard payment or the electronic bank payment process to create a payment from the main bank account.
a
Good insight, appreciate the response!