Sage 200 UKI Ideas Portal

Improve Excel VAT Transactions Report

The current VAT Transactions report (Excel) records the VAT on Sales Invoices as a positive amount, rather than as a negative amount and Sales Credits as negatives instead of positives so that the cumulative total differs from the VAT return. Can this be amended so that purchase invoices remain as a positive figure and purchase credits as a negative but sales invoices appear as a negative value and sales credits as a positive value so that the cumulative total for all transactions matches the VAT return

  • David Waller
  • Feb 7 2024
  • Idea Accepted - Gauging Support
Idea Benefit To produce an annual VAT transactions list that matches the VAT claims made during the financial year
How do you solve for this problem today? Identify all the sales invoices and credits in the list and reverse the signage from positive to negative. Time taken depends on the volume of transactiions and time taken to download the data so that it is not affected by the piot table
Product Variant Sage for Education
  • Rabea Begum commented
    13 Feb 02:11pm

    This is definitely needed.

  • Samia Hussain commented
    13 Feb 02:03pm

    This will be very useful

  • David Waller commented
    8 Feb 10:44am

    It is in the Excel reports section and is titlled "VAT Transactions.xlsx"

    Does that help?

  • Admin
    Jo Kirkup commented
    8 Feb 09:13am

    thanks for the idea, please can you clarify the name of the report you are looking to change?