Help us improve

I programmed an new Excel macro that would give you a report to easily review the VAT transactions.

I attach a screenshot and the instructions. Unfortunately, I can't directly upload to the Canvas as an Excel file with programming code is rejected.

If you interested, leave a message and I will organise to email it to you.

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!!

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.

z

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

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?

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

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

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