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:
-
Go to Lists > Search > Saved Search.
-
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
-
-
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
-
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.