NetSuite Amendment Pushes
The NetSuite Amendment Push feature from Blue Onion allows you to reconcile payouts for which there are missing NetSuite transactions. It creates placeholder transactions in a holding account, like Deferred Revenue. Later, these placeholders are replaced by actual NetSuite transactions from an upstream integration and re-pushed to NetSuite to remove the placeholder.
Common Use Case
A common scenario is cash sales created at fulfillment. Combining revenue and cash transactions, cash sales force you to either record revenue too early (at order) or miss the cash transaction until fulfillment, even though cash was already received.
With Blue Onion's Amendment Pushes you'll be able to:
- Reconcile cash timely when NetSuite transaction may be missing
- Maintain accurate Deferred Revenue balances
- Replace placeholder transactions with real ones systematically
Navigation
To include transactions in a deposit in NetSuite as a placeholder for an unfulfilled order, start by opening the Payout Detail page from the GL Payout Reconciliation Page. You can find more details about this page on the NetSuite Detail Payout and Variance article.
How It Works
1. Identify Unreconciled Payouts
On the GL Payout Detail page, locate any payments that are unreconciled under the "Include Additional Transactions" section.
2. Select Payment and Clearing Account
Select the unreconciled payment processor payments that you know are not yet fulfilled. Choose the account where you'd like to post the placeholder value until the NetSuite record will be created - typically a deferred revenue account. This will create a record of this value in the Included Transaction section and updates the variances to zero and allows you to push to NetSuite.
3. Export to NetSuite
Export the deposit to NetSuite by selecting the export button, selecting Deposit API Push and the correct posting period. And then export again.
4. Track Amendments
Exported placeholder transactions are tracked on the Amendments page under the General Ledger menu. All placeholders that were successfully pushed to NetSuite are tracked here and remain until pushed in an amendment push. The left side of the page shows pushed placeholders; the right shows subsequently created real transactions that have now reconciled to the placeholder and are ready to be included in amendments.
5. Replace Placeholders
Once the NetSuite transactions are created upstream and they are reconciled, you are free to push them to NetSuite. Select certain transactions to include or all that are reconciled by using the checkboxes on the left.
You can then select the Export items button at the top of the page to include them in a deposit push and select the posting period. This creates a new NetSuite deposit moving the amount from Deferred Revenue to Undeposited Funds.
If you have many transactions and only care about a subset, you can filter by either Deposit Date (when the Placeholder was originally included in a deposit) or by the Transaction Date of the reconciled NetSuite transaction.
6. Verify Transaction Push
The Transaction Push History page shows all attempted and successful pushes, here you can review the status of your push as well as the details of the push. Amendment pushes will include the cash sales, customer deposits or customer payments in the payments tab and the reversal of the placeholder in the cashback tab, removing this value from the holding account, in this case, deferred revenue.
