Categorize Stripe Fees to Specific Accounts in NetSuite

  • Updated

Tracking individual Stripe transaction types into separate accounts within NetSuite Deposit, including those specified in the configuration settings, would be a valuable integration for improving payout tracking and reconciliation. 

 

The following changes are made to accommodate the above functionality.

Addition of Mappings in Settings

 

Below are the additional Mappings provided to transfer individual Stripe transaction types into specific Netsuite Accounts. 

 

 

Settings

 

To configure this feature go to Settings => Stripe Type to NetSuite Account Mappings

 

  1. Select the individual stripe fee type name along with the corresponding NetSuite account name and save the mappings. 

 

  1. This setting supports the following Stripe transaction types:
    • Application Fee (application_fee)
    • Stripe Fee (stripe_fee)          
    • Payment Refund (payment_refund)          
    • Payment Failure Refund (payment_failure_refund)              
    • Adjustment (adjustment)             
    • Refund (refund)
    • Charge (charge)   
    • Payment (payment)             
    • Transfer (transfer)        
    • Transfer Refund (transfer_refund)                  
    • Reserve Transaction (reserve_transaction)                
    • Application Fee Refund (application_fee_refund)                  
    • Financing Paydown (financing_paydown)             
    • Network Cost (network_cost)

Flow mapping changes

Import - Add a Deposit into NetSuite Mapping:

 



Account mappings for payment, deposit, and cash sale are added and the value is read dynamically whereas the cashback account which was previously hardcoded to a value is now being passed dynamically.

Import - Add Stripe Refund Transactions into Deposit Mapping:

 

 

Account mappings for payment and cash refund are added and the value is read dynamically from the mapping of refund accounts present in settings.

 

 

The source record field of the above-highlighted fields is modified 

 

from 

 

{{#compare pageIndex "==" 0}}{{#compare depositId  "!=" ""}}true{{else}}false{{/compare}}{{else}}false{{/compare}}

 

to

 

{{#compare pageIndex "==" 0}}{{#if depositId}}false{{else}}true{{/if}}{{else}}false{{/compare}}

Script Changes

 

  • The financing paydown pay type is removed from functionality and change for this is made in the post map hook of the flow
  • If any extra mappings are added in the Celigo platform, the mappings are passed to NetSuite Deposit record.