Built from inside practice. Built by Mr H Hammad FCCA, ACA, ICAEW Chartered Accountant with over 20 years in practice.
ProductFor ClientsClient PortalResourcesWhy BalansixPricingSupportBook a demoLogin
BalansixVAT

Why is a transaction missing from the VAT return?

Troubleshoot a transaction missing from a Balansix VAT return by checking VAT dates, scheme, source records, settlement status and submitted-period locks.

VAT
Short answerWhat to checkWhy it happensStepsFAQs

Short answer

A transaction appears on a VAT return only when its VAT treatment, effective date and scheme rules place it in that open period. Under Cash VAT, the relevant settlement may also need to exist before VAT is released.

What to check first

Work through these before changing the accounting recordConfirm the client is VAT registered for the transaction period.Check the VAT rate and tax treatment on the accounting source.Check the VAT effective/tax point date used by the workflow.For Cash VAT, check whether the invoice has been settled and allocated.Check whether the expected VAT period is already submitted and locked.

Why this happens

VAT reporting is not driven only by the transaction’s accounting date. The applicable VAT scheme, source document, VAT effective date, settlement status and period locks all affect which return owns the VAT amount.

Steps to resolve it

  1. Open the source transaction and verify the VAT code/rate.
  2. Check the VAT date against the return period boundaries.
  3. If the client uses Cash VAT, review payment or receipt allocation.
  4. If the original return is already submitted, check whether the transaction correctly rolls into the next open return.
  5. Recalculate/refresh the open VAT return after correcting the underlying source where the workflow permits.

What to avoid

Keep the audit trail intact. Do not change a genuine transaction date or historic VAT registration date merely to force an item into the return you expected. Correct the underlying fact or use the appropriate adjustment process.

Frequently asked questions

Why is an invoice not in a Cash VAT return?

Cash VAT generally depends on settlement. If the invoice has not been paid or received or the settlement has not been allocated, VAT may not yet be released.

Why did a late transaction move to the next VAT return?

Once a VAT period is submitted and locked, later entries that belong to closed history should not silently change the filed return. Balansix carries eligible late items into the next open period according to the workflow.

Could the VAT registration date be the cause?

Yes, if the transaction falls outside the client’s VAT registration position. The historic registration date should remain accurate rather than being changed to fit a current return.

Still need help?

Contact Balansix Support with the client, module, period, what you expected and what happened. Avoid sending passwords or unrelated client secrets.