What is the VAT rate in Israel and how is it calculated?

The VAT rate in Israel is 18%. To calculate VAT from a total amount, divide by 1.18 to get the net amount, then subtract. For example: 1,180 / 1.18 = 1,000 ILS (net), VAT = 180 ILS. To calculate VAT from a net amount, multiply by 0.18.

What is the difference between output VAT and input VAT?

Output VAT is the VAT collected from customers on income. Input VAT is the VAT paid on business expenses. Net VAT liability (the amount to pay the tax authority) is output VAT minus input VAT.

Which expenses are tax-deductible in Israel?

Fully deductible expenses include: office rent, equipment, professional services, software and subscriptions, marketing, and insurance. Partially deductible: business meals (80%), car expenses (45% or fixed). Non-deductible: personal expenses, fines, and gifts over 220 ILS.

How often do I need to report VAT in Israel?

Most small businesses and freelancers in Israel report VAT bi-monthly (every two months). There are 6 reporting periods per year: January-February, March-April, May-June, July-August, September-October, and November-December. The deadline is the 15th of the month following the period end.

Can I use this tool without a paid Google Workspace account?

Yes. The gws CLI works with any Google account, including free Gmail accounts. You only need to set up a Google Cloud project (free) and authenticate via OAuth. The Google Sheets API is included in Google Cloud free tier quotas.

How do I export data for my accountant?

Run gws sheets spreadsheets values get with the --format csv flag to export a sheet range as CSV, for example: gws sheets spreadsheets values get --params '{"spreadsheetId":"...","range":"Sheet1!A:J"}' --format csv. The backup-sheets.py script automates multi-tab export. CSV files open in Excel and most Israeli accounting software.

What is an osek patur and how does it change the sheet?

An osek patur (exempt dealer) does not charge VAT on income and cannot reclaim input VAT on expenses. For an osek patur, drop the VAT columns, record gross amounts only, and skip the VAT-liability calculation. An osek murshe (authorized dealer) charges and reclaims VAT, so it needs the full net/VAT/total columns. Always confirm the user's status first. An osek patur whose annual turnover crosses the ceiling (NIS 120,000 for 2025, NIS 122,833 for 2026) must convert to osek murshe.

GWS Israeli Business Sheets

Trusted84/100

Before deciding whether to install, talk to the skill

Google Sheets financial tracking and automation for Israeli freelancers and small businesses using the Google Workspace CLI (gws). Use when user asks to create income/expense sheets with Shekel formatting, track VAT (18%) calculations, generate tax-period summaries for accountants, backup spreadsheets as CSV, or auto-log payments. Do NOT use for direct bank API integrations, payroll processing, or filing taxes with the Israel Tax Authority.

The Problem

Israeli freelancers and small businesses struggle to systematically track income and expenses. VAT calculations (18%), bi-monthly tax authority reports, and categorizing deductible expenses require tedious manual work in spreadsheets. Without automation, businesses miss tax deductions, delay filings, and waste hours preparing materials for their accountant.

skills-il Accounting|23installs1,093views

0Write a Review

1.1.0MITGitHub

23installs1,093views

0Write a Review

Updated: June 7, 2026|Tags:google-workspace google-sheets expense-tracking vat freelancer accounting

npx skills-il add skills-il/accounting@v1.1.0-gws-israeli-business-sheets --skill gws-israeli-business-sheets -a claude-code

Install on Claude.ai, Claude Desktop, ChatGPT, Manus, or other platforms

1. Click "Download ZIP" to download the skill files.
2. Open Claude Desktop and go to Customize > Skills.
3. Click "+" and select "Upload a skill", then upload the ZIP file.
4. Start a new conversation. The skill will activate automatically when relevant.

A new version released? How to update your installed skill

Not sure how? Read the guide

When to Apply

When you need to set up a new income/expense tracking spreadsheet structured for an Israeli business with Shekel formatting
When you need to automatically calculate VAT (18%) on income and expenses and generate a bi-monthly VAT liability summary
When you want to export financial data as CSV for your accountant or for local backup
When you need to batch-log multiple transactions from a bank statement with automatic categorization into tax-deductible categories
When you want to create summary reports by tax period (bi-monthly) with detailed output VAT and input VAT breakdown

Try These Prompts

Set Up Financial Tracking Sheet

Create a new Google Sheet to track my business income and expenses. Add columns for date, description, category, amount excluding VAT, 18% VAT, total amount, type (income/expense), invoice number, payment method, and notes.

