GWS Israeli Business Sheets
Trusted81/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 81/100 (Trusted) · 43+ 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.2.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
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
Added Reference Links section pointing to official sources for fact verification.
Apr 15, 2026
Related Skills
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-ilIntegrate Green Invoice (Morning) API for Israeli invoicing, receipts, client management, and payment processing. Use when user asks to create invoices via Green Invoice, generate hashbonit mas through Morning API, manage clients in Green Invoice, set up webhook automation for document creation, query documents or expenses, or mentions "Green Invoice", "Morning", "hashbonit yeruka", "greeninvoice API", Israeli cloud invoicing, or needs to create tax invoice-receipt (cheshbonit mas/kabala). Covers all 13 document types, 8 payment types, client CRUD, item catalog, and webhook integration. Do NOT use for SHAAM allocation numbers or Tax Authority e-invoice compliance (use israeli-e-invoice), Cardcom payment processing (use cardcom-payment-gateway), or Tranzila integration (use tranzila-payment-gateway).
Author: skills-ilGenerate, validate, and manage Israeli e-invoices (hashbonit electronit) per Tax Authority (SHAAM) standards. Use when user asks to create Israeli invoices, request allocation numbers, validate invoice compliance, or asks about "hashbonit", "e-invoice", "SHAAM", "allocation number", or Israeli invoicing requirements. Uses the official SHAAM document type codes including transaction invoice (300), tax invoice (305), periodic tax invoice (310), tax invoice/receipt (320), credit invoice (330), and proforma (332). Do NOT use for general accounting, bookkeeping, or non-Israeli invoice formats.
Use at your own risk. Terms of Use · Security
Want to build your own skill? Try the Skill Creator · Submit a Skill