Power BI and Making Tax Digital - HMRC APIs to file VAT returns directly from Power BI

[Amit_Dev]

Hi Power BI experts!

I have an interesting one and was wandering whether someone has already explored this question. The tax authorities in the UK (HMRC) have recently implemented the requirement to file VAT returns under Making Tax Digital ('MTD'). This means that businesses need to file their VAT return using software that can call upon HMRC's newly issued RESTful + XML APIs.

Curious to understand whether MS/anyone in the community have developed an MTD compliant 'brdige' that enables Power PI users to transmit the Box 1 to 9 (essentially 9 figures) to HMRC?

HMRC API spec: https://developer.service.hmrc.gov.uk/api-documentation/docs/api

HMRC MTD software already available, most bridging software type are Excel based: https://www.tax.service.gov.uk/making-tax-digital-software?_ga=2.9763127.34125654.1600338769-1351632...

I feel this would be a game changer for a number of businsses if you could have all your VAT data analytics in API and then could submit directly from Power BI : )

Great to get your thoughts on this.

Thanks,
Amit

[PhilipTreacy]

Hi @Amit_Dev 

You're welcome.

If my reply answered your question please mark it as the solution.

regards

Phil

[PhilipTreacy]

Hi @Amit_Dev 

PBI is for getting data and reporting on it, not for submitting data to systems so I'm afraid it wouldn't be able to do this.

regards

Phil

[Amit_Dev]

Thank you for your response, this is much appreciated.