After running the three payout flows, the following records are created in NetSuite. Understanding these records helps your finance team interpret the payout data and reconcile variances.
One Celigo Shopify Payout custom record is created per Shopify payout report. This is the summary record that ties the payout together.
The record contains:
-
Charges Net Amount = Charges Gross − Charges Fee
-
Refunds Net Amount = Refunds Fee Gross − Refunds Fee
-
Adjustments Net Amount = Adjustments Gross − Adjustments Fee
-
Retried Payouts Net Amount = Retried Payouts Gross − Retried Payouts Fee
-
Reserved Funds Net Amount = Reserved Funds Gross − Reserved Funds Fee
-
Payout ID: The Shopify Payments payout identifier.
-
Settled amount: The total net amount that was transferred to your bank account.
-
Payout date: Date the payout was issued (converted from ISO 8601 to MM/DD/YYYY).
-
Transaction breakdowns:
-
Deposits tab: Links to the Make Deposit record(s) created in Flow 3.
Deposits tab: Links to the Make Deposit record(s) created in Flow 3.
Note
Transaction types payout_failure and payout_cancellation are not captured in the Celigo Shopify Payout record. Add these to the Transaction types to be excluded setting to prevent errors.
One or more Make Deposit records are created per payout, depending on the transaction volume.
-
Payments tab: Lists all reconciled transactions: cash sales, cash refunds, customer deposits, and customer refunds linked to Shopify orders.
-
Other Deposits tab: Tracks refund adjustments, variance records, fees, and disputes any amounts added to the deposit total.
-
Cash Back tab: Tracks deductions from the deposit fees, chargebacks, and any negative adjustments.
A maximum of 2,000 transactions can be included in a single deposit. For high-volume payouts with more than 2,000 transactions, multiple deposits are created automatically.
Variance transactions are created when a Shopify payout transaction cannot be fully matched to a NetSuite record. They are linked to the Make Deposit record and appear in the Other Deposits tab.
|
Variance Type |
Cause |
Resolution |
|---|---|---|
|
Amount Mismatch |
A matching NetSuite transaction was found, but the amount differs from the Shopify payout transaction amount. |
Review the NetSuite transaction for adjustments, partial payments, or currency rounding. Check whether the Sync records in local currency setting is configured correctly. |
|
Missing Transaction |
No matching NetSuite transaction was found for the Shopify payout transaction. |
Verify the order exists in NetSuite. Check whether the order, billing, or refund flow has synced the transaction. Increase the Delay to reconcile transactions setting to allow more time for sync. |
Note
Variance transactions are informational records intended for your finance team to review and resolve. They do not represent errors in the integration; they identify gaps between Shopify's payout data and the NetSuite transactional records.