Reviewing Invoices for an Imported Bank Line
On the Automated Cash Application page, review the invoices payments will be applied to, along with payment amounts the system automatically allocates.
To review invoices for an imported bank line:
-
To open the Automated Cash Application page, do one of the following:
-
Go to Transactions > Bank > Automated Cash Application.
-
If you're on the Match Bank Data page, click Automated Cash Application in the upper right-hand corner.
-
-
From the Account list, select the bank or credit card account you want to review.
NetSuite displays a list of imported bank lines that don't have matching payments. If NetSuite found invoice matches, the invoice numbers appear in the Invoice Matches column.
-
For the bank line you want to review, click the plus icon.
The expanded details for the bank line appear.
If the bank line specifies invoices, the system displays the invoices it applies the payment to, or provides a list of suggested invoices.
The Applied Amount fields display the payment amounts NetSuite can apply to each invoice. The system considers whether the invoice is preallocated in other payments. When you click Submit, the system applies these amounts to the invoices.
The system displays invoice suggestions based on the Apply Payments Without Invoice Numbers preference. For details, see Setting Accounting Preferences.
When suggesting invoices by amount, the system doesn't consider discounts or preallocated amounts. A preallocated amount is already assigned to another payment and can't be assigned elsewhere. For example, if an invoice is assigned to Payment A, it can't be assigned to Payment B.
Important:You can only apply payments to invoices with the same currency as the account. To create a payment with a different currency, see Adding Additional Information to a Customer Payment.
-
(Optional) If needed, select a different customer.
The system updates invoice suggestions based on the Apply Payments Without Invoice Numbers preference. See Setting Accounting Preferences.
If you have a multicurrency customer, the system suggests invoices that match the currency of the imported bank line.
Note:If a payment from a customer has open invoices under the customer's top-level customer or subcustomer, those invoices aren't listed. To view invoices for another customer, change the customer you want to generate the payment for. See Adding or Changing a Customer. Note that you can generate a payment only for a single customer.
To generate a payment for multiple customers, go to Customers > Accounts Receivable > Accept Customer Payments. Ensure you have the Consolidated Payments feature enabled. For details, see Consolidated Payments.
-
(Optional) In the Applied Amount field for an invoice or invoices, adjust the value by entering a positive number.
The system recalculates the applied amounts for the other invoices. In the Summary box, the system also recalculates the payment’s applied and unapplied amount.
If you enter a nonnumerical character or a negative number, the system displays an error message. In some cases, the system autocorrects the value you enter. For error and warning scenarios, see Applied Amount Error and Warning Scenarios.
-
If NetSuite displays an invoice you don't want to apply the payment to, remove the invoice by clicking the trash icon next to it.
-
To view all open invoices for the customer, along with journal entries with the same general ledger impact, click View Invoices. For more information, see Viewing Open Invoices for a Customer.
Applied Amount Error and Warning Scenarios
When you adjust an applied amount for an invoice on the Automated Cash Application page, you may get an error or warning message, depending on the situation. The following table outlines the error and warning scenarios that you may see when updating an applied amount.
Scenario |
Message Type |
Message Example |
Action Item |
---|---|---|---|
Pasting a nonnumerical character or negative number. |
Error |
Applied Amount Not Accepted For Invoice A, enter a positive number in the Applied Amount field. |
In the Applied Amount field for your invoice, enter a positive number that doesn't exceed the amount due or payment amount.
Note:
Pasting a value cause an error. |
Entering an amount greater than the amount due after other preallocations are subtracted from a preallocated invoice. |
Warning |
Applied Amount Autocorrected Invoice A has been matched with other imported payments. We adjusted the invoice's applied amount accordingly. |
(Optional) Adjust the applied amount for your invoice if needed needed. |
Entering an amount that exceeds the payment’s remaining balance after other allocations. |
Warning |
Applied Amount Autocorrected The applied amount for Invoice A exceeded the payment amount for Payment A. We adjusted the invoice's applied amount accordingly. |
|
Entering an amount greater than the payment amount. |
Warning |
Applied Amount Autocorrected The applied amount for Invoice A exceeded the payment amount for Payment A. We adjusted the invoice's applied amount accordingly. |
|
Entering an amount greater than the amount due for the invoice. |
Warning |
Applied Amount Autocorrected For Invoice A, the applied amount exceeded the amount due. We adjusted the invoice's applied amount accordingly. |
To view invoices and update applied amounts, see Reviewing Invoices for an Imported Bank Line.
Related Topics
- Setting Accounting Preferences
- Generating Customer Payments
- Filtering Imported Bank Lines
- Adding or Changing a Customer
- Customer Match Criteria
- Customer Mapping Rules for Automated Cash Application
- Viewing Open Invoices for a Customer
- Including or Excluding Invoices from Payment Application
- Troubleshooting Missing Records from the Customer
- Checking the Process Status for Generated Payments