Insights / NetSuite

12 NetSuite saved searches every controller should have

8 minute read · Dellajax

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

  1. Unapplied customer payments and deposits. Payments with an unapplied balance. These distort aging and borrowing base reports.
  2. Aging by invoice date, at invoice level. Useful for lender reporting and for spotting old items hidden in customer totals.
  3. Customers over credit limit. Balance compared with credit limit, with open orders included.
  4. Credit memos not applied. Open credits that should be applied or refunded.

Payables

  1. Possible duplicate vendor bills. Same vendor, same amount and similar reference number within a short window.
  2. Bills pending approval for more than a few days. Shows where approvals are stuck.
  3. Inactive vendors with open balances. A sign something was missed.

Revenue and orders

  1. Fulfilled but not billed. Orders shipped or delivered but not invoiced. This is revenue leakage until it's billed.
  2. Old open sales orders. Orders open well past their expected date.

General ledger

  1. Balances in suspense and clearing accounts. These should trend to zero.
  2. Manual journal entries above a threshold. For review and audit support.
  3. Transactions created by non-finance roles that hit the P&L. Helps catch miscoded entries early.
Tip: include the record's internal ID in every search result. It makes mass updates, imports and audit samples much easier.

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.