SimonL1
Member
Joined 2 years ago
User Profile
User Widgets
Contributions
Re: GST Cash Repot not displaying sales imported from Square
Certainly not solved, and certainly nothing about this limitation is displayed on all the MYOB pages promoting this integration. If you did just live with it and use accrual then basically you accept you MYOB accounts are incorrect for ALL cash reports (not just GST). I've reverted to - Bank feed rule that allocates to a Square Balance asset account (type is a bank account). This picks up the daily square transfer. - Querying Square and manually entering a "Receive Money" transaction that itemises income at the end of the month (could be done more often as per when you need reporting) with the bank account as Square Balance. You can also add a negative item into an expense account for the Square Fees. - If you don't have any pending transfers at the end of the month the Square Balance should be $0 and you can check this in the bank reconciliation. Of course this just adds a whole lot of manual work that the integration is supposed to eliminate. I find it staggering that MYOB doesn't properly integrate with a payment system like Square. Someone should really look at this properly, the excuses are silly, it can almost be certainly fixed or simply don't promote the integration or state clearly that it will break cash reporting.162Views1like3CommentsRe: GST Cash Repot not displaying sales imported from Square
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.672Views0likes1CommentRe: GST Cash Repot not displaying sales imported from Square
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.704Views0likes0CommentsRe: 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.706Views0likes0Comments