Solution Properties
Solution ID:
200929130445480
Last Modified Date:
Fri Nov 05 20:22:23 UTC 2021
Taxonomy Path:
Case category//How do I...//processing
Author:
[email protected]
What VAT verification reports are available?
Description

[BCB:42:CSat FB drive:ECB]

Run the Verification reports
  1. On the navigation bar click either Transactions or VAT, then click Verification reports.
  2. Browse to the required report, then click Preview.

For more information about the reports available, please refer to the following sections.

 

Accounts Verification Reports
Report folder Description What it shows Also available in
Bank Reports Bank Report - Reconciled & Unreconciled (by Transaction Type) All bank transactions grouped by transaction type. Not available elsewhere.
Financials (Audit Trail) Reports Audit Trail (Deleted Transactions) All deleted transactions. Company > Financials > Audit.
Products (Stock) Reports Product Valuation (Average Cost Price) The product valuation based on the average cost price. Products > Reports > Product Valuation Reports.
Product Valuation (Last Purchase Price) The product valuation based on the last cost price. Products > Reports > Product Valuation Reports.
Sales & Purchases Reports Time Taken To Pay Sales Invoices How long it has taken to pay each invoice and the average number of days. Customers > Reports > Credit Control Reports.

 

VAT Audit Reports

Standard VAT Scheme Reports

Report folder Description What it shows Also available in
Bank Reports Day Books: Bank Payments (Detailed) Net, tax and gross amounts of bank payments (BP). Bank > Reports > Bank Payments Reports.
Day Books: Bank Receipts (Detailed) Net, tax and gross amounts of bank receipts (BR). Bank > Reports > Bank Receipts Reports.
Day Books: Cash Payments (Detailed) Net, tax and gross amounts of cash payments (CP). Bank > Reports > Cash Payments Reports.
Day Books: Cash Receipts (Detailed) Net, tax and gross amounts of cash receipts (CR). Bank > Reports > Cash Receipts Reports.
Day Books: Credit Card Payments (Detailed) Net, tax and gross amounts of credit card payments (VP). Bank > Reports > Credit Card Payments Reports.
Day Books: Credit Card Receipts (Detailed) Net, tax and gross amounts of credit card receipts (VR). Bank > Reports > Credit Card Receipts Reports.
Customer (Sales) Reports Day Books: Customer Credits (Detailed) Net, tax and gross amounts of sales credits (SC). Customers > Reports > Day Book Reports.
Day Books: Customer Invoices (Detailed) Net, tax and gross amounts of sales invoices (SI). Customers > Reports > Day Book Reports.
EC Sales List (Standard VAT) T4 sales invoices (SI) and sales credits (SC). Customers > Reports > EC Sales Reports.
Invoicing Reports IntraStat SSD Information (Invoicing) (Standard VAT)

Intrastat supplementary declaration.

You cannot use this report to complete the Intrastat supplementary declaration. For further information about this, please refer to article .

 Not available elsewhere.
IntraStat SSD Information (Invoicing) - Detailed

Intrastat supplementary declaration.

You cannot use this report to complete the Intrastat supplementary declaration.

 Not available elsewhere.
Nominal Reports Day Books: Nominal Ledger All journal transactions (JC / JD). Company > Nominal Ledger > Reports > Day Book Reports.
Nominal Activity All transactions grouped by nominal code. Company > Nominal Ledger > Reports > Nominal Activity Reports.
Purchase Order Reports IntraStat SSD Information (POP) (Standard VAT)

Intrastat supplementary declaration.

You cannot use this report to complete the Intrastat supplementary declaration. For further information about this, please refer to article .

Not available elsewhere.
IntraStat SSD Information (POP) - Detailed

Intrastat supplementary declaration.

You cannot use this report to complete the Intrastat supplementary declaration.

 Not available elsewhere.
Sales Order Reports IntraStat SSD Information (SOP) (Standard VAT)

Intrastat supplementary declaration.

You cannot use this report to complete the Intrastat supplementary declaration.

 Not available elsewhere.
IntraStat SSD Information (SOP) - Detailed

Intrastat supplementary declaration.

You cannot use this report to complete the Intrastat supplementary declaration.

 Not available elsewhere.
Supplier (Purchase) Reports Day Books: Supplier Credits (Detailed) Net, tax and gross amounts of purchase credits (PC). Suppliers > Reports > Day Book Reports.
Day Books: Supplier Invoices (Detailed) Net, tax and gross amounts of purchase invoices (PI). Suppliers > Reports > Day Book Reports.
EC Purchases List (Standard VAT) T7 and T8 purchase invoices (PI) and purchase credits (PC). Suppliers > Reports > EC Purchase Reports.

 

