I have been working recently with some new clients who have moved to Dynamics GP from smaller systems and are used to having a specific GST Report print out of the system. Dynamics GP doesn’t have specific reporting for GST in New Zealand. Implementing the GST Reporting for Australia could be an option, but it disables some of the features our clients like using.
Part of my recent focus has been to try and get some relevant dashboard / query reports set up for clients using the Excel data connectors. They are really underutilised at the moment and I want to see our clients getting good reporting easily – particularly for those sites that don’t have access to bigger reporting tools such as BI360.
So I joined the two problems together and have developed a template that can be used for GST Returns. It is based on three main queries into the database:
Tax Detail Transactions – this reports on all items that have had a tax detail associated with them. Generally this covers all transactions that originate from purchasing or sales.
Financial Transactions – this reports on transactions that might have been coded to one of the GST GL codes and did not have a Tax Detail associated with them. This is generally general journals and bank transactions.
Financial Summary – the queries the balance sheet account summaries for all your GST accounts for the YTD. Essentially the balance of these accounts should match the movements for the reporting period.
There is space to include adjustments that might need to be made (e.g. a payment or refund that is due but not yet recorded) and the GST Return Summary can be used to calculate the correct numbers to enter into the physical return form.
So what’s it going to cost you? Here is a breakdown:
- The report structure and layout – nothing – the work we have done is on us!*
- Deployment – that is your cost at standard time and materials. Assuming you already have data connections deployed, it will take us about 30 minutes for a single database. Add an additional 15 minutes per extra database.
- Modifications to the report – those are on you as needed as standard time and materials rates.
- Training and assistance with reconciliation – time and materials as needed.
- Full instructions on how to use the report – including saving a permanent copy for your records are included with the file.
While we could probably do something similar for earlier versions, this report is set up to work for Dynamics GP 2010 and 2013.
If you are interested in obtaining a copy of this report, please contact: firstname.lastname@example.org
*This offer is available to current clients of Olympic Software – external users of Dynamics GP are welcome to a copy of the report, however, there may be a fee involved.
Heather Roggeveen is a MS Dynamics GP Consultant with Olympic Software. After 15 years of working with the end user all the way from designing the solution to user training, she has become a Dynamics GP expert. Heather regularly shares her knowledge, including tips and tricks for end users in her blog articles. Follow her on Twitter @HRoggeveen to be notified of her latest articles. You can also like Olympic Software on Facebook or follow us on LinkedIn or on Twitter @OlympicSoftware. For more information about Dynamics GP and how it could benefit your business, view the Dynamics GP page on our website or give us a call, 09-357 0022.