How can I check the VAT values are correct on my transactions?
Description

You can use the Tax values audit option to check the VAT amounts on your transactions. For the date range you enter, it lists transactions where the actual VAT amount is different to the expected VAT amount.

Cause
Resolution
  1. Click VAT then click Tax values audit.
  2. Enter the date range you want to check, then click OK.

    Sage 50 Accounts calculates the expected amount by applying the tax code percentage to the net amount.

  3. To allow for slight differences, enter a percentage tolerance in the VAT rounding tolerance % box.

    TIP: The percentage you enter applies to the VAT amount. For example, if the net amount is 1000.00 and the VAT rate is 20%, the expected VAT is 200.00. If you enter a tolerance of 10%, the VAT amount can be in the range 180.00 to 220.00. If the VAT amount is outside this range, the transaction appears in this window.

  4. If required, to print the transaction list click Print list, or to send the list to Microsoft Excel, click Send to Excel.

Sage 50 Accounts has a range of audit tools available to help you check your accounts are correct. Read more >

[BCB:97:Limitless - 50 Accounts - VAT:ECB]


Steps to duplicate
Related Solutions