Hi, SimonL1
Thanks for your post, and welcome to the MYOB Community Forum.
We're sorry for the delay in response.
We truly appreciate you providing the resolution and workaround regarding the issue with GST Cash reports. It will help other users who might have the same issue to find a workaround. Thank you for supporting the MYOB Community Forum.
Best regards,
Doreen
Yes thank you Simon.
I agree quite unbelievable this matter is not being resolved.
While the workaround provides a solution editing every transaction is not a feasible option.
I do not have time to chase this further to ground. It is just another reason I will recommend my client to convert the MYOB to Xero, where I do not have the same issues.
I have no doubt if the right heads from MYOB and Amaka get together they could resolve this, but the support from both parties is just woeful - (I've raised at least 3 or 4 bug requests with MYOB since I started using it this year and each time the response has been very very ordinary).
If Square integration works far better with Xero and reporting on a cash basis then I may have no option to move as well at the end of the year as the workaround takes just too much time.
Hi Brad74
The explanation at the Amaka link is IMHO a poor 'miss-direct'. I am not an 'apologist' for MYOB, however this is not a MYOB problem. There are hundreds of integrations that work properly, there are many that don't. When a developer takes a 'short-cut' rather than doing things in accordance with how MYOB functions, the end result usually has flow on consequences, which is what you are seeing here.
I have seen worse.
Without knowing more about what exactly the integration is doing it is difficult to add any value. Typically Sales are brought into MYOB via a Sales Invoice. A Payment is then applied to that invoice. The Payment is usually deposited to an asset account which is designated as a 'Bank' account, it does not have to be an actual bank account, merely designated as such, so you can use a clearing account. Despite the Amaka explanation, this is not the problem. The problem would be matching the Payment with the invoice. This seems to be where the integration is falling apart. The API allows the developer to allocate an invoice number, which the integration could store until the payment is processed, and use that invoice number to apply the payment.
One integration I have seen created the sales invoice and failed to capture the invoice number. The invoice was for $100 and remained open (there was no negative amount posted as you have with yours). When processing the Payment, a new $0 invoice was created and then the Payment was applied to this invoice, creating a credit note. So the MYOB file had 2 invoices, one open for $100 and another with credit of $100, net zero. From a lazy developer's view, no problem. From a client's view, thousands of open invoices that will never be closed and thousands of matching credit notes. Client was expected to later apply credits to open invoices to close the invoices.
Regards
Gavin
gavin12345 this is great information of what is likely happening behind the scenes. I hadn't looked at the MYOB API.
An issue here is MYOB endorse and promote this integration and Square isn't exactly some obscure application! So if people set up MYOB expecting this to work (like me) then any limitations should be clear rather than having individuals scratching their heads why transactions don't appear in reports. It's not usual to use cash reporting for GST.
https://www.myob.com/au/apps/products/square
As you say you can only create a payment for an invoice from a designated bank account, the Square Balance which is generally used for payment by this integration is set up as a bank account (it's essentially a clearing account where fees are deducted with a bill, then a transfer created to the bank account when it clears), however some of the other Square asset accounts may not be designated as such (eg gift cards) and perhaps this is the reason for implementation. My workaround sounds like it could be done automatically, because the "payment" is applied to the invoice immediately after it is created through a clearing account, so there is no need to store the invoice number. (a similar thing needs to be done for the bill part being paid by the clearing account).
One can only hope someone senior enough takes issue with this particular broken implementaiton and seeks to fix it in some way.
This is pititful.
Just have my first client using Square with MYOB thats on a cash basis and have found this issue.
I think I will be seeing if I can convert them to Xero.
