Skip to main content

Where can I find the billing data for the tax audit?

For billing data from version 6.10.0 of the Pickware POS App:

Log in to the fiskaly Dashboard and click on the DSFINV-K Export entry in the menu on the left. There, you can use the button at the top to create a new DSFINV-K export for any time period.

dsfinv-k1.png

You can see all generated exports in the list and download them there via the right-hand column of the table.

dsfinv-k2.png

For billing data up to version 6.10.0 of the Pickware POS App:

For all cash register closings you generated before version 6.10.0 of the POS App, you can find the billing data in the Shopware 5 backend under Kunden → Kassenbericht → Z3 Datenträgerüberlassung (Customers → Cash Register Report → Z3 Data Carrier Transfer). There, you can select the subshop, cash register(s), and time period, and then use the Alle exportieren (Export All) button to download a CSV file with the corresponding data.

The CSV file contains one row per sold item, with the following fields:

  • id – consecutive number within the CSV file

  • date – date of the transaction

  • transactionId – fiskaly transaction ID of the checkout process

  • cashRegisterId – ID of the cash register used

  • cashRegisterName – name of the cash register used

  • articleOrderNumber – product number

  • bookingText – product name

  • quantity – quantity

  • revenueGross – total gross price

  • includedVat – amount of VAT included

  • revenueNet – total net price

  • taxRate – tax rate used

  • process – type of transaction (“create” for sales, “manual” for cash deposits and withdrawals)

  • manualType – “withdrawal” or “deposit” in the case of a deposit/withdrawal, otherwise this field remains empty

  • paymentText – payment method

  • currencyCode – currency

  • currencyFactor – conversion factor (see Grundeinstellungen → Währung (Basic Settings → Currency))

  • cash – “1” for cash payments

  • orderNumber – order number

  • shopId – ID of the subshop

  • shopName – name of the subshop

  • userName – Shopware user who carried out the transaction

  • reportId – ID of the associated cash register report in the Shopware database, if one was created

  • attachmentMediaId – ID of the receipt file in the Shopware database

  • branchStoreId – ID of the fiskaly branch

  • branchStoreName – name of the fiskaly branch

Did this answer your question?