In Winner Bizz, you are able to export financial data, for example, for a financial audit.
From your customer invoice list, select Export > Export tax audit data.
The Tax audit export dialog opens, and allows you to choose the company, the period for the extract, the destination folder and the name of the files.
4 .csv files will be exported, with the corresponding data :
- Invoice headers (File name.csv)
- Payment (File name-1.csv)
- Payment calendars (File name-2.csv)
- Item lines (File name-3.csv)
Invoice headers
|
Column name |
Explanation |
| Invoice number | |
| Invoice type | |
|
Contract number |
|
|
Payment conditions |
|
| Invoice date | |
| Invoice due date | |
| Invoice reminder date | |
|
Customer number |
|
|
Customer name |
Customer name and surname |
|
Customer address |
|
|
Customer zip |
|
|
Customer address post |
Customer city |
| Customer address country code |
example: FR for France |
|
Customer address country |
|
| Delivery address | |
| Delivery address zip | |
| Delivery address post | Delivery address city |
| Delivery address country code |
example: FR for France |
| Delivery address country |
|
| Invoice address |
|
| Invoice address zip |
|
| Invoice address post |
Invoice address city |
| Invoice address country code |
example: FR for France |
| Invoice address country |
|
| Currency code |
example: EUR for euro |
| Excluded VAT1 amount |
Amount excluded VAT group 1 |
| VAT1 percentage |
Percentage of VAT group 1 |
| VAT1 amount |
Amount VAT group 1 |
| Excluded VAT2 amount |
Amount excluded VAT group 2 |
| VAT2 percentage |
Percentage of VAT group 2 |
| VAT2 amount |
Amount VAT group 2 |
| Excluded VAT3 amount |
Amount excluded VAT group 3 |
| VAT3 percentage |
Percentage of VAT group 3 |
| VAT3 amount |
Amount VAT group 3 |
| Excluded VAT4 amount |
Amount excluded VAT group 4 |
| VAT4 percentage |
Percentage of VAT group 4 |
| VAT4 amount |
Amount VAT group 4 |
| Excluded VAT5 amount |
Amount excluded VAT group 5 |
| VAT5 percentage |
Percentage of VAT group 5 |
| VAT5 amount |
Amount VAT group 5 |
| Total excluded VAT |
Amount excluded VAT |
| Total included VAT |
Amount including VAT |
|
Total VAT |
Total amount VAT |
| Total outstanding amount |
Total amount including VAT |
| Total overdue outstanding amount |
Total amount overdue, including VAT |
Payment
|
Column name |
Explanation |
|
Payment number |
|
|
Payment date |
|
|
Payment type |
|
|
Invoice number |
|
|
Invoice type |
|
|
Contract number |
|
|
Payment conditions |
|
|
Invoice date |
|
|
Invoice due date |
|
|
Invoice amount |
Invoice amount including VAT |
|
Payment amount |
|
|
Invoice percentage |
|
|
Payment method |
|
Payment calendars
|
Column name |
Explanation |
|
Invoice Number |
|
|
Deadline amount |
|
|
Invoice due date |
|
|
Negotiated due date |
|
|
Payment condition |
|
|
Contract number |
|
|
Contract amount percentage |
|
| Excluded VAT1 amount |
Amount excluding VAT group 1 |
| VAT1 percentage |
Percentage VAT group 1 |
| VAT1 amount |
Amount VAT group 1 |
| Excluded VAT2 amount |
Amount excluding VAT group 2 |
| VAT2 percentage |
Percentage VAT group 2 |
| VAT2 amount |
Amount VAT group 2 |
| Excluded VAT3 amount |
Amount excluding VAT group 3 |
| VAT3 percentage |
Percentage VAT group 3 |
| VAT3 amount |
Amount VAT group 3 |
| Excluded VAT4 amount |
Amount excluding VAT group 4 |
| VAT4 percentage |
Percentage VAT group 4 |
| VAT4 amount |
Amount VAT group 4 |
| Excluded VAT5 amount |
Amount excluding VAT group 5 |
| VAT5 percentage |
Percentage VAT group 5 |
| VAT5 amount |
Amount VAT group 5 |
Item lines
|
Column name |
Explanation |
|
Invoice Number |
|
|
Contract number |
|
|
Main position |
|
|
Sub position |
|
|
Item code |
|
|
Serie |
|
|
Item group |
|
|
Description |
Item description |
|
Total quotation quantity |
|
|
Unit |
|
| Item invoice percentage |
Percentage of the item in proportion to the invoice |
| Cost Sales Price Ex. VAT |
Gross sales price, excluding VAT |
| Recycle Cost Type |
|
| Recycle Cost Code |
|
| Recycle Cost Ex. VAT |
Recycle code excluding VAT |
| Recycle Cost VAT percentage |
|
| Disc. Per Item percentage |
Percentage of discount per item |
| Disc. Per Item Amount |
Amount of discount per item |
| Disc. Per Group percentage |
Percentage of discount per group |
| Disc. Per Group Amount |
Amount of discount per group |
| Disc. Global percentage |
Percentage of global discount |
| Disc. Global Amount |
Amount of global discount |
| Rounding Amount Ex. VAT |
|
| Block Disc. Amount |
|
| Final Sales Price Ex. VAT |
Excluding VAT |
| VAT percentage |
Comments
0 comments
Article is closed for comments.