Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowMy online store uses Shopify. Before they send you a Payout for your sales they take out a transaction fee. Does this fee need to be entered in Quickbooks since it was taken before they paid me for my sales? And if so, how do I make a journal entry for it, since it didn't come out of my bank account. I am just confused if this counts as an actual expense or not since it didn't come from my business bank account.
I need help with this as well!!
Hi GK23,
There are two things that we can consider when recording Shopify fees.
If those transaction fees were posted in your bank account together with your sales, you'll want to create an expense transaction so you can match it with the downloaded transaction fees.
Here's how:
However, if transaction fees were charged outside QuickBooks without affecting any of your accounts, you don't have to record it since it will not affect your books. However, I still recommend reaching out to your accountant for other ways on how to record the fees.
When bank transactions are downloaded, you can match the bank transactions in Quickbooks Online (QBO): Match and Categorize Bank Transactions in QuickBooks Online.
In case you need further assistance, please let us know so we can help you.
It's a bit tricky for those whose shops are on shopify, lazada or Amazon. But's that oki, kindly just record the total amount that you earned from shopify shop and deduct the fee as bank charge expense. As Revenue need to be recorded correctly. Kindly share below what i did:
Step 1. Open new Journal Entry
1. + New, Journal Entry
2. Credit Revenue : exact amount that your shop's invoice on shopify states (you might consider to record shipping income + product revenue if you need to) (enter Name: Shopify's Shop as you customer )
3. Debit Trade & Other Receivable : amount that shopify really paid to your bank (enter Name: Shopify's Shop => treat this one as your customer)
3. Debit Bank Charge : amount of transaction fee that shopify deducted before paying you
4. Save and close
Step 2.
1. go to Sales => All Sales
2. on the New Transaction arrow => choose Payment
3. Select Name "Shopify's Shop" and chose Journal Entry # that you want to make payment
4. Enter the real amount that Shopify paid you at Payment Received. (Payment Method : Cash, Ref Number: as bank reference: Shopify.....)
5. Save and New
Hope it help. And might other have better solution. Good luck!
I am not an accountant but I just went through this, preparing for my tax return. It is my understanding that yes, you do need to keep track of the fees in some manner. The reason is that the gross amount that the 1099-K that Shopify issues (and reports to the IRS) includes those fees. So, you have to report them as an expense. Otherwise, you'd be paying taxes on money that you never received.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here