Why do I have no VAT due on Sales

Picking up on this specifically, the MTD guidelines do allow for manual adjustments to implement things like retail scheme or partial exemption corrections that by their nature can only be calculated out at the end of the quarter/year. See “example 7” at VAT Notice 700/22: Making Tax Digital for VAT - GOV.UK