Spain Help Topics

Overview

The following help topics provide information about NetSuite features that are specific to companies doing business in Spain. The NetSuite International Edition can be configured with capabilities and reports specific to a Spanish business setting and requirements.

To know more about localized editions of NetSuite, as well as setting up NetSuite accounts and subsidiaries, refer to the following Help topics:

NetSuite Editions Overview
Set up NetSuite OneWorld
Creating Subsidiary Records in NetSuite OneWorld.
Introduction to NetSuite OneWorld for companies using NetSuite across multiple subsidiaries and countries.

Note that general NetSuite features are covered in other chapters and topics.

General Setup

Spain Account Setup: Provides an overview of NetSuite features to be enabled by the users in Spain and SuiteApps available for installation.

Setting Up Spain-Specific Preferences: Set your NetSuite company and user preferences including date, currency, language, time zone, and support for Spanish number, phone, and address format.

Functional Areas

Spanish users can activate and get access to different features from the following functional areas.

Accounting
Taxation Features For Accounts Without SuiteTax
Taxation Features For Accounts With SuiteTax
Payments
Banking

For information about SuiteApps installation, see Installing a Bundle.

For information about enabling NetSuite features, see Enabling Features.

Important:

If you don’t have sufficient permissions to install SuiteApps or enable features, contact your account administrator.

Accounting

Feature	Description	Prerequisites
Chart of Accounts Management	Enables you to modify the Chart of Accounts according to the SNC accounting standards. You can use the Chart of Accounts Import to add ledger accounts to the Account list record. For more information, see Chart of Accounts Import.	Check the Use Account Numbers box on the Accounting Preferences page. If you are using a OneWorld account, fill in the Subsidiaries field. You must map the NetSuite Subsidiaries field to a field in your CSV file.
Accounting Contexts	For Spain where the Chart of Accounts is statutory, an accounting context provides a solution to conform to the Spanish account numbering requirements. Through the Accounting Contexts subtab on the General Preferences page, you can create a Spanish Accounting Context, which allows mapping between the main accounts and the Spanish numbers	Available in all NetSuite OneWorld accounts.
GL Audit Numbering	Applies gapless numbering sequences to all general ledger posting transactions. This is an optional feature.	Enable the GL Audit Numbering feature. For more information, see Enabling GL Audit Numbering and Setting Preferences.
GL Impact Locking	Enables you to lock the general ledger (GL) impact of a transaction to the GL. When you use this feature on a company or a subsidiary, any change to a GL impacted field or entity field on a GL numbered impacting transaction after running a GL audit numbering sequence automatically generates copy and reversal transactions. These transactions appear on the GL Impact subtab on the original GL impacted transaction.	Enable the GL Audit Numbering feature. For more information, see Enabling GL Audit Numbering and Setting Preferences. Check the GL Impact Locking box on the Company Information page or Subsidiary page. For more information, see GL Impact Locking.
Period End Journal Entries	An optional feature that enables you to create the income closing journals, balance sheet opening and closing journals as a task in the Period End Checklist.	Enable the Period End Journal Entries feature and perform additional setup tasks. For more information, see Setup for Period End Journal Entries.

Feature

Description

Prerequisites

Chart of Accounts Management

Enables you to modify the Chart of Accounts according to the SNC accounting standards. You can use the Chart of Accounts Import to add ledger accounts to the Account list record. For more information, see Chart of Accounts Import.

Check the Use Account Numbers box on the Accounting Preferences page.

If you are using a OneWorld account, fill in the Subsidiaries field. You must map the NetSuite Subsidiaries field to a field in your CSV file.

Accounting Contexts

For Spain where the Chart of Accounts is statutory, an accounting context provides a solution to conform to the Spanish account numbering requirements. Through the Accounting Contexts subtab on the General Preferences page, you can create a Spanish Accounting Context, which allows mapping between the main accounts and the Spanish numbers

Available in all NetSuite OneWorld accounts.

GL Audit Numbering

Applies gapless numbering sequences to all general ledger posting transactions. This is an optional feature.

Enable the GL Audit Numbering feature. For more information, see Enabling GL Audit Numbering and Setting Preferences.

GL Impact Locking

Enables you to lock the general ledger (GL) impact of a transaction to the GL.

When you use this feature on a company or a subsidiary, any change to a GL impacted field or entity field on a GL numbered impacting transaction after running a GL audit numbering sequence automatically generates copy and reversal transactions. These transactions appear on the GL Impact subtab on the original GL impacted transaction.

