Israeli Spreadsheets
Community60/100The Problem
Israeli financial spreadsheets require knowledge of specific tax brackets, VAT rates, Bituach Leumi contributions, municipal arnona rates, and NIS currency formatting. Without this skill, developers must research and hardcode these constantly changing values, risking errors in tax calculations and financial reports.
Author: @skills-il
Generate Excel spreadsheets with Israeli tax calculations, VAT, NIS formatting, and Hebrew-labeled financial templates.
npx skills-il add skills-il/developer-tools/israeli-spreadsheetsWhen to Apply
- When creating Israeli tax invoices (heshbonit mas) with proper VAT calculations
- When building salary slip (tlush maskoret) templates with all Israeli payroll deductions
- When estimating income tax liability using the 2025 Israeli tax brackets
- When calculating arnona (municipal property tax) for different Israeli cities
- When generating financial reports with NIS currency formatting and Hebrew labels
Instructions
Step 1: Set Up Python Environment
Install openpyxl:
pip install openpyxlStep 2: Israeli Financial Constants
- VAT rate: 17% (2025)
- Tax brackets 2025: 10% up to 84,120 NIS, 14% up to 120,720, 20% up to 193,800, 31% up to 269,280, 35% up to 560,280, 47% up to 721,560, 50% above
- Credit point value: 2,904 NIS/year, 2.25 points for residents
- Bituach Leumi: 0.4% (low) / 7% (high)
- Health tax: 3.1% (low) / 5% (high)
Step 3: Tax Calculation Functions
Progressive (marginal) tax calculation with credit point deduction. Use Python Decimal for precision.
Step 4: Formatted Workbooks
Set ws.sheet_view.rightToLeft = True for RTL sheets. NIS format: '#,##0.00 "₪"'
Step 5: Templates
- Invoice (Heshbonit Mas): Business/customer details, item table, subtotal, 17% VAT, total
- Salary slip (Tlush Maskoret): Earnings, deductions (income tax, Bituach Leumi, health tax, pension, keren hishtalmut), net pay
- Arnona estimator: Rates by city (Tel Aviv 55.80, Jerusalem 40.50, Haifa 33.20, Beer Sheva 27.90, Netanya 43.10 per sqm/bi-monthly)
Metadata
GitHub:israeli-spreadsheets
installs:0
views:24
reviews:0 (0.0)
Created:March 3, 2026
Updated:March 3, 2026
Supported Agents
Claude Code
Tags
exceltaxvatshekelaccounting
Best Practices
- Use Python Decimal type (not float) for all monetary calculations to avoid precision errors
- Apply tax brackets progressively (marginal rates), not as flat rates on the entire income
- Always verify tax rates against the latest Israel Tax Authority publications before production use
- Set ws.sheet_view.rightToLeft = True for proper RTL sheet direction in Excel
- Format NIS amounts with shekel symbol and two decimal places for financial documents
Avoid
- Do not use this skill for Google Sheets or CSV files; it generates XLSX files only
- Do not rely on the embedded tax rates for official tax filing; always verify with the Israel Tax Authority for the current year
- Arnona rates are approximate; actual rates vary by neighborhood and property classification within each city
- Do not use float arithmetic for financial calculations; always use Decimal with ROUND_HALF_UP
Try These Prompts
Israeli Tax Invoice
Create an Israeli tax invoice (heshbonit mas) in Excel with itemized products, 17% VAT calculation, business details, and customer information. Format all amounts in NIS.
Income Tax Calculator
Build an income tax calculator spreadsheet using the 2025 Israeli tax brackets. Show the marginal rate breakdown, credit point deductions, Bituach Leumi, health tax, and final net income.
Salary Slip Template
Generate a Hebrew salary slip template with all standard Israeli payroll components: base salary, overtime, bonus, income tax, Bituach Leumi, health tax, pension (employee and employer), and keren hishtalmut.
Arnona Calculator
Create an arnona (municipal property tax) calculator spreadsheet comparing rates across Tel Aviv, Jerusalem, Haifa, Beer Sheva, and Netanya. Show bi-monthly and annual totals for different apartment sizes.
Security Analysis
60/100
Trust Score
Code Quality65
Permissions45
Data Handling72
Publisher Reputation40
Maintenance65
Documentation78
Pending reviewv13/3/2026
Checks Performed
Snyk Agent Scan (Not scanned)
Cisco Skill Scanner (Not scanned)
Skill spec validation
Tool permission scope analysis
Content pattern scanning
GitHub repository verification
Code quality assessment
Maintenance activity check
License verification
Risk Factors
Quality Score
66Architecture65
Maintainability62
Content82
Spec Compliance85
Community35
Frequently Asked Questions
Are the tax brackets in this skill up to date?
The skill includes 2025 Israeli income tax brackets as published by the Israel Tax Authority. Tax brackets are updated annually, so always verify against the latest official publications for the current tax year.
What is the current Israeli VAT rate?
The Israeli VAT (ma'am) rate is 17% as of 2025. This rate has been stable since 2015. The skill uses this rate for all VAT calculations.
How accurate are the arnona rates?
The arnona rates are approximate averages for residential properties in major cities. Actual rates vary by neighborhood, property classification (residential vs. commercial), building age, and other municipal factors. Contact your local municipality for exact rates.
Does this handle employer-side payroll calculations?
The salary slip template includes employee deductions (income tax, Bituach Leumi, health tax, pension, keren hishtalmut). Employer-side contributions (pension match, severance, keren hishtalmut) can be added to the template.
Can I use this for official tax filing?
This skill is for estimation and planning purposes. For official tax filing, use the Israel Tax Authority systems or consult a certified accountant (ro'eh heshbon). Always verify calculations against official rates.
Related Skills
Israeli Phone Formatter
Author: skills-ilTrusted83/100
Validate, format, and convert Israeli phone numbers between local and international (+972) formats. Use when user asks to validate Israeli phone number, format phone for SMS, convert to +972, check phone prefix, or implement Israeli phone input validation in code. Handles mobile (050-058), landline (02-09), VoIP (072-077), toll-free (1-800), and star-service numbers. Do NOT use for non-Israeli phone systems or general telecom questions.
0.00189
Claude CodeCursorGitHub Copilot+4
Israeli Agritech Advisor
Author: skills-ilTrusted74/100
Guide developers in integrating Israeli agritech tools and precision agriculture platforms including CropX (soil monitoring), Netafim GrowSphere (IoT irrigation), Taranis (crop intelligence), and 750+ Israeli agritech companies. Use when user asks about agritech APIs, precision agriculture, smart irrigation, "hashkaya cham", crop monitoring, pest detection, Israeli agriculture tech, or needs to build farm management software. Covers irrigation optimization, pest detection, climate data integration, and Israeli agricultural context. Do NOT use for general gardening advice or non-agricultural IoT projects.
0.00196
Claude CodeCursorGitHub Copilot+3
Idf Date Converter
Author: skills-ilTrusted80/100
Convert between Hebrew (Jewish) calendar and Gregorian dates, look up Israeli holidays, format dual dates for Israeli documents, and calculate Israeli business days. Use when user asks about Hebrew dates, "luach ivri", Jewish calendar, Israeli holidays, "chagim", Shabbat times, or needs dual-date formatting for Israeli forms. Do NOT use for Islamic Hijri calendar or non-Israeli holiday calendars.
0.00237
Claude CodeCursorGitHub Copilot+4
Want to build your own skill? Try the Skill Creator · Submit a Skill
Reviews (0)
No reviews yet. Be the first to write one!