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:
- 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
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 |