I was wondering how to do a VAT reconciliation - Is there an easy way to do this? From what I understand you are comparing what is in the vat control account compared to the vat which has been submitted to HMRC? (After googling) Is there any easy way to contrast and compare the data in excel?
I did ask my manager how to do this, however they suggested taking the figure due per the return and balancing the remaining with a directors loan account irrespective of what the trial balance VAT control account says. I feel this is massively wrong and inflating a directors loan account without actual justification.