cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
StuartL
Level 1

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

I feel I'm missing something obvious here.
12 REPLIES 12
John C
QuickBooks Team

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

Hi StuartL Thanks for reaching out to us here on the Community. When you refer to the connector are you referring to an app or bank account?

StuartL
Level 1

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

I'm referring to the Quickbooks Connector by OneSaas

On Beta
Level 4

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

@StuartL 

QB Connector is a free app and only offers limited features. You should consider having a paid connector app.

StuartL
Level 1

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

Hi On Beta, thank you for responding. I'll certainly consider a paid app. Are there any that you would recommend that I consider? 

John C
QuickBooks Team

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

Hi StuartL Thanks for confirming. Does the app create the sales transactions for you and when it allocates the payments to your cash account is it the net amount after the fees are deducted?

StuartL
Level 1

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

The app creates both gross sales and fees. As I am in the UK, it requires the transactions to be posted to a cash account. I am able to map the revenues to a "Undeposited Funds" account, but the fees will only go to a cash or bank account. Therefore, in order to combine the fees and the gross sales to match bank deposits, I have to manually move each fee transaction to the Undeposited funds account.

John C
QuickBooks Team

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

Hi StuartL As the app doesn't enable you to allocate the amounts to the undeposited funds account then the only way to allocate them to the undeposited funds account would be to do this manually as you have been doing.   

StuartL
Level 1

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

Hmmm...that's disappointing. As volumes increase, that's a mite tiresome. Particularly as each transaction needs to be done individually. The developer maintains that Quickbooks insists the transactions be sent to a cash account in the UK and Aus. Any idea why that might be? 

John C
QuickBooks Team

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

Hi StuartL We're unable to answer that question, you could reach out to our developers to see if they can provide you with further information: https://help.developer.intuit.com/s/topic/0TOG0000000kF9JOAU/quickbooks-online?t=1726497101082&searc...

StuartL
Level 1

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

Well, yes John. I suppose I could reach out to the developers. 

I have asked how to reconcile the simplest possible e-commerce transaction. I use the biggest supplier of storefronts, Shopify. I use QuickBooks, a service entirely online these days. I connect the two with an app developed by the company that owns QuickBooks. Surely, it can't escape your notice that your vaunted product does not reconcile the simplest e-commerce transaction - so I'm left wondering what QB is for? Maybe ask the developers?

On Beta
Level 4

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

StuartL
Level 1

I have a Shopify store. How do I reconcile (sales - fees) against deposits? The connector won't allow me to sync fees to an undeposited funds account, only to a cash one.

Thanks @On Beta Looks a sledgehammer to crack a nut. I think that I will set up a cash account called "Shopify" and map revenues and fees to go there. Then, when I see a deposit in the main account from Shopify, I will make a transfer to the main account to match against the deposit. I think that will work - I shall have to test it.

Need to get in touch?

Contact us