Accounting Software Integration - Payment Gateway Fees Automation

New Member
2 1 2

Hello Shopify Community!

We provide bookkeeping & accounting services to customers online - check us out Open Accounts (

For our Shopify customers, we have a software integration that sends all orders to the accounting software (which is included in all our packages) & we use the automation / matching feature within the software to connect those orders to their bank transactions.
However, their bank transactions have their payment gateway fees deducted!?
So we have to create an automatic transfer from a contra account (or balancing account) for those transactions with the payment gateway deduction included (which we're happy to do since its automated).
But then we have to download the transactions from the contra account manually & use excel formulas to separate the sale /  payment gateway fees before we can upload them to be identified by the automation / matching feature. 

We would love to automate this entirely for our team & any customers managing their accounts themselves.

Our dev is having issues trying to resolve this. 


Any ideas how best to resolve this issue?





For those who are looking for bookkeeping & accounting services online:


Prices start from:

  • Online Bookkeeping ($142 / £109 per month)
  • Training & Support ($129  / £99 per month) 

*All our packages include market leading accounting software


Reach out to us for more details via the chat service on Open Accounts or our contact us page.


Note that we also have a Referral program that offers potential customers a 10% discount with our affiliates receiving 50% commission for every new subscription.

(Our package prices range from $129 / £99 to $585 / £449 with customized services > $727 / £559)

Feel free to contact us - even just for some guidance on how to proceed or integrate with Shopify.
We're here to help!

"Behind every good business, is a great accountant"

The Support Team
Open Accounts

The Support Team
Open Accounts
Replies 0 (0)