cancel
Showing results for 
Search instead for 
Did you mean: 
user57
Level 3

Shopify Sales Recording in QBO using Daily Sales Receipt

Hello! We have just started with Shopify and I've seen some tips on how to record sales but it mostly entails entering journal entries or using an integrator.

 

What I plan to do is use the daily sales receipt to record sales but for that sales receipt I would list down the products sold (we don't have much so I don't mind) and subtract the Shopify fees so the daily sales receipt matches with the Shopify deposit (we only have Shopify payments). 

 

I haven't started entering Shopify sales on QBO yet until I figure out the best workflow. Thoughts?

 

#shopify #daily #sales #receipts

3 Comments 3
RoseJillB
QuickBooks Team

Shopify Sales Recording in QBO using Daily Sales Receipt

Let’s configure your Shopify and QuickBooks Online (QBO) together, @user57. This is to make certain your sales transactions are well synchronized in both applications.

 

Let’s start with connecting your Shopify account to automatically bring in your orders and payouts to QBO:

 

  1. Log in to your QBO as a company admin.
  2. From there select Commerce, and choose Connect sales channel.
  3. Select Shopify and tap Next.
  4. Since you haven’t entered any data into your Shopify yet, you can proceed to click Next. Then, Continue.
  5. Select Agree after reading through the consent to connect information.
  6. Enter the info for your sales channel, then sign into your account.

 

After that, choose the accounts to use to get deposits and pay fees by following the steps below:

 

  1. Select the account where funds are deposited.
  2. Choose the account you use to pay fees.
  3. Lastly, click Next.

 

Once done connecting and setting up your bank accounts, complete any setup task to keep your records up-to-date and your books accurate.

 

To begin entering your sales receipts, you can refer to Shopify’s page to see the best way or the usual workflow for entering the sales transaction. The application has its own designated website which outlines the application’s suggested procedures.

 

Moreover, you can review and add payouts to your accounts in QuickBooks with Shopify. These are sent from your sales channel for completed orders. You can proceed to that by referring to this article: Review and add payouts to your books in QuickBooks Online with Commerce.

 

I’m always around the Community if you need further assistance with the data synced from your sales channel to QBO. I wish your business to prosper. Have a good one!

4Gal
Level 11

Shopify Sales Recording in QBO using Daily Sales Receipt

@user57 

Explore this 3rd party connector app

https://partnerstack.synder.com/quickbooks

 

user57
Level 3

Shopify Sales Recording in QBO using Daily Sales Receipt

Hello. In the meantime, our dedicated bookkeepers discourage the use of any connections or integrations.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us