Can I confirm if you are using the Cash-based or Standard VAT scheme? You can check which you have this set to by going to Taxes > Edit VAT > Edit settings.
If you have this set to cash then only transactions that are marked as paid within your open return period will be accounted for.
