About this tool
What it does
The VAT return checker reads a CSV export of a ledger or VAT report and lists the lines worth a second look before the return goes in. It looks for VAT claimed where there is normally none, such as insurance, bank charges and train fares, and for blocked claims such as business entertainment and cars.
It also finds sums that do not add up, VAT that does not match the rate, possible duplicates, one supplier treated two ways, and lines dated outside the period. It runs in your browser and the export is never uploaded. It does not replace a review, and it is not tax advice.
How to use it
- Export the ledger or VAT report for the period as a CSV.
- Drop the file in, or press Try a sample.
- Open each group to read its lines and the reason given.
- Download the list as a CSV, then check each line against its invoice.
Questions
- Is my ledger uploaded?
- No. The file is read by your own browser. Nothing is sent anywhere and the contents are never stored.
- Does a flag mean the line is wrong?
- No. A flag means the line is worth a second look. Many flagged lines will turn out to be right.
- Which exports does it read?
- A CSV with a date, a supplier or description, and the net, VAT or gross amounts. It finds the columns by their headings, and you can correct what it picks. Save an Excel file as CSV first.
- Does it replace a review of the return?
- No. It is a first pass that finds common slips. Someone who knows the business should still review the return.