Transaction Analysis Reports

Report folder Description What it shows Also available in
Bank Reports Bank, Cash and Credit Card Payments with VAT (by Nominal Code) Bank payment (BP), cash payment (CP) and credit card payment (VP) transactions where the VAT amount is not zero. Not available elsewhere.
Bank, Cash and Credit Card Receipts with VAT (by Nominal Code) Bank payment (BP), cash payment (CP) and credit card payment (VP) transactions where the VAT amount is not zero. Not available elsewhere.
Unreconciled Receipts

All receipt transactions (BR, CR, VR, SR, SA, JD) that are not bank reconciled.

This report excludes opening balance transactions.

 Bank > Reports > Unreconciled Transaction Reports.
Customer (Sales) Reports All Sales Transactions (VAT Cash Accounting) Sales transactions applicable to VAT Cash Accounting (SR, SA, BR, CR, VR). Not available elsewhere.
Outstanding Sales Invoices Over 6 Months Outstanding sales invoices (SI) where the transaction date is more than 6 months prior to the date that the report is run to. Customers > Reports > Customer Invoice Reports.
Sales for Tax Codes T9 - T99 Sales transactions (SI, BR, CR, VR) that use any tax code between T9 and T99. Not available elsewhere.
Sales with VAT rate less than 16% and Credits with VAT Rate more than 19%

Sales transactions (SI, BR, CR, VR) where the VAT amount is less than 16% of the net amount.

Sales credits where the VAT amount is more than 19% of the net amount.

 Not available elsewhere.
Un-Allocated Sales Credit Notes & Payments on Account Outstanding sales credits (SC) and sales receipts on account (SA). Customers > Reports > Customer Invoice Reports.
VAT Only or High VAT Sales Credit Notes (VAT over £250.00) Sales credits (SC) with zero net amount or VAT amount over £250.00 Not available elsewhere.
Zero Rated EC sales to Customer with no VAT Registration Number

Customer transactions that use an EC Sales tax code and the Customer Record > VAT Registration Number is blank.

There are two copies of this report. One of these reports was intended for use in Ireland but they are actually identical.

 Not available elsewhere.
Zero Rated EC sales to Customer with no VAT Registration Number

Customer transactions that use an EC Sales tax code and the Customer Record > VAT Registration Number is blank.

There are two copies of this report. One of these reports was intended for use in Ireland but they are actually identical.

 Not available elsewhere.
Zero Rated Sales Invoices for Tax Codes T0 - T8 (Net over £500.00)

Sales transaction types SI, BR, CR and VR where:

  • The tax code is between T0 and T8.
  • The net amount is over £500.00
  • The VAT amount is zero.
 Not available elsewhere.
Zero Rates Sales with Address details (Net over £250 and Tax Code T0 - T8)

Sales invoices (SI) where:

  • The tax code is between T0 and T8.
  • The net amount is over £250.00
  • The VAT amount is zero.

This report includes the customer's address information.

 Not available elsewhere.
Financial Reports Deleted Transactions with VAT over £50 All deleted transactions where the VAT amount is over £50.00. Not available elsewhere.
EC Import Tax Report All transactions with tax code T7 or T8. Company > Financials > Reports > Tax Analysis Reports.
Forward Posted Taxable Transactions

All transactions where the transaction date is prior to the date that the transaction was entered.

There are two copies of this report. One of these reports was intended for use in Ireland but they are actually identical.

 Not available elsewhere.
Forward Posted Taxable Transactions

All transactions where the transaction date is prior to the date that the transaction was entered.

There are two copies of this report. One of these reports was intended for use in Ireland but they are actually identical.

 Not available elsewhere.
Journals without T9 Tax Code Journal transactions (JC / JD) where the tax code is not T9. Not available elsewhere.
T9 Journals (Nominal 2200 - 2202) T9 journal transactions (JC / JD) posted to nominal code 2200, 2201 or 2202. Not available elsewhere.
T9 Transaction Listing All transactions that use tax code T9. Company > Financials > Reports > Transaction Reports.
Tax Code Details Lists the details of all tax codes that have been used. Company > Financials > Reports > Miscellaneous Reports.
VAT only Transactions All transactions where the net amount is zero. Company > Financials > Reports > Tax Analysis Reports.
Fixed Asset Reports Fixed Asset Valuation The cost price, depreciation and book value of each fixed asset. Fixed Assets > Reports > Fixed Asset Valuation Reports.
Invoicing Reports Invoices Not Posted Lists all invoices that have not been updated. Invoicing > Reports > Invoice Details Reports.
Invoices Not Printed Lists all invoices that have not been printed. Invoicing > Reports > Invoice Details Reports.
Sales By Product (Detailed) Shows the quantity and value of sales invoices grouped by Product Code. Invoicing > Reports > Invoice Details Reports.
Nominal Reports Nominal List A list of all nominal codes and their names. Company > Nominal Ledger > Reports > Nominal Details Reports.
Product (Stock) Reports Products with T1 not set as default Tax Code Lists all products that do not have T1 set as the default tax code. Not available elsewhere.
Supplier (Purchase) Reports All non-Standard vatable Purchases and Credits

