Customized Automatic Bank Deposit Reconciliation

If you have existing NetSuite integrations in place for transactions, you can still use the automatic reconciliation feature.

The automatic bank reconciliation feature can be used as a standalone feature and integrate with existing NetSuite integrations.

You can associate Stripe refunds or payments with corresponding payment and refund records in NetSuite by adding the internalId to the Stripe resource's metadata. When a transfer is created in Stripe, SuiteSync inspects records referenced in Stripe metadata, validating them against the corresponding Stripe resource.

If the validation process succeeds, a deposit is automatically created. The deposit contains any fees charged by Stripe.

Supported payment and refund record types

Stripe charges can be linked to the following NetSuite record types:

  • CashSale. Use netsuite_cash_sale_id.
  • CustomerPayment. Use netsuite_customer_payment_id
  • CustomerDeposit. Use netsuite_customer_deposit_id

Stripe refunds also need to be linked. The following NetSuite refund record types are supported:

  • CashRefund. Use netsuite_cash_refund_id
  • CustomerRefund. Use netsuite_customer_refund_id

Disputes (chargebacks)

In this workflow, SuiteSync represents the full chargeback amount on the NetSuite deposit under the Other Payments tab. The dispute is not linked to any NetSuite Invoice, Sales Order, Customer Deposit, Customer Payment, etc.

Dispute chargebacks reversals and dispute fees (and fee reversals) are represented in the same way: a line item on the "Other Deposits" area on NetSuite deposits

This is the default way of handling disputes under the deposit reconciliation workflow. It's also possible to represent disputes using Cash Refunds, Credit Memos, and CustomerRefunds. This is how SuiteSync handles disputes in all other workflows; learn more about this.