Help us improve

VAT Report Layout

Please can you do a proper report for the VAT. When I send it to Excel, I have to spend loads of time to make it presentable.
  • Elrè Woods
  • Jan 10 2017
  • Released
  • Nov 5, 2018

    Admin Response

    This report will be updated as part of our MTD VAT and VAT Improvements work which is planned for release in December. 

  • Attach files
  • Andrew Lowe commented
    January 10, 2017 09:17

    I agree on this, could it be styled like the new management accounts, this could show a clear breakdown between Sales and Purchases

  • andrew commented
    January 10, 2017 09:17

    I agree, nominal codes to be shown as well as supplier code. NET, VAT and Gross columns should also be shown.

  • John Biggs commented
    July 19, 2017 20:50

    No please don't put formatting into the Excel file!

    In its current format its great for analysing etc and formatting would mess this up.

    If we need more "presentable" reports then lets have these but lets not put formatting into the Excel download

  • John Biggs commented
    February 02, 2018 11:32

    looking at comments it would appear we need 2 reports;

    1. A pretty formatted summary report that can be emailed to clients

    2 The current unformatted report with some extra data fields for analysis - and importantly without additional formatting in this report that would then make analysis difficult

  • John Biggs commented
    July 03, 2018 12:35

    Please do not put formatting into the excel download as it will then need to be unformatted in order to be worked with. there is a print option if you want a pretty summary. A data download should be exactly that

  • John Biggs commented
    October 05, 2018 16:03

    please be very careful with this. the reason most people will want to download to excel will be to do sense checks and calcs. Formatting can make this very difficult. If we want a pretty report then perhaps the output should be going to word or PDF option and we shouldn't really be messing with the excel version?

  • John Biggs commented
    October 05, 2018 16:06

    while we are looking at this would be useful if we also have the no VAT or N/A codes shown ie the VAT status of all transactions not just those that have an impact on the VAT return

  • G B commented
    November 04, 2018 16:30

    z

  • G B commented
    November 08, 2018 08:23

    I'm aware this is probably going to be out of date after the updated report in December.

    If anyone has Excel, this macro will automatically format the detailed CSV report created by Kashflow.

     

  • Guest commented
    10 Feb 11:57

    The new detailed report whilst very pretty is absolutely useless for anything.

    The old report whilst needing a little tweak in excel to get in a printable state was very good. One client was 5 pages last quarter, the new report 24 pages!

    The main problem is not having net and VAT for inputs and outputs side by side, this is essential for checking the VAT return but impossible on the new improved" report.

    I sometimes wonder if bookkeepers or accountants have any input in the design process!

    I know with MTD VAT figures need to be locked down, but if you notice a transposed invoice number or misspelt description you can no longer amend short of raising a credit and re-entering the invoice, so much for progress and MTD making businesses more efficient!!