NetSuite Changelog
AccountingIntegrationeCommerceAccountingNew FeatureConfiguration

Shopify Payout Report Sync Configuration in NetSuite

Configure Shopify Payout Report Sync settings in NetSuite to manage payouts efficiently, including account definitions and timing options.

·2 min read·View Oracle Docs

Starting with the configuration of the Shopify Payout Report Sync in NetSuite, it's essential to define the specific accounts involved in the sync process. This setup can be found in the NetSuite Connector under the Settlement tab in Shopify > Settings > Other Transactions.

Key Account Settings

To ensure the proper posting of payouts, the following account settings must be defined:

Account SettingTypeDescription
Payout Base AccountInternal IDThe account at the base level of the deposit record in NetSuite.
Payout Cash Back AccountInternal IDThe cash back account for posting payouts, referenced in the Cash Back subtab of the deposit record.
Payout Other AccountInternal IDThe account for the Other Deposits subtab, typically the undeposited funds account. If a Shopify order is canceled and refunded, it processes into this account.
Payout Undeposited AccountInternal IDThe account used for posting variances and unmatched transactions.

Additional Settings

Furthermore, there are several settings that enhance the payout processing:

  • Delay Factor for Payouts (in hours): Set the hour delay before importing new payouts to ensure all cash sales records are created prior to the sync.
  • Sum fees and add a fee line to payout: Enable to calculate fees and add them as a line to the payout.
  • Order Fee Name: Customize the name displayed in the memo field for the fee line on the deposit.
  • Add non-imported transactions as standalone lines: Allows addition of transactions without matching cash sales as standalone entries in the deposit.

These configurations ensure that payouts are systematically managed and accurately represented in NetSuite, facilitating efficient reconciliation and streamlined financial processes.

Frequently Asked Questions (4)

Where can I configure the account settings for Shopify Payout Report Sync in NetSuite?
The configuration for Shopify Payout Report Sync account settings can be found in the NetSuite Connector under the Settlement tab in Shopify > Settings > Other Transactions.
What is the purpose of the Payout Other Account in Shopify Payout Report Sync configuration?
The Payout Other Account is typically used as the undeposited funds account where Shopify canceled and refunded orders are processed.
How does the Delay Factor for Payouts setting affect the Shopify Payout Report Sync?
The Delay Factor for Payouts setting controls the hour delay before importing new payouts, allowing all cash sales records to be created prior to the sync.
What happens if transactions do not match cash sales during the Shopify Payout Report Sync?
If transactions do not match cash sales, they can be added as standalone lines in the deposit by selecting the option to add non-imported transactions as standalone entries.
Source: Shopify Payout Report Sync Settings — Oracle NetSuite Help Center. This article was generated from official Oracle documentation and enriched with additional context and best practices.

Was this article helpful?

More in Accounting

View all Accounting articles →