Best Practice for Representative Payee Accounting in NetSuite (Pooled Bank Account with Individual Client Balances)
I’m an AP Analyst at human services company that provides Representative Payee services for Social Security beneficiaries. Our accounting workflow doesn’t fit a typical AR or AP process, and we’re trying to determine the best-practice NetSuite design.
**Our process**
\* We have one pooled bank account that receives Social Security deposits for many clients.
\* The money belongs to each client individually—we’re only managing it as their Representative Payee.
\* We need to track each client’s running balance separately.
\* We issue payments from that same bank account for:
\* Room & Board
\* Personal Needs
\* Other approved client expenses
\* Payments are made by ACH or check.
\* Every transaction must reconcile through the bank feed.
**What we’ve tried**
Initially we linked each person as both:
\* a Customer (Client) for deposits and balance tracking
\-this includes creating invoices from billable bills and applying the deposit to the invoice so their deposit balance decreases.
\* a Vendor for outgoing payments
A NetSuite Pro Bono consultant thought this approach made sense.
This week, another consultant recommended eliminating the Vendor entirely and using only:
\* Customer Invoice
\* Client Deposit
\* Credit Memo
\* Client Refund
Their reasoning was to keep everything on the AR side.
My concern
Our clients do not owe us money in the traditional AR sense.
We are simply holding and disbursing their own funds.
Using Credit Memos and Client Refunds feels more like refunding an overpayment than paying expenses from funds we manage.
My questions
Has anyone implemented a Representative Payee or trust-account style process in NetSuite?
Would you keep the linked Customer + Vendor model?
Is there a better native NetSuite approach for tracking individual client balances while reconciling one pooled bank account?
How would you produce a client ledger or monthly statement showing deposits, rent, personal needs, and the remaining balance?
Any advice would be greatly appreciated!