Skip to content
The report library

SuiteQL reports, ready to import.

Reports, dashboards and portlets written by HiScale consultants, covering sales, receivables, payables, inventory, projects and more. Fill a bundle, download one file, and import it through Advanced Reports.

Reports
61
Dashboards
07
Portlets
07
  1. 01PickAdd reports and dashboards to your bundle. Dashboards bring the reports they read.
  2. 02DownloadOne .json file, with every shared report packed once.
  3. 03ImportManage, Import / Export, Import tab. Review the preview, then confirm.

75 of 75 items in the library

Sales

11
DashboardAny account

Sales overview

Net sales this year and this month, the monthly trend, top customers, sales reps and the open order backlog.

  • dashboard
  • sales
  • monthly
PortletAny account

Sales trend portlet

Net sales by month this year against the same months last year, on a NetSuite dashboard.

  • portlet
  • sales
  • trend
ReportAny account

Open sales orders backlog

Every sales order still waiting to be fulfilled or billed, with its age and value.

  • backlog
  • operational
  • orders
ReportAny account

Sales by customer by month

Net sales per top-level customer per month for two years, with each figure linked to the lines behind it.

  • monthly
  • customers
  • drill-through
ReportAny account

Sales by item (12 months)

Net quantity, net sales and average selling price per item over the last twelve months.

  • items
  • ranking
  • 12 months
ReportNeeds Classes

Sales by item class by month

Net sales and quantity by item class, month by month, for the last two years.

  • monthly
  • classes
  • product lines
ReportAny account

Sales by sales rep by month

Net sales credited to each sales rep, month by month, for the last two years.

  • monthly
  • sales reps
  • performance
ReportNeeds OneWorld

Sales by subsidiary by month

Net sales per subsidiary per month, each in that subsidiary's base currency.

  • monthly
  • subsidiaries
  • consolidation
ReportAny account

Sales orders by month

Sales orders entered each month over the last two years, with their count, value and average.

  • monthly
  • trend
  • orders
ReportAny account

Sales transaction lines

Every invoice, cash sale and credit memo line of the last two years, the detail behind the sales summaries.

  • detail
  • lines
  • invoices
ReportAny account

Top customers by revenue (12 months)

Customers ranked by net sales over the last twelve months, with each one's share of the total.

  • ranking
  • customers
  • 12 months

Receivables

09
DashboardAny account

Receivables overview

What customers owe, how overdue it is, how fast they pay and which invoices to chase.

  • dashboard
  • collections
  • aging
PortletAny account

Overdue invoices portlet

Open invoices past their due date, most overdue first, as a collections list on a NetSuite dashboard.

  • portlet
  • collections
  • table
ReportAny account

AR aging by customer

How much each customer owes, by days past due, with unapplied credits netted off.

  • aging
  • collections
  • drill-through
ReportAny account

Customer payments by month

Cash collected from customers each month, with the number of payments and paying customers.

  • monthly
  • cash
  • collections
ReportAny account

DSO trend

Days sales outstanding for each of the last twelve months, from receivables at month end and that month's revenue.

  • monthly
  • trend
  • kpi
ReportNeeds Multi-Currency

Invoices by currency by month

Invoice totals per currency per month, in the invoice currency and in base currency.

  • monthly
  • currency
  • exposure
ReportAny account

Open receivables

Every open invoice and unapplied customer credit, with due date, days overdue and aging bucket.

  • detail
  • collections
  • operational
ReportAny account

Overdue invoices

Open invoices past their due date, most overdue first, for collections.

  • collections
  • operational
  • portlet
ReportAny account

Unapplied customer credits

Credit memos and customer payments with an amount not yet applied to an invoice.

  • cleanup
  • operational
  • credits

Payables

11
DashboardAny account

Payables overview

What the business owes vendors, what falls due in the next 30 days, spend by vendor and expense reports waiting.

  • dashboard
  • payables
  • cash planning
PortletAny account

Bills due portlet

Open vendor bills due within 30 days, overdue ones first, as a portlet on a NetSuite dashboard.

  • portlet
  • payables
  • table
PortletAny account

Expense reports pending portlet

