ANS-0438 · FINANCIAL REPORTING
How to Configure Transaction Exclusions in NetSuite Reports
Understand how NetSuite prevents double-counting by excluding specific transaction types from financial reports, particularly when 'Expand Account Lists' is not enabled.
Short answer
To prevent double-counting, NetSuite reports often exclude certain transaction types. These exclusions are configurable. For Sales Reports, if "Expand Account Lists" is not checked, transactions like Bills may not be intended for inclusion, as they typically do not directly impact sales accounts unless explicitly configured.
Scenario
Users may observe that certain transaction types, such as Checks or Bills, appear to be excluded from NetSuite reports, specifically Sales Reports or Forecast Reports. This behavior can lead to questions regarding data accuracy and the methodology NetSuite employs to prevent financial figures from being counted multiple times within various reports.
Solution
To prevent financial figures from being counted twice, NetSuite reports are designed to exclude specific transaction types. Transaction types to exclude from forecast and sales reports are configurable options. The general principle is to manage these exclusions to ensure accurate reporting and avoid double-counting.
When considering a Sales Report, the inclusion or exclusion of certain transaction types, such as Bills, becomes relevant, especially if the "Expand Account Lists" feature is not selected. If "Expand Account Lists" is not checked, the system restricts the accounts that can be chosen on a Bill. This means that accounts typically associated with sales (including 4000 Sales!) would not be available for selection on a Bill, thus making its inclusion in a Sales Report potentially illogical without specific configuration.
Expert NetSuite Support
Need help with this NetSuite issue?
Financial Reporting consulting and configuration support