Blue Onion’s proprietary reconciliation logic will automatically reconcile all payment processor payouts to the order, refund, or other payment records contained in each deposit. This reconciliation logic is then used to create deposit records in NetSuite for each payout. In scenarios in which the relevant NetSuite records do not reconcile to the payout data, Blue Onion will allow you to post the transaction by adjusting for the variance in two different ways.
To navigate to the variance adjustment page, click on the “View” link on the relevant line for the unreconciled payout:
Clicking the “View” link will lead you to the Payout Reconciliation Details page:
The payout above for $5,068.87 shows a variance of $115.83 when reconciled against the NetSuite records. This can be resolved in two ways:
1. Manually including relevant payment records in the deposit:
The detail payout page will include any NetSuite General Ledger (GL) records that are tied to any of the payment process or payment records in the payout. If you would like to include those record(s) in the payout, select the relevant checkbox in the “General Ledger Transactions” page. The “Total Variance” total will adjust to include this transaction.
Note: Refund expected but not appearing in the General Ledger Transactions list?
If you've issued a refund and can see it on the GL Transactions page but it's not showing up in this payout's reconciliation, the Customer Refund record in NetSuite is most likely missing the Shopify order reference.
Blue Onion uses the order reference field on the Customer Refund to link the refund back to the Shopify payment and match it to the correct payout. When that field is empty, Blue Onion can't tie the refund to a payout, so it never appears in the list above for you to check.
To resolve going forward: Configure the integration that creates Customer Refunds in NetSuite to copy the order ID from the related Sales Order onto the Customer Refund record at creation.
For existing affected refunds: Manually update each Customer Refund record in NetSuite with the corresponding Shopify order ID. Blue Onion will pick them up on the next reconciliation.
2. Adjust via Cashback or Other Deposit line item:
If there are adjustments unrelated to a NetSuite GL record that need to be added to the deposit in order to reconcile to the bank payout, line items may be added to the Other Deposit or Cashback sections of the deposit instead, under the “Variances Adjustments” section:
The GL impact will mirror the regular NetSuite Cashback/Other Deposit workflow, in which the positive (Other Deposit) values added will debit the relevant bank account cash and credit the selected GL account. Negative values (Cashback) will debit the selected general ledger account and credit the bank account.
Once line items have been added to reduce the variance to zero, the transaction can be pushed to NetSuite from this screen.