Generating Customer Payments

The Automated Cash Application feature automatically generates customer payments from imported bank lines and applies them to invoices in NetSuite.

Note:

The Automated Cash Application feature lets you generate an unapplied payment for a single customer. If you have the Consolidated Payments feature enabled, you can apply a payment to multiple customers at Customers > Accounts Receivable > Accept Customer Payments. For details on the Consolidated Payments feature, see Consolidated Payments. For information about applying payments, see Applying a Payment on the Customer Payment Page.

Your role needs certain permissions to do this procedure. For details, see Permissions for Banking Features.

To generate customer payments:

  1. If you haven't already done so, import your bank data (see Bank Data Import).

    All imported bank lines with a positive amount appear and can be processed on both the Match Bank Data and Automated Cash Application pages. However, you should generate all customer payments first, and then match any remaining imported bank lines.

  2. To open the Automated Cash Application page, do one of the following:

    • Go to Transactions > Bank > Automated Cash Application.

    • If you are on the Match Bank Data page, click Automated Cash Application in the upper right-hand corner.

  3. From the Account list, select the bank or credit card account you want to generate customer payments for.

    NetSuite displays a list of imported bank lines that don't have matching payments. An imported line appears if the following criteria are met:

    Important:

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

    • The bank line contains a positive amount.

    • The bank line hasn't been matched to an existing account transaction in NetSuite that's been submitted on the Match Bank Data page. If a transaction was matched and submitted, NetSuite permanently removes the imported bank line from the Automated Cash Application page.

    Note:

    If you import bank lines that specify invoices and later change the customer ID or currency on the invoices, NetSuite can't generate the payments.

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

  5. If needed, add or change the customer for an imported bank line. For details, see Adding or Changing a Customer.

    To generate a payment from an imported bank line, you must select a customer. If a customer isn't selected and no customers are available in the list, see Troubleshooting Missing Records from the Customer.

    Tip:

    You can create a customer mapping rule from your selection that the system remembers and uses for similar imported bank lines. For details, see Creating Customer Mapping Rules.

    The field in the Customer column for an imported bank line is populated if NetSuite finds an exact, preferred, or partial customer match. For details, see Customer Match Criteria.

  6. To review the invoice or invoices a payment is applied to, click the plus icon in a row. For details, see Reviewing Invoices for an 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. For details, 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. Make sure you have the Consolidated Payments feature enabled. For details, see Consolidated Payments.

  7. (Optional) To view all open invoices for a customer, click View Invoices in the expanded details of a row. For details, see Viewing Open Invoices for a Customer. In addition to invoices, NetSuite displays journal entries with the same general ledger impact.

  8. To include or exclude open invoices from payment application for a customer, see Including or Excluding Invoices from Payment Application.

  9. If you want to generate a payment for a bank line, check the left box. This box is active only if a customer is selected.

  10. If you don't want to generate a payment for a bank line, clear the box.

    Note:

    You can generate customer payments that don't apply to any invoices if none are applicable.

  11. After reviewing your imported bank lines, making any adjustments, and selecting boxes as needed, click Submit.

    NetSuite displays the confirmation message detailing the number of payments being generated or excluded.

  12. Click OK.

    NetSuite starts generating the payments, applying them to applicable invoices, and matching them to imported bank lines.

    NetSuite redirects you to the Processed Records page, which displays your batch's processing status. For details, see Checking the Process Status for Generated Payments.

    Important:

    If you set accounting preferences that make fields like Class, Department, and Location required, those fields in customer payments aren't populated. To set values for required fields, edit the payment after it's created. For details, see Correcting Payments to Invoices.

    When an invoice number isn't specified, the system applies the payment according to your preference settings. For details, see .

  13. When processing completes, view your matched and cleared transactions at Transactions > Bank > Reconcile Account Statement.

Continue with the reconciliation process:

Related Topics

General Notices