Enable the GL Audit Numbering feature. For more information, see Enabling GL Audit Numbering and Setting Preferences.

Check the GL Impact Locking box on the Company Information page or Subsidiary page. For more information, see GL Impact Locking.

Period End Journal Entries

An optional feature that enables you to create the income closing journals, balance sheet opening and closing journals as a task in the Period End Checklist.

Enable the Period End Journal Entries feature and perform additional setup tasks. For more information, see Setup for Period End Journal Entries.

Taxation Features For Accounts Without SuiteTax

Note:

The following table describes taxation features for companies in Spain. These features are for NetSuite accounts without SuiteTax. If you have SuiteTax enabled in your NetSuite account, see Taxation Features For Accounts With SuiteTax. For more information, see SuiteTax.

Feature	Description	Prerequisites
Spain Tax Codes Spain Tax Code Changes Tax Code Table for Spain	These help topics provide a list of tax codes that are needed to calculate VAT on transaction records, and generate the Spanish VAT Return, and the tax code properties that you must assign to your Spanish tax codes to ensure correct VAT amounts on the tax report and the QR code.	Enable the accounting features that you would like to use. For more information, see Enabling and Setting Up Taxation Features. Depending on your selection of features, you may need to install the following SuiteApps: International Tax Reports. For more information, see Installing and Setting Up International Tax Reports. Supplementary Tax Calculation. For more information, see Setting Up Nondeductible Input Tax. Tax Audit Files. For more information, see Installing the Tax Audit Files SuiteApp.
Sales and Purchase Reports Grouped by Tax Code	These are customizable saved reports that can be used in a Spanish nexus.
EU Intrastat Report	Enables you to generate the Intrastat Report for Arrivals and Dispatches. The International Tax Reports SuiteApp does not provide a template for this report that is localized for Spain.
Tax Audit Files	A bundle used to generate the SII report (Suministro Inmediato de Información). It is currently able to generate the files for issued and received invoices. However, it contains some issues and limitations, such as the software's inability to communicate files directly to the tax agency.
Automatic Tax Code Provisioning	A feature of the International Tax Reports SuiteApp that automatically creates nexus and VAT/GST tax codes when you add a new subsidiary country. The auto-generated tax codes related to surcharges (recargo de equivalencia) cannot be used in practice, as they cannot be directly applied in a transaction line. They are always used in combination with another tax code (S-ES, R-ES or R2-ES).
EU Sales List for Spain	Enables you to generate the EU Sales List (ESL) report using the International Tax Reports SuiteApp. ESL is a report currently used only for sales transactions, and it prints EU sales for both services and goods.
Reverse Charge VAT	Provides information about the reverse charges on goods and services within the European Union (EU). For more information about configuration, see Setting Up Tax Codes to Post Notional Tax Amounts Applying the Notional Tax Posting Feature to Transactions and Subsidiaries	Install International Tax Reports (see Installing and Setting Up International Tax Reports) and Supplementary Tax Calculation.
Recording Nondeductible Input Tax	Enables to apply nondeductible tax on vendor bills, expense reports, checks, and vendor bill credits in NetSuite. For more information, see Setting Up Nondeductible Input Tax
EU One Stop Shop Tax Code Provisioning	Automatically provisions MOSS tax codes when you assign a MOSS nexus to a subsidiary in NetSuite OneWorld.	Install International Tax Reports (see Installing and Setting Up International Tax Reports)
OSS Tax Code Provisioning for Regular NetSuite Accounts	Automatically provisions MOSS tax codes for non-OneWorld NetSuite accounts.
Withholding Tax	A bundle used to calculate withholding taxes on transactions and generate withholding tax reports. This bundle is required in Spain.

Feature

Description

Prerequisites

Spain Tax Codes

Spain Tax Code Changes
Tax Code Table for Spain

These help topics provide a list of tax codes that are needed to calculate VAT on transaction records, and generate the Spanish VAT Return, and the tax code properties that you must assign to your Spanish tax codes to ensure correct VAT amounts on the tax report and the QR code.

Enable the accounting features that you would like to use. For more information, see Enabling and Setting Up Taxation Features.

Depending on your selection of features, you may need to install the following SuiteApps:

International Tax Reports. For more information, see Installing and Setting Up International Tax Reports.
Supplementary Tax Calculation. For more information, see Setting Up Nondeductible Input Tax.
Tax Audit Files. For more information, see Installing the Tax Audit Files SuiteApp.

Sales and Purchase Reports Grouped by Tax Code

