dreamsight.ai

Shopify payouts reconciliation quickstart

Every Shopify Payments payout matched to a NetSuite deposit, with fees, refunds, chargebacks and reserves posted and a per-payout reconciliation report.

Book a free consultation

Free consultation to scope your project

Shopify payouts reconciled to NetSuite

Each Shopify payout combines many orders, minus fees, refunds and chargebacks. This quickstart breaks every payout into its parts, posts each part in NetSuite and matches the total to the bank deposit.

What's included

Payout matching

Every Shopify Payments payout matched to a NetSuite deposit.

Processing fees

Fees posted to the expense account you choose.

Refunds and chargebacks

Refunds, chargebacks and chargeback fees posted correctly.

Reserves

Reserve holds and releases tracked.

Payout report

A report for each payout showing orders, fees and adjustments against the deposit.

Exceptions list

Any payout or order that doesn't match is listed for review.

Pricing and add-ons

Included in the base price

  • Shopify Payments
  • One Shopify store
  • One NetSuite subsidiary and currency
  • Orders already syncing to NetSuite through any integration

No license required.

Add-ons (fixed price)

Each additional payment processor (PayPal, Shop Pay Installments, Afterpay) $950

One week project plan

  1. 1

    Free consultation

    We review your requirements and confirm the scope and price.

  2. 2

    Access and field mapping

    You provide access. I document every field mapping for your approval.

  3. 3

    Build and test

    I build and test each sync in your sandbox, then in production.

  4. 4

    Review

    We review the integration together and I make any changes that week.

  5. 5

    Go-live

    Go-live on your schedule, with 30 days of post-launch support.

What you provide

  • NetSuite administrator access
  • Shopify staff account with app permissions
  • Your chart of accounts mapping for fees and reserves
  • A finance contact to approve the posting rules

Performance guarantee

If the reconciliation doesn't work as scoped, you receive a partial or full refund.

US Based Integration Architect

I'm a certified solution, system, integration and data architect, and I have built ERP and warehouse systems since the 1990s. I do the work myself, and you work directly with me.

FAQ

Is the price fixed? +

Yes. If your requirements are outside the base scope, add-on pricing is confirmed during the free consultation, before the project starts.

Do our orders need to sync a certain way? +

No. Orders can sync to NetSuite through NetSuite Connector, Celigo or a direct integration. The reconciliation works on top of any of them.

What happens after go-live? +

30 days of post-launch support is included. Managed services are available after that.

Who does the work? +

I do.

Schedule a free consultation

We'll review your requirements and confirm the scope and posting rules.