Square Xero Intergration - Poo Poo

[BondiPauly]

So i rang the guy from square yesterday about a problem i have. The square intergration and the bank feed both are sending info into xero, thus double reporting the revenue. He said i have to choose one or the other... cant have both?!?!

Surely thats not right???

Basically i want Square to send the sales into a clearing account in xero and when the actual money comes in to the bank it roconciles it against the clearing account and then the bank fees are automatically entered.

1. Sale to Clearing account and reported as a Sale

2. Square sends $$ to Bank and gets reconciled against the Sale

3. The difference is the square fees which are slotted into a 'Bank Fees' Account.

That would be nice...

Instead.. its.

1. Sale to Clearing account and reported as a Sale

2. Square sends $$ to Bank ( less fees) and gets reported as a Sale.

3. I spend money freely thinking i have more than i actually have....

What am i doing wrong and has anyone else encountered this??

[Seamus]

Hi @BondiPauly,

What you were told was correct - if you have a link from Square to Xero, we'll send through data on a transaction by transaction basis and Xero will compile this data on their system.

If you also have a link from your bank to Xero this will also send through data on your deposits (the same funds being fed from Square to Xero as individual transactions). Square doesn't have insight into or influence what your data your bank sends to Xero, and your bank doesn't influence what data Square sends to Xero.

Keep in mind that Xero make the integration between Square and Xero, and Square can't see what's happening on the Xero end. It's possible Xero may have different advice for you on how to best tweak the integration settings on their end to achieve what you're looking to do.

Sorry we couldn't be of more help here, all the best!