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

How do you match imported shopify sales to payouts received into the bank? I am trying to reconcile the bank account.

I have manually been matching and inputing all of the sales from Shopify into Quickbooks, but I have recently connected Shopify to Quickbooks online, so now I am trying to figure out how to to match all of the sales.
Solved
Best answer September 15, 2021

Best Answers
ShiellaGraceA
QuickBooks Team

How do you match imported shopify sales to payouts received into the bank? I am trying to reconcile the bank account.

I'll be happy to walk you through how to reconcile your Shopify transactions with QuickBooks, @weslaughton.

 

Since you're already connecting Shopify with QuickBooks, all your sales transactions from Shopify will be downloaded automatically in the All Sales tab in QuickBooks. From there, you can review all the imported Shopify transactions. You can compare QuickBooks transactions with Shopify transactions by going to Reports and then Finances in your Shopify account.

 

When you're ready to reconcile, follow these steps:

 

  1. Go to Banking and then the Banking tab.
  2. Select the bank account where Shopify deposits all their payouts.
  3. Select the Shopify deposits and then Add.

 

For more details about reconciling an account, check out this article: Reconcile an account in QuickBooks Online.

 

Feel free to also browse this link for more insights on how the integration works and the answers to the most frequently asked questions about it: QuickBooks & Shopify Better together

 

Please let me know if you have other questions or concerns with Shopify transactions. I'll be here to help. Take care and stay safe.

View solution in original post

10 Comments 10
ShiellaGraceA
QuickBooks Team

How do you match imported shopify sales to payouts received into the bank? I am trying to reconcile the bank account.

I'll be happy to walk you through how to reconcile your Shopify transactions with QuickBooks, @weslaughton.

 

Since you're already connecting Shopify with QuickBooks, all your sales transactions from Shopify will be downloaded automatically in the All Sales tab in QuickBooks. From there, you can review all the imported Shopify transactions. You can compare QuickBooks transactions with Shopify transactions by going to Reports and then Finances in your Shopify account.

 

When you're ready to reconcile, follow these steps:

 

  1. Go to Banking and then the Banking tab.
  2. Select the bank account where Shopify deposits all their payouts.
  3. Select the Shopify deposits and then Add.

 

For more details about reconciling an account, check out this article: Reconcile an account in QuickBooks Online.

 

Feel free to also browse this link for more insights on how the integration works and the answers to the most frequently asked questions about it: QuickBooks & Shopify Better together

 

Please let me know if you have other questions or concerns with Shopify transactions. I'll be here to help. Take care and stay safe.

Fiat Lux - ASIA
Level 15

How do you match imported shopify sales to payouts received into the bank? I am trying to reconcile the bank account.

@weslaughton 

As another option, consider having a 3rd party app to help. The app summarizes all your Shopify orders and separates the fees. You get a simple journal entry with all the fees in the appropriate accounts in QuickBooks and the app checks your bank account to make sure the deposits match and reconcile.

weslaughton
Level 3

How do you match imported shopify sales to payouts received into the bank? I am trying to reconcile the bank account.

Great thansk for your suggestion. Can you please recommend a third party app that does this?

Fiat Lux - ASIA
Level 15

How do you match imported shopify sales to payouts received into the bank? I am trying to reconcile the bank account.

@weslaughton 

Explore these apps

https://synder.grsm.io/quickbooks

https://bookkeep.grsm.io/quickbooks

https://www.a2xaccounting.com/shopify

for A2X, use the promo code FL_10_6MON_2021 to get 10%

 

 

 

weslaughton
Level 3

How do you match imported shopify sales to payouts received into the bank? I am trying to reconcile the bank account.

Thanks 

weslaughton
Level 3

How do you match imported shopify sales to payouts received into the bank? I am trying to reconcile the bank account.

Thanks for following up with me. I am still having trouble. I am just trying to match all Shopify sales with payouts in the bank. This is all new for me and I got disconnected from customer care. Is there anyway I can get a bookkeeper to help. Thanks, Wes 

Maybelle_S
QuickBooks Team

How do you match imported shopify sales to payouts received into the bank? I am trying to reconcile the bank account.

Hi there, @wes.

 

To resolve this, I'd recommend getting in touch with our Customer Support Team again. This way, they can pull up your account securely and help check the cause of the issue.

 

Check this article on how to check when QuickBooks deposits customer payments into your bank account: Find out when QuickBooks Payments deposits customer payments.

 

You can also refer to this article how QuickBooks Payments deposits work in QBO and different information about QuickBooks Payments: Common questions about payments deposits in QuickBooks Online.

 

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.

weslaughton
Level 3

How do you match imported shopify sales to payouts received into the bank? I am trying to reconcile the bank account.

Great thanks

diana.clark
Level 2

How do you match imported shopify sales to payouts received into the bank? I am trying to reconcile the bank account.

Hi, 

I think I set up something incorrectly because our actual bank balance is like 4 times less than what QBO is showing as the 'bank balance'. I wonder if it has to do with allocation of transactions/accounts?

 

So, as you know, individual orders filter in from Shopify (website) into QBO with no actual monies coming in, but then there is also the Shopify 'transfer' of those actual funds (minus their fees) into QBO. Could it be as the individual orders filter in,those items for sale are set as an 'income' account and then as the Shopify (and probably Paypal too) 'Transfer' shows in the Banking Review window, where I've set a Rule to categorize that shopify transfer under an income account, that I'M GETTING A COUPLE ENTRY OF THAT INCOME??? 

 

Because Shopify is transfering actual funds in, I thought that wouldn't just be set as a transfer, but it's 'Income' coming into our account, but something is way off because QBO shows like $250K as bank balance and it's actually only like $28K! 

Mich_S
QuickBooks Team

How do you match imported shopify sales to payouts received into the bank? I am trying to reconcile the bank account.

We appreciate you for bringing your banking experience to our attention, diana. I'm here to help rule this out.

 

Your QuickBooks Online balance and real-life bank balance are off due to the following factors:

 

  • Outstanding transactions
  • New transactions for a connected account
  • Duplicate transactions
  • Edited or deleted transactions
  • Credit card (liability) account

 

In your case, transactions are duplicated reason for the bank balance to show four times less than what your QBO bank balance is showing. 

 

If you connected your Shopify with QuickBooks, I recommend excluding the downloaded data on your QBO account to prevent double income from displaying. Additionally, since you added a rule to automatically add and categorize transactions, you'll have to Undo first and then Exclude them. I'll show you how:

 

To undo:

 

  1. Open the Banking menu.
  2. Select the Banking tab.
  3. Go to the Categorized area, and pick the transactions you want to remove.
  4. Once done, click on Undo

 

To exclude:

 

  1. Open the Banking menu.
  2. Select the Banking tab.
  3. Go to the For review area and pick the transactions to exclude.
  4. Once done, click on Exclude.

 

For more details about how to manage your data, see this: Categorize and match online bank transactions in QuickBooks Online.


If you're all good and you want to keep your accounts in order, read this for some useful details: Reconcile an account in QuickBooks Online.

 

Please get back to me if you need help with anything else with banking or QuickBooks. I'd be glad to help. Stay safe.

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

Need to get in touch?

Contact us