Understand the payout variance transactions

A variance transaction could occur because of a mismatch between the order total in the payment gateway and NetSuite. It could also be that the transactions are not found in NetSuite.

Find order and transaction details

In NetSuite, all the order and transaction details that cause variance are reported in the Deposit below the Payout tab. The reason for a variance can be:

• If any of the payout-related records such as cash sale, customer deposit, cash refund, or customer refund is not available in NetSuite, it leads to a “Missing transaction.”
• If there is an order total mismatch in the payment gateway account and NetSuite, then the difference is tracked as a variance transaction with type as “Amount Mismatch.”

Minimize the missing transactions

To minimize the number of missing transactions, use the Lag to bring payout related records setting in your Integration App. This gives you some buffer to create posting transactions (cash sale, customer deposit, cash refund, or customer refund) for the order before you run the deposit flow. This setting helps you to reduce the missing transactions.

Alternative ways to minimize the missing transactions

Before you run the deposit flow, ensure to: 

• Resolve all the Integration App Dashboard errors related to cash sales and cash refunds.
• All your payout-related records are synced to NetSuite. 
• Schedule the refund flow prior to the payout flow.

Correct your variance transactions

With type “Missing Transaction”

For this variance transaction type as the Source transaction ID and Order ID is known, perform the following steps:

1. Import or create the respective transaction to NetSuite using the integration flows. 
2. In NetSuite, open the appropriate deposit record and click Edit.
3. In the Payments tab, select the checkbox next to the newly imported or created transaction.
4. In the “Other Deposits” or “Cash Back” tab, edit the variance amount.
5. Click Save.
6. In the Deposit record, go to the “Payout” tab.
7. Click Edit next to the missing transaction.
8. From the Actions list, click Delete.

With type “Amount Mismatch” 

Note: Make a note of the “Amount Mismatch” transaction from the “Payout” tab.

Step1: Un-deposit the transaction

1. In NetSuite, open the appropriate deposit record and click Edit.
2. In the Payments tab, uncheck the box next to that appropriate “Amount Mismatch” transaction. 
3. Click Save.

Step 2: Match the transaction total

Modify the NetSuite transactions to match the transaction total in the payment gateway account and NetSuite.

Step 3: Re-deposit the transaction

1. In the Payments tab, select the checkbox next to the edited transaction.
2. In the “Other Deposits” or “Cash Back” tab, edit the variance amount.
3. Click Save.

Step 4: Delete the transaction

1. In the Deposit record, go to the “Payout” tab.
2. Click Edit next to the missing transaction.
3. From the Actions list, click Delete.