Reports

There are several reports included in the SuiteApp. Some are for internal use only. There are also reports you can submit to the Israel Tax Authority.

The following are external reports/files you can send from NetSuite to the Israel Tax Authority:

• Open Format Annual File

• WHT Annual File (856)

• WHT Vendor Letter Annual Report (857)

• VAT Monthly File (pcn874)

To access Israeli Reports, go to Reports > Israeli Reports.

Israeli Saved Tax Reports

Israeli Saved Tax Reports include following:

• Israeli Vendors Tax Information: Used to check the set up for WHT for all vendors in a given subsidiary. Any missing information will be flagged.

• Israeli vendor Tax Certificates Report: Flags vendors with expired withholding tax certificates, shows the status. Any missing information should be updated.

• Israeli Vendors Bank Details Report: Lets you check that all vendors have the relevant bank details populated.

Israeli Saved Financial Reports

The following financial saved reports have been customized to suit the business requirements in Israel.

• Israeli Transactions Statement: GL detail per account.

• Israeli Account Reconciliation: Used to reconcile accounts which are not credit cards or bank accounts. To use this, use the fields to filter the transactions to be displayed, and click the lines to be reconciled.

To display End of Period Reports, go to Reports > Israeli End of Period Reports. The reports are:

• Trial Balance

• Amortisation Forecast Detail

• Transaction Detail

• Invoices Printed

• ILS Bills/ Credits related to foreign vendors in Israeli Subsidiary

Israeli Open Format

Open Format is an annual report for Israeli subsidiaries. The Israel Localization SuiteApp generates the report through a process that produces a ZIP file containing two files.

The data included in the report is typically applicable for a full year (12 months) and covers all business activity for a selected Israeli subsidiary. The report is based on accounting periods, which are defined by the From Period and To Period settings. The accounting periods can either be closed or open, and this does not affect the Open Format report.

Note:

You should run the Open Format process on full months that have already passed, not on the current month.

The Open format is used for audit purposes. The report covers all the transactions, inventory in a company, throughout all accounting books. This is generated on request by the IRS or VAT authorities. It is an annual report. To generate an Open Format Report, the following set up and steps should be followed.

To set up the Open Format branch ID:

1. Go to Setup > Company > Subsidiary.

2. Click Edit on the subsidiary record to issue the Open Format File for.

3. On the Israeli OF Details subtab, in the מזהה סניף / ענף field, enter: 0 (zero) for regular companies or 1 (one) for companies with branches.

4. Click Save.

To set up record type:

1. Go to Customization > Lists, Records and Fields > Record Types.

2. Click IL OF Auto ID Num Israel ILS, and then copy the value from the ID field (‘_il_of_auto_id_num_’ format).

3. Go to Setup > Company > Subsidiaries, and click the View link of the applicable subsidiary.

4. Copy the value from the Internal ID field, and add it to IL OF Auto ID Num Israel ILS, for example > il_of_auto_id_num_18.

To set up new custom records:

1. Go to Customization > List, Records & Fields > Record Types > New.

2. In the Name field, enter IL OF Auto ID Num XXX ILS (where XXX = company name).

3. In the ID field, enter _il_of_auto_id_num_5.

4. Mark additional parameters in the numbering category as follows:

   • Verify that the Include Name box is cleared.

   • On the Numbering subtab, verify that the Enable box is checked and that the Initial Number field contains the value 1.

5. Click Save. Repeat the procedure for any other subsidiaries which should be included in the Open Format File.

To map between NetSuite Transactions and the Israeli Tax Requirements:

1. Go to Customization > Lists, Records and Fields > Record Types, and then click IL OF Documents Mapping Number.

