Where the numbers in Israel's annual 856 withholding report come from, how to aggregate payments and deductions per supplier, and which reconciliations to run before filing.
Key takeaways
- 856 is an aggregation, not a source. Every number in it must be explainable from existing payment lines.
- The grouping key is the supplier's numeric identifier, never the name. A name is a source of duplicates, not a key.
- Filing is online, and the standing date is 30 April for the closed tax year. The Tax Authority has published extensions in particular years.
- The reconciliation that matters is total withholding in the report against what was actually reported and paid during the year.
- The 806 certificate handed to a supplier and that supplier's line in the 856 must tell the same story.
Form 856 is Israel's annual report of tax withheld from payments to suppliers and service providers, filed online with the Tax Authority. Nothing in it is new data - it is a yearly aggregation of payment transactions you already hold, grouped per supplier and per identifier. The manual work almost always comes from identifiers that are not clean.
Where the numbers come from
The report summarises, per supplier, the amounts paid during the tax year and the tax withheld from them. In an average system that information sits in three different places, which is exactly why producing it hurts:
| The value | Where it actually lives | The usual problem |
|---|---|---|
| Amount paid to the supplier | Payment transactions, bank file or Masav file | One payment covering several invoices from different suppliers |
| Amount withheld at source | A journal entry or a field on the payment | Withholding recorded on the invoice rather than on the payment |
| Supplier identifier | The supplier record | One supplier with two records and two identifiers |
| The rate that was in force | The certificate stored on the record | The certificate changed mid-year and nobody recorded when |
That last row is why supplier verification and 856 output are really the same project. If validity dates were never stored as fields, there is no way to explain retroactively why 5% was withheld in February and 0% in May. The groundwork for that is covered in automated supplier verification.
What the production process looks like when it is automated
- Extract. Pull every payment transaction in the tax year with supplier identifier, value date, gross amount and amount withheld.
- Normalise identifiers. Strip whitespace, cast to string, preserve leading zeros, and collapse duplicate supplier records onto one canonical identifier.
- Aggregate. Sum by supplier identifier - not by name, not by record.
- Reconcile. Compare aggregated withholding against the periodic filings transmitted during the year.
- Exceptions report. Produce a list of everything that does not tie out, before generating any output.
- Generate. Only once the exceptions list is empty or explicitly approved.
Step five is the one that decides whether this was worth building. A system that produces an 856 without an exceptions report has not saved work; it has moved the checking onto the accountant.
How do you handle a supplier with two records?
Collapse them onto one canonical identifier before aggregating, never after. Duplicate suppliers appear for three recurring reasons:
- Entered once with a hyphen in the number and once without.
- A new record opened when the supplier changed trading name.
- The same entity exists both as a supplier and as a one-off service provider on another record.
The fix is not deletion. Mark one record primary, point the others at it, and route every aggregation query through the primary identifier. Deleting a record breaks payment history and leaves orphan transactions that will not appear in the report at all.
What do you check before filing?
Five reconciliations catch nearly every error:
- Total withholding against periodic filings. If the annual figure does not tie to what was reported and paid during the year, there is a gap that needs explaining.
- Payments with no supplier identifier. Any transaction without a valid identifier is a line that will not appear in the report.
- A withheld rate that appears on no certificate. Signals a hand-typed rate or an expired certificate.
- Negative amounts. Credits and refunds recorded as negative payments distort the aggregate.
- Year-boundary transactions. A payment with a value date of 31 December and a posting date in January needs one consistent rule, applied the same way every year.
How does 856 relate to the 806 certificate the supplier receives?
They are two sides of the same fact. The 806 certificate is the annual confirmation you give the supplier of tax withheld from payments to them; Form 856 is the filing you submit to the Tax Authority covering those same deductions. If a supplier holds a certificate for one figure and the report carries another, the gap surfaces - because it is visible from both directions.
That is why both documents should be produced from the same aggregation query, in the same run. Generating them separately, weeks apart, is the reliable way to create a mismatch nobody can explain six months later.
What happens when a supplier changed legal entity mid-year
This is the case that breaks the most automated productions, because it looks like one supplier and behaves like two. A sole trader that incorporates receives a new company number, and payments before and after the change belong to two entirely separate entities - even though they came from the same contact and went to the same bank account.
- Payments before the change aggregate under the old identifier and payments after it under the new one. Merging them produces a wrong line.
- One withholding certificate does not cover both entities, and if somebody swapped the number on the record by hand, the validity dates did not travel with it.
- Where the entity number was "updated" in place instead of opening a new record, the entire history silently moved to the new identifier, and the output will look clean while being wrong.
The design rule is simple: a legal entity identifier is a field you never edit. An entity change opens a new record linked to the previous one, and the aggregation query respects the date the change took effect. The same problem, with the roles reversed, is covered in automated supplier verification.
What to keep so next year is easier
- A snapshot of the data the report was produced from, not only the output.
- Historical validity dates and withholding rates, stored as fields with a date range.
- The duplicate-to-primary identifier mapping, stored rather than recomputed each year.
- The exceptions report as it stood at production time, including what was manually approved and by whom.
- The version of the rules used, so a re-run gives the same result.
Related: checking a withholding certificate before paying a supplier, automating payment-to-invoice matching, Masav supplier payment files.
Sources
Frequently asked questions
When is Form 856 due?
The standing date is 30 April for the tax year that closed, and filing is online. In particular years the Tax Authority has published extensions for the 126 and 856 reports. The binding date for any given year should be confirmed against Tax Authority announcements and with your accountant.
Can the report be produced from a spreadsheet?
The totals can technically be computed in a sheet, but then there is no exceptions report, no stored canonical identifiers and no way to reproduce the run. The problem with a spreadsheet is not the arithmetic - it is traceability. Next year nobody will know which manual adjustments were applied.
What if total withholding does not tie to the filings made during the year?
Do not adjust the total. Find the transactions creating the gap - usually year-boundary payments, credits recorded as negatives, or withholding attached to an invoice rather than the payment - and correct them at source. Then re-run the production process from the corrected data.
Do suppliers with no tax withheld need to be reported?
That is a question about reporting scope, answered by Tax Authority instructions and your accountant, not by the system. Technically it is worth holding the data regardless: a system that aggregates only payments with withholding cannot answer the question later without a rebuild.
Keep reading
automation
Automated Supplier Verification in Israel: Withholding Tax, Company Registry and Bank Details in One Check
automation
Digital Form 101 and Tax Coordination: The Workflow for a Business With Employees
automation
Uniform Format (OPENFRMT): What a BKMVDATA File Is and Why Your Accountant Wants It
Related service
Dashboards
One screen with the few numbers that actually change a decision.
About the author
Yehonatan Saadia
Freelance automation, web & MVP developer
I'm Yehonatan Saadia, a senior developer who builds business automation, custom websites, and MVPs for small and mid-sized companies across the US, Europe, and Israel. These guides come from real client work, not theory.
Work with meHave a project like this?
Tell me what you're trying to automate or build. I reply within 24 business hours with a few targeted questions, then we walk through it on a free 30-minute call, with no commitment. You come away with a scope, a timeline and a fixed price - or a straight answer that it isn't worth building.
