The NetSuite Accountant

How to build a monthly spend by vendor saved search in NetSuite

Paul Giese Mar 9, 2020 8:15:00 AM
Paul Giese

For an accounting team explaining the spending changes, having a report that quickly shows vendor spending is helpful. In this blog post, I will walk you through how to build this with a NetSuite saved search. 

To start, navigate to Reports->New Report. Select the 'Transactions' type. On the 'New Transactions Report' page, select:

  • 'Amount' on the field to report on ;
  • 'Detail' on the format on the report; and 
  • 'Entity' and 'Name' on how to subtotal the report 

Finally, add a report title and click 'More Customization' when finished.

NetSuite_Vendor_Report

On the customization page, start by updating the columns on the report. Add a prior period amount column. On the left side, open the Transactions section and select 'Amount.' Under the Alternate Period Range Type, select 'Relative to Report Date' and select the alternative period to be used, such as the last period. A few other columns to consider are:

  • Transaction Number: this will give more detail on the specific vendor transactions.
  • Subsidiary/Department/Class: the associated segment with the transaction.
  • PO # or PO requester: if using NetSuite or a 3rd-party purchasing tool is bringing in the purchase order detail, consider including this detail in the report.
NetSuite_Vendor_Analytics

On the filters page, add the segments included in columns to the filters. The filter will allow users to filter to see the appropriate data.

The Monthly Department Spend by Vendor report, built by intheBlk, makes tracking vendor spend significantly easier by showing all of the relevant information in one place whenever you need it. - Sara Kangas, Manager, Financial Planning and Analysis

Select the 'Preview' button, and the report will provide the vendor activity based on the selected segments. If you expand Vendor activity, you can see the transaction details.

NetSuite_Vendor_Department_Report

In summary, this report will allow accounting teams to get insight into how departments are spending and use vendor activity to explain balance changes. If you or your organization are looking to get more from NetSuite, contact intheBlk today to see how we can help optimize your NetSuite environment.

Are you looking for more tips, tricks, and how-to articles on reporting in NetSuite? Check out our NetSuite Reporting Resource page.

Topics: NetSuite, Budgeting, Reporting