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