I will be working on clickability for all reports this month. It is certainly something I consider essential.
Excellent, as I have said before it just gets better each day.
Hi Lubos
I am having the same difficulty. Because I couldn’t allocate a credit note to a particular invoice and they were both sitting in outstandings, I deleted the credit note and raised a negative invoice. I then paid both of them into the Cash Drawer account just to negate the two off the outstandings list. Unfortunately, while the Tax Audit report is correct the GST calculation sheet is putting this through as a purchase.
What version are you using? This shouldn’t be an issue in the latest version anymore. Negative amounts on invoices will offset sales rather than inflate purchases.
We are having to do monthly GST returns again, have you had a chance to look at the clickability of purchases and sales again. This programme just gets better and better, great job.
Check the latest version (14.3.40) which has clickable amounts on Tax Summary report.
Thank you very much, any chance we will be able to change the fields. What I need is a report that gives Gross sales, Tax collected, name of customer and gross purchase amount and tax paid. Unfortunately in the purchases report, it shows net amounts, and in the sales report it doesn’t have the customers name
Not sure if this will eventually be possible
I can make report that will show VAT collected by customer names and VAT paid by supplier names. Is that what is needed?
Yes please, I guess we just substitute VAT for GST
Hi Lubos, did you manage to get this done, unfortunately I still have to to do all this on MYOB at the moment to satisfy the GST monthly report, which requires customers names who have been charged GST and suppliers names who I have paid claimable GST to. With this would it be possible to have the two entries as in amount paid total and GST collected or paid whichever the case may be. At the moment the amount paid to the supplier shows the amount less the GST where it would be better for us, at least to show for example date, supplier name, description, amount column = $112.00 and GST Paid column $12.00. The same for sales, date, Customer name, Invoice number, description, Amount = $179.20 GST Collected $17.90
Check the latest version (14.4.36)
Tax collected and Tax paid amounts on Tax Summary report are now clickable. This will show you list of all individual tax amounts with new Contact column which will show the name of customer or supplier every tax amount relates to.
Manager doesn’t support Group by function on this screen yet so you will need to click Export button in bottom-right corner and open the file in external spreadsheet program such as Excel and do the Group by (contact) operation in Excel which should give you totals by customers/suppliers.
Let me know if this solution is workable.
Thank you for your updates.
My only problem is that when I do a tax summary and then click on tax collected, where you have AMOUNT column I need the total included tax and in the column BALANCE I really need TAX COLLECTED, with a total at the bottom, and then to be able to print.
Likewise when I click on Nett purchases I need the total sale in the AMOUNT Column and the GST paid in the AMOUNT column with a total at bottom and a print box
This is obviously a problem which is why I unfortunately still have to use MYOB. I need to show on the report amount of purchase and tax paid.
What exactly MYOB shows you on report? List of customers+suppliers in rows and tax collected / tax paid as columns?
Date ID# Name Rate Sale Value Purchase Value Tax Collected Tax Paid
GST Norfolk GST12 %
2/05/2013 CR001594 Payment; MacK E 12.00% $156.80 $16.80
2/05/2013 CR001617 Payment; McRae 12.00% $145.60 $15.60
2/05/2013 CR001622 Payment; Grube T 12.00% $190.40 $20.40
2/05/2013 CR001626 Payment; Anne Fo 12.00% $201.60 $21.60
4/05/2013 CR001618 Payment; Forsyth 12.00% $89.60 $9.60
6/05/2013 536 Cascade Motors 12.00% $60.00 $6.43
10/05/2013 CR001591 Payment; Butterfie 12.00% $156.80 $16.80
10/05/2013 CR001623 Payment; Administ 12.00% $112.00 $12.00
10/05/2013 CR001624 Payment; Norfolk I 12.00% $168.00 $18.00
12/05/2013 CR001621 Payment; Pinetree 12.00% $95.20 $10.20
13/05/2013 CR001615 Lisner Johanna for 12.00% $190.40 $20.40
14/05/2013 CR001630 Payment; Hawthor 12.00% $179.20 $19.20
15/05/2013 CR001616 Mokutu Inns for C 12.00% $291.20 $31.20
15/05/2013 CR001625 Payment; Norfolk I 12.00% $156.80 $16.80
16/05/2013 CR001634 Payment; Bigg Ma 12.00% $168.00 $18.00
20/05/2013 CR001629 Payment; Pinetree 12.00% $134.40 $14.40
20/05/2013 CR001631 Payment; Bowling 12.00% $179.20 $19.20
20/05/2013 CR001632 Payment; Pinetree 12.00% $201.60 $21.60
20/05/2013 CR001636 Payment; Buffett 12.00% $201.60 $21.60
22/05/2013 537 Paw Paw 2800155 12.00% $60.00 $6.43
22/05/2013 538 TelCom28002992 12.00% $188.78 $20.23
22/05/2013 CR001633 Payment; LeCren 12.00% $134.40 $14.40
24/05/2013 CR001637 Payment; The Cho 12.00% $134.40 $14.40
26/05/2013 CR001635 Payment; Christia 12.00% $168.00 $18.00
27/05/2013 CR001627 Payment; Cascad 12.00% $252.00 $27.00
27/05/2013 CR001628 Payment; Hyaat B 12.00% $179.20 $19.20
30/05/2013 CR001620 Payment; Norfolk I 12.00% $336.00 $36.00
31/05/2013 CR001619 Payment; Quintal 12.00% $156.80 $16.80
Total: $4,379.20 $308.78 $469.20 $33.09
Grand Total: $469.20 $33.09
not sure if all my messages are getting through.
I sent one to explain that the above was tabbed but it wouldn’t send like that.
Also I have noticed that the programme has started to freeze.
Regards