Viewing Transactions Generated for Spain Online VAT Register Reports

A saved search is made available for you to view information about the transactions included in any of the reports for Spain Online VAT register. You must modify the saved search to show transactions specific to Spain subsidiaries or nexuses.

To view or modify the saved search:

  1. Go to Lists > Search > Saved Search.

  2. On the Saved Searches page, click the Edit link next to any of the following searches:

    • ES TAF SII Issued Invoices

    • ES TAF SII Issued Invoices Rectification

    • ES TAF SII Received Invoices

    • ES TAF SII Received Invoices Rectification

    • ES TAF SII Cash Collections

    • ES TAF SII Investment Goods Register

    • ES TAF SII Intra-Community Transaction

    • ES TAF SII Transactions for Flagging

  3. Under the Criteria subtab, add filters on each of your saved search. See table below for the correct search filter values. For more information about adding a search filter, see Advanced Search Criteria Filters

    Filter

    Value

    Common Filters for Spain Online VAT Register Reports

    Nexus

    is Spain

    Subsidiary

    is the selected subsidiary

    Start Date

    Transaction date that is equal to or later than the date in the Period field

    End Date

    Transaction date that is equal to or earlier than the date in the To field

    Accounting Book

    applicable if MBA is enabled

    For ES TAF SII Issued Invoices

    Type

    is any of Cash Sale, Invoice

    Main Line

    is false

    Tax Line

    is false

    Tax Item

    is not none

    Intra-community Transaction Type (Custom Body)

    is none

    Approval Status

    is none of Pending Approval, Rejected

    Tax Item : Excluded From Tax Reports

    is false

    Registration Status (Custom Body)

    is none of Registered, Registered with errors

    Tax Rate

    is any of 0, 4, 10, 21, 5.2, 1.4, 0.5, 1.75

    For ES TAF SII Issued Invoices Rectification

    Type

    is any of Cash Refund, Credit Memo

    Main Line

    is false

    Type

    Journal

    Approval Status

    is none of Pending Approval, Rejected

    Account Type

    is Accounts Receivable

    Tax Line

    is false

    Tax Item

    is not none

    Tax Item : Excluded From Tax Reports

    is false

    Intra-community Transaction Type (Custom Body)

    is none

    Created From

    is not none

    Original Invoice (Custom Body)

    is not none

    Registration Status (Custom Body)

    is not Registered

    Tax Rate

    is any of 0, 4, 10, 21, 5.2, 1.4, 0.5, 1.75

    For ES TAF SII Received Invoices

    Type

    is any of Bill, Cheque, Credit Card

    Main Line

    is false

    Tax Line

    is false

    Tax Item

    is not none

    Amount (Credit)

    is not empty

    Memo

    starts with Non-Deductible Tax

    Intra-community Transaction Type (Custom Body)

    is none

    Approval Status

    is none of Pending Approval, Rejected

    Tax Item : Excluded From Tax Reports

    is false

    Registration Status (Custom Body)

    is none of Registered, Registered with errors

    Tax Rate

    is any of 12, 10.5, 0, 4, 10, 21, 5.2, 1.4, 0.5, 1.75

    For ES TAF SII Received Invoices Rectification

    Type

    is any if Bill Credit, CCard Refund

    Main Line

    is false

    Type

    Journal

    Approval Status

    is none of Pending Approval, Rejected

    Account Type

    is Accounts Payable

    Tax Line

    is false

    Tax Item

    is not none

    Amount (Debit)

    is not empty

    Memo

    starts with Non-Deductible Tax

    Intra-community Transaction Type (Custom Body)

    is none

    Correction Type (Custom Body)

    is not none

    Created From

    is not none

    Original Bill (Custom Body)

    is not none

    Registration Status (Custom Body)

    is Registered with errors

    Tax Rate

    is any of 12, 10.5, 0, 4, 10, 21, 5.2, 1.4, 0.5, 1.75

    For ES TAF SII Cash Collections

    Type

    is any of Payment, Cash Refund, Cash Sales, Customer Deposit, Customer Refund

    Main Line

    is true

    Posting

    is true

    Total Gross Amount

    is greater than 6000

    For ES TAF SII Investment Goods Register

    Type

    is any of Bill, Cheque, Credit Card

    Main Line

    is false

    Tax Line

    is false

    Tax Item

    is not none

    Approval Status

    is none of Pending Approval, Rejected

    Tax Item : Excluded From Tax Reports

    is false

    Tax Code

    is any of CG-ES, IG-ES, EIG-ES

    Registration Status (Custom Body)

    is any of Registered, Rejected, and Registered with Errors or none of Registered, Registered with Errors

    For ES TAF SII Intra-Community Transaction

    Type

    is any of Bill, Cash Sale, Cheque, Invoice, Credit Card

    Main Line

    is false

    Tax Line

    is false

    Tax Item : EC Code

    is true

    Tax Item : Excluded From Tax Reports

    is false

    Intra-community Transaction Type (Custom Body)

    is not none

    Approval Status

    is none of Pending Approval, Rejected

    Tax Code

    is any of ES, ER, EZ, ESSP, ESSS, EIG

  4. Modify the search title, and then click Save As.

    You only have to modify the saved search one time. You can use the modified search to keep track of the transactions that have been included in the generated reports.

General Notices