Sage Line 50 - VAT

[johnamber]

When I print my VAT return Box 4 contains a figure for tax reclaimed.
If I then print the VAT report (Summary) this figure matches the figure on the return
However, when I print the VAT report (Detailed) a single credit note and no purchases invoices appear.
If I print my sales invoices for the same period the figure is quite different from that on the VAT return?
I would appreciate any help

[johndon68]

When you ran the VAT Return, did it mention transactions before the period that had not been reconciled?

John

[johnamber]

Many thanks for your response. I am sorry for not replying earlier - I have been away.
Well, we reconcile everything when we do the VAT return each quarter.
The puzzle with this is that on the VAT Return we have one figure for Box 4. On the VAT Report (summary) the figure is the same but when we print the VAT Report (detailed) only one credit note and no purchase invoices appear. The figure there for Box 4 is just the amount of this single credit note.
If you have any ideas it would be very much appreciated. This was discovered during a VAT inspection and, on the face of it, it seems that we have seriously underpaid for this quarter

[Tom Egerton]

From your two posts, I'd suspect that it's likely to be you rather than Sage that's made the error. I've never known the detailed VAT report (which is effectively an audit trail of every entry for the quarter) be different to the summary or the actual return.

This presupposes that you printed the three reports concurrently. We don't know whether you've "reconciled" the entries for the particular quarter - if so these entries cannot be altered or included again in any future period.

It depends upon the size of your company but I'd revert to the nominal ledger account numbers 2200 (output tax) and 2201 (input tax) and attempt to tick your way out of trouble.

It's always useful to produce a dummy return from the start of the next period to date in order to compare with the nominal ledger.

[johnamber]

Thank you very much for this.
We are small company and I am sure you are right that it is us rather than Sage who are at fault. However, it does seem strange that you can print these reports at the same time and yet get different figures for the same VAT Box 4. I would have thought that would have been impossible.
Anyway, we will do as you sugest and get stuck into the VAT nominal account 2201 and 2202.
Thanks, once again. Your help is much appreciated.

[sheelagh]

I recently came across a similar error in VAT reports on Sage. The total in Box 1 in the VAT 100 was different to the total for Box 1 on the detail report. I haven't had the opportunity to look into this in detail - the number of transactions was small enough for us to check it manually. We found that several sales invoices had been omitted from the details report although the total on the VAT 100 included those invoices.
In the past I have noticed that the grand totals in the details report are incorrect. For example Sage might add a SC to the total, rather than subtract it. In all cases I have found the VAT 100 report to be correct.
The details report is not, in my opinion, to be trusted unconditionally.