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