Setting Up Cash Basis Reporting
By default, NetSuite reports use an accrual basis to meet generally accepted accounting standards. You can choose cash basis for your report data. Your choice is applied only to reports where the distinction is relevant. You can change this default for all relevant reports or for certain custom reports only.
To change the default globally, use the Cash Basis Reporting preference at Setup > Accounting > Accounting Preferences on the General Ledger subtab. Setting this preference makes all standard reports that support cash basis use cash instead of accrual.
Custom reports use the Cash Basis Reporting preference by default, but you can choose cash or accrual for each custom report.
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 and accrual reporting.
-
Enable – Select this option if you want to use cash-basis tax data for the report.
-
Disable – Select this option if you want to use accrual-basis tax data for the 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 is cash-based. Otherwise, it is accrual-based. To check nexus settings, a user with the Administrator role can go to Setup > Accounting > Set Up Taxes, and see if the Tax Reporting Cash Basis box is checked for that nexus. See also Setting Tax Preferences.
-
-
Click Save.
If you don't see the Cash Basis option on the More Options page for a report, choosing between cash basis and accrual basis doesn't matter for that 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