These are customizable saved reports that can be used in a Spanish nexus.

EU Intrastat Report

Enables you to generate the Intrastat Report for Arrivals and Dispatches. The International Tax Reports SuiteApp does not provide a template for this report that is localized for Spain.

Tax Audit Files

A bundle used to generate the SII report (Suministro Inmediato de Información). It is currently able to generate the files for issued and received invoices. However, it contains some issues and limitations, such as the software's inability to communicate files directly to the tax agency.

Automatic Tax Code Provisioning

A feature of the International Tax Reports SuiteApp that automatically creates nexus and VAT/GST tax codes when you add a new subsidiary country.

The auto-generated tax codes related to surcharges (recargo de equivalencia) cannot be used in practice, as they cannot be directly applied in a transaction line. They are always used in combination with another tax code (S-ES, R-ES or R2-ES).

EU Sales List for Spain

Enables you to generate the EU Sales List (ESL) report using the International Tax Reports SuiteApp. ESL is a report currently used only for sales transactions, and it prints EU sales for both services and goods.

Reverse Charge VAT

Provides information about the reverse charges on goods and services within the European Union (EU). For more information about configuration, see

Setting Up Tax Codes to Post Notional Tax Amounts

Applying the Notional Tax Posting Feature to Transactions and Subsidiaries

Install International Tax Reports (see Installing and Setting Up International Tax Reports) and Supplementary Tax Calculation.

Recording Nondeductible Input Tax

Enables to apply nondeductible tax on vendor bills, expense reports, checks, and vendor bill credits in NetSuite. For more information, see Setting Up Nondeductible Input Tax

EU One Stop Shop Tax Code Provisioning

Automatically provisions MOSS tax codes when you assign a MOSS nexus to a subsidiary in NetSuite OneWorld.

Install International Tax Reports (see Installing and Setting Up International Tax Reports)

OSS Tax Code Provisioning for Regular NetSuite Accounts

Automatically provisions MOSS tax codes for non-OneWorld NetSuite accounts.

Withholding Tax

A bundle used to calculate withholding taxes on transactions and generate withholding tax reports. This bundle is required in Spain.

Taxation Features For Accounts With SuiteTax

Note:

The following table describes taxation features for companies in Spain. These features are for NetSuite accounts with SuiteTax. For more information about these features, see Spain Localization.

Feature	Description	Prerequisites
Tax Reporting for Accounts with SuiteTax	The tax reporting feature provides generation of the following Spain-specific reports based on SuiteTax: Modelo 303 Modelo 349 Modelo 390 SII – Registration: Issued Invoice SII – Correction: Issued Invoice SII – Registration: Received Invoice SII – Correction: Received Invoice These tax reports are generated in NetSuite accounts only when the SuiteTax feature is enabled. For more information, see Generating Spain VAT Reports in the Spain Localization SuiteApp.	Enable the following features: Custom Records See Custom Records. Advanced PDF/HTML Templates See Enabling the Advanced PDF/HTML Templates Feature. SuiteScript Client SuiteScript Server SuiteScript SuiteAnalytics Workbook See Enabling SuiteAnalytics Workbook in Your NetSuite Account. Customer Relationship Management Disable the following feature: Multi-Book Accounting Install the following SuiteApps: SuiteTax Engine SuiteApp See Installing the SuiteTax Engine. Tax Reporting Framework SuiteApp See Installing Tax Reporting Framework. Localization Assistant SuiteApp See Installing the Localization Assistant SuiteApp.
Visual Drill-down and Electronic Format	The SuiteApp offers a visual drill-down of Spain-specific tax reports to validate which transactions are included in each box. It also offers a downloadable machine-readable report format that is ready for upload to the AEAT online portal. For more information, see Exporting Spain VAT Report Files in a TXT Format.
Interpretation of AEAT Response XML Files	After the SII report generation and manual submission to the AEAT online portal, you will receive an XML file as a response from AEAT regarding your submission. The Spain Localization SuiteApp provides you with a platform where you can upload this response and let the system interpret it for you. For more information, see SII – AEAT Response.
Financial Reports	The SuiteApp provides you with the following financial reports specific to Spain: Balance de Situación (Balance Sheet for Spain) Balance de Sumas y Saldos (Trial Balance for Spain) Cuenta de Pérdidas y Ganancias (Profit and Loss Account for Spain) Libro Diario (Journal for Spain) Libro Mayor (General Ledger for Spain) Book of Issued and Received Invoices for Spain For more information, see Spain-Specific Financial Reports.

