How to reconcile payments received from Square in Simpro & Xero?

[TammyAA]

I've received a payment for an invoice in Simpro for $1188 with automatic finance charge fee of $26.14 added, total $1214.14.  These two lines export to Xero, however the actual payment received in the bank is $1183.73 so this won't automatically reconcile.  Can anyone help with how to reconcile this and set up rules so this can set up all parts of the transaction without entering manually?

[Seamus]

Hey @TammyAA,

Thanks for getting in touch and sorry to hear you're having trouble with these integrations.

Unfortunately 3rd party integrations are something we're not able to provide support for - I'm also personally not aware of how they work, having not used them myself. 

While Square allows for third party apps to use our payments gateway on their platforms, these integrations are built, managed and supported by Xero and SimPro respectively (or Amaka, depending on which Xero integration you're using). It is possible that you may need to manually reconcile, however I'd try lodging support tickets with the integration developers to see if they are able to provide any further advice.

Sorry I couldn't be of more help here!

[TammyAA]

Thanks Seamus

[AmandaSor]

Hi @TammyAA, I've just come across this post as I am also having the same issue. Did you have any luck in resolving it?

[Arie]

Hey @AmandaSor,

Sorry to hear you've also got trouble reconciling payments! Have you had any luck filing a support ticket with Xero or Simpro? 

[simmorice]

 Hi There, hope you are all keeping well. I have simPRO and Xero scanning through posts in attempt to resolve this issue. Having both simpro and amaka posting sales and transactions to Xero is quite the hassle. In my opinion simpro needs to update their side to perform the same functions as amaka. I have a work around by disabling amaka and posting simpro payments to square balance then manually performing amaka's functions. Has anyone come up with a workaround. Happy to share this with anyone who is interested.