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?

I'm referring to the Quickbooks Connector by OneSaas

@StuartL 

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

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

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?

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.

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.   

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? 

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...

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?

@StuartL 

Explore this one

https://partnerstack.synder.com/quickbooks

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.