Feature

Description

Prerequisites

Tax Reporting for Accounts with SuiteTax

The tax reporting feature provides generation of the following Spain-specific reports based on SuiteTax:

Modelo 303
Modelo 349
Modelo 390
SII – Registration: Issued Invoice
SII – Correction: Issued Invoice
SII – Registration: Received Invoice
SII – Correction: Received Invoice

These tax reports are generated in NetSuite accounts only when the SuiteTax feature is enabled.

For more information, see Generating Spain VAT Reports in the Spain Localization SuiteApp.

Enable the following features:

Custom Records

See Custom Records.
Advanced PDF/HTML Templates

See Enabling the Advanced PDF/HTML Templates Feature.
SuiteScript
- Client SuiteScript
- Server SuiteScript
SuiteAnalytics Workbook

See Enabling SuiteAnalytics Workbook in Your NetSuite Account.
Customer Relationship Management

Disable the following feature:

Multi-Book Accounting

Install the following SuiteApps:

SuiteTax Engine SuiteApp

See Installing the SuiteTax Engine.
Tax Reporting Framework SuiteApp

See Installing Tax Reporting Framework.
Localization Assistant SuiteApp

See Installing the Localization Assistant SuiteApp.

Visual Drill-down and Electronic Format

The SuiteApp offers a visual drill-down of Spain-specific tax reports to validate which transactions are included in each box. It also offers a downloadable machine-readable report format that is ready for upload to the AEAT online portal.

For more information, see Exporting Spain VAT Report Files in a TXT Format.

Interpretation of AEAT Response XML Files

After the SII report generation and manual submission to the AEAT online portal, you will receive an XML file as a response from AEAT regarding your submission. The Spain Localization SuiteApp provides you with a platform where you can upload this response and let the system interpret it for you.

For more information, see SII – AEAT Response.

Financial Reports

The SuiteApp provides you with the following financial reports specific to Spain:

Balance de Situación (Balance Sheet for Spain)
Balance de Sumas y Saldos (Trial Balance for Spain)
Cuenta de Pérdidas y Ganancias (Profit and Loss Account for Spain)
Libro Diario (Journal for Spain)
Libro Mayor (General Ledger for Spain)
Book of Issued and Received Invoices for Spain

For more information, see Spain-Specific Financial Reports.

Payments

Feature	Description	Prerequisites
Spain Payment Formats Setting Up Company Bank Records in Spain Setting Up Bank Records of Vendors in Spain Setting Up Bank Records of Employees in Spain Setting Up Bank Records of Customers in Spain Setting Up Bank Records of Partners in Spain	Provides information about the Electronic Bank Payments SuiteApp and its supported payment formats specific to Spain, including steps on setting up bank records for your company, partners, vendors, customers, and employees in Spain.	Install the following SuiteApps: Electronic Bank Payments. For more information, see Setting Up Electronic Bank Payments. EMEA Localization. For more information, see Prerequisites for Installing the EMEA Localization SuiteApp and Installing the EMEA Localization SuiteApp.
Importing Electronic Bank Payments Data	Provides information about how to transfer electronic bank payments data such as your entity bank details (vendors, employees, customers) to NetSuite.

Feature

Description

Prerequisites

Spain Payment Formats

Provides information about the Electronic Bank Payments SuiteApp and its supported payment formats specific to Spain, including steps on setting up bank records for your company, partners, vendors, customers, and employees in Spain.

Install the following SuiteApps:

Electronic Bank Payments. For more information, see Setting Up Electronic Bank Payments.
EMEA Localization. For more information, see Prerequisites for Installing the EMEA Localization SuiteApp and Installing the EMEA Localization SuiteApp.

Importing Electronic Bank Payments Data

Provides information about how to transfer electronic bank payments data such as your entity bank details (vendors, employees, customers) to NetSuite.

Banking