Purchase transaction types PI, BP, CP and VP where the VAT amount is more than 20% of the net amount.

Purchase credits (PC) where the VAT amount is less than 16% of the net amount.

 Not available elsewhere.
All Purchase Transactions (VAT Cash Accounting) Purchase transaction types applicable to VAT Cash Accounting - PP, PA, BP, CP and VP. Not available elsewhere.
Day Books: Supplier Invoices (Detailed) Net, tax and gross amounts of purchase invoices (PI). Suppliers > Reports > Day Book Reports.
High VAT Purchases (VAT over £1500) Purchase transaction types PI, BP, CP, VP and PC where the VAT amount is more than £1500.00. Not available elsewhere.
Non-Standard Rated Purchases (VAT over £50)

Purchase transaction types PI, BP, CP and VP where the VAT amount is more than £50.00 and more than 19% of the net amount.

Purchase credits (PC) where the VAT amount is more than £50.00 and less than 16% of the net amount.

 Not available elsewhere.
Outstanding Purchase Invoices Over 6 Months Outstanding purchase invoices (PI) where the transaction date is more than 6 months prior to the date that the report is run to. Suppliers > Reports > Supplier Invoice Reports.
Zero Rated Purchase Credits (by Account - Net over £500.00)

Purchase credits (PC) where the VAT amount is zero and the net amount is more than £500.00.

This report is grouped by supplier account.

 Not available elsewhere.
Zero Rated Purchase Credits (Net over £500.00) Purchase credits (PC) where the VAT amount is zero and the net amount is more than £500.00. Not available elsewhere.

 

VAT Cash Scheme Reports

Report folder Description What it shows Also available in
Bank Reports Day Books: Bank Payments (Detailed) Net, tax and gross amounts of bank payments (BP). Bank > Reports > Bank Payments Reports.
Day Books: Bank Receipts (Detailed) Net, tax and gross amounts of bank receipts (BR). Bank > Reports > Bank Receipts Reports.
Day Books: Cash Payments (Detailed) Net, tax and gross amounts of cash payments (CP). Bank > Reports > Cash Payments Reports.
Day Books: Cash Receipts (Detailed) Net, tax and gross amounts of cash receipts (CR). Bank > Reports > Cash Receipts Reports.
Day Books: Credit Card Payments (Detailed) Net, tax and gross amounts of credit card payments (VP). Bank > Reports > Credit Card Payments Reports.
Day Books: Credit Card Receipts (Detailed) Net, tax and gross amounts of credit card receipts (VR). Bank > Reports > Credit Card Receipts Reports.
Customer (Sales) Reports Day Books: Customer Receipts (Detailed) Net, tax and gross amounts of sales receipts (SR) and receipts on account (SA). Bank > Reports > Customer Receipts Reports.
EC Sales Invoice and Credits List (VAT Cash Accounting) Sales invoices (SI) and sales credits (SC) where the tax code is T4. Not available elsewhere.
EC Sales List (VAT Cash Accounting)

Sales receipts (SR) and sales receipts on account (SA) where the tax code is T4.

This report is incorrect. On VAT Cash Accounting, the EC sales list should include invoices and credits, not sales receipts.

 Not available elsewhere.
Nominal Reports Day Books: Nominal Ledger All journal transactions (JC / JD). Company > Nominal Ledger > Reports > Day Book Reports.
Supplier (Purchase) Reports Day Books: Supplier Payments (Detailed) Net, tax and gross amounts of purchase payments (PP) and payments on account (PA). Bank > Reports > Supplier Payments Reports.
EC Purchases Invoices and Credits List (VAT Cash Accounting) Purchase invoices (PI) and purchase credits (PC) where the tax code is T7 or T8. Not available elsewhere.
EC Purchases List (VAT Cash Accounting)

Purchase payments (PP) and payments on account (PA) where the tax code is T7 or T8.

This report is incorrect. On VAT Cash Accounting, the EC sales list should include invoices and credits, not sales receipts.

 Not available elsewhere.

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

 

[BCB:43:CSAT - Move feedback:ECB] [BCB:62:F1 Help Centre promo:ECB] [BCB:21:Sage Q&A live - Support message:ECB]