Insights / NetSuite
12 NetSuite saved searches every controller should have
Saved searches are one of NetSuite's most useful features, and one of the most underused. These twelve give a controller early warning on the issues that usually surface during close. Add them to a dashboard so they're reviewed every week, not every month.
Cash and receivables
- Unapplied customer payments and deposits. Payments with an unapplied balance. These distort aging and borrowing base reports.
- Aging by invoice date, at invoice level. Useful for lender reporting and for spotting old items hidden in customer totals.
- Customers over credit limit. Balance compared with credit limit, with open orders included.
- Credit memos not applied. Open credits that should be applied or refunded.
Payables
- Possible duplicate vendor bills. Same vendor, same amount and similar reference number within a short window.
- Bills pending approval for more than a few days. Shows where approvals are stuck.
- Inactive vendors with open balances. A sign something was missed.
Revenue and orders
- Fulfilled but not billed. Orders shipped or delivered but not invoiced. This is revenue leakage until it's billed.
- Old open sales orders. Orders open well past their expected date.
General ledger
- Balances in suspense and clearing accounts. These should trend to zero.
- Manual journal entries above a threshold. For review and audit support.
- Transactions created by non-finance roles that hit the P&L. Helps catch miscoded entries early.
Put them to work
Set the critical ones to email a summary on a schedule, and add the rest to a controller dashboard as reminders with counts. The goal is a close where nothing on these lists is a surprise.
Get a NetSuite health check
A fixed-scope review of your NetSuite account with a ranked list of fixes. Start with a free call.