Viewing Imported Data on the Automated Cash Application Page

You can view imported bank or credit card lines on the Automated Cash Application page, provided that the following criteria are met:

• The bank lines contain a positive amount.

• The bank lines have never been matched to an existing account transaction in NetSuite, which was subsequently submitted on the Match Bank Data page. If an existing transaction was matched and submitted, NetSuite permanently removes the corresponding imported bank line from the Automated Cash Application page.

The Automated Cash Application feature enables you to automatically generate a batch of customer payments in NetSuite and apply them to open invoices. The generated customer payments are then automatically matched and cleared in the system.

To view imported data on the Automated Cash Application page:

1. Go to Transactions > Bank > Automated Cash Application.

   To use the Automated Cash Application feature, your user role requires certain permissions. For details, see Permissions for Banking Features.

2. From the Account list, select the bank or credit card account for which you want to view your imported data.

   NetSuite displays a list of imported bank lines for the account that NetSuite was unable to find matching payments for.

   Important:

   Not all bank lines on the Automated Cash Application page are necessarily payments.

3. (Optional) Filter the list of incoming bank lines. See Filtering Imported Bank Lines.

4. To validate the integrity of your imported account statement, 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 on using the Automated Cash Application feature, see Generating Customer Payments.

To match and reconcile your data, see Bank Data Matching and Reconciliation.

Related Topics

Bank Data Import

Viewing Data Imported for Reconciliation

Viewing Imported Data on the Match Bank Data Page

General Notices