ACH Check and AfterPay Payments and QB

[pfab]

We have QB integrated with Square so that we can have a better idea of profits and losses.  I wish square was more like QB or that QB and square synced harmoniously, but it doesn't and that's why I'm asking this.  We have several customers who pay using the ACH Check option.  They do this monthly, HOWEVER when QB pulls that information it does not bring in the invoice that payment was made to. When we go to QB it just shows as some amount that was paid but no customer information, not even that it was a payment or that it was a check.  When we want to tie it to a customer on QB we cant this is a nightmare with book keeping and our accountant.  were trying to figure out how to navigate this.  Same thing happens with AfterPay

Any suggestions how to work through or around this? 

[MayaP]

Hey there @pfab, I am sorry you are running into some difficulties with Square/Quickbooks integration. I know having to go through reporting and trying to reconcile payments is such a pain.  We can't control how Quickbooks pulls our data. Truly with all integrations but specifically with the QuickBooks integration Square is limited in the troubleshooting we can provide, have you been able to speak with Quickbooks support on this?   I am tagging some of our super sellers to see if they have any insight that could help @HC_Charlie @ryanwanner @LLCafe. Thank you guys! 

[HC_Charlie]

Sorry @MayaP and @pfab , although I use Quickbooks (desktop Mac version) I stayed away from integrations because of some reports I heard about import errors. It's more work for me, but I manually enter everything so I can learn how/what accounts certain transactions affect in my quickbooks. @pfab is there a specific app you use for the integration, or is it by Quickbooks itself? I'd check with that end of the transaction for any help articles if you can't find out anything here.

I did briefly read about accepting ACH invoice payments and assigning a vendor to the transaction, but I think that was for manual entry. Are you able to maybe setup your ACH paying customers with details in Quickbooks (either account number or something) so that the automatic pulling of data would help correspond to that customer? Just a guess on that...good luck with this, Quickbooks has some challenges for sure.