Since there is no documented automatic process that reliably matches those imported Shopify payment records to Acumatica Bank Deposit payment lines. Has anyone designed and created a customization or a controlled reconciliation process to automatically link imported Shopify payments to Bank Deposits?
Solved
Customization to automate matching Shopify payments to Acumatica's Bank Deposit 'Add Payment'
Best answer by Steve Milner
@kstrobel You're right, there's no native process for Shopify Payments. Acumatica's automatic path (Import Settlement Batches on the processing center, which builds the bank deposit for you) needs the payment plug-in to supply settled batches. The Shopify Payments plug-in doesn't, and the Shopify connector has no payout entity. That's as of 2026 R1.
A customization doesn't have to match on amounts, though. The connector writes the Shopify order transaction ID into Payment Ref. on every Shopify Payments payment it imports. Shopify's payout balance transactions carry that same ID in sourceOrderTransactionId, along with the payout they belong to (associatedPayout) and amount, fee and net.
So per payout: pull its balance transactions, find the clearing-account payments by Payment Ref., and build the deposit with CADepositEntry.AddPaymentInfoBatch. Acumatica's own Create Deposit on Settlement Batches (CCBatchMaint) does exactly that, including charges and adjustments, so copy that pattern.
Two cautions. Book fees once: if the connector's Payment Fees mapping already puts them on each payment, don't add them again as deposit charges. And leave any deposit whose total doesn't tie to the payout's net on hold for review. Build and test it in a sandbox first.
There's no Bank Deposit entity on the shipped REST endpoints, so I'd build this inside Acumatica rather than drive it from an outside integration.
+7@kstrobel You're right, there's no native process for Shopify Payments. Acumatica's automatic path (Import Settlement Batches on the processing center, which builds the bank deposit for you) needs the payment plug-in to supply settled batches. The Shopify Payments plug-in doesn't, and the Shopify connector has no payout entity. That's as of 2026 R1.
A customization doesn't have to match on amounts, though. The connector writes the Shopify order transaction ID into Payment Ref. on every Shopify Payments payment it imports. Shopify's payout balance transactions carry that same ID in sourceOrderTransactionId, along with the payout they belong to (associatedPayout) and amount, fee and net.
So per payout: pull its balance transactions, find the clearing-account payments by Payment Ref., and build the deposit with CADepositEntry.AddPaymentInfoBatch. Acumatica's own Create Deposit on Settlement Batches (CCBatchMaint) does exactly that, including charges and adjustments, so copy that pattern.
Two cautions. Book fees once: if the connector's Payment Fees mapping already puts them on each payment, don't add them again as deposit charges. And leave any deposit whose total doesn't tie to the payout's net on hold for review. Build and test it in a sandbox first.
There's no Bank Deposit entity on the shipped REST endpoints, so I'd build this inside Acumatica rather than drive it from an outside integration.
Translate
+8
A customization is required to add a new column on the Deposit screen that displays the Shopify Order Number.
This will help identify and match the corresponding Shopify payment with the appropriate deposit transaction in Acumatica.
The customization should retrieve the Shopify Order Number associated with the payment and make it available on the Deposit screen for easier reconciliation and payment matching.
Translate
Thank you so much Steve for your insights into this situation; I will take all of this into consideration. Also, thank you Mohammad-I do have this customization in place. This is helpful, but when there are hundreds of payout lines per day, this is still a tedious process. I appreciate your quick responses!! Have a nice day!
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.