Overview
This article explains how to resolve errors when pushing deposits to NetSuite that fail because a transaction has already been deposited. This issue can block your reconciliation process and requires specific steps to resolve.
Related Article: For instructions on unreconciling deposits when encountering deletion errors due to already-deposited bank deposits, please refer to our Unreconciling Deposits Guide.
Common Causes
There are three main reasons why you might encounter this error:
Manual Inclusion: You've manually included a payment in a prior deposit, and it's now being reconciled and included in the current payout
External Process: An external process (such as an unsupported reconciling provider) has deposited the transaction and mistakenly included it
Logic Changes: Blue Onion's reconciliation logic has changed between your last push and the current push, causing some payments to be reassociated
Investigate in NetSuite
Step 1: Create a Saved Search
Navigate to Lists > Search > Saved Searches > New
Scroll to the bottom of the list and select Transaction
Name your search something memorable
Step 2: Configure Search Filters
Set up the following filters:
Transaction Type: Include relevant payment types:
Customer Deposit
Customer Refund
Cash Sale
Cash Refund
Customer Payment
Document Number/ID: Enter the ID from Blue Onion (e.g., 7762 or CD-38372)
Step 3: Configure Results Display
Add these fields to the Results tab for easy identification:
Transaction Number
Document Number
Invoice Number
Deposit/Refund Transaction (most important field)
Step 4: Locate the Problematic Transaction
Run the search to find the transaction (e.g., CD-38372)
Identify which deposit includes this transaction
Note the Deposit ID for the next step
Resolution Methods
Method 1: Edit the Existing Deposit
Once you've identified the deposit containing the duplicate transaction:
Open the deposit in NetSuite
Locate and uncheck the problematic transaction to remove it
Important: Adjust the Cash Back or other tabs to increase the deposit value
This ensures the deposit still matches your bank transaction amount
The adjustment offsets the removal of the transaction
Method 2: Delete and Recreate Deposits
If the deposit was originally created by Blue Onion:
Delete the entire deposit in NetSuite
Return to Blue Onion and recreate the deposit with current data
Re-push both:
The recreated deposit
The deposit that originally triggered the error
Required Action for Blue Onion Users
Critical Step: After resolving the issue in NetSuite, you must:
Send the Deposit ID to Blue Onion Customer Success
Our team will remove it from our system
Once removed, you can successfully re-send the transaction
Best Practices
Always verify transaction IDs before making changes
Document which deposits you've modified for audit purposes
Keep track of manual adjustments made to Cash Back values
Consider setting up regular saved searches to monitor for duplicate deposits
Need Additional Help?
For unreconciling deposits, see our related guide
Contact Blue Onion Customer Success with any Deposit IDs that need to be removed
Watch the video tutorial for a visual walkthrough of these steps