Generate Bi-Monthly VAT Summary

Generate a VAT summary for January-February 2026 from my tracking sheet. Calculate total output VAT, input VAT, and net VAT liability. Export the summary as CSV for my accountant.

Batch Log Payments

Log these payments in my sheet: Client A paid 11,700 ILS for consulting (including VAT), I paid 526 ILS for AWS hosting, and 351 ILS for a business lunch. Calculate the VAT breakdown and categorize appropriately.

Backup and Export for Accountant

Back up all tabs in my tracking spreadsheet as CSV files in a backups folder. Export the main tracking sheet and all VAT period summary tabs separately.

Frequently Asked Questions

Changelog

v1.1.0

Replaced the fabricated gws command surface with the real Google Workspace CLI syntax, fixed VAT to 18%, and added osek patur/murshe branching plus tax-invoice and allocation-number requirements.

May 14, 2026

v1.0.2

Added Reference Links section pointing to official sources for fact verification.

Apr 15, 2026

Related Skills

Israeli Financial Reports

Verified·93

Author: skills-il

v1.2.0Popular

Generate Israeli-standard financial reports including profit and loss (Doch Revach VeHefsed), balance sheet (Maazan), trial balance (Maazan Bochein), and cash flow statements. Supports bilingual Hebrew/English output with NIS formatting, VAT summary reports for bi-monthly and monthly filing, year-end annual report preparation, and comparison periods. Works with Osek Patur, Osek Murshe, and Chevra (company) business types. Reflects the Israeli accounting-standards regime where full IFRS is mandatory only for public companies while private companies may use Israeli GAAP or IFRS for SMEs. Use when you need to produce financial statements, tax-related summaries, or periodic reports for Israeli businesses. Exports to PDF, Excel, and CSV formats. Do NOT use for tax filing submissions, payroll processing, or bank reconciliation workflows.

Ask the Skill

0.0751,333

Claude CodeCursorGitHub Copilot+4

Israeli Expense Categorizer

Verified·92

Author: skills-il

v2.0.0Popular

AI-powered categorization of business expenses into Israeli tax-deductible categories based on current Israeli Tax Ordinance rules. Applies the correct deduction mechanics (vehicle = the higher of running-costs-minus-use-value or 45%, mobile phone with the ~50% disallowance floor, home office and internet proportional), maps to a common Israeli chart of accounts, and handles Osek Patur vs Osek Murshe differences for VAT eligibility (private-car VAT not deductible, running-cost VAT two-thirds). Use when you need to classify business expenses for Israeli tax reporting, prepare expense reports for your accountant, or verify deduction eligibility. Do NOT use for final tax filing, legal tax advice, or payroll-related expense processing.

Ask the Skill

0.05001,536

Claude CodeCursorGitHub Copilot+4

Israeli Annual Reports

Trusted·88

Author: skills-il

v1.2.0Popular

Navigate and analyze Israeli corporate annual reports (dochot titkuftiim), financial filings, and regulatory disclosures. Use when user asks about Israeli annual reports, MAYA filings, IFRS financial statements, doch titkufti, dochot kaspiyim, or Companies Law reporting requirements. Covers TASE filing types, Israeli GAAP to IFRS transition, Hebrew financial terminology, and key financial statement analysis.

Ask the Skill

0.0461,373

Claude CodeCursorGitHub Copilot+5

Found an issue with this skill?

Use at your own risk. Terms of Use · Security

Want to build your own skill? Try the Skill Creator · Submit a Skill

Reviews (0)

No reviews yet. Be the first to write one!

GWS Israeli Business Sheets

When to Apply

Try These Prompts

Developer & AI Agent Instructions

Security Analysis

Quality Score

Performance Data

Frequently Asked Questions

What is the VAT rate in Israel and how is it calculated?

What is the VAT rate in Israel and how is it calculated?

What is the difference between output VAT and input VAT?

What is the difference between output VAT and input VAT?

Which expenses are tax-deductible in Israel?

Which expenses are tax-deductible in Israel?

How often do I need to report VAT in Israel?

How often do I need to report VAT in Israel?

Can I use this tool without a paid Google Workspace account?

Can I use this tool without a paid Google Workspace account?

How do I export data for my accountant?

How do I export data for my accountant?

What is an osek patur and how does it change the sheet?

What is an osek patur and how does it change the sheet?

Changelog

Related Skills

Israeli Financial Reports

Israeli Expense Categorizer

Israeli Annual Reports

Reviews (0)