Expense reports waiting for a supervisor, for accounting, or for payment, on an approver's NetSuite dashboard.

  • portlet
  • approvals
  • employees
ReportAny account

AP aging by vendor

How much is owed to each vendor, by days past due, with unapplied credits netted off.

  • aging
  • payables
  • drill-through
ReportAny account

Bills due in the next 30 days

Open vendor bills due in the next 30 days or already overdue, soonest first, for planning the payment run.

  • cash planning
  • operational
  • portlet
ReportAny account

Expense reports awaiting approval or payment

Employee expense reports waiting for a supervisor or for accounting, or approved and not yet paid.

  • approvals
  • operational
  • employees
ReportAny account

Open payables

Every open vendor bill and unapplied vendor credit, with due date, days overdue and aging bucket.

  • detail
  • payables
  • operational
ReportAny account

Top vendors by spend (12 months)

Vendors ranked by spend over the last twelve months, with their share and the last bill date.

  • ranking
  • spend
  • 12 months
ReportAny account

Vendor bill lines

Every vendor bill and vendor credit line of the last two years, the detail behind vendor spend.

  • detail
  • lines
  • spend
ReportAny account

Vendor payments by month

Cash paid to vendors each month, with the number of payments and vendors paid.

  • monthly
  • cash
  • payments
ReportAny account

Vendor spend by month

Spend per vendor per month from bills less vendor credits, with each figure linked to the lines behind it.

  • monthly
  • spend
  • drill-through

Purchasing

04
ReportAny account

Open purchase orders by expected date

Purchase order lines still waiting to be received, by expected receipt date, with how many days late each one is.

  • receiving
  • operational
  • late
ReportAny account

Purchase orders by month

Purchase orders raised each month, with the number of orders and vendors and the order value.

  • monthly
  • trend
  • purchasing
ReportAny account

Purchase orders pending approval

Purchase orders waiting for supervisor approval, oldest first.

  • approvals
  • operational
  • purchasing
ReportAny account

Purchase orders vs bills received by month

The value ordered on purchase orders each month against the value billed on bills created from purchase orders.

  • monthly
  • commitments
  • purchasing

Inventory

06
DashboardNeeds Inventory, Locations

Inventory overview

Stock value by location and item type, what needs reordering, what is not moving, and quantity out by month.

  • dashboard
  • stock
  • replenishment
ReportNeeds Inventory

Inventory movements by month

Inventory documents per month and transaction type, with the quantity going in and out.

  • monthly
  • stock
  • movements
ReportNeeds Inventory, Locations

Inventory on hand by location

On hand, committed, available and on order for every item at every location, with its value.

  • stock
  • operational
  • valuation
ReportNeeds Inventory, Locations

Inventory valuation summary

On-hand quantity and value by location and item type, from the item location records.

  • valuation
  • month end
  • stock
ReportNeeds Inventory, Locations

Items below reorder point

Items whose available quantity at a location is at or below the reorder point, with a suggested order quantity.

  • replenishment
  • operational
  • purchasing
ReportNeeds Inventory

Slow-moving items

Items with stock on hand that have not been sold or shipped in more than 90 days.

  • stock
  • aging
  • working capital

Financials

12
DashboardAny account

Financial overview

Revenue and net income this year, revenue against last year, cash by bank account and the income statement by month.

  • dashboard
  • statement
  • profit and loss
PortletAny account

Cash position portlet

The book balance of every bank account as a bar chart on a NetSuite dashboard.

  • portlet
  • cash
  • chart
PortletAny account

Journals pending approval portlet

Journal entries waiting for approval, oldest first, on a controller's NetSuite dashboard.

  • portlet
  • approvals
  • month end
ReportAny account

Accounting period status

Every accounting period since 1 January two years ago, with whether it is closed and which ledgers are locked.

  • month end
  • close
  • controls
ReportAny account

Balance sheet summary

The balance of every balance sheet account as of today, grouped into assets, liabilities and equity.

  • balance sheet
  • month end
  • snapshot
ReportAny account

Cash position by bank account

The ledger balance of each bank account today, with money in and out over the last 30 days.

  • cash
  • treasury
  • snapshot
ReportNeeds Departments

Expenses by department by month

Operating expenses posted to each department, month by month, for the last two years.

  • monthly
  • departments
  • cost control
