MYOBCommunity
Partner Zone
|
|
Partner Zone

Show both GST and Ex-GST

This thread is now closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Highlighted
Experienced Cover User DerekM
42 Posts
Experienced Cover User
Australia
DerekM
Experienced Cover User

42Posts

14Kudos

0Solutions

Solved: Go to Solution

Show both GST and Ex-GST

We are an eductional facility so do not charge GST.  We have found a case where some income was marked as GST by mistake.  We want to check out all transactions over the last 6 months to see if this mistake has happened before.

 

We use Accountright 2014.4.16.7861.

 

I had planned to run a General Ledger Detail report showing both the GST and Ex-GST and export to Excel to check.

 

But I can't find an option for showing both.  I'd even be happy to run the report twice and comparing in Excel.

 

Can anyone help?

 

Thanks

Derek

6 REPLIES 6
Partner AlanT
1,085 Posts
Partner
Australia
AlanT
Partner

1085Posts

842Kudos

179Solutions

Accepted Solution Solved Solution

Re: Show both GST and Ex-GST

Hi @DerekM 

 

Try using the GST [Detail] report from the Reports » GST / Sales Tax section.

 

I use this report each quarter to review all my Tax allocations before I complete my BAS report.

 

Hope this gives you the info you need.

 

Regards,

 

Alan

Experienced Cover User DerekM
42 Posts
Experienced Cover User
Australia
DerekM
Experienced Cover User

42Posts

14Kudos

0Solutions

Re: Show both GST and Ex-GST

Thanks Alan

 

I had hoped to restrict it to just one account where the error may have occurred, but I can work with that report.

 

Cheers

Derek

Partner AlanT
1,085 Posts
Partner
Australia
AlanT
Partner

1085Posts

842Kudos

179Solutions

Re: Show both GST and Ex-GST

Hi @DerekM 

 

Once you have displayed the report, from the Filters tab, you can select to display transactions for just Customers by selecting the Card Type.

 

This may also help.

 

Regards,

 

Alan

Experienced Cover User DerekM
42 Posts
Experienced Cover User
Australia
DerekM
Experienced Cover User

42Posts

14Kudos

0Solutions

Re: Show both GST and Ex-GST

Unfortunately we have other software for tracking the customers and so don't put them into MYOB as cards.

 

Thanks for the thought though.

 

Cheers

Derek

Ultimate Partner CathieR
958 Posts
Ultimate Partner
Australia
CathieR
Ultimate Partner

958Posts

20Kudos

245Solutions

Re: Show both GST and Ex-GST

Another way to highlight the wrong use of tax codes is to go to:

Accounts Tab

Company Data Auditor

4 Tax Exception Review

Enter the dates applicable

Run Review

If a red ? appears select display

 

This report shows where the default tax code was not used.

Cathie Robilliard
BCom. (Acc/Finance) UNSW
MYOB Certified Consultant
BAS Agent
email:cathier@optusnet.com.au
Servicing Sydney South, NSW
Experienced Cover User DerekM
42 Posts
Experienced Cover User
Australia
DerekM
Experienced Cover User

42Posts

14Kudos

0Solutions

Re: Show both GST and Ex-GST

That is quite a handy little report.  I will keep that in mind for the future.

 

Thanks

Derek

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