Setting Up Cash Basis Reporting
By default, NetSuite provides reports on an accrual basis to meet generally accepted accounting standards. You can choose to use cash basis for your report data. Your choice is applied only to reports where the distinction is relevant. You can modify this default globally for all relevant reports or individually for each custom report.
To change the default globally, use the Cash Basis Reporting preference at Setup > Accounting > Accounting Preferences on the General Ledger subtab. Enabling this preference causes all standard reports that support cash basis reporting to be on a cash basis rather than accrual basis.
The default for custom reports follows the Cash Basis Reporting preference set in Accounting Preferences. However, you can choose whether each custom report uses cash basis or accrual basis.
Reports that currently have access to the Cash Basis box are the following reports:
-
Account Detail
-
Cost by Customer Detail
-
Budget vs. Actual
-
Budget Income Statement
-
Budget Income Statement Detail
-
Income Statement
-
Income Statement Detail
-
Comparative Income Statement
-
Multi-Book Income Statement
-
Multi-Book Income Statement Detail
-
Financial Layout Description
-
GST on Purchases Detail
-
GST on Sales Detail
-
GST on Purchases Summary
-
GST on Sales Summary
-
Customer Profitability Detail
-
Customer Profitability Summary
-
Purchase by Item Detail
-
Purchase by Vendor Detail
-
Purchase by Item Summary
-
Purchase by Vendor Summary
-
Sales by Customer Detail
-
Sales by Item Detail
-
Sales by Promotion Detail
-
Sales by Sales Rep Detail
-
Sales by Partner Detail
-
Sales by Partner Summary
-
Sales by Customer Summary
-
Sales by Item Summary
-
Sales by Promotion Summary
-
Sales by Sales Rep
-
Summary Sales Tax Liability by Tax Item
-
Sales Tax Liability By Tax Agency
-
Sales Tax Transaction Detail
-
VAT on Purchases Detail
-
VAT on Sales Detail
-
VAT on Purchases Summary
-
VAT on Sales Summary
To change a custom report between cash basis and accrual basis:
-
Go to Reports > Saved Reports > All Saved Reports and click Edit next to the custom report you want to edit to open the Report Builder (or Financial Report Builder).
-
Click More Options.
-
On the More Options page, use the Cash Basis menu to switch between cash basis and accrual basis reporting.
-
Enable – Select this option if you want to use cash-basis tax data for this report.
-
Disable – Select this option if you want to use accrual-basis tax data for this report.
-
Nexus setting – Select this option if you want to use nexus settings for tax data. If the nexus has cash-basis tax reporting enabled, the tax data in the report will be cash-based. Otherwise, it will be accrual-based. To check the settings for a nexus, an administrator can go to Setup > Accounting > Set Up Taxes, click the nexus, and check whether the Tax Reporting Cash Basis option is enabled for that nexus. See also Setting Tax Preferences.
-
-
Click Save.
If the Cash Basis option is not available on the More Options page for a report, the choice between cash basis and accrual basis is not meaningful for the report.
Related Topics
- Report Customization
- Report Builder Interface
- Report Customization Permission
- Adding, Removing, or Reordering Report Columns
- Formatting Numbers on Reports
- Filtering Data on Reports
- Sorting Data on Reports
- Setting Additional Options for Custom Reports
- Arranging Data on Summary Reports
- Sharing Custom Reports with Other Users
- Exporting a Saved Report as an Excel Web Query
- Example Report Format Changes
- Saving a Custom Report
- Deleting a Custom Report