General Ledger and GST - Can I print a detailed ledger showing the GST related to each transaction?

[KellyGrimmer]

Hi

In the 'old' Accountright Premier v19 I could print a detailed ledger showing the GST related to each transaction through customise report and selecting the appropriate report field.

Is there a way to do this in Accountright Live?

Thanks

[jenniek]

Hi there,

Are you using AccountRight Live or MYOB Essentials. In AR Live the same report is still there under Report - GST. Choose either GST Detail Payments, or GST Detail Invoice depending on which basis you are on for GST.

[KellyGrimmer]

Hi

AccountRight Live Standard. It's an audit client so the reports you mentioned aren't showing me what I need to see. I need to see the GL with all transactions and whether or not GST has been extracted on each transaction. Much easier than drilling down on each transaction. Helps to quickly see whether items such as grants etc have been treated correctly.

Thanks

[Steven_M]

Hi @KellyGrimmer 

Welcome to the MYOB Community Forum, I hope you find it a wealth of knowledge.

I would have gone with Jennie and said it was the GST Reports that you were after. I couldn't think of another report that it would be provide you with  the required information. In saying that are you able to provide a copy of the custom report that you use to print in the previous version.

[KellyGrimmer]

Hi

Thank you for your response. But no, the GST detail reports do not work as I want the information sorted by account code.

I'm ashamed to admit, that I have just realised it is Quickbooks/Reckon that has this ability, sorry. But is there anyway I can pull this information from MYOB? Attached is a copy of an example report from Quickbooks/Reckon.

Thank you for your help.

Kelly

[jenniek]

Hi @Steven_M 

I had a look in 19.5 - and I was sure there was a report too - which you had to add extra fields to - an exceptions report? - but I can't find it now

[Steven_M]

Hi @KellyGrimmer 

We all make mistakes, as long as we got to the bottom of the report.

As to AccountRight produce a similar report it wouldn't be able to produce a report like this due to the nature of the way it records transactions. When you record a transaction the GST amount is filtered off to the GST account. So when you look at the transaction you would have the Income amount and then the GST Amount  as a separate line. 

I would say the closest reports to achieved what you are after would be the ones mentioned by Jennie.

[ronatbas]

@KellyGrimmer 

There is a report that we use regularly to visually scan all transactions -it  is the transactions tax codes report as it compares the entered code to that on the account and on (I think) that on the card. it is amazing how an incorrect entry seems to jump out at you. as Jenny has pointed out the Exceptions Reports can also be useful.