vat on sage

vat on sage

Didn't find your answer?

I have asked a new client for copies of the vat calculations as they are on cash accounting and run a customers and suppliers ledger and i cannot get the final calculations of vat still on codes 2200 and 2201 to tie up with the unpaid creditors and debtors.  The client has never run off the detailed copies of the sage vat returns, only the summary copies which are useless as they do not detail which invoices have been paid.  I presume the vat office will not also be happy in an inspection as they will have the same problem..The are using version 14, is there anyway i can get them to print off copies now after the vat reconciliations to see what was in each return

Replies (6)

Please login or register to join the discussion.

avatar
By wood2207
15th Jun 2011 13:52

Manage VAT function

If they are on Version 14 they should be able to see the old VAT returns by using the 'Manage VAT' facility.

This can be found by clicking on Company on the left hand side and then selecting Manage VAT from the panel at the top of the left hand side.  This will only show VAT returns which have been reconciled since they have been on this version and not any older versions.

 

Thanks (0)
avatar
By chancewind
15th Jun 2011 16:16

vat on sage

No they must have used an early version and i cannot find any info. on this manage vat.  I have found a large error in that they used the previous quarters figures in the next vat return and the vat man owes them plenty.  I have the summary figures for each return and have printed out the customers receipts summary for each quarter hoping that they would tie up with the vat returns but they do not.  I have approx 1900 debit difference on the vat codes on sales of 220,000.  Any bright suggestions.                         

Thanks (0)
avatar
By wood2207
15th Jun 2011 16:33

trying using Financials

If there is no info in the Manage VAT section you could try using the audit trail in Financials.  Depending on the version they are using you should have a column which says VAT rec Date.  If you export the data to excel you can sort by this column and effectively produce a report showing the entries on the return, but it is a bit long winded (you will need to watch out for debit, credits and deleted items!).

Hope this helps.

Thanks (0)
avatar
By Gouldn2me
15th Jun 2011 16:41

Financials and Export to Excel

If the client has reconciled when they produced the VAT report, they should be able to reproduce a transaction listing using the Financials section.

If you sort the financials by VAT Rec Date and then send to excel (under "File" menu"), you should be able to re sort in Excel for each VAT period.

Thanks (0)
avatar
By Nadine
15th Jun 2011 17:00

Rerun the report

Why not rerun the quarterly returns to include reconciled transactions for the period. You should then be able to print the detailed report.

The only drawback is that if the client has entered transactions that refer to an earlier period they will show on the earlier period return but, at least, you may be able to pick these up from the reports.

Also, if the VAT return wizard hasn't been run to transfer the sales & purchase VAT to n/c 2202, then 2200 and 2201 won't agree.

Thanks (0)
avatar
By chancewind
15th Jun 2011 17:53

vat on sage

Yes i have managed to reconcile the whole year in one go by running off the day book customers receipts, credit card payments, bank payments and suppliers they balance within £150 for the year, however i still have the estimated £1900 debit balance after allowing for unpaid debtors and creditors on codes 2200, 2201 and the final vat payment on 2202, it must have been from previous years.

Thanks (0)