GST Cash Repot not displaying sales imported from Square

Thank goodness I'm not the only one with this issue. (this relates MYOB Business, not sure about others).

I have raised this exact case with both Amaka and MYOB - raised tickets with both companies - neither seem interested in fixing the issue and point the finger at the other party. 

It's really quite unbelivable that an integration of Square and MYOB will NOT allow you to report GST on a cash basis without some serious workarounds, in fact the issue is with any cash report (rather than accrual) eg P&L. How can one of the largest POS systems not have proper MYOB integration.

It's caused by "negative" line items applied to invoices/bills that the integration uses to import Square transaction - adding the line whilst zeroing the invoice/bill (and hence entering the double entry) does not appear to mark the bill/invoice as properly "paid" behind the scenes and therefore the items on the bill/invoice only ever appear in accrual reports and not cash ones - a invoice payment / supplier payment is needed to properly close the bill (dispite what MYOB reports in the summary).

As the invoice/bill remains not properly marked as paid, it will not show on the GST BAS report in cash mode, or ANY cash based report (eg P&L etc.). Amaka will claim this is the only way to do things because of the complexities of various payment methods with Square (eg it could also be from a voucher), I'm not so sure, so we now have a finger pointing game where it appears nobody is seeking to resolve the matter.

MYOB Invoice Total Amounts are Zero | Amaka

The very long workaround I have found works is as follows

• Go into each invoice generated by the integration (one for each day!)
• Remove the negative amount line item that says paid from Square balance (hopefully that's your only negative line)
• Save invoice
• Create a full payment for the invoice, select bank account as Square balance and apply it. (you could perhaps apply one payment to several invoices if you wished rather than each one ensuring it doesn't span reporting periods)

Then for bills, do similar

• Go into each bill generated by the Square integration (usually this has Square's fees/charges)
• Remove the negative amount line item that says paid from Square balance
• Save
• Record a full payment on the bill, selecting Square balance as the bank account (you could perhaps apply one payment to several bills if you wished rather than each one ensuring it doesn't span reporting periods)

Make sure the above is done for EVERY invoice/bill generated for this integration. Note there are no issues with the "transfer" transaction the Square integration creates to transfer from Square Balance to your nominated bank account.

I have then found cash reports should then reconcile correctly as the bills/invoices have been properly closed/paid with an invoice payment / bill payment rather than the negative line items.