NetCash Data Validation

Overview

After your NetCash data has been uploaded to sandbox or transferred to production, it is important to review and validate your data. The following are recommended steps to validate your data.

Validate Bank Accounts

Navigation: NetCash > Setup > Bank Accounts

Ensure all bank account records include the following fields. See this article for a detailed description of each.

• Name
• Number
• Bank Institution
• Currency
• Cutover Date
• Initial Balance
• GL Account
• Rounding Account

To see all fields in list view, search NetCash Bank Account in your global search bar and navigate to Page: NetCash Bank Account.

To see additional fields not shown by default, select Edit View.

View full size

Validate Automation Rule Groups

Navigation: NetCash > Setup > Automation Groups

For each group, review Names and Bank Accounts selected.

Validate Automation Rules

Navigation: NetCash > Setup > Automation Rules

It is recommended to review the following, as applicable:

• Name
• Rule Type
• Rule Group
• Status
• Amount Variance Limit
• Date Tolerance
• Require Confirmation
• Filters
• Match Criteria
• Grouping
• Transaction Template

To access the above information in list views, refer to this article.

Validate Bank Transactions

There are a few different ways to review bank transactions.

1. To review a listing of all bank transactions, navigate to NetCash > Reports > Bank Activity. Here, you can filter transactions by Bank Account, Transaction Date, Automation Group, Matched Status, and Transaction Flow. You can also utilize the Search bar.
2. To review all unmatched bank transactions, navigate to NetCash > Bank > Manual Match. On the lefthand side, you can filter by Bank Account and Transaction Date to see a listing of all unmatched transactions.
3. To review a comprehensive list of all bank transaction fields, create a NetSuite saved search on NetCash Bank Transaction.
   1. Under Results, select Add Multiple View full size
   2. Select All fields (select the first row, hold down SHIFT, then select the last row) and Add View full size
   3. Save & Run search View full size
   4. You can download this list to excel or CSV.