Recently I switched on the VAT Calculation service. I read all the pros and cons from various posts on these forum and was prepared for extra difficulties when it comes to reconcile. Thought I’d figure it out but I am stumped! How do you reconcile the VAT Calculations report against the fortnightly disbursement?
Missing settlement id
Before, I’d simply run a date range report which crucially included ‘settlement id’. This was by far the easiest way to reconcile. All the entries under that one settlement id would tally up perfectly to the disbursement figure. Unfortunately settlement is not included in the VAT Calculations report.
No time stamp
I thought I’d try grouping all entries together via date and time stamp to match that of disbursement, but no time stamp is included within VAT Calculations report either. As disbursements are at random times, for example Oct 31, 2019 10:27 - Nov 14, 2019 10:27, without time stamp I cannot simply sum the totals from Oct 31 to Nov 14 as it will include some sales within that sum that shouldn’t be there and therefore won’t reconcile correctly.
How then do you reconcile using the VAT Calculations report please?