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) · 7+ installs · 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.
choroshinnpx skills-il add skills-il/accounting --skill gws-israeli-business-sheets -a claude-codeInstall 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.
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
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
Related Skills
Author: skills-ilGenerate Israeli-standard financial reports including profit and loss (Doch Ruvach 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. Compliant with Israeli accounting standards based on IFRS adaptations. 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.
Author: skills-ilOCR and parse Israeli receipts and invoices with Hebrew and English text extraction. Extracts merchant name, date, total amount in NIS, VAT amount, receipt or invoice number, payment method, and VAT registration number (osek murshe). Handles common Israeli retail formats including supermarkets, gas stations, restaurants, and online purchases. Auto-categorizes expenses into standard Israeli accounting categories and outputs structured JSON or CSV ready for import into accounting software. Use when you need to digitize, extract data from, or categorize Israeli receipts and tax invoices. Do NOT use for non-Israeli receipt formats, handwritten notes without printed text, or bank statement reconciliation.
Author: skills-ilCalculate Israeli payroll including income tax, Bituach Leumi (National Insurance), health tax, pension contributions, and net salary. Use when user asks to calculate salary, "tlush maskoret", payroll deductions, "bruto to neto", employer cost, tax credits (nekudot zikui), or needs help understanding Israeli payslip items. Covers employees, freelancers (atzmai), and employer cost calculations. Do NOT use for US, UK, or other countries' payroll calculations.
Use at your own risk. Terms of Use · Security
Want to build your own skill? Try the Skill Creator · Submit a Skill