GST Cash Repot not displaying sales imported from Square

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