Choose the verification checks you want to useBy default all available checks run automatically, but if there are any checks you don't need, it's easy to choose which checks are run.
- In Sage 50 Accounts click VAT, then click VAT Return.
- In VAT Verification Settings select or clear the check boxes as required, then click OK.
 TIP: v28.1 and above - You can use the Select all and Clear buttons to add or remove ticks to all boxes.
You can find out more about each check, and how to correct any issues found, in the Verification checks available section.
View the verification check results- Within your VAT Return click Calculate.
- On the Reconcile VAT Return window click View results.
- To view any potential issues, to the right of the relevant check, click View.
You can find out more about each check, and how to correct any issues found, in the Verification checks available section.
Verification checks availableTo find out more about each check and how to correct any issues found, choose the options below:
Identify possible duplicate transactions Checks for transactions with a matching account reference, date, reference, nominal code, net value, tax code and VAT value. To resolve these: | If the transactions aren't duplicates | If you are confident they have been entered correctly you can ignore this warning, click Close then check any other warnings in the Verification results summary or click Close again to continue with your VAT Return. | | If the transactions are duplicates | You can either delete or reverse one of the transactions. - Close out of the VAT Return.
- Click Transactions, select the transaction to delete or reverse, then click Delete. Read more >
Once you have deleted or reversed the transactions you must then recalculate the VAT Return to update the values. |
Identify Invoices or Credits which have not been updated Checks for all invoices and credits which you've created through Invoicing but which haven't been updated yet. To resolve these: | If you don't want to update these | Click Close then check any other warnings in the Verification results summary or click Close again to continue with your VAT Return. | | If you need to include these in your VAT Return | You can update the invoices to include them on your VAT Return. - Close the VAT Return.
- Click Invoices and credits, select the required invoice or credit then click Update ledgers.
Once you have updated the required invoices or credits to include these values you must then recalculate the VAT Return. |
Identify Purchase Orders which have been delivered but not invoiced Sage 50 Accounts Professional and above - Checks for delivered purchase orders which are in the Purchase orders window but haven't been updated yet. To resolve these: | If you don't want to update these | Click Close then check any other warnings in the Verification results summary or to continue with your VAT Return, click Close again. | | If you need to include these in your VAT Return | - Close the VAT Return.
- Click Purchase orders, select the required order then click Update ledgers. Read more >
Once you have updated the required orders to include these values you must then recalculate the VAT Return. |
Identify transactions with a VAT value, where the Tax Code is not included on the VAT Return This checks for transactions which have a tax code which is not included on the VAT Return, therefore the values on the transaction are not included. To resolve these: | If the tax code should be included in the VAT Return | Close the VAT Return and then change the tax code in: - Settings, Configuration, in the Tax Codes tab. Read more >
| | If the transaction should not have a VAT value | You can either delete, amend or reverse the transactions: - Close out of the VAT Return.
- To delete or reverse a transaction, click Transactions, select the transaction to delete or reverse, then click Delete.
To amend a transaction, click Transactions, select the transaction to amend, then click Edit.
Read more > |
Once you have either amended the tax code or deleted or reversed the transactions, to update the values you must then recalculate the VAT Return. Check VAT values on transactions for possible errors Checks for transactions where the VAT value is more or less than you expect it to be. The transactions that appear depend on which percentages you enter in the VAT Verification Settings. To resolve these: | If the values are correct | You can ignore this warning, click Close then check any other warnings in the Verification results summary or to continue with your VAT Return click Close again. | | If the values are incorrect | You can either delete, amend or reverse the transactions: - Close out of the VAT Return.
- To delete or reverse a transaction, click Transactions, select the transaction to delete or reverse, then click Delete.
To amend a transaction, click Transactions, select the transaction to amend, then click Edit.
Read more > |
Once you have deleted, amended or reversed the transactions, to update the values you must then recalculate the VAT Return. Identify sales and purchase transactions not using your most common Tax Code Checks for sales and purchase transactions that don't use your most common tax code. You can specify your most common tax code within the VAT Verification Settings. To resolve these: | If the tax codes are correct | You can ignore this warning, click Close then check any other warnings in the Verification results summary or to continue with your VAT Return, click Close again. | | If the tax codes are incorrect | You can either delete, amend or reverse the transactions. To do this: - Close out of the VAT Return.
- To delete or reverse a transaction, click Transactions, select the transaction to delete or reverse, then click Delete.
To amend a transaction, click Transactions, select the transaction to amend, then click Edit.
Read more > |
Once you have deleted, amended or reversed the transactions, to update the values, you must then recalculate the VAT Return. Identify journal transactions where the Tax Code is not selected as non-vatable This checks what your non-vatable Tax Code is in Company Preferences and identifies all journals that don't use this Tax Code. To resolve these: | If the tax codes are correct | You can ignore this warning, click Close then check any other warnings in the Verification results summary or to continue with your VAT Return, click Close again. | | If the non-vatable tax code is incorrect | You can change this within Settings, Company Preferences on the VAT tab. Read more > | | If the tax codes are incorrect | Close the VAT Return then delete the journals and re-post them with the correct tax codes. Read more > |
Once you have corrected the non-vatable tax code or the journals you must then recalculate the VAT Return to update the values. Identify possible incorrect EC transactionsSelect this to check for transactions using an EC tax code where the customer or supplier record doesn't have all the correct EC information. For example, the customer record may not have a VAT registration number. To resolve these:  NOTE: If these transactions are incorrect this may also affect your EC Sales List.
| If the tax code is correct | You must check the customer or supplier record to ensure the correct country and VAT number have been entered. | | If the tax code should not be an EC tax code | You can change this within Settings, Configuration, in the Tax Codes tab. Read more > | If the tax codes are incorrect on the transactions
| You can either delete, amend or reverse the transactions. To do this: - Close out of the VAT Return.
- To delete or reverse a transaction, click Transactions, select the transaction to delete or reverse, then click Delete.
To amend a transaction, click Transactions, select the transaction to amend, then click Edit.
Read more > |
Further informationSage 50 Accounts has a range of audit tools available to help you check your accounts are correct. Read more > There are extra reports you can run outside of the VAT Return to help reconcile the values. Read more >
[BCB:191:UKI - #GetMoreFeedback:ECB]
|