Free tool

12-month cash-flow forecast for Israel

Profit is not cash. See your bank balance month by month once customer payment terms, bimonthly VAT and income tax advances are taken into account, and spot the months where cash runs short.

100% freeNo sign-up

A personal tool, not professional advice. These are calculation tables I built for my own decisions and now share freely. Please check every figure and assumption yourself before relying on it.

Starting point

Cash in the bank today

₪

Including any credit line you have already drawn

First month of the forecast

Sales

Monthly sales

₪

Invoiced in month 1, excluding VAT

Monthly growth

Compounded each month

When customers pay you

Shotef plus is common in Israel: shotef + 60 can mean 60 to 90 days in practice.

Costs

Monthly operating costs

₪

Rent, software, marketing, accountant, excl. VAT

Cost of sales

Purchases and subcontractors, % of sales, paid in the month

Salaries

₪

Total employer cost per month, including your own salary

VAT and income tax

Costs with deductible VAT

Share of your costs on which you reclaim input VAT

Income tax advances

Rate set by the tax authority, % of monthly turnover

Lowest cash balance

-₪12,654

Cash goes below zero in: Dec 26, Jan 27.

Tightest monthJan 27

Cash after 12 months₪129,136

Still owed by customers at the end₪225,345

Sales invoiced over 12 months₪993,442

Cash collected over 12 months₪946,916

You would need about ₪12,654 more cash, a credit line or faster payments from customers to get through the tightest month.

Over the 12 months

Collected from customers (incl. VAT)₪946,916

Costs paid (incl. VAT)-₪433,220

Salaries-₪360,000

VAT paid-₪99,734

Income tax advances-₪44,827

Change in cash₪9,136

Bank balance month by month

End-of-month balanceNet cash flow of the month

Month by month

Month	Invoiced	Collected	Costs	Salaries	VAT	Advances	Net	Balance
Nov 26	₪70,000	₪0	-₪33,176	-₪30,000	-	₪0	-₪63,176	₪56,824
Dec 26	₪72,100	₪0	-₪33,656	-₪30,000	-	-₪3,500	-₪67,156	-₪10,332
Jan 27	₪74,263	₪82,600	-₪34,151	-₪30,000	-₪17,166	-₪3,605	-₪2,322	-₪12,654
Feb 27	₪76,491	₪85,078	-₪34,661	-₪30,000	-	-₪3,713	₪16,704	₪4,049
Mar 27	₪78,786	₪87,630	-₪35,186	-₪30,000	-₪18,474	-₪3,825	₪146	₪4,195
Apr 27	₪81,149	₪90,259	-₪35,727	-₪30,000	-	-₪3,939	₪20,593	₪24,788
May 27	₪83,584	₪92,967	-₪36,284	-₪30,000	-₪19,862	-₪4,057	₪2,763	₪27,552
Jun 27	₪86,091	₪95,756	-₪36,858	-₪30,000	-	-₪4,179	₪24,719	₪52,271
Jul 27	₪88,674	₪98,629	-₪37,449	-₪30,000	-₪21,335	-₪4,305	₪5,541	₪57,811
Aug 27	₪91,334	₪101,588	-₪38,057	-₪30,000	-	-₪4,434	₪29,097	₪86,908
Sept 27	₪94,074	₪104,635	-₪38,684	-₪30,000	-₪22,897	-₪4,567	₪8,487	₪95,395
Oct 27	₪96,896	₪107,774	-₪39,330	-₪30,000	-	-₪4,704	₪33,741	₪129,136

Invoiced is shown excluding VAT, cash columns include VAT. Months highlighted in gold end with a negative balance.

VAT is due on what you invoice, not on what you collect: with long payment terms you often pay the VAT on a sale before your customer has paid you. The two-month period (January and February, March and April...) is paid in the following month.

A simplified forecast: advances are paid the month after the turnover, VAT refunds arrive in the payment month, and annual tax, Bituach Leumi for the self-employed, loans and investments are not included.

These calculators are spreadsheets I originally made for my own use, shared as they are to help you think things through. They give estimates based on the published rates for the current tax year and on the assumptions you enter, and they may contain errors or simplifications. They are not tax, legal or financial advice: check all the information yourself and with a licensed accountant, lawyer or mortgage adviser before making any decision.

Want a second opinion on your numbers?

We help buyers, owners and investors in Israel every week, from choosing the right apartment to managing it once it’s yours. Tell us what you’re planning.

Talk to Reztate

More free tools

Break-even

How many sales you need each month to cover your costs, and how long it takes to get there.

Open the tool

Pricing and margin

From cost to price for the margin you want, or from price to margin, with VAT and platform fees.

Open the tool

Cap table and dilution

Founders, option pool, SAFEs and priced rounds: who owns what after each round, and what it is worth.

Open the tool