Core Application/ERP SubLedger Customers
Shop Cash Campaign Debit Payments
We've enhanced the granularity of your Cash Receipt journal entries with a dedicated line item for Shop Cash Campaign Debits. This update allows for more precise financial tracking, with most customers mapping these transactions to marketing expenses in their Chart of Accounts.
In the example above, the Shop Cash Campaign Debit is shown as an Advertising Fee of $25. You can now see this detailed breakout, where your customer used an $11 Shop Cash Credit, on which $0.24 of fees were charged. The resulting Shop Cash portion of this transaction nets to a payout of $14.24.
Shopify Collective Payments
Two new separate line items have been added to your Cash Receipt journal entries:
Supplier Payments:
Tracks records remittances to other Shopify vendors for selling their items on your site
Typically mapped to COGS accounts in Chart of Accounts
Clearly identifiable as "Shopify Collective Supplier Payment" in the description
Retailer Payments
Tracks incoming payments from vendors who sold your products on their Shopify stores
Usually mapped against Accounts Receivable
Clearly identifiable as "Shopify Collective Retailer Payment" in the description (column all the way to the right in the screenshot below)
Note: You may notice duplicate manual transactions recorded by Shopify that should be removed
NetSuite Deposit Reconciliation Customers
The above changes are automatically reflected in your deposit reconciliation workflow, providing improved transaction visibility and easier reconciliation. If you haven’t already, you’ll need to update your COA mapping in the Configuration menu before pushing payments for these payment processors.
Key Notes
All changes are live in the application
Updates have been applied retroactively
Customers will only need to update COA mapping for booking transactions correctly
Additional Resources
For general information about these features from Shopify, please visit: