Sage 200 UKI Ideas Portal
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
| 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 |
This is definitely needed.
This will be very useful
It is in the Excel reports section and is titlled "VAT Transactions.xlsx"
Does that help?
thanks for the idea, please can you clarify the name of the report you are looking to change?