Understanding the 347 Tax Declaration
This chapter provides an overview of the 347 tax declaration and discusses how to:
Generate the Model 347 workfiles.
Generate the 347 tax declaration tape file.
Revise Model 347 records.
Generate the 347 tax declaration reports.
Understanding the 347 Tax Declaration
Businesses in Spain with an annual volume exceeding 3.005,06 euros must submit the 347 tax declaration to the Spanish tax authority. The 347 tax declaration includes information about all accounts payable and accounts receivable transactions. The tax declaration also includes information about insurance and leasing transactions, as well as leasing information for buildings that are owned or maintained by the company.
If a large company is subdivided into subcompanies within the system, the parent company should report the consolidated information for all subcompanies.
The first step in processing the Model 347 declaration is to run the Model 347 - Generate Acquisition Records (R74S100) and Model 347 - Generate Sales Records (R74S110) programs to generate the Model 347 workfiles.
The Model 347 workfiles consist of these tables:
F74S75 - Model 347 - Link Between Rec.Type 0 and Rec. Type 1 - Spain.
F74S76 - Model 347 - Record Type 0 Tag File - Spain.
This table explains the record types:
|
Record Type |
Description |
|
Record Type 0 |
Contains information about the number of records being submitted. Record type 0 is necessary only if you are using a single file to present tax information about two or more companies with different tax identification numbers. |
|
Record Type 1 |
Contains information about company addresses, as well as the amount and number of records that are associated with each company. Record type 1 contains one record for each company with a different tax identification number for which the tax declaration is being made. |
|
Record Type 2 |
Contains a summary of the amounts of selected transactions from AR and AP. Records are distinguished by the tax identification number of the customer or supplier, and by the type of operation (acquisitions or sales). Insurance operations and leasing operations are also identified. |
|
Record Type 3 |
Contains the total amount of leasing operations and the address of the leased commercial site. Record Type 3 is necessary only if the company leases a commercial site to a customer. |
The system uses the information in the Model 347 workfiles to produce the Model 347 - Dec. Companies Report and the 347 - Operations Report. You use the Model 347 - Print Records Type 1 - Spain program (R74S71) and the Model 347 - Print Records Types 2 & 3 - Spain program (R74S72) to print these required reports. The Model 347 workfiles are also used to generate the tape file that you submit to the Spanish tax authority.
This graphic illustrates the Model 347 process:
Processing the 347 Tax Declaration
Prerequisites
Before you complete the tasks in this section:
In the JD Edwards EnterpriseOne Address Book system, enter a tax identification number for each company, customer, and supplier.
If the business leases a commercial site, set up additional information for the site.
Set up additional information for the company that is submitting the tax declaration to the tax authority.
See Also
Copying, Importing, and Resetting Text Files
Generating the Model 347 Workfiles
This section provides an overview of the Model 347 workfiles and discusses how to:
Run the 347 - Generate Acquisitions (R74S100) program.
Set processing options for 347 - Generate Acquisitions (R74S100).
Run the 347 - Generate Sales (R74S110) program.
Setting processing options for 347 - Generate Sales (R74S110).
Understanding the Model 347 Workfiles
Use the 347 - Generate Acquisitions (R74S100) program to add information from the JD Edwards EnterpriseOne Accounts Payable system to the Model 347 workfiles. Use the 347 - Generate Sales (R74S110) program to add information from the JD Edwards EnterpriseOne Accounts Receivable system to the Model 347 workfiles.
The 347 - Generate Acquisition and 347 - Generate Sales programs summarize transactions by the customer's or supplier's tax identification number.
The 347 - Generate Acquisitions and the 347 - Generate Sales programs retrieve information from these tables to build the Model 347 workfiles:
Address Book Master (F0101)
Accounts Payable Ledger (F0411)
Customer Ledger (F03B11)
The system populates the Zip Code field in the Model 347 workfiles based on information in the address book. For domestic customers and suppliers, the system appends three zeros to the first two digits of the customer's or supplier's zip code from the address book. For international customers and suppliers, the system uses 99 plus the customer's or supplier's three-digit country code from user-defined code (UDC) (00/CN).
You use the processing options on the 347 - Generate Acquisitions and the 347 - Generate Sales programs to specify general information that must be included on the declaration.
Important! You must define specific data selection to generate the correct information in the Model 347 workfiles. For example, you might
define the data selection based on company, GL period, and document type that correspond to a specific operation type and
class. You need to run the generation programs several times with different data selections to record information on all operation
types and classes.
You should set the processing options to regenerate the workfile only the first time that you run one of the generation programs
to clear existing information for the company and declaration year that are specified in the processing options. Whether you
run 347 - Generate Acquisitions or 347 - Generate Sales first does not matter.
Running the 347 - Generate Acquisitions (R74S100) Program
Select Process 347 - Spain (G74S8011), 347 - Generate Acquisitions.
Setting Processing Options for 347 - Generate Acquisitions (R74S100)
Processing options enable you to specify the default processing for programs and reports.
Presentation
|
1. Company |
Enter the Company who is sending the declaration. (Required) |
Common Data
|
1. Declaration Year |
Enter the Declaration Year (4 Digits). Specify the year of the 347 or 349 declaration to be presented. |
|
2. Tax Office Number |
Enter the Tax Office Number. Specify the Tax Office Number where the declaration has to be presented. The number is assigned by the Spanish Tax Organism for the company. |
|
3. Code |
Enter the County Code ( 3 digits) for the company. |
|
4. Line Number |
Enter the Line Number to get the Contact Name from Company's Who's Who. If it is left blank, the default value will be 1. |
|
5. Declaration Type |
Declaration Type Blank = Current Declaration 1 = Complementary 2 = Substitute |
|
6. Previous Declaration Number |
Previous Declaration Number |
Regeneration
|
1. Regenerate Files: Selection |
Blanks - Add information into the files 1 - Regenerate files |
Amount
|
1. Minimum Amount |
Enter the minimum amount per supplier or customer that must be declared. If left this option in blank, the process will use 500.000 ESP. |
Currency
|
1. Currency Code |
Enter the Company Currency Code. |
|
2. Currency Code |
Enter the Third Currency Code. |
Operation Type
|
1. Operation Type |
Enter the Operation Type. A = Acquisitions D = Acq. EP C = Payments |
|
2. Operation Class |
Enter the Operation Class. 0 = Regular Operations. 1 = Insurance Operations. 2 = Leasing Operations. |
Running the 347 - Generate Sales (R74S110) Program
Select Process 347 - Spain (G74S8011), 347 - Generate Sales.
Setting Processing Options for 347 - Generate Sales (R74S110)
Processing options enable you to specify the default processing for programs and reports.
Presentation
|
1. Company |
Enter the Company who is sending the declaration. (Required) |
Common Data
|
1. Declaration Year |
Enter the Declaration Year (4 Digits). Specify the year of the 347 or 349 declaration to be presented. |
|
2. Tax Office Number |
Enter the Tax Office Number. This field contains the Tax Office Number where the declaration has to be presented. The number is assigned by the Spanish Tax Organism for the company. |
|
3. Code |
Enter the County Code ( 3 digits) for the company. |
|
4. Line Number |
Enter the Line Number to get the Contact Name from Company's Who's Who. If it is left blank, the default value will be 1. |
|
5. Declaration Type |
Declaration Type Blank = Current Declaration 1 = Complementary 2 = Substitute |
|
6. Previous Declaration Number |
Previous Declaration Number |
Regeneration
|
1. Regenerate Files: Selection |
Blanks - Add information into the files 1 - Regenerate files |
Amount
|
1. Minimum Amount |
Enter the minimum amount per supplier or customer that must be declared. If left this option is blank, the process will use 500.000 ESP. |
Currency
|
1. Currency Code |
Enter the Company Currency Code. |
|
2. Currency Code |
Enter the Third Currency Code. |
Operation Type
|
1. Operation Type |
Enter the Operation Type. A = Acquisitions D = Acq. EP C = Payments |
|
2. Operation Class |
Enter the Operation Class. 0 = Regular Operations. 1 = Insurance Operations. 2 = Leasing Operations. |
Generating the 347 Tax Declaration Tape File
This section provides an overview of the 347 tax declaration tape file and discusses how to:
Run the 347 - Generate Tape File (R74S120) program.
Set processing options for 347 - Generate Tape File (R74S120).
Understanding the 347 Tax Declaration Tape File
Use the 347 - Generate Tape File program to generate the tape file that you submit to the Spanish tax authority. The tape file contains information from these Model 347 workfiles:
Model 347 - Record Type 0 - Spain (F74S70).
Model 347 - Record Type 1 - Spain (F74S71).
Model 347 - Record Type 2 - Spain (F74S72)
Model 347 - Record Type 3 - Spain (F74S73)
Model 347 - Link Between Rec. Type 0 and Rec. Type 1 - Spain (F74S75)
Model 347 - Record Type 0 Tag File - Spain (F74S76)
Model 347 - Record Type 1 Tag File - Spain (F74S77)
The 347 - Generate Tape File program creates Text File Processor batches that contain the declaration.
Running the 347 - Generate Tape File (R74S120) Program
Select Process 347 - Spain (G74S8011), 347 - Generate Tape File.
Setting Processing Options for 347 - Generate Tape File (R74S120)
Processing options enable you to specify the default processing for programs and reports.
Company
|
1. Company |
Enter the Company who is sending the declaration. (Required) |
Default
|
Declaration Year |
1. Enter the Declaration Year (4 Digits). Specify the year of the 347 or 349 declaration to be presented. |
|
2. Transaction Currency |
Enter currency for the transaction Blank = Peseta 1 = Euro |
|
3. Declaration Number |
Enter the Declaration Number |
|
4. Media Type |
Blank = Tape 1 = Disk |
|
5. Create Record |
Create Record Type 0 Blank = Yes 1 = No |
Revising Model 347 Records
This section provides an overview of how to revise model 347 records and discusses how to revise model 347 records.
Understanding How to Revise Model 347 Records
After you have generated the Model 347 workfiles, you can revise information in the Model 347 workfiles.
Note. The information that you can revise is the same information that appears on the 347 - Operations Report (R74S72) and the 347 - Dec. Company Report (R74S71) reports.
Forms Used to Revise Model 347 Records
|
Form Name |
FormID |
Navigation |
Usage |
|
Work With Pres. Companies |
W74S349L |
Process 347 - Spain (G74S8011), 347 - Operations Revision. |
Select records. |
|
Presented Company Revisions |
W74S347M |
On the Work With Pres. Companies form, select Company Revisions from the Row menu. |
Revise the name and address of the presenting (parent) company. |
|
Work With Declared Companies |
W74S347B |
Click Select on the Work With Pres. Companies form. |
Access the Dec. Company Revisions form. |
|
Dec. Companies Revisions |
W74S347K |
On the Work With Declared Companies form, select Edit Company from the Row menu. |
Review acquisition and sales totals for a declaring company. |
|
Work With C & V Operations |
W74S347P |
Click Select on the Work With Declared Companies form. Click Find on the Work With C & V Operations form. |
Review transaction detail for a declaring company. |
|
Work With C & V Operations |
W74S347P |
On the Work With C & V Operations form, select Change Tax ID from the Row menu. The system validates the tax ID that you enter. |
Revise a customer's or vendor's tax ID. |
|
C & V Operations Revisions |
W74S347D |
On the Work With C & V Operations form, select C & V Revisions from the Row menu. |
Revise a customer's or vendor's name, province, and total operations amount. |
|
Work with Leasing Operations |
W74S347V |
On the Work With C & V Operations form, select a row that represents leasing transactions, and then click Select. |
Revise leasing information for a customer or vendor. |
Generating the 347 Tax Declaration Reports
This chapter provides an overview of the 347 tax declaration reports and discusses how to:
Print the 347 - Dec. Companies Report (R74S71).
Print the 347 - Operations Report.
Set processing options for 347 - Operations Report (R74S72).
Understanding the 347 Tax Declaration Reports
You can print these reports for the 347 tax declaration:
347 - Dec. Companies Report
The 347 - Declaring Companies report lists each company with a unique tax identification number that is included in the tax declaration. Information for companies that share a tax identification number is combined.
The report is for the review only. You should not submit this report to the tax authority. Instead, you should submit the 347 Tax Declaration tape file.
For each reporting company, the report lists the number of records of each type and the total amount of transactions for each record type. The report lists these record types:
|
Record Type |
Transaction Total |
|
Record Type A |
Acquisitions over 3.005,06 euros |
|
Record Type B |
Sales over 3.005,06 euros |
|
Record Type C |
Payments over 300,51 euros to a third-party payee |
|
Record Type D |
Acquisitions over 3.005,06 euros by government companies that are not related to regular company activity |
|
Record Type E |
Government subsidies over 3.005,06 euros |
The 347 - Declaring Companies report includes information from the F74S71 table.
347 - Operations Report
The 347 - Operations report lists the total operations amount by operation type for each customer or supplier. Customer and supplier records are grouped by the declaring company. The report also lists the tax identification number for each customer and supplier.
The 347 - Operations report is for the review only. You should not submit this report to the tax authority. Instead, you should submit the 347 Tax Declaration tape file.
The 347 - Operations report includes information from the F74S72 table.
Printing the 347 - Dec. Companies Report
Select Process 347 - Spain menu (G74S8011), 347 - Dec. Companies Report.
Printing the 347 - Operations Report
Select Process 347 - Spain (G74S8011), 347 - Operations Report.
Setting Processing Options for 347 - Operations Report
Processing options enable you to specify the default processing for programs and reports.
Print Option
|
1. Selection |
Select 1 if you want to include the Leasing Operations in the report. |