Viewing Imported Data on the Automated Cash Application Page
You can view imported bank or credit card lines on the Automated Cash Application page, if all of the following criteria are met:
-
The bank lines contain a positive amount.
-
The bank lines haven’t been matched to an existing account transaction in NetSuite, which was then submitted on the Match Bank Data page. If an existing transaction has been matched and submitted, NetSuite permanently removes the corresponding imported bank line from the Automated Cash Application page.
The Automated Cash Application feature lets you automatically generate a batch of customer payments in NetSuite and apply them to open invoices. NetSuite then automatically matches and clears the generated customer payments.
To view imported data on the Automated Cash Application page:
-
Go to Transactions > Bank > Automated Cash Application.
To use the Automated Cash Application feature, you need certain permissions. For details, see Permissions for Banking Features.
-
From the Account list, select the bank or credit card account you want to use to view your imported data.
NetSuite displays a list of imported bank lines for the account that didn't have matching payments.
Important:Not all bank lines on the Automated Cash Application page are payments.
-
(Optional) Filter the list of incoming bank lines. See Filtering Imported Bank Lines.
-
To confirm your imported account statement is accurate, review the following information in the data grid on the Automated Cash Application page.
-
Type – The type of transaction, such as Payment, Deposit, and Interest.
-
Date – The date on which the transaction occurred.
-
Ref No. – The transaction ID, if available.
-
Payor – The name of the merchant or payor
-
Memo – The memo for the transaction, if available.
-
Customer – The customer associated with the transaction.
-
Amount – The transaction amount.
-
For more information about using the Automated Cash Application feature, see Generating Customer Payments.
To match and reconcile your data, see Bank Data Matching and Reconciliation.