skills.rest
amitpo23
amitpo23COMMUNITY
Explore all skills by this author →
GitHub

gws-israeli-business-sheets

Automates Google Sheets income and expense tracking with Israeli VAT calculations via the gws CLI.

Updated Jan 9, 2026
Search Tags:#expense tracking#google sheets#israel#vat#freelancer#tax reporting#gws cli
One-click install
npx skills add https://github.com/amitpo23/cfo --skill gws-israeli-business-sheets-amitpo23
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: gws-israeli-business-sheets
Source: https://github.com/amitpo23/cfo/tree/main/.agents/skills/gws-israeli-business-sheets
Command: npx skills add https://github.com/amitpo23/cfo --skill gws-israeli-business-sheets-amitpo23

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @google/gws, and includes scripts (resource) and references (resource) components.

What problem does it solve? Israeli freelancers and small businesses must track income and expenses with correct 18% VAT breakdowns and produce bi-monthly summaries for their accountants, which is tedious and error-prone when done manually in spreadsheets. ## Core Features & Use Cases - Structured Sheet Creation: Creates Google Sheets with a 10-column Israeli financial layout (dates, categories, net/VAT/gross amounts, invoice numbers) via the Google Workspace CLI. - Automatic VAT Calculation: Computes 18% VAT splits from gross or net amounts, applies deduction rates (80% meals, 45% car), and appends single or bulk transaction rows. - Tax-Period Reporting: Generates bi-monthly VAT summaries (income, expenses, VAT collected, input VAT, liability) and exports them as CSV backups for accountants. - Use Case: A freelancer says "log these three payments and prepare my January-February VAT summary" — the Skill categorizes each transaction, calculates VAT, appends the rows, and exports an accountant-ready CSV. ## Quick Start Ask the assistant to create a Google Sheet for tracking your freelance income and expenses with Israeli VAT using the gws CLI.

Frequently Asked Questions about gws-israeli-business-sheets

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I track freelance income and expenses in Google Sheets with VAT?▼

Use the gws CLI to create a spreadsheet with columns for date, description, category, net amount, VAT, and total. Each transaction is appended with gws sheets append, and VAT is calculated automatically at the 18% Israeli rate.

How do I calculate Israeli VAT from a total amount?▼

Divide the VAT-inclusive total by 1.18 to get the net amount, then subtract to get the VAT portion. For example, 1,180 ILS total equals 1,000 ILS net plus 180 ILS VAT at the current 18% rate.

What are the bi-monthly VAT reporting periods in Israel?▼

Israel uses six bi-monthly VAT periods: Jan-Feb, Mar-Apr, May-Jun, Jul-Aug, Sep-Oct, and Nov-Dec. Reports are due by the 15th of the month following each period, such as March 15 for January-February.

Does the gws CLI require special authentication for Google Sheets?▼

Yes, the gws CLI requires OAuth authentication through gws auth login after installing with npm install -g @google/gws. API keys and service accounts are not supported; a Google Cloud project must be configured first via gws auth setup.

Which business expenses are fully deductible in Israel?▼

Office rent, equipment, professional services, software subscriptions, marketing, and business insurance are 100% deductible. Meals are 80% deductible, car expenses are limited to 45% or a fixed amount, and home office costs are proportional.

Can this skill file taxes or connect to my bank directly?▼

No, it does not file taxes with the Israel Tax Authority, process payroll, or integrate with bank APIs. It only manages Google Sheets data and generates summaries you provide to your accountant.

Related Skills

Explore More Finance & Accounting Skills→
steveclarkesteveclarke
35

invoice-organizer

Extract invoice data from PDFs and images into a CSV summary.

Community
Advanced
skills-ilskills-il
10

israeli-vat-reporting

Automate Israeli VAT report preparation, validation, and submission guidance.

Official
Advanced
skills-ilskills-il
10

il-invoice-organizer

Parse Hebrew invoices and extract VAT using the 1/6 rule.

Official
Advanced
skills-ilskills-il
10

hashavshevet-data-tools

Import and export Hashavshevet accounting data between JSON, CSV, and Excel formats.

Official
Advanced