Accounts payable
Duplicate payments, supplier overcharges and unclaimed credits are predictable, persistent and already recorded in your ERP. Two working SuiteQL queries to find them, and how to turn a finding into a claim a supplier will actually honour.
Read the guide →
Revenue leakage
Revenue leakage is earned revenue you never collect — and it hides in ordinary, well-run processes rather than in fraud. A precise definition, the five types finance teams actually encounter, and what each one typically costs.
Read the guide →
Pricing & margin
Three working SuiteQL queries that surface price dispersion by item, order lines sold below your margin floor, and products whose cost rose while the price didn't. Including how to turn the output into a defensible number.
Read the guide →
Accounts payable
In a OneWorld account the duplicates that survive are the ones that differ — a re-keyed reference, a second subsidiary, a different currency. Fuzzy-matching SuiteQL that catches them, plus a confidence score so you review the right rows first.
Read the guide →
Accounts payable
Done badly, statement reconciliation is the single largest cause of duplicate payments. Done properly it's the highest-yield hour in AP. A method that builds your ledger position first, then matches — with the SuiteQL to do it.
Read the guide →
Customer profitability
Gross margin ranks your customers one way; cost to serve often reverses the order. A practical activity-driver model you can build from ERP data you already capture — with the SuiteQL to extract it.
Read the guide →
Working capital
An aged debt report ranks invoices by how late they are. That is not the same as ranking them by how likely they are to be collected. SuiteQL to calculate true DSO, segment customers by payment behaviour, and build a chase list worth working.
Read the guide →
Marketing & demand
Marketing platforms measure clicks and conversions. Neither is money. How to join campaign data to the orders and gross profit sitting in NetSuite — including why attributing to margin rather than revenue frequently reverses which channel is winning.
Read the guide →