Check the File Content

To ensure the accuracy of the generated file, it's essential to review the processed data.

To check the data that was processed to generate the file:

  1. Navigate to Schedule Processes.
  2. Select the Generate VAT Report for Israel process that produced the file.
  3. Click the Republish button in the Output section.
  4. In the popup window, select the Actions icon and Export->CSV.
  5. Open the CSV output in your spreadsheet application.
  6. You can now review the raw data that was processed. For example, the column VAT_FILE_LINE_TYPE shows transactions that may not have a VAT file line type associated, and therefore, exclude from the file.

Appendix A - Tax Reporting Codes

This table shows the tax reporting codes which are provided for use with the VAT File in 835 Format for Israel.

Reporting Type Code Reporting Code Description
Reporting Type Code Reporting Code Description
ORA_JEIL_835_LINETYPE T Payables Standard VAT
C Payables VAT Self-Invoicing
K Payables VAT Petty Cash
R Payables VAT Foreign Imports
P Payables VAT Palestinian Supplier
H Payables Miscellaneous Classifications
S Receivables Standard VAT
L Receivables VAT Unknown Customer or Missing Tax Registration
M Receivables VAT Self-Invoicing
Y Receivables VAT Export Invoices
I Receivables VAT Palestinian Customer
ORA_JEIL_835_SECONDARY A Asset Purchase