GST on Cash and Accrual bases in Dynamics NAV

You can set up NAV to report GST on both cash and accrual bases using Unrealised GST functionality. This functionality enables GST to be calculated when the invoice is posted and not realised or due until the invoice is paid.

The first step is to activate the functionality by setting the ‘Unrealised GST’ and ‘Prepayment Unrealised GST’ to True.

 

Next step is to define the how the GST is realised in the ‘Unrealised GST Type’ field and select the ‘Unreal. Account’ and ‘Input Tax Cr. Unreal. Account’ in the ‘GST Posting Setup page

 

You can select ‘Unrealised GST Type’ from the below options.

And this is it!! We are now set up to use GST unrealised functionality for GST reporting on accrual and cash basis.

Now when you post the Invoice, Unrealised GST Account will be affected.

And when you make payment, Realised GST Account will be update reversing out the Unrealised GST Account.

In the example below, I made a partial payment of 50%. So $10 is taken out of Unrealised GST Account and posted to Realised GST Account.

 

Elvin Narain

Elvin Narain

Solution Specialist

This post was written by Elvin Narain, Solution Specialist at Evolution Business Systems.

 

If you have out-dated business software that’s limited in its reporting and analytical capabilities – then you should to talk to EBS about a powerful business management software solution – Microsoft Dynamics NAV. To find out more about our suite of Microsoft business management software solutions, please call Paul Woods at EBS for an obligation free discussion on 1300 303 973.

Subscribe here to get our free EBS monthly enewsletter to get valuable blog articles from EBS and the latest updates on the Microsoft Dynamics product suite.