How to Reconcile Box 6 (Total Value of Sales and other supplies excluding VAT)

Modified on Mon, 8 Dec at 2:51 PM

Box 6 reconciliation requires isolating Output figures from your VAT report and adjusting for Margin Scheme transactions.
Step 1: Configure the Full VAT Report
1. Run the complete VAT return report in your system.
2. Enable Filtering by Type: Click and drag the column header for the word "TYPE" up into the grey bar immediately above the report grid. This allows you to filter the data separately.
3. Filter to Outputs Only: Close the filter for all Inputs (purchase transactions). Ensure only Outputs (sales transactions) remain visible.
Step 2: Calculate Box 6 Value
The Report Turnover includes your Margin Scheme VAT, which must be removed. Use the following simple calculation:
1. Take the Report Turnover (the total turnover value displayed on the filtered report).
2. Subtract the total Margin Scheme VAT (the figure displayed on the right-hand side of the report).
3. The resulting figure should equal the value shown in Box 6 on your official VAT return.