Feature	Description	Prerequisites
Manual bank reconciliation	Lets you manually mark bank transactions as reconciled. For more information, see Reconciling Bank Statements.	Assign the correct permissions for a role. For more information, see Permissions for Banking Features. If you want to use the pages for an account, check the Use Match Bank Data and Reconcile Account Statement Pages box on the Edit Account page. For details, see Editing an Account.
Reconciliation based on online bank statement upload	When bank data has been imported to NetSuite, you can match and reconcile transactions without the need for third-party tools. For more information, see Reconciling Bank and Credit Card Statements.
Reconciling your account statement from beginning to end by: Importing your bank statement file. You have two options when using online banking: Download the account statement from your financial institution or credit card company, and then import the statement to your NetSuite account. Use the Financial Connectivity Plug-in to automate your file uploads through sFTP.	For more information, see the following topics: Importing Data Using a Financial Institution Record — the following formats are supported: MT940 OXF QXF BAI2 CAMT.053 For more information about these formats, see Bank Statement Parsers SuiteApp.	Install the Bank Statement Parsers SuiteApp. For more information, see Installing the Bank Statement Parsers SuiteApp. This SuiteApp provides parser plug-ins for the supported formats.
Importing Data Using Default Parsers — the following formats are supported: BAI2 TXT with UTF-8 encoding CAMT.053.001.06 XML with UTF-8 encoding CSV with UTF-8 encoding OFX QFX For more information, see Supported File Formats for Default Parsers.
Auto Bank Statement Import SuiteApp which uses the Financial Connectivity Plug-in to automatically import bank data through sFTP from your financial institution. The Auto Bank Statement Import SuiteApp is usually used together with the Bank Statement Parsers SuiteApp.	Install the Auto Bank Statement Import SuiteApp. For more information, see Installing Auto Bank Statement Import SuiteApp. Install the Bank Statement Parsers SuiteApp. For more information, see Installing the Bank Statement Parsers SuiteApp.
Matching imported bank statement transactions with NetSuite transactions.	For more information, see Matching Bank Data.	See Permissions for Banking Features for the proper permissions to use the Match Bank Data and Reconcile Account Statement pages. If you want to use these pages for an account, check the Use Match Bank Data and Reconcile Account Statement Pages box on the Edit Account page. For more information, see Editing an Account.
Confirming the transaction matches.	After matching the transactions, you can submit the matches and continue to the reconciliation process. For more information, see Submitting Matched or User-Cleared Transactions.
Reconciling the transactions.	For more information, see Reconciling Transactions.

Feature

Description

Prerequisites

Manual bank reconciliation

Lets you manually mark bank transactions as reconciled. For more information, see Reconciling Bank Statements.

Assign the correct permissions for a role. For more information, see Permissions for Banking Features.

If you want to use the pages for an account, check the Use Match Bank Data and Reconcile Account Statement Pages box on the Edit Account page. For details, see Editing an Account.

Reconciliation based on online bank statement upload

When bank data has been imported to NetSuite, you can match and reconcile transactions without the need for third-party tools. For more information, see Reconciling Bank and Credit Card Statements.

Reconciling your account statement from beginning to end by:

Importing your bank statement file.

You have two options when using online banking:

Download the account statement from your financial institution or credit card company, and then import the statement to your NetSuite account.
Use the Financial Connectivity Plug-in to automate your file uploads through sFTP.

For more information, see the following topics:

Importing Data Using a Financial Institution Record — the following formats are supported:
- MT940
- OXF
- QXF
- BAI2
- CAMT.053

For more information about these formats, see Bank Statement Parsers SuiteApp.

Install the Bank Statement Parsers SuiteApp. For more information, see Installing the Bank Statement Parsers SuiteApp. This SuiteApp provides parser plug-ins for the supported formats.

Importing Data Using Default Parsers — the following formats are supported:
- BAI2 TXT with UTF-8 encoding
- CAMT.053.001.06 XML with UTF-8 encoding
- CSV with UTF-8 encoding
- OFX
- QFX
For more information, see Supported File Formats for Default Parsers.

Auto Bank Statement Import SuiteApp which uses the Financial Connectivity Plug-in to automatically import bank data through sFTP from your financial institution.

The Auto Bank Statement Import SuiteApp is usually used together with the Bank Statement Parsers SuiteApp.

Install the Auto Bank Statement Import SuiteApp. For more information, see Installing Auto Bank Statement Import SuiteApp.

Install the Bank Statement Parsers SuiteApp. For more information, see Installing the Bank Statement Parsers SuiteApp.

Matching imported bank statement transactions with NetSuite transactions.

For more information, see Matching Bank Data.

See Permissions for Banking Features for the proper permissions to use the Match Bank Data and Reconcile Account Statement pages.

If you want to use these pages for an account, check the Use Match Bank Data and Reconcile Account Statement Pages box on the Edit Account page. For more information, see Editing an Account.

Confirming the transaction matches.

After matching the transactions, you can submit the matches and continue to the reconciliation process. For more information, see Submitting Matched or User-Cleared Transactions.

Reconciling the transactions.

For more information, see Reconciling Transactions.

General Notices