Reconciling your OpenFiskal totals with the Agenzia delle Entrate portal
OpenFiskal sends every sale to the Agenzia delle Entrate (AdE, the Italian Revenue Agency). The AdE Reconciliation report inside OpenFiskal puts your Shopify sales next to what was transmitted by OpenFiskal, and shows you whether they match. When the totals look different, the cause is usually one of three things: reading a single payment column on the portal instead of the whole block, a channel you do not fiscalize, or a register that was never fiscalized, but was used to make sales.
This article shows you how to open and read the report, how to pinpoint a difference, and how to cross-check a single day against the Agenzia delle Entrate portal.
Open the AdE Reconciliation report
- In OpenFiskal, go to Settings > Italy > AdE Reconciliation.
- Choose a date range. You can pick a single day, a full month, or any span.
- Click Generate report.
The report is built on the receipt creation date, not the transmission date. Receipts that were transmitted late, for example after a portal outage, are still included.
Check the green and red panels
The report compares your Shopify revenue against what OpenFiskal transmitted, split into POS, Ecommerce, and a combined total. Each block ends in a coloured panel.
- A green panel with a check means that channel reconciles. Everything that should have reached the Agenzia delle Entrate did.
- A red panel flags a difference to look into.
A channel with nothing transmitted shows a red panel. In the example above, no ecommerce sales were sent, so that channel shows red while POS reconciles. If a channel should be transmitting and is not, the red panel is your signal to investigate.
A green panel can still appear when some orders were not sent, as long as the report can account for them. The next sections show how.
Why doesn't my Netto AdE (OpenFiskal report) match the Dati di pagamento on the Agenzia delle Entrate portal?
The report's daily summary has a Netto AdE column. It equals the daily total the Agenzia delle Entrate holds for you, and you can check it day by day. A difference appears when you compare it against one figure in the Dati di pagamento block on the portal, rather than the whole block. The portal does not hold your whole day in one column. It records the full value of the day's documents, then splits it across that block by how each sale was settled: cash, electronic, gift cards, and meal vouchers. Amounts not yet collected sit under Non riscosso, and returns are tracked separately and lower the net.
To reconcile the two figures, account for all of it:
Netto AdE = Pagato contanti + Pagato elettronico + Sconto a pagare + Ammontare ticket + Non riscosso (all types) − Returns (resi)
Returns are the refunds you issued that day. The portal shows their taxable base under Imponibile resi; add the VAT (value added tax) to get the gross amount to subtract.
Worked example
Take 11 April. OpenFiskal shows a Netto AdE of 55.674,69 € for that day.
On the portal, the same day breaks down like this:
Field | Amount |
|---|---|
Pagato contanti | 0,00 € |
Pagato elettronico | 55.510,97 € |
Sconto a pagare | 175,95 € |
Ammontare ticket | 0,00 € |
Non riscosso (beni consegnati) | 0,76 € |
It also shows one return: an Imponibile resi of 11,81 € at 10%, which is 12,99 € gross.
55.510,97 + 175,95 + 0,76 − 12,99 = 55.674,69 €
The figures match. This shop took only card and gift-card payments that day, so Pagato contanti reads 0. A day with cash sales would include that column in the same sum.
Compare the document counts
Each day in the daily summary shows the number of documents next to the amount. The portal shows the same count under Numero documenti commerciali.
This is the fastest way to spot a problem. If the counts match, every receipt reached the Agenzia delle Entrate. If a day is off by one or two, go to that day, compare the amounts, and you have the exact figure to chase. A one document difference on a single day points you straight to the missing or extra receipt.
Why are some transactions not sent to the Agenzia delle Entrate?
The report lists POS orders that were not transmitted, with a reason in the Motivo column.
The most common reason is Registratore non fiscalizzato (register not fiscalized). The POS register that processed the sale has not been fiscalized, so its sales are correctly not sent. These orders appear on the Non previsti per la trasmissione (not expected for transmission) line in the result, which is why a channel can still reconcile with them present.
If you expected those sales to be fiscalized, check the register's status. If it should be fiscalized and is not, write to us.
When the totals still don't match
If you have accounted for every payment column, the channels you do not fiscalize, and any non-fiscalized registers, and the figures still differ or the document counts differ, the cause is something else.
The most common one is a sale that reached the Agenzia delle Entrate outside OpenFiskal. For example, a documento commerciale entered by hand directly on the portal shows on the portal but not in OpenFiskal. Check the date for any manual entry of this kind.
If you still cannot explain the gap, write to us at support@openfiskal.com with the date and both sets of figures, and we will look into it with you.
What the report columns mean
The report exports to CSV. The Riferimento colonne CSV panel lists all twelve columns. These are the ones you will use most.
Column | What it records |
|---|---|
AdE Document Type | RECEIPT (a sale) or CORRECTION (a refund or return). Net total = sum of RECEIPTs minus sum of CORRECTIONs. |
Shopify Sale Amount | What Shopify recorded (the actual charge or refund). For a 100% discount (gift or omaggio) order, this is 0 €. |
Amount Sent to AdE | The exact amount submitted to the Agenzia delle Entrate. For gifts, this is the full pre-discount value, as Italian rules require. Use this column to reconcile against the portal. |
Status | submitted means accepted by the Agenzia delle Entrate. pending means awaiting submission. no_receipt means the register was not fiscalized, so nothing was sent. |
AdE Submission Date | When the document was submitted. This can differ from the creation date if it was resubmitted after an outage. |
A gift order shows this pattern: 0 € in Shopify, full value sent to the Agenzia delle Entrate. The report subtracts the gift (omaggio) on the transmitted side so the two sides line up.
What the Agenzia delle Entrate daily detail shows
To open one day on the portal, sign in to Fatture e Corrispettivi at https://ivaservizi.agenziaentrate.gov.it/portale/, choose your working profile, open the Corrispettivi consultation, and click the day. Your commercialista can also do this for you. The day opens as the Dettaglio del riepilogo giornaliero dei documenti commerciali online, with three blocks.
Totals by VAT rate
Field | What it records |
|---|---|
Aliquota IVA | The VAT rate applied. |
Imponibile | The taxable base at that rate, net of returns. |
Imposta dovuta | The VAT due on that base. |
Imponibile resi | The taxable base of returns (refunds) at that rate. |
Imponibile annulli | The taxable base of voided documents. |
Natura | The VAT nature code for operations without VAT, for example exempt or not subject. |
Codice attività | The activity (ATECO) code, when totals are split by activity. |
Unpaid amounts (Dettaglio del corrispettivo non riscosso)
Field | What it records |
|---|---|
Non riscosso per cessione di beni consegnati | Goods delivered but not yet collected. For goods, VAT is due at delivery, so the amount counts in the day's total even though no cash or card came in. Split or deferred payments on goods can appear here. |
Non riscosso per prestazione di servizi | Services completed but not yet paid. |
Non riscosso fattura | The part of a sale that will be settled by an invoice (fattura) instead of collected at the till. |
Non riscosso omaggio | Goods or services given for free, such as promotions, samples, or gifts. The taxable base and VAT are still recorded. |
Payment data (Dati di pagamento)
Field | What it records |
|---|---|
Pagato contanti | Collected in cash. |
Pagato elettronico | Collected by card or other electronic means. |
Sconto a pagare | The part of the total covered by a gift card or store voucher, not by cash or card. |
Ammontare ticket | The amount paid with meal vouchers (ticket restaurant). |
Numero ticket | The number of meal vouchers used. |
Numero documenti commerciali | Total documents issued that day, including sales, returns, and voids. |
Updated on: 16/06/2026
Thank you!