GWS Israeli Business Sheets
Trusted79/100Google 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.
Trust score 79/100 (Trusted) · 44+ installs · 2 GitHub contributors · MIT license
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-ilHow to use this skill
Not sure how? Read the guide- 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.
Developers? Install via command line (CLI)
npx skills-il add skills-il/accounting@v1.3.0-gws-israeli-business-sheets --skill gws-israeli-business-sheets -a claude-codeWhen 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
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 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.
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.
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
Important correction: the monthly VAT filing threshold is NIS 1,775,000 (was a stale 1,520,000), and the separate detailed-reporting obligation (PCN874) is now covered, which applies to a self-employed individual above NIS 500,000 from 2026 and has a much lower threshold than the filing-frequency one. The allocation-number threshold is now presented as the NIS 5,000 figure in force since June 2026. Added the input-VAT deductibility limits that were missing entirely: none on a private vehicle, none on hospitality and refreshments, and two thirds or one quarter on mixed business/private inputs. The 80% rate was corrected to apply only to light refreshments at the place of business, and the vehicle income-tax test was corrected to the higher of 45% or upkeep minus the use value. Added a warning that a Google Sheet is not a legal book of account. The VAT script no longer reports a silent zero for currency-formatted cells.
Jul 26, 2026
Update: added allocation-number (Israel Invoice) + withholding columns, corrected the monthly-VAT threshold (1.52M), reclassified equipment as a depreciable asset, and the 7-year retention rule.
Jun 26, 2026
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
Related Skills
Author: skills-ilExplains how a payslip in Israel's public-healthcare system is actually built, which is nothing like private-sector pay. The salary is set by collective agreements and by wage grade (dirug): nurses, three separate allied-health grades (occupational therapy, physiotherapy, and the para-medical grade for dietitians and speech clinicians), pharmacists in the academic grade, and doctors under the IMA agreement. The skill identifies the right grade, reads the combined salary by rank and seniority, adds healthcare-specific supplements like the nurses' tosefet achayot, the banded allied-health training supplement, and doctors' on-call and duty pay valued in workdays, and shows how gross becomes net. Useful for nurses, allied-health workers, doctors, hospital payroll staff, and anyone reading a healthcare payslip. Do NOT use for standard private-sector payroll, teachers' pay, or employing a home caregiver.
Author: skills-ilAI-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.
Author: skills-ilExplains how an Israeli teacher's salary is actually built, which is nothing like private-sector pay. Teacher pay is set by one of two reforms: Ofek Chadash (kindergartens, elementary, and junior-high) or Oz LaTmura (upper-secondary only), and each has its own work-week structure, rank-and-seniority table, and increments (gmulim). The skill identifies the right reform, reads the split between front-of-class hours and private and stay hours, adds gmulim like gmul hishtalmut and gmul chinuch, and shows how gross becomes net. It also covers the split appointment, where a teacher teaches in both a junior-high and a high school and earns under both reforms at once (each part by its position fraction), plus salary unification versus tax coordination. Useful for teachers, kindergarten teachers, school payroll staff, and anyone reading a teacher's payslip. Do NOT use for standard private-sector payroll, bookkeeping entries, or Bagrut and school-system navigation.
Use at your own risk. Terms of Use · Security
Want to build your own skill? Try the Skill Creator · Submit a Skill