Thanks to the community help I have been able to pull the VAT figure from Trial Balance using the API.
I am able to pull the correct figure for the period 1st April 2021- 29th June 2021 however, I am not able to get the correct figure for the current period 30th June 2021 - 30 September 2021.
The figure returned is a positive of the previous period i.e -£20,000 is +£20,000
The previous figure has not been paid as it’s due in August. How can I correctly retrieve the current period’s Tax in the same way?
Any help is greatly apopriciated.