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.
This post was written by Jonathan Martin, COO at Evolution Business Systems.
His expertise extends to software development, support, implementations and project management, he can envisage potential problems and identify them to improve the client experience and outcomes, like a mad scientist, behaviour, statistics and data are where he gets his insights from and lives by a golden rule to always start at the beginning as there are no shortcuts. Jonathan’s passion is to make a difference by assisting clients with their business problems.