2. Add the mapping below:

   Name	IL OF Documents Mapping Number	Quantity Dependent	Document Mapping Dependency
   100	Sales Order	No
   200	Item Shipment	No
   210	Return Authorization	No
   305	Invoice	No
   320	Cash Sale	No
   320	Cash Refund	No
   330	Credit Memo	No
   400	Payment	No
   500	Purchase Order	No
   610	Vendor Return Authorization	No
   700	Bill	No
   710	Bill Credit	No
   810	Item Receipt	No
   810	Inventory Distribution	No	Negative Quantity
   820	Inventory Distribution	No	Positive Quantity
   820	Item Shipment	No
   830	Transfer	No
   830	Transfer Order	No
   840	Inventory Adjustment	No
   840	Inventory Worksheet	No
   900	WO Unbuild	No	Negative Quantity
   900	WO Build	No	Positive Quantity
   910	WO Build	No	Negative Quantity
   910	WO Unbuild	No	Positive Quantity

3. If the company does not have inventory and warehouse, from the Actions list, select Delete, and delete following lines:

   Name	IL OF Documents Mapping Number		Quantity Dependent	Document Mapping Dependency
   810	Inventory Distribution		No	Negative Quantity
   820	Inventory Distribution		No	Positive Quantity
   820	Item Shipment		No
   830	Transfer		No
   830	Transfer Order		No
   840	Inventory Adjustment		No
   840	Inventory Worksheet		No
   900		WO Unbuild	No	Negative Quantity
   900		WO Build	No	Positive Quantity
   910		WO Build	No	Negative Quantity
   910		WO Unbuild	No	Positive Quantity

To connect company payment methods to the Israeli Tax Requirements:

1. Go to Setup > Accounting > Accounting Lists, and filter Payment Method to view the company’s payment methods.

2. Go to Customization > Lists, Records and Fields > Record Types, and then click IL OF Payment Method Number to map the base payment methods to the Israeli Tax Requirements. Sometimes, the IL OF PM NAME field needs to be updated to the correct value according to the table.

   Name	IL OF PM Name
   1	Cash
   2	Check
   3-1	MasterCard
   3-2	Visa
   4	Discover
   4	Wire
   4	PayPal
   4	EFT

To update the software data for the Israeli Tax Authorities:

The certificate is updated annually.

1. Go to Record Type > IL OF Payment Method Number > List > Edit.

2. Make sure that the fields below bear the correct value:

   • System Tax Version Number = 2019

   • Provider Tax Reg. Number = 513825752

   • Provided Name (In Hebrew): נטקלאוד בע"מ( NetCloud Ltd.)

   • System Tax Registration Number = 176810

   • System Name= NETSUITE

To submit Open Format file, use the IL OF Role. This is defined automatically.

To edit the IL Open Format Role:

1. Go to Setup > Users/Roles > Manage Roles, and then click Customize on the IL OF Role record.

2. In the Name field, enter IL OF Role XXX (xxx should be your company’s name).

3. In the Subsidiary Restrictions section, select All to mark all company books & Accessible Subsidiaries.

4. In the Accounting Books section, choose Primary And Selected, and then select Adjustment Book and Secondary Accounting book.

5. Go to Setup > Users/Roles > Manage Users to apply the role.

6. Go to Edit > Access > Roles and select IL OF Role XXX.

7. Select the user that will submit the OF file and apply the new role.

To run the Open Format file program:

Starting from the Israel Localization SuiteApp version 8.8, the option of selecting a book is available.

If the primary book is in foreign currency, and there are several books in ILS (tax book), in the "Book" field you will be given the option to select the relevant book. The program automatically creates a directory named OPENFRMT and saves the files in Library Location in Disc C.

1. Go to Reports > Israeli Reports > Israeli Open Format, and then click Download Open Format Client Application. The file IL-OpenFormat.exe downloads and saves to your Downloads folder.

2. Right-click the file and select Run as Administrator.

3. Log in to the system and enter the following:

   • E-mail: IL OF Role XXX user e-mail set up in previous step.

   • Password: user NetSuite password (up to 15 digits).

   • Customer code: go to Setup > Company > Company Information and copy the Account ID.

     Note:

     Account ID can be found in the URL, copy the numerals proceeding the app.netsuite.com.

   • Role: go to Setup > Users/Roles > Manage Users and copy the Role internal ID.

4. Set Sent to שלח.

5. Select the book ( ספר) and dates.

Note:

When using a foreign entity, that is, a foreign vendor or foreign customer, make sure that the tax registration number of the foreign entity is set at 999999999.

General Notices