Best Practice for Representative Payee Accounting in NetSuite (Pooled Bank Account with Individual Client Balances)
ur 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
- 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!
Your instinct is correct, and the AR-only approach (Invoice/Deposit/Credit Memo/Refund) is the wrong model here. Those transaction types all imply the client owes you money or you’re refunding an overpayment, and under GAAP that’s not what’s happening. You’re holding fiduciary funds, so they belong on your balance sheet as a liability, not run through revenue/AR at all.
Here’s a structure that holds up to an audit and to SSA’s annual accounting requirements for organizational payees:
1. Create one Other Current Liability account: “Client Funds Held in Trust.”
2. Track each client as a dimension, not as a Customer. A custom record (Representative Payee Client) or a Class/Department segment works better than the Customer entity here, because Customer carries AR baggage (aging reports, dunning, finance charges) you don’t want or need. You can rename “department” or “class” to whatever internal nomenclature that you want.
3. Deposits: use NetSuite’s native Customer Deposit transaction (or a Deposit transaction with multiple lines) and code each line to the liability account, tagged to the specific client. This already matches GAAP, since Customer Deposit posts to a liability by default, not revenue. If one bank deposit covers several clients’ SSA payments, split it into multiple lines on the same Deposit transaction, one per client.
4. Disbursements: you don’t need to eliminate Vendor, you need to recode it. Keep Vendor Bill + Bill Payment (or Write Checks) for the operational benefits, check printing, ACH batching, positive pay, but change the GL line on the bill from an expense account to the client’s liability account. Net effect: liability goes down, cash goes down, nothing hits your P&L, which is correct, since this was never your expense.
5. If a payee (like a landlord) is unincorporated and you’re paying $600+/year in what could be considered rent on the client’s behalf, keep the Vendor record for 1099 tracking purposes even though the GL coding points to the liability account.
6. Client ledger/statement: build a saved search (or SuiteQL query) filtered by the client dimension across all transactions hitting the trust liability account, columns for date, type, memo, debit, credit, running balance. NetSuite supports running balance in saved searches, or you can get more control with SuiteQL window functions. Push that into an Advanced PDF/HTML template and schedule it monthly per client, that becomes your audit trail and your SSA reporting source in one shot.
This keeps everything reconcilable against the one pooled bank account while giving you a clean, GAAP-correct running balance per client, and it holds up much better than routing trust funds through Invoices and Credit Memos.
What would you do about the balances of each client before starting this?
Right now, I’m doing Vendor bills+ Payments with marking the bills billable for each client for the bank reconcile and Client Deposits, Invoices, and Deposit Applications to show how much each client has using the Deposit balance. The problem I am having with that is the funds they had before starting this.
i’d seed the opening client balances with a one-time journal entry: debit the pooled bank account (or an opening balance equity if cash already exists on books) and credit the trust liability, tagged per client, so you start with a clean subledger. after that, i’d keep bills/checks for disbursements and just code the expense line to the liability with the client segment, so bank rec stays normal. we tried pushing this through ar once and it got messy fast, plus our staff kept bumping into customer statements that made no sense. also, please tell me i’m not the only one dealing with random internal chat spam that includes stuff such as https://balloonrace.org/, https://spin-a-win.in/ and https://dream-catcher-game.com/ which wastes time when you’re trying to reconcile and build the monthly client ledger report .
Right now, I’m doing Vendor bills+ Payments with marking the bills billable for each client for the bank reconcile and Client Deposits, Invoices, and Deposit Applications to show how much each client has using the Deposit balance. The problem I am having with that is the funds they had before starting this. This the the Vendor + Customer model.
Praise1425
Your concern is valid. Treating managed client funds as AR can create accounting distortions since you’re not recognizing receivables—you’re acting in a fiduciary capacity.
I’ve helped design NetSuite workflows for similar trust/fiduciary fund scenarios. A cleaner approach is usually to track each client’s balance through liability accounts (or sub-ledgers) while keeping the pooled bank account fully reconciled. Happy to review your setup and recommend a native, audit-friendly workflow that also produces clear client ledger statements.