GWS Israeli Business Sheets
Trusted72/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 72/100 (Trusted) · 7+ installs · MIT license
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.
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
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
Related Skills
Trusted·78
Author: skills-ilv1.0.2Popular
Generate, 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. Supports tax invoice (300), tax invoice/receipt (305), credit invoice (310), receipt (320), and proforma (330) types. Do NOT use for general accounting, bookkeeping, or non-Israeli invoice formats.
0.075565
Claude CodeCursorGitHub Copilot+5
Trusted·72
Author: skills-ilv1.1.0PopularTrending
Integrate 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).
5.0113424
Claude CodeCursorGitHub Copilot+5
Trusted·87
Author: skills-ilv1.0.2PopularTrending
Calculate 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.
0.0134757
Claude CodeCursorGitHub Copilot+6
Found an issue with this skill?
Want to build your own skill? Try the Skill Creator · Submit a Skill
Reviews (0)
No reviews yet. Be the first to write one!