Skip to content

VAT Report Documentation

Menu Location: Reports > Financial > VAT Report

Access Level: Administrator and above

Last Updated: 2026-03-01

Overview

The VAT (Value Added Tax) Report provides comprehensive tax reporting for businesses operating in VAT jurisdictions. This compliance-focused report calculates VAT collected, tracks tax rates applied, and generates data required for VAT return filing with tax authorities.

Primary Functions:

  • Calculate total VAT collected by period
  • Track VAT by rate (standard, reduced, zero-rated)
  • Generate VAT return data for tax filing
  • Analyze VAT by product category or customer location
  • Reconcile VAT accounts
  • Export VAT data for accounting systems

Page Layout

Header Section

  • Date Range Filter: Tax period (typically monthly or quarterly)
  • VAT Rate Filter: Standard rate (20%), Reduced (5%), Zero-rated
  • Customer Location: Domestic vs International
  • Export Formats: VAT Return Format, Detailed CSV

Main Content Area

Summary of VAT collected with breakdowns by rate, category, and location. Detailed transaction list below summary.

VAT Summary Panel

  • Total Net Sales (before VAT)
  • Total VAT Collected
  • Breakdown by VAT rate
  • VAT Return Summary (Box 1-9 format if UK)

Report Data & Columns

Column Description
Transaction Date When order placed/invoiced
Order ID Order reference
Customer Customer name
Customer Location Country/region
Net Amount Sale amount before VAT
VAT Rate Percentage applied (0%, 5%, 20%)
VAT Amount Tax collected
Gross Amount Total including VAT
Product Category Item category (affects VAT rate)
VAT Treatment Standard, Reduced, Zero-rated, Exempt

Common Use Cases

Use Case 1: Quarterly VAT Return Filing

Goal: Generate VAT return data for tax authority submission

Steps:

  1. Set date range to VAT quarter (e.g., Jan 1 - Mar 31)
  2. Run report
  3. Note VAT Summary figures:
    • Box 1: VAT due on sales
    • Box 4: VAT reclaimed on purchases (manual entry)
    • Box 5: Net VAT due (Box 1 - Box 4)
    • Box 6: Total value of sales (net)
    • Box 7: Total value of purchases (manual entry)
  4. Export report for records
  5. File VAT return with tax authority
  6. Retain report for 7 years (UK requirement)

Example: Q1 2026 VAT Return:

  • Box 1 (VAT on sales): £42,350
  • Box 6 (Net sales): £211,750
  • File by April 30, pay by May 7

Use Case 2: Monthly VAT Reconciliation

Goal: Verify VAT figures for monthly management accounts

Steps:

  1. Set date range to calendar month
  2. Review total VAT collected
  3. Compare to accounting system VAT account balance
  4. Investigate discrepancies:
    • Orders in different months
    • Refunds/credits
    • Manual adjustments
  5. Document reconciliation
  6. Adjust accounting entries if needed

Use Case 3: Product Category VAT Analysis

Goal: Ensure correct VAT rates applied by product type

Steps:

  1. Group by product category
  2. Review VAT rate for each category
  3. Verify:
    • Food products: Zero-rated or reduced
    • Supplements: Standard rate
    • Books: Zero-rated (UK)
    • Digital goods: Standard rate
  4. Identify any incorrect categorizations
  5. Correct product VAT settings
  6. Adjust past transactions if needed

Use Case 4: International vs Domestic Sales Split

Goal: Report domestic and international sales separately

Steps:

  1. Filter to domestic customers
  2. Note VAT collected
  3. Filter to EU customers (if applicable)
  4. Note VAT treatment (reverse charge, etc.)
  5. Filter to non-EU international
  6. Note zero-rated exports
  7. Complete VAT return boxes accordingly

Example:

  • UK sales: £180,000 + £36,000 VAT (standard rate)
  • EU sales: £25,000 (reverse charge, no VAT)
  • Non-EU exports: £15,000 (zero-rated, no VAT)

Use Case 5: VAT Audit Preparation

Goal: Prepare for tax authority VAT audit

Steps:

  1. Export VAT reports for all audited periods
  2. Print or save PDFs for documentation
  3. Prepare reconciliation to bank payments
  4. Document any unusual transactions
  5. Organize by tax period
  6. Prepare explanations for:
    • Large refunds
    • Rate changes
    • Zero-rated sales
  7. Provide to auditors upon request

Troubleshooting

VAT Total Doesn't Match Bank Payments

Explanation: VAT collected on sales ≠ VAT paid to tax authority. Must subtract VAT reclaimed on purchases. Also timing: collected in one period, paid in next.

Some Products Show Wrong VAT Rate

Solutions:

  1. Check product VAT settings
  2. Verify product category VAT rules
  3. Update product VAT rate
  4. Run VAT report again to verify
  5. Manual adjustment for past transactions if needed

Report Shows Zero VAT for All Orders

Check:

  1. Verify VAT enabled in system settings
  2. Check if all customers marked as VAT-exempt
  3. Ensure VAT calculation not disabled
  4. Review tax configuration with administrator
  • Tax Settings - Configure VAT rates and rules
  • Product Catalog - Set product VAT categories
  • Customer Tax Settings - Manage customer tax exemptions
  • Order Detail - Review individual order VAT calculations

Permissions & Access

Required Access Level: Administrator or higher

Best Practices

Compliance

  1. Run VAT report for every tax period
  2. File returns on time (avoid penalties)
  3. Retain reports for required period (typically 7 years)
  4. Document unusual transactions
  5. Reconcile monthly, file quarterly

Accuracy

  1. Verify product VAT rates regularly
  2. Check new products have correct VAT category
  3. Review cross-border transactions carefully
  4. Audit high-value transactions
  5. Reconcile to accounting system monthly

Record Keeping

  1. Export and save report for each tax period
  2. Document all adjustments
  3. Keep evidence for zero-rated sales (export documents)
  4. Maintain audit trail
  5. Backup reports securely

Quick Reference Card

Task Action
Quarterly VAT return Date: Quarter dates, export summary
Monthly reconciliation Date: Last month, compare to accounting
Check VAT by rate Group by VAT rate
Domestic vs international Filter by customer location
Product category check Group by product category
Export for accountant Apply filters, export CSV
VAT audit prep Export all periods, organize by quarter

FAQs

Do I need this if not in UK/EU?

No - VAT is UK/EU tax system. US businesses use sales tax (different report). Check your tax jurisdiction.

What's the difference between zero-rated and exempt?

Zero-rated: 0% VAT charged, can reclaim VAT on inputs Exempt: No VAT charged, cannot reclaim VAT on inputs Zero-rated is better for business.

Can customers see VAT on invoices?

Yes, if VAT is enabled and customer requires VAT invoice, it shows as separate line item.

What if I made a mistake on previous VAT return?

Contact tax accountant. May need to file correction or adjust current return. Don't ignore errors.

Do refunds affect VAT?

Yes - refunded orders reduce VAT liability. Should appear as negative VAT in report for refund period.

Change Log

2026-03-01

  • Initial documentation created

End of Documentation

For additional help, contact your system administrator or Kiva Logic support.