Skip to main content
July 26, 2022
Question

Shopify invoices and fees - Quickbooks self-employed

  • July 26, 2022
  • 2 replies
  • 0 views

Hello, I've just launched a small candle business and am currently trading as a Sole Trader (not VAT registered).

 

I have a Shopify website but I am confused how to deal with invoices and Shopify fees.

 

Do i need to manually create an invoice in Quickbooks every time I make a sale? Do those invoices have to be emailed to the customer from Quickbooks before I can mark them as paid? How do I account for the shopify fee?

 

I think it might be easier if i use Quickbooks online but I am able to use that if I am not VAT registered?

 

Please help!

2 replies

July 26, 2022

Welcome to the QuickBooks Community, @GBansal.

 

Thanks for choosing QuickBooks Self-Employed (QBSE) to cater to your business needs. I'm here to provide some information about Shopify so you can handle this matter properly.

 

Since e-commerce services like Shopify cannot connect to QBSE, you're correct that you'll have to manually create an invoice for each sale. However, you can import transactions from Shopify through a third-party application. You just need to contact the Shopify Support Team to check the configuration of the software and assist you with transferring transactions to QuickBooks.

 

Moreover, there's no need for you to email the created invoices to your customer before you can mark them as paid.

 

For your Shopify fees, you can categorise them based on the SAF103F deduction categories. This will help organise your income and expenses so you can see which aspects of your self-employed business have the most impact. If you're still unsure of what category to use, I recommend seeking assistance from an accountant.

 

I also agree that QuickBooks Online might be convenient for you since you have the option to connect Shopify to the program. You can surely utilise the program even if you are not VAT registered.

 

Additionally, kindly visit this resource to see different information on how QBSE tracks your business income and taxes: QuickBooks Self-Employed Overview.

 

Please keep me posted if there's anything else you need or any concerns about managing invoices or payment transactions in QBSE. Just leave a comment below. Have a great day ahead!

GBansalAuthor
August 4, 2022

Hi there, 

 

Thanks for coming back to me.

 

You said that you don't need to send emails to mark them as paid, but I am finding that is not the case. If my invoice is still a draft, there is no option to 'mark as paid'. I don't need to send an invoice via Quickbooks as Shopify already does that for me.

 

So my questions are:

 

1) Do I need to log manual invoices from Shopify, and offset the Shopify fees as an expense? Currently, I have my business bank account synced to my Quickbooks Self Employed, so whenever Shopify is ready to do a payout, I receive payment from Stripe (minus any Shopify fees) and that is automatically logged as business income. As that transaction is logged minus fees, is there any reason to create invoices in Quickbooks?

 

2) If I do still need to manually add all invoices in Quickbooks, despite them being sent out from Shopify, is a work-around just sending the invoice to myself? Rather than to the customer. That way, I can mark it as paid. And then log the fee as an expense.

 

I have tried Quickbooks online so that I can get the Shopify integration but to be honest it looks so complicated. I'm making very minimal sales at the moment so it feels like its way too advanced for where my business is at. I find the Quickbooks Self employed much more user friendly, but I'm unsure about whether or not I should be recreating my invoices in Quickbooks. 

GBansalAuthor
August 6, 2022

@Kevin_C just tagging you so you see this post

Fiat Lux - ASIA
July 27, 2022

@GBansal 

QBSE is a stand alone product and you may need a 3rd party connector to reconcile Shopify transactions into your QBO account.

https://quickbooks.grsm.io/UK