Start a Post

Different Sales figures on GST reports

Experienced Cover User Poodlz
21 Posts
Experienced Cover User
New Zealand
Solved: Go to Solution

Different Sales figures on GST reports

Hi

Wondering if anyone can explain??

When I ran a GST report for the month I found that the figure in the Output Value is different to the amount applied to an invoice?

To explain the value of the invoice is $590.42 which is the amount received an applied to the invoice.

The Output value on the report is $605.56.  A difference of $15.14.  This amount is a credit on the invoice for an Admin Fee charged by the customer (i.e. Supermarket charge).  The invoice is an item invoice & I have an item named 'Discount' which is set to an Income account called Supermarket Admin Fee with an N-T tax code 

Why is the report picking this figure up and increasing the value of the Output Value from $590.42 to $605.56?

The GST value is correct?

Would appreciate anyones help?

4 REPLIES
MYOB Staff Post RienaP
1,242 Posts
MYOB Staff Post
New Zealand

Re: Different Sales figures on GST reports

Hi @Poodlz,

 

I would appreciate if you can send us a screen capture of the transaction that is causing this error so we ca verify the reason for GST figure to distort. Since this is a public forum, you may like to send it by Private Message so we can help you further.

 

Looking forward to hearing from you so we can sort this out as soon as possible.

 


Regards,
Riena
MYOB Training Specialist
Ultimate Partner Mike_James
3,252 Posts
Ultimate Partner
New Zealand
Accepted Solution Solved Solution

Re: Different Sales figures on GST reports

Hi @Poodlz, @RienaP, I think the GST report is correct - the output value on that report refers to the GST-inclusive value of relevant supplies, which in this case is $605.56. The exempt amount (credit) is excluded from the GST report (section S15 or S), but will be found in the N-T section.

Regards Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)
Experienced Cover User Poodlz
21 Posts
Experienced Cover User
New Zealand

Re: Different Sales figures on GST reports

Yes I can see that when I run the N-T report & I have now calculated the GST on the Total Sales figure which includes the $605.56 and the GST amount is the same as the report.  So obviously everything is correct!!

MYOB Staff Post RienaP
1,242 Posts
MYOB Staff Post
New Zealand

Re: Different Sales figures on GST reports

Hi @Poodlz,

 

Many thanks to @Mike_James as well for spotting it in his previous posts. I am so glad and honoured to have a great MYOB community on board.

 

I have checked the reports you have sent and the report looks all correct. The transactions have split GST as per your code and reflected in your report.

 

Should there be anything please do not hesitate to contact us on this forum.


Regards,
Riena
MYOB Training Specialist
Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post