skills.rest
skills-il
skills-ilOFFICIAL
Explore all skills by this author →
WebsiteGitHub

gws-israeli-business-sheets

Automate income and expense tracking with VAT calculations in Google Sheets.

10|6|Updated Mar 8, 2026
Search Tags:#expense tracking#google sheets#gws cli#israeli accounting#vat reporting#freelancer finance
One-click install
npx skills add https://github.com/skills-il/accounting --skill gws-israeli-business-sheets
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: gws-israeli-business-sheets
Source: https://github.com/skills-il/accounting/tree/main/gws-israeli-business-sheets
Command: npx skills add https://github.com/skills-il/accounting --skill gws-israeli-business-sheets

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines financial tracking and automation for Israeli freelancers and small businesses by leveraging Google Sheets and the Google Workspace CLI, simplifying tasks like expense categorization, VAT calculation, and report generation.

Core Features & Use Cases

  • Automated Spreadsheet Setup: Creates structured Google Sheets for income and expense tracking with Israeli financial conventions.
  • VAT Calculation & Reporting: Automatically calculates VAT on transactions and generates bi-monthly summaries for tax purposes.
  • Data Export & Backup: Exports financial data to CSV for accountants or local backups.
  • Use Case: A freelancer can use this Skill to automatically log all their income and expenses, calculate the VAT due for the period, and generate a summary report to send to their accountant.

Quick Start

Use the gws-israeli-business-sheets skill to create a new Google Sheet for tracking business income and expenses.

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 Israeli business expenses and income in Google Sheets?▼

No, you do not need manual VAT calculations for bi-monthly reporting. The automation calculates VAT on your logged transactions and generates bi-monthly tax-period summaries automatically, streamlining your reporting workflow.

Do I need Node.js and Google Workspace CLI to automate freelancer finance tracking?▼

You can export your financial tracking data to CSV format. This creates local backups of your income and expense logs or allows you to share transaction summaries directly with your accountant for tax purposes.

Can I use Google Sheets for VAT reporting as an Israeli freelancer?▼

Yes, you can use Google Sheets for VAT reporting as an Israeli freelancer. The system automatically applies Israeli financial conventions to calculate VAT on transactions and generates bi-monthly summaries for tax periods.

What is the best way to generate bi-monthly VAT summaries for Israeli accounting?▼

The best way to generate bi-monthly VAT summaries for Israeli accounting is automating the calculation directly within Google Sheets. It processes your logged income and expenses to produce accurate tax-period reports without manual math.

Related Skills

Explore More Finance & Accounting Skills→
Oruga420Oruga420

gws-installer

Install and configure the Google Workspace CLI for terminal access.

Community
Advanced
skills-ilskills-il
10

israeli-vat-reporting

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

Official
Advanced
jordanhubbardjordanhubbard
9

google-workspace

Automate Gmail, Calendar, Drive, Docs, and Sheets via Python scripts.

Community
Intermediate
skills-ilskills-il
10

il-invoice-organizer

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

Official
Advanced