Tax Report¶
Scarica fatture¶
Tipo di report: IVA Fatture
Intervallo di tempo: Giornaliero
Estra file zip e sposta i documenti alla cartella in corrispondenza.
| Nome del file contiene | Cartella |
|---|---|
| CN-IT | //DSM/vendita/ANNO/MESE/IT_ESTERO/ |
| INV-IT | //DSM/vendita/ANNO/MESE/IT_ESTERO/ |
| CN-DS-IT | //DSM/vendita/ANNO/MESE/IT_ESTERO/ |
| INV-DS-IT | //DSM/vendita/ANNO/MESE/IT_ESTERO/ |
| -68211 | //DSM/vendita/ANNO/MESE/IT/ |
Rimuove i documenti rimasti.
Genera Tax Report¶
Tipo di report: Calcoli IVA
Clicca qui per scaricare report di esempio
Prepara Report¶
Rimuove le colonne inutile, rimangono queste:
- Marketplace ID
- OUR_PRICE Tax Inclusive Selling Price
- OUR_PRICE Tax Amount
- OUR_PRICE Tax Exclusive Selling Price
- OUR_PRICE Tax Inclusive Promo Amount
- OUR_PRICE Tax Amount Promo
- OUR_PRICE Tax Exclusive Promo Amount
- SHIPPING Tax Inclusive Selling Price
- SHIPPING Tax Amount
- SHIPPING Tax Exclusive Selling Price
- SHIPPING Tax Inclusive Promo Amount
- SHIPPING Tax Amount Promo
- SHIPPING Tax Exclusive Promo Amount
- GIFTWRAP Tax Inclusive Selling Price
- GIFTWRAP Tax Amount
- GIFTWRAP Tax Exclusive Selling Price
- GIFTWRAP Tax Inclusive Promo Amount
- GIFTWRAP Tax Amount Promo
- GIFTWRAP Tax Exclusive Promo Amount
- Buyer Tax Registration
- VAT Invoice Number
- Invoice Url
- Export Outside EU
- Ship To Country
- Ship To City
Clicca qui per scaricare report elaborato
Applica Filter
SEZ 05¶
Filter:
- VAT Invoice Number:
ITXX-668211
SEZ 06¶
Filter:
- VAT Invoice Number:
ITXX-68211I
SEZ 07¶
Filter:
- VAT Invoice Number:
ITXX-68211C
SEZ 08¶
Filter:
- VAT Invoice Number:
INV-IT-148668211
SEZ 09¶
Filter:
- VAT Invoice Number:
CN-IT-148668211
SEZ 10¶
Filter:
- VAT Invoice Number:
DS-INV-IT-148668211
SEZ 11¶
Filter:
- VAT Invoice Number:
DS-CN-IT-148668211
Salva Report¶
Crea un nuovo file excel, copia e incolla i dati filtrati
Calcola Imponibile, IVA e Totale
Formula¶
| Imponibile | OUR_PRICE Tax Exclusive Selling Price + OUR_PRICE Tax Exclusive Promo Amount + SHIPPING Tax Exclusive Selling Price + SHIPPING Tax Exclusive Promo Amount + GIFTWRAP Tax Exclusive Selling Price + GIFTWRAP Tax Exclusive Promo Amount |
| IVA | OUR_PRICE Tax Amount + OUR_PRICE Tax Amount Promo + SHIPPING Tax Amount + SHIPPING Tax Amount Promo + GIFTWRAP Tax Amount + GIFTWRAP Tax Amount Promo |
| Totale | OUR_PRICE Tax Inclusive Selling Price + OUR_PRICE Tax Inclusive Promo Amount + SHIPPING Tax Inclusive Selling Price + SHIPPING Tax Inclusive Promo Amount + GIFTWRAP Tax Inclusive Selling Price + GIFTWRAP Tax Inclusive Promo Amount |
Scaricare report salvato