MyWorks has the ability to sync the transaction fee charged to you by Shopify Payments as a negative line item in the QuickBooks order that we sync into QuickBooks for you.
This can be helpful to record the transaction fee properly in QuickBooks, and have the order total in QuickBooks be the “net” amount - so it more exactly lines up with the deposit to your bank from Shopify.
Enabling this setting
This can be easily turned on in MyWorks Sync > Settings > Payment Methods:
Visit MyWorks Sync >Settings > Payment Methods, and enable the setting to sync transaction fees as a negative line item. In the dropdown option below this setting, choose the product in your QuickBooks that should be used as this negative line item in each order.
Don't have a product in QuickBooks for this yet? See below for a helpful example to easily create one.
Then, in orders synced to QuickBooks, the transaction fee will be present as a line item, and the order/payment total in QuickBooks would be the “net” amount you receive from the Shopify order.
Creating an item in QuickBooks
Don't yet have an item in QuickBooks to use for this transaction fee line item? No problem, it's easy to create one yourself! Here's the steps, and a helpful video that show how to easily create this in QuickBooks.
- In QuickBooks, visit your Products & Services - and create a new product. You can name this anything you'd like, but normally it would be named Transaction Fee or Shopify Fees.
- In the “Income Account” section of the product, select the expense account in your QuickBooks Chart of Accounts that these fees should be recorded to. This may be an account already in your QuickBooks Chart of Accounts, otherwise you can create your own! This account is normally named something like Bank Fees, Transaction Fees, or Credit Card/Merchant Fees.
See the below video to see these steps in action!