Help needed please - Square transactions

Cheryl_M

Hi, really hoping I can get some help with this today after being on the phone for over an hour and a half today and not getting a solution.

 

I use Square as my EFTPOS machine in my business and was previously reconciling the transaction in Bank Feeds as per below. This is obviously incorrect as the Square Fees account ended up in credit which will affect my BAS.

I have searched the board and found the linked discussion "mismatches between invoice and payment 

mismatches between invoice and payment | MYOB Community where it is suggested to raise an invoice for the total amount of sales and then a spend money transaction for the Square fees then select both transactions in bank feeds. Problem is that I discovered after so long on the phone today is that the spend money transaction will not show on feeds for a deposit transaction. 

 

I have since tried creating a supplier and purchase order for the square fees and moved both that and the sale to a clearing account but the transaction disappears and does not show in bank feed anymore. 

Surely there is someone that is doing this manually and can assist please, I am going crazy over this. I have to redo 5 months of transactions and would think there would be a simple way to do all this. 

 

I have worked with MYOB previously in roles but never with Square. I signed up for the integrated thing but it would not back date. 

 

Any help is greatly appreciated please.

Cheryl_M

Just wanted to update this in case someone else comes looking for a solution, this is what I have worked out for my use. 

1. Create a Spend money transaction for the fee from a "Square clearing" account.

2. Create a Receive money transaction for the gross sales for the day to the "Square clearing" account.

3. Create a transfer money transaction for the net amount of sales from the clearing account to bank account Square transaction goes to.

4. Match the transferred transaction in bank feeds.