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.
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:
-
Daily Settlement Batch Scheduling – The Daily Settlement Batch is configured to run daily at 5:00 am by default. You can modify the schedule's timing and frequency as required. For more information, see Scheduling the Daily Settlement Batch.
-
Settlement Fees Setup – Fee records are created for each relevant category. Each Fee Type Name includes one of the following suffixes: (fees), (interchange), (network), and (payfac). For example, Wolf Electronics Fees (fees) and Wolf Electronics Interchange (interchange).
To review the records, go to NetSuite Pay > Daily Settlement Batch > Settlement Fee Setup. If you need to include department, class, or location information for journal entries, you can edit the fee records accordingly.
Tip:To determine if department, class, and location are required on the default form, go to Transactions > Financial > Make Journal Entries.
-
GL Account Mapping – Your Account Number and Routing Number are automatically added to your Chart of Accounts, based on information in your merchant application.
-
Deposit Field Mapping – Map your deposit fields when your deposit form requires department, class, or location in the header. For more information, see Mapping Deposit Fields.
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(s) column. Fees are displayed in the Lines subtab. Each type of fee appears as a separate line.
In the Settlement and Fee Report, you might encounter records that show Retry in the first column for the deposit record. This indicates that there is a discrepancy in the settlement because a matching payment from the bank settlement couldn't be found in NetSuite. For more information, see Settlement Discrepancies.
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