Invoicing in Excel - What's Allowed and What Breaks

Searching for "invoice in Excel" is nearly always the same question: can I get by without paying for software. The honest answer is yes, for a while, under certain conditions. This page sets out what the law actually requires, where a spreadsheet breaks, and what the signal is that it's time to stop.

The law doesn't talk about software

The bookkeeping regulations don't mandate a particular product. They mandate a result: a document with all mandatory fields, running sequential numbering, a document that can't be altered after issue, and the ability to produce everything going back seven years.

Excel clears the first requirement easily. The other three are the problem, and none of them looks like a problem in month one.

Three things a spreadsheet doesn't do

Numbering breaks quietly

This is the first failure, and it's close to inevitable. A file opened "just to check something", saved under a new name, copied to another folder or edited after it was sent produces a duplicate or a gap. Nobody notices at the time.

A Tax Authority audit looks for precisely this. A broken sequence has to be explained, sometimes with an amended filing, and fixing it after the fact costs far more than was ever saved.

The document stays editable

An issued document is supposed to be final. In Excel you can open last year's invoice, change an amount, save, and export a fresh PDF identical to the old one. Nothing in the file records that this happened.

A digital signature exists for exactly this: it's created by the issuing system at the moment of issue, and any later change breaks it. A spreadsheet can't generate one by itself.

Seven-year retention

The retention requirement is seven years, in a state where documents can actually be produced. A folder on a personal machine isn't a retention mechanism: computers get replaced, drives die, folders scatter across a desktop, a cloud drive and an old backup.

The real test comes two years later, when a specific invoice is requested and turns out to live in a different version of the file.

The Open Format file

During an audit, the Tax Authority can request an Open Format file: a fixed-format export of every transaction and document in a period. The format is produced from a system that holds the data in structured form.

Reconstructing it by hand from a spreadsheet is a multi-day project, assuming the data even exists and is consistent. This is the point where most people who started in Excel discover they have to move, usually at the worst possible moment.

The hard stop: allocation numbers

Above the allocation number threshold, ILS 5,000 before VAT since June 2026, a tax invoice must carry a number obtained from the Tax Authority before it's handed to the customer. Without it, the customer can't deduct input VAT, and they will find out and call.

You can request a number manually in the Tax Authority's personal area and type it into the spreadsheet. That works for a one-off, and falls apart at any steady rate: every invoice above the threshold becomes two systems and a hand-copied number, and one typo invalidates the customer's deduction.

What's actually being saved

The calculation most people run is software cost against zero. The full one includes time: retyping repeat customer details, tracking by hand what's been paid and what hasn't, gathering figures for the VAT report, and accountant hours spent tidying a spreadsheet instead of doing work.

And risk: broken numbering, a document you can't prove wasn't altered, and an invoice with no allocation number that a customer can't deduct VAT on.

The simple way to check

Before downloading an Excel template, it's worth issuing one real document in a system and seeing how it comes out. You can issue an invoice for free in Slate, with no installation, and it includes stored sequential numbering, a digital signature, document retention and an automatic allocation number request above the threshold.

Anyone already on other software and looking to move will find the order of operations in the switching invoicing software guide, including what to do about existing numbering.

This is general information, not tax advice. For a specific case, consult an accountant or tax adviser.

Common questions

Is it legal to issue invoices from Excel?

The law doesn't mandate any particular software, but it does require a document that satisfies the bookkeeping regulations: running sequential numbering, all mandatory fields, a document that can't be altered after issue, and seven-year retention. A plain Excel file doesn't deliver the last three on its own.

What's the main problem with invoicing in Excel?

Numbering. A file that gets opened, saved under a new name or copied breaks the sequence without anyone noticing, and a missing or duplicated number is exactly what an audit looks for.

Can you digitally sign an invoice made in Excel?

Not from within Excel. A digital signature proving the document hasn't changed since issue is produced by the issuing system, and neither the spreadsheet nor a PDF exported from it carries one.

Can you produce an Open Format file from Excel?

Not directly. Open Format is a fixed export the Tax Authority asks for during an audit, produced from a system that holds the data in a structured way. Reconstructing it by hand from a spreadsheet is days of work.

Can an osek patur manage with Excel?

At very low volume it works, because there's no VAT, no periodic report and no allocation number. Problems start with a steady issuing rhythm, with retention over seven years, and with an audit request.

When does Excel definitely stop working?

When an allocation number is required on a tax invoice above the threshold. The number has to come from the Tax Authority before the invoice is handed to the customer, and a spreadsheet doesn't do that.

Share