By Alex Rolnik

Netsuite Income Statement - BigQuery

Integrates with:

The Netsuite Income statement Kit combines data from 10 popular Netsuite ODBC reporting entities and outputs a table representing a generic income statement for your organization. Due to the nature of the Netsuite source, this Kit is intended to be a starting point for more customized report creation and specific reporting.

This Kit includes…

  • Data ingestion rivers for for the following entities:
    • Transactions
    • Transaction Lines
    • Accounts
    • Subsidiaries
    • Companies
    • Departments
    • Employees
    • Accounting Periods
    • Entity
    • Vendors
  • Logic that joins these entities together to recover values for total income across all customers and channels and accounts. 

Minimum RPU Consumption: 11

You can find the full contents, data model documentation, and source fields here.

Configuring this Kit for use

Variables

In this Kit, there are two variables that are used to make for dynamic use of target configuration. 

  • {Dataset_Netsuite} is used in all Target configurations and queries as the target dataset ID.
  • {Netsuite_Alert_Group} is used as the alert email address(es) for when a river fails.
  • {gcs_file_zone} is used as the File Zone Bucket for all Google BigQuery Target configurations. This variable should already be populated in your Rivery account as long as a Google BigQuery connection has previously been created. 

Go to the Variables menu on the left side navigation bar and create variables for Dataset_Netsuite and Netsuite_Alert_Group. Then fill in the values as the Google BigQuery schema where you would like the data to land and the email address(es) to which you would like the failure emails sent.

Connections

Kits are imported with ‘blank’ source and target connections. In order to use the kit, you have two options:

  • Swap out blank connections with existing connections
  • Add credentials to the blank connections that come with the imported Kit

Additional Considerations

This template is intended as a starting point for creating more customized reports in Netsuite. It is not intended for compliance with any tax, audit, legal, or regulatory requirements.

Easily Solve Your Most Complex Data Challenges

No Credit Card Required.