Skip to content
This image has an empty alt attribute; its file name is revenue-reporting.png

Background

We were recently tasked with building a report based not only on the GL account but also on the department of the transactions booked on it. More precisely our client wanted to be able to generate an Income Statement using three main categories. Some GL accounts were mapped with a category in a one-to-one relationship, but others were mapped to a different category depending on the department, meaning that one GL account should be split into different reporting categories based on the department filled out at transaction level. Here is how we managed that within NetSuite.

Functionalities

NetSuite includes a quite powerful and flexible reporting tool that offers many interesting features. In the case detailed above, we were able to meet our customer’s expectations using a simple but helpful standard functionality.

Most reports are usually built based on GL accounts, and the filters used in the account section are Account Name, Account Number or Account Type. However, other filters are available and can prove to be really useful: Customer, Department, Item, Subsidiary.

This image has an empty alt attribute; its file name is f0J6kLUdExZU78i-xLF5cIkEpHRNXeWUqTBDLfgRASb6-b41TQ5g5O3cNE9JKBfmstpaIkF4EF_iyxntkI_9Qto9KZ0lg2PP-b74eaWRpUEJVy-hj-Y2Kc_IxBUxa7dWu1uTsQ7k

By mixing account and department filters, we managed to generate an Income Statement that fitted our customer’s needs. 

Depending on the department, one transaction could hit either of the categories constituting the P&L. This provides two main advantages that were required by our client:

  1. Clear visibility on each segment’s costs (here the departments grouped in overhead categories).
  2. In accordance with the report structure and the department on the transactions , the costs of one account will be included in different metrics (Gross Profit, EBITDA, EBIT…).

Outcome

Once the accounts are correctly mapped in the report customization tool, the result is really straightforward and the costs are correctly allocated to the corresponding section. Furthermore, NetSuite ensures that it is impossible to count the same transaction twice, which means that if there is a Section A with a GL Account + Department rule and a Section B with only a GL Account rule, Section B will not include the transactions counted before in Section A.

Account number
This image has an empty alt attribute; its file name is chrome_859JQJn1tK.png
This image has an empty alt attribute; its file name is chrome_CmggPifgLc.png

Conclusion

When it comes to reporting, NetSuite provides a wide range of features and filters allowing the users to build highly customizable reports and offering them a clear view on the segments, metrics and periods they want to monitor. More often than not, these standard features are more than enough to meet the customers’ specific reporting requirements.

In short

  • Standard and easy-to-use feature
  • Clear visibility on the costs booked by segment
  • Customizable metrics
  • Duplicate-proof, each transaction can be included only once

A question? You would like to implement this solution?

Related articles

Professional Services Companies: NetSuite 2020 Release 1 Helps Firms Thrive in a Time of Change

NetSuite articles

May 20 2020

This image has an empty alt attribute; its file name is revenue-reporting.png

Background

We were recently tasked with building a report based not only on the GL account but also on the department of the transactions booked on it. More precisely our client wanted to be able to generate an Income Statement using three main categories. Some GL accounts were mapped with a category in a one-to-one relationship, but others were mapped to a different category depending on the department, meaning that one GL account should be split into different reporting categories based on the department filled out at transaction level. Here is how we managed that within NetSuite.

Functionalities

NetSuite includes a quite powerful and flexible reporting tool that offers many interesting features. In the case detailed above, we were able to meet our customer’s expectations using a simple but helpful standard functionality.

Most reports are usually built based on GL accounts, and the filters used in the account section are Account Name, Account Number or Account Type. However, other filters are available and can prove to be really useful: Customer, Department, Item, Subsidiary.

This image has an empty alt attribute; its file name is f0J6kLUdExZU78i-xLF5cIkEpHRNXeWUqTBDLfgRASb6-b41TQ5g5O3cNE9JKBfmstpaIkF4EF_iyxntkI_9Qto9KZ0lg2PP-b74eaWRpUEJVy-hj-Y2Kc_IxBUxa7dWu1uTsQ7k

By mixing account and department filters, we managed to generate an Income Statement that fitted our customer’s needs. 

Depending on the department, one transaction could hit either of the categories constituting the P&L. This provides two main advantages that were required by our client:

  1. Clear visibility on each segment’s costs (here the departments grouped in overhead categories).
  2. In accordance with the report structure and the department on the transactions , the costs of one account will be included in different metrics (Gross Profit, EBITDA, EBIT…).

Outcome

Once the accounts are correctly mapped in the report customization tool, the result is really straightforward and the costs are correctly allocated to the corresponding section. Furthermore, NetSuite ensures that it is impossible to count the same transaction twice, which means that if there is a Section A with a GL Account + Department rule and a Section B with only a GL Account rule, Section B will not include the transactions counted before in Section A.

Account number
This image has an empty alt attribute; its file name is chrome_859JQJn1tK.png
This image has an empty alt attribute; its file name is chrome_CmggPifgLc.png

Conclusion

When it comes to reporting, NetSuite provides a wide range of features and filters allowing the users to build highly customizable reports and offering them a clear view on the segments, metrics and periods they want to monitor. More often than not, these standard features are more than enough to meet the customers’ specific reporting requirements.

In short

  • Standard and easy-to-use feature
  • Clear visibility on the costs booked by segment
  • Customizable metrics
  • Duplicate-proof, each transaction can be included only once

A question? You would like to implement this solution?

Read more

Templafy, a booming Tech Scale-up in the Nordics

Customer use case

