Automated Settlement Reconciliation for NetSuite Pay
Automated settlement reconciliation is also known as automatic reconciliation, auto-recon, and settlement and fee reporting. It allows automated reconciliation of batch settlements, bank deposits with payments, and deposits in NetSuite. Whether you've set up automated settlement reconciliation doesn't affect gateway batch settlement or funds transfer processes upstream. It's used only for recording and reporting.
Complete the following tasks to set up automated settlement reconciliation:
During automated settlement reconciliation setup, several reports and records are created. Some of these can be customized and updated as needed. Review the following information to ensure your NetSuite Pay automated settlement reconciliation is setup:
After automated settlement reconciliation is set up, you can view deposits for reconciled payments. To view deposits, go to NetSuite Pay > Daily Settlement Batch > Settlement and Fee Report.
-
To view the details of a specific deposit, select the deposit record listed in the Deposit Transaction(s) column. Payments are displayed on the Payments subtab.
-
To view the details for the fees of a batch, select the journal record listed in the Journal Entry Transaction column. Fees are displayed in the Lines subtab. Each type of fee appears as a separate line.
Payment Scenarios Supported with Automated Settlement Reconciliation
The following payment scenarios are supported:
-
ERP Payments: Credit Card
-
Cash Sale
-
Customer Payment
-
Sales Order Authorization
-
Sales Order Capture
-
Customer Deposit
-
Cash Sale Refund
-
Customer Payment Refund
-
NetSuite Native Payment Link
-
SuiteCommerce MyAccount
-
SuiteCommerce Advanced
-
NetSuite Customer Center
-
-
ERP Payments: ACH
-
Cash Sales
-
Customer Payment
-
Sales Order Capture
-
Customer Deposit
-
Cash Sale Refund
-
Customer Payment Refund
-
NetSuite Native Payment Link
-
SuiteCommerce MyAccount
-
SuiteCommerce Advanced
-
NetSuite Customer Center
-
-
Single Subsidiary Invoice paid using Bank payment
-
Single Subsidiary Invoice paid using Credit Card
-
Multi-subsidiary Invoices of single customer paid using Bank payment
-
Multi-subsidiary Invoices of single customer paid using Credit Card
-
Hierarchy Customer Invoices paid using Bank payment
-
Hierarchy Customer Invoices paid using Credit Card
-
Multi-Customer Invoices paid using Bank payment
-
Multi-Customer Invoices paid using Credit Card
-
Prepayment applied to Invoices
-
Payment method + Credit Memo application on Invoices
-
Invoices paid using NetSuite’s Paylinks with Bank Account or Credit Card payment and Customer Payment sent to NetSuite
Payment Scenarios Not Supported with Automated Settlement Reconciliation
The following scenarios are not supported:
-
When a non-sufficient funds (NSF) fee occurs, it isn’t cleared from the Undeposited Funds queue
-
When a payment is voided and recreated after the reconciliation, the new payment isn't cleared from the Undeposited Funds queue