ReportAny account

General ledger postings

Every posted general ledger line of the last two years, with account, document, name and memo.

  • detail
  • general ledger
  • reconciliation
ReportAny account

Income statement by month

Income and expense accounts by posting period for two years, laid out for the Statement widget with sections and net income.

  • statement
  • profit and loss
  • monthly
  • drill-through
ReportAny account

Journal entries pending approval

Journal entries waiting for approval, with who created them, the period and the amount.

  • approvals
  • month end
  • operational
ReportAny account

Profit and loss summary by month

Revenue, cost of sales, gross profit, operating expenses and net income per month, with margins.

  • monthly
  • kpi
  • profit and loss
ReportAny account

Trial balance

Debit and credit balances of every account today, with balance sheet accounts to date and income and expense for the fiscal year.

  • month end
  • general ledger
  • snapshot

Projects

06
DashboardNeeds Projects

Projects overview

Hours this month, active projects, the projects with the most revenue and who is logging time.

  • dashboard
  • projects
  • utilization
ReportNeeds Projects

Active projects

Every active project with its status, dates, recent hours and the date of the last time entry.

  • projects
  • roster
  • operational
ReportNeeds Projects

Project hours by resource by month

Hours logged per employee per month, billable and non-billable, with the billable share.

  • time
  • utilization
  • drill-through
ReportNeeds Projects

Project profitability

Revenue, direct cost, gross profit, margin and hours to date for every project with postings or time.

  • projects
  • margin
  • drill-through
ReportNeeds Projects

Project transactions

Every revenue and cost posting charged to a project, the detail behind Project profitability.

  • detail
  • projects
  • general ledger
ReportNeeds Projects

Time entries

Every time entry of the last two years with employee, customer or project, service item and hours.

  • detail
  • time
  • billing

CRM

10
DashboardAny account

CRM overview

Open pipeline by stage, win rate, new customers and open support cases on one page.

  • dashboard
  • pipeline
  • support
PortletAny account

Pipeline by stage portlet

The weighted value of open opportunities per sales stage, on a NetSuite dashboard.

  • portlet
  • pipeline
  • chart
ReportAny account

Customers without recent sales

Active customers whose last sale was more than 180 days ago, with what they bought over the last two years.

  • retention
  • churn
  • customers
ReportAny account

Leads and prospects by status

Active leads and prospects counted by stage, status and lead source, with how many were created in the last 30 days.

  • funnel
  • leads
  • marketing
ReportAny account

New customers by month

Customers making their first purchase each month, and the running total of customers who have bought.

  • monthly
  • growth
  • customers
ReportAny account

Open opportunities

Every open opportunity with stage, sales rep, expected close, probability and value.

  • pipeline
  • detail
  • sales
ReportAny account

Open support cases

Every support case not yet closed, with company, status, priority, owner and age.

  • support
  • operational
  • detail
ReportAny account

Opportunities won and lost by month

Opportunities closed each month, won against lost, with their values and the win rate.

  • monthly
  • win rate
  • sales
ReportAny account

Opportunity pipeline by stage

Open opportunities by sales stage, with count, projected and weighted value, and the next expected close.

  • pipeline
  • forecast
  • drill-through
ReportAny account

Support cases by status and age

Open support cases by status and priority, split by how long they have been open.

  • support
  • backlog
  • drill-through

Administration

06
ReportNeeds Departments

Employee headcount by department

Active employees per department, with login access, sales reps and hires in the last twelve months.

  • headcount
  • licences
  • hr
ReportAny account

Roles in use

Every active role with how many active employees hold it, with a click through to who they are.

  • access review
  • security
  • drill-through
ReportAny account

Saved searches

Every saved search with its type, owner, sharing and creation date.

  • customization
  • audit
  • cleanup
ReportAny account

Script deployments

Every SuiteScript deployment with its script, type, record, status, log level and owner.

  • customization
  • audit
  • scripts
ReportAny account

Users and roles

Every active employee with NetSuite access and each role they hold.

  • access review
  • security
  • audit
ReportAny account

Workflows

Every SuiteFlow workflow with its record type, release status, trigger, owner and dates.

  • customization
  • audit
  • workflows