Checking 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:
- Navigate to Schedule Processes.
- Select the Generate VAT Report for Israel process that produced the file.
- Click the Republish button in the Output section.
- In the popup window, select the Actions icon and Export->CSV.
- Open the CSV output in your spreadsheet application.
- 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
The following 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 |
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 |