Auto Reconciliation

BlueSnap Global Payments for NetSuite supports auto reconciliation. In NetSuite, reconciliation is the process of ensuring your internal financial records match external sources, such as your payment processing statements. Auto reconciliation reduces manual effort by automatically importing these statements and matching them to your internal transactions.

Auto reconciliation leverages BlueSnap webhooks and reporting data to compare against NetSuite transactions. Once the process is enabled, NetSuite will listen for BlueSnap's payout webhook to activate auto reconciliation. When an event is received, auto reconciliation will retrieve the associated payout data from BlueSnap and begin mapping it to your NetSuite transactions.

Payout Statuses

Once the reconciliation process occurs, either manually or automatically, a payout will be marked with one of two statuses:

• Reconciled means that all transactions were successfully mapped.
• Pending means that reconciliation could not be completed, usually due to transactions that could not be found in NetSuite. This can happen when transactions occurred outside of NetSuite, such as when performing a refund from the BlueSnap portal. In this case, you will need to manually map the event to a transaction within NetSuite.

Setup

Follow the steps below to ensure that NetSuite can receive the payout information from BlueSnap and handle funds appropriately before using auto reconciliation.

1. In BlueSnap's Merchant Portal, enable the Payout webhook. Use the postback URL from your Payment Processing Profile in NetSuite as the webhook's endpoint URL.
2. In your NetSuite account, go to BlueSnap > Payouts > BlueSnap Auto Reconciliation Settings > New to configure the rules for mapping transactions.
   1. Select the Currency, Subsidiary, Account Type, and Target Account to indicate which of your bank accounts receives the payout deposits for that currency and subsidiary. This is what allows auto reconciliation to match your transaction records against BlueSnap's payout reports.
3. Go to BlueSnap > Payouts > Import Payout to test your mappings and try out auto reconciliation before enabling it.
   1. Select "BlueSnap" for the Payment Processing Profile and enter a BlueSnap Payment ID for the Payout ID. Then, check the Auto-Reconcile box and click Import.
   2. Once processing is complete, you should receive a success message indicating that the record was imported and auto reconciled successfully. That transaction's status will also change to Deposited.
4. Once you have confirmed that reconciliation works as expected, you can fully automate the process. To enable auto reconciliation in your NetSuite account, go to Payment Processing Profile > BlueSnap Connection settings and check the box next to Enable Auto-Reconciliation.

Auto Reconciliation Process

Once enabled, all future payouts will be reconciled automatically when triggered by BlueSnap's webhook.

1. Before reconciling occurs, make sure that all transactions are appropriately recorded in NetSuite. When doing so, you must specify the BlueSnap transaction ID in the P/N Ref field or else reconciliation will be unable to map the transaction from BlueSnap's payout information.
2. BlueSnap's payout webhook notifies NetSuite when a payout has occurred, and auto reconciliation attempts to map all of its transactions.
3. In your NetSuite account, go to BlueSnap > Payouts to view the list of payouts and their statuses. Here, you can click the payout to view its details and the transactions that were included in it.
4. If the payout's status is Pending, you will need to manually correct any transactions that were not mapped. Add any missing transactions to NetSuite with their BlueSnap transaction ID in the P/N Ref field to map the payout events. There is no need to re-run the reconciliation process, as your actions will reconcile the transaction.

📘

Note

Transactions displayed in a payout will include captures, refunds, chargebacks, and BlueSnap fees. Funds paid out by third parties (such as AMEX or PayPal) will not be included, as they are not paid by BlueSnap. Partial captures and refunds will be listed as separate transactions with different Invoice IDs.