Reports

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

Israeli Saved Tax Reports

Israeli Saved Tax Reports include following:

Israeli Saved Financial Reports

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

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

Israeli Open Format

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, and Mark: 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 List, 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

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

  4. 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

In order 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 Accounting Books section, choose Primary And Selected, and then select Adjustment Book and Secondary Accounting book.

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

  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.

General Notices