May 20 2020

This image has an empty alt attribute; its file name is revenue-reporting.png

Background

We were recently tasked with building a report based not only on the GL account but also on the department of the transactions booked on it. More precisely our client wanted to be able to generate an Income Statement using three main categories. Some GL accounts were mapped with a category in a one-to-one relationship, but others were mapped to a different category depending on the department, meaning that one GL account should be split into different reporting categories based on the department filled out at transaction level. Here is how we managed that within NetSuite.

Functionalities

NetSuite includes a quite powerful and flexible reporting tool that offers many interesting features. In the case detailed above, we were able to meet our customer’s expectations using a simple but helpful standard functionality.

Most reports are usually built based on GL accounts, and the filters used in the account section are Account Name, Account Number or Account Type. However, other filters are available and can prove to be really useful: Customer, Department, Item, Subsidiary.

This image has an empty alt attribute; its file name is f0J6kLUdExZU78i-xLF5cIkEpHRNXeWUqTBDLfgRASb6-b41TQ5g5O3cNE9JKBfmstpaIkF4EF_iyxntkI_9Qto9KZ0lg2PP-b74eaWRpUEJVy-hj-Y2Kc_IxBUxa7dWu1uTsQ7k

By mixing account and department filters, we managed to generate an Income Statement that fitted our customer’s needs. 

Depending on the department, one transaction could hit either of the categories constituting the P&L. This provides two main advantages that were required by our client:

  1. Clear visibility on each segment’s costs (here the departments grouped in overhead categories).
  2. In accordance with the report structure and the department on the transactions , the costs of one account will be included in different metrics (Gross Profit, EBITDA, EBIT…).

Outcome

Once the accounts are correctly mapped in the report customization tool, the result is really straightforward and the costs are correctly allocated to the corresponding section. Furthermore, NetSuite ensures that it is impossible to count the same transaction twice, which means that if there is a Section A with a GL Account + Department rule and a Section B with only a GL Account rule, Section B will not include the transactions counted before in Section A.

Account number
This image has an empty alt attribute; its file name is chrome_859JQJn1tK.png
This image has an empty alt attribute; its file name is chrome_CmggPifgLc.png

Conclusion

When it comes to reporting, NetSuite provides a wide range of features and filters allowing the users to build highly customizable reports and offering them a clear view on the segments, metrics and periods they want to monitor. More often than not, these standard features are more than enough to meet the customers’ specific reporting requirements.

In short

  • Standard and easy-to-use feature
  • Clear visibility on the costs booked by segment
  • Customizable metrics
  • Duplicate-proof, each transaction can be included only once

A question? You would like to implement this solution?

Read more

Oracle NetSuite a Leader Again in Gartner’s 2019 Magic Quadrant for Cloud Core Financial Management Systems for Midsize, Large and Global Enterprises

NetSuite articles

May 20 2020

This image has an empty alt attribute; its file name is revenue-reporting.png

Background

We were recently tasked with building a report based not only on the GL account but also on the department of the transactions booked on it. More precisely our client wanted to be able to generate an Income Statement using three main categories. Some GL accounts were mapped with a category in a one-to-one relationship, but others were mapped to a different category depending on the department, meaning that one GL account should be split into different reporting categories based on the department filled out at transaction level. Here is how we managed that within NetSuite.

Functionalities

NetSuite includes a quite powerful and flexible reporting tool that offers many interesting features. In the case detailed above, we were able to meet our customer’s expectations using a simple but helpful standard functionality.

Most reports are usually built based on GL accounts, and the filters used in the account section are Account Name, Account Number or Account Type. However, other filters are available and can prove to be really useful: Customer, Department, Item, Subsidiary.

This image has an empty alt attribute; its file name is f0J6kLUdExZU78i-xLF5cIkEpHRNXeWUqTBDLfgRASb6-b41TQ5g5O3cNE9JKBfmstpaIkF4EF_iyxntkI_9Qto9KZ0lg2PP-b74eaWRpUEJVy-hj-Y2Kc_IxBUxa7dWu1uTsQ7k

By mixing account and department filters, we managed to generate an Income Statement that fitted our customer’s needs. 

Depending on the department, one transaction could hit either of the categories constituting the P&L. This provides two main advantages that were required by our client:

  1. Clear visibility on each segment’s costs (here the departments grouped in overhead categories).
  2. In accordance with the report structure and the department on the transactions , the costs of one account will be included in different metrics (Gross Profit, EBITDA, EBIT…).

Outcome

Once the accounts are correctly mapped in the report customization tool, the result is really straightforward and the costs are correctly allocated to the corresponding section. Furthermore, NetSuite ensures that it is impossible to count the same transaction twice, which means that if there is a Section A with a GL Account + Department rule and a Section B with only a GL Account rule, Section B will not include the transactions counted before in Section A.

Account number
This image has an empty alt attribute; its file name is chrome_859JQJn1tK.png
This image has an empty alt attribute; its file name is chrome_CmggPifgLc.png

Conclusion

When it comes to reporting, NetSuite provides a wide range of features and filters allowing the users to build highly customizable reports and offering them a clear view on the segments, metrics and periods they want to monitor. More often than not, these standard features are more than enough to meet the customers’ specific reporting requirements.

In short

  • Standard and easy-to-use feature
  • Clear visibility on the costs booked by segment
  • Customizable metrics
  • Duplicate-proof, each transaction can be included only once

A question? You would like to implement this solution?

Read more