This page equips companies with a comparison of their payouts in NetSuite to the Source Account’s data for the payouts. Once the details within the settlements are reconciled to the General Ledger (GL), you will have the ability to push journal entries or deposits directly into your NetSuite Account, automating the complete order-to-cash reconciliation and recording process.
The Payout Reconciliation page displays each payout received into your bank account with corresponding transactions broken out into three columns: Total Transactions, Fees, and the Settlement amounts. The General Ledger column displays the totals for orders in your GL related to the payouts.
The Variance column provides comparisons of values in different sources in two categories: Settlement and Total Transactions. A Settlement Variance indicates that Blue Onion has been unable to identify all payment processor records that comprise a payout in the bank. A Total Transaction Variance occurs when Blue Onion has been unable to identify all of the relevant GL transactions to account for a payout.
Troubleshooting: "View" Button Is Grayed Out
If you notice that the "View" button next to a payout is grayed out and unclickable, this could mean that Blue Onion is missing one or more GL account mappings for the payment types included in that payout. Without these mappings, the system cannot build the deposit detail page.
This commonly occurs when a new payment processor integration is connected (e.g., TikTok Shop) and the new payment types haven't been mapped to GL accounts yet.
How to Identify the Issue
Hover over the grayed-out "View" button. You'll see the following message:
"Cannot view this payout — please set up your chart of account mapping for your payments on the General Ledger Configuration page."
How to Resolve
Click the hyperlinked "General Ledger Configuration" text in the error message — this will take you directly to the configuration page with the missing mappings.
On the GL Configuration page, the mappings that need update will be highlighted in red. We also recommend reviewing other unmapped lines (blank or missing a GL account).
Select the appropriate GL account for each unmapped payment type from the dropdown.
Click Save.
Return to the GL Payout Reconciliation Summary page and the "View" button should now be active. You can proceed to view the payout details and push the deposit.
If the Payout Was Already Pushed and Failed
If a push was already attempted before the mappings were completed, the payout may show as a failed push in your Transaction Push History. After completing the mapping steps above, return to the payout and re-attempt the export to push it successfully.
Tip: After connecting any new payment processor integration, always check the General Ledger → Configuration page to make sure all new payment types are mapped before attempting your first deposit push.
To investigate differences by following the instructions in our NetSuite Payout Detail article or you can click into the “Settlement Amount” column and compare the transaction amounts to the GL amounts, using the filter for General Ledger Reconciliation Status. These detailed comparisons will reveal any corrections that are required in your GL. Once the changes are made in your GL and the variances are null a settlement, we can then push the deposits or journal entries for the settlements directly into your GL.