Declarations > Tax management > Spain > Bookkeeping > Bookkeeping 

If you do not have SII communication, use this function to calculate the VAT declaration and withholdings for companies operating in Spain.

When you search, the grids display data from the DCLVATSPATax working table. Data in this table comes from validated invoices in Sales invoices, Customer BP invoices, Purchasing invoices, and Supplier invoices.

When you save, the missing data is calculated and added to the SPLIBREG Bookkeeping table for two tax types:

  • R for issued invoices and revenues
  • S for received invoices and expense

You can export the data to an Excel file for each grid that you can use to manually upload to the Spanish fiscal authority website. For each Excel file, you need to enter a specific name and update the header to comply with Spanish legal requirements.

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Header

    Presentation

    After you enter your search criteria and select Search, you are asked if you want to resynchronize the tax table for VAT and cash. Select Yes to calculate the values.

    Close

     

    Fields

    The following fields are present on this tab :

    Filters

    Enter or select a Spanish company.
    Enter or select a site linked to the selected company. You can leave this field empty to include all sites for that company in your search.
    • Start date (field INIDAT)
    Enter a date range to limit your search to transactions within these dates.
    • End date (field ENDDAT)

     

    Default values

    • Main activity type (field MAINACTTYP)

    Enter the main activity type for the selected company as defined by the Spanish fiscal authority.

    This is an alphanumeric character that displays by default in the grid along with the search results.


    If you save your data for a given company and period, you can no longer change this default value in the Header section. You can change it manually in the grid.

    • IAE activity (field MAINACTIAE)

    Enter the IAE activity code for the company as defined by the Spanish fiscal authority. The Impuestos sobre Actividades Económicas (IAE) is a tax on the economic activity.

    This code includes two values:

    • 2 alphanumeric characters for the activity subtype
    • 4 alphanumeric characters for the group

    This displays by default in the grid along with the search results.

    If you save your data for a given company and period, you can no longer change this default value in the Header section. You can change it manually in the grid.

    • Main billing agreement (field MAINREGAGR)

    Enter or select the main billing agreement for the selected company. This number is a specific authorization code, typically starting with "RGE," from the Spanish fiscal authority when requested. If you have not requested this authorization, you can leave this field empty.

    This displays by default in the grid along with the search results.

    If you save your data for a given company and period, you can no longer change this default value in the Header section. You can change it manually in the grid.

    Close

     

    Tab Issued inv./Revenues

    Fields

    The following fields are present on this tab :

    Grid

    • Fiscal year (field YEA)
    This field defaults from the original invoice and cannot be modified.
    • Period (field PER)

     

    • Activity type (field ACTTYP)
    This field defaults from the value entered in the Header section.
    • IAE activity (field ACTIAE)
    This field defaults from the value entered in the Header section.
    • Invoice type (field INVTYPSPA)
    This field defaults from the original invoice and cannot be modified.
    • Operation subject (field OPECONCEPT)
    Enter the 3-digit code as defined by the Spanish legal authority.
    This field is empty when the taxpayer is a legal person not subject to income declaration.
    • Document amount (field OPEAMT)
    Enter the total amount subject to tax from invoices and other operations not invoiced.
    • Operation date (field OPEDAT)
    This field defaults from the original invoice and cannot be modified.
    • Issue date (field SDHDAT)

     

    • Series (field SERIE)
    This number can be part of the invoice.
    • Invoice number (field INVNUM)
    This field defaults from the original invoice and cannot be modified.
    • Final invoice number (field INVNUMEND)
    The posted invoice number can be different from an invoice number that is not posted.
    • Document type (field DOCTYP_V)
    This field displays the document type for the business partner. If defaults from the business partner profile but can be modified.
    This field defaults from the original invoice and cannot be modified.
    • BP identification (field CRN)
    Enter a code to define how the BP is identified.
    • BP name (field BPNAME)
    This field defaults from the original invoice and cannot be modified.
    • Operation key (field OPEKEY)
    Enter the two-digit code to identify the tax for the operation on the invoice. This code is defined by the Spanish fiscal authority.
    For example:
    • 01: general operations
    • 02: exports
    • Exempted operation (field OPEEXE)
    For an exempted operation, enter the two-character code for the reason.
    • Invoice total (field AMTTOT)
    This field defaults from the original invoice and cannot be modified.
    • Subject to tax (field SUBTAX)

     

    • Rate (field VATRAT)
    This field defaults from the original invoice and cannot be modified.
    • Tax amount (field AMTTAX)

     

    • Surcharge type (field SURRAT)

     

    • Equivalence surcharge tax (field SURTAXAMT)

     

    • Cash VAT date (field CSHVATDAT)

     

    • Cash VAT amount (field CSHAMT)

     

    • Cash VAT method (field CSHMET)

     

    • Cash VAT method ID (field CSHMETID)

     

    • Withholding type (field WTHRAT)
    This field defaults from the original invoice and cannot be modified.
    • Withholding amount (field WTHAMT)

     

    • Operation nature (field NATTYP)

     

    • Billing agreement (field REGAGR)
    This field defaults from the value entered in the Header section.
    • Location (field BUILOC)

     

    • Cadastre (field CDRREF)

     

    • External reference (field EXTREF)

     

    Close

     

    Tab Received inv./Expenses

    Fields

    The following fields are present on this tab :

    Grid

    • Fiscal year (field YEA)
    This field defaults from the original invoice and cannot be modified.
    • Period (field PER)

     

    • Activity type (field ACTTYP)
    This field defaults from the value entered in the Header section.
    • IAE activity (field ACTIAE)
    This field defaults from the value entered in the Header section.
    • Invoice type (field INVTYPSPA)
    This field defaults from the original invoice.
    • Operation subject (field OPECONCEPT)
    Enter the 3-digit code as defined by the Spanish legal authority.
    This field is empty when the taxpayer is a legal person not subject to income declaration.
    • Document amount (field OPEAMT)
    Enter the total amount subject to tax from invoices and other operations not invoiced.
    • Issue date (field SDHDAT)
    This field defaults from the original invoice and cannot be modified.
    • Operation date (field OPEDAT)

     

    • Invoice number (field INVNUM)

     

    • Final invoice number (field INVNUMEND)
    The posted invoice number can be different from an invoice number that is not posted.
    • Receipt date (field PTHDAT)

    This date is on or after the shipment date and the operation date or transaction date.

    • Receipt number (field PTHNUM)
    This field defaults from the original invoice and cannot be modified.
    • Final receipt number (field PTHNUMEND)
    This is the final receipt number that can be different from the original receipt number.
    • Document type (field DOCTYP_V)
    This field displays the document type for the business partner. If defaults from the business partner profile but can be modified.
    This field defaults from the original invoice and cannot be modified.
    • BP identification (field CRN)
    Enter a code to define how the BP is identified.
    • BP name (field BPNAME)
    This field defaults from the original invoice and cannot be modified.
    • Operation key (field OPEKEY)
    Enter the two-digit code to identify the tax for the operation on the invoice. This code is defined by the Spanish fiscal authority.
    For example:
    • 01: general operations
    • 02: exports
    • Investment goods (field INVGOOD)

    Enter S if the transaction is for an investment property.

    Enter N if the transaction is not related to an investment property.

    • Reverse charge (field REVCHG)
    This field defaults from the original invoice and cannot be modified.
    • Deductible in later period (field DEDLATPER)
    Enter S if this is deductible for a later period.
    Enter N if not.
    • Deduction fiscal year (field DEDFIY)
    Enter the fiscal year for the deduction.
    • Subject to tax (field SUBTAX)
    This field defaults from the original invoice and cannot be modified.
    • Deduction period (field DEDPER)
    Enter the period for the deduction.
    • Invoice total (field AMTTOT)
    This field defaults from the original invoice and cannot be modified.
    • Rate (field VATRAT)
    This field defaults from the original invoice and cannot be modified.
    • Deductible amount (field DEDAMT)

     

    • Surcharge type (field SURRAT)

     

    • Equivalence surcharge tax (field SURTAXAMT)

     

    • Cash VAT date (field CSHVATDAT)

     

    • Cash VAT amount (field CSHAMT)

     

    • Cash VAT method (field CSHMET)

     

    • Cash VAT method ID (field CSHMETID)

     

    • Withholding type (field WTHRAT)
    This field defaults from the original invoice and cannot be modified.
    • Withholding amount (field WTHAMT)

     

    • Billing agreement (field REGAGR)
    This field defaults from the value entered in the Header section.

     

    Specific actions

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation