Excel calculations
Buys
Invoice
number-
Date
26/4/2023
14/6/2023
26/4/2023
14/6/2023
14/6/2023
27/6/2023
14/6/2023
14/6/2023
14/6/2023
14/6/2023
26/4/2023
14/6/2023
14/6/2023
14/6/2023
26/4/2023
14/6/2023
14/6/2023
14/6/2023
26/4/2023
14/6/2023
14/6/2023
26/4/2023
14/6/2023
14/6/2023
14/6/2023
27/6/2023
14/6/2023
14/6/2023
14/6/2023
27/6/2023
14/6/2023
14/6/2023
14/6/2023
14/6/2023
14/6/2023
27/6/2023
Article
Amount
Tax base
Vat
ROSHFRANS MOTONIC 4T 20W50 QT 15/13
6.632,09
1.061,13
REAR BRAKE BANDS WITH SPRING M/ELEGANCE
2
148,56
23,77
CHECK MOTORCYCLE BATTERY (12N7-3B)
2
807,54
129,21
TX200 MUFFLER CLAMP
2
63,74
10,20
GASOLINE KEY HORSE-,50
17,20
CHECK MOTORCYCLE BATTERY (YTX7L-BS)
2
1.062,54
170,01
RK6 SHIFT PEDAL BASE
3
777,89
124,46
MATRIX SPORT 150 HANDLEBAR LOWER 3CASING
378,41
60,55
TX200 MUFFLER CLAMP
2
63,74
10,20
YELLOW RIGHT CANE M/ELEGANCE-,20
128,35
CHECK MOTORCYCLE BATTERY (12N7-3B)
4
1.410,05
225,61
TX200 MUFFLER CLAMP
2
63,74
10,20
LEFT YELLOW CANE M/ELEGANCE-,20
128,35
BLUE MASK WITH STICKER EMPIRE-KEEWAY
M/ELEGANCE
3
1.059,-,45
CHECK MOTORCYCLE BATTERY (12N7-3B)
2
705,03
112,80
BLACK FRONT MASK MOD NEW OUTLOOK-,51
227,92
LIGHTHOUSE HORSE-,93
99,83
MATRIX ELEGANCE AIR FILTER
2
552,62
88,42
CHECK MOTORCYCLE BATTERY (12N7-3B)
2
705,03
112,80
MATRIX ELEGANCE AIR FILTER
2
552,62
88,42
WHITE FRONT FENDER OUTLOOK-,69
139,63
CHECK MOTORCYCLE BATTERY (12N7-3B)
2
705,03
112,80
TX200 MUFFLER CLAMP
2
63,74
10,20
GASOLINE KEY HORSE-,50
17,20
RED FRONT FENDER SPEED-,33
142,61
CHECK MOTORCYCLE BATTERY (YTX9-BS)
2
1.200,78
192,13
MATRIX ELEGANCE BRAKE GUIDE
2
108,04
17,29
MATRIX ELEGANCE AIR FILTER
2
552,62
88,42
LEFT CONTROLLER S.SHADOW-,91
49,27
CHECK MOTORCYCLE BATTERY (YTX9-BS)
4
2.401,57
384,25
MATRIX ELEGANCE BRAKE GUIDE
2
108,04
17,29
OUTLOOK DATE
3
471,59
75,46
MATRIX ELEGANCE AIR FILTER
2
552,62
88,42
LEFT CONTROLLER S.SHADOW-,91
49,27
OUTLOOK DATE
2
314,40
50,-,45
288,23
CHECK MOTORCYCLE BATTERY (YTX 14-BS)
TOTALS
29.510,24
4.721,64
Sale
Total Amount
7.693,22
172,32
936,75
73,94
124,70
1.232,54
902,35
438,96
73,94
930,55
1.635,66
73,94
930,55
1.228,51
817,83
1.652,43
723,76
641,04
817,83
641,04
1.012,32
817,83
73,94
124,70
1.033,94
1.392,91
125,33
641,04
357,18
2.785,82
125,33
547,05
641,04
357,18
364,70
2.089,-,88
Tax base
8.621,72
193,12
1.049,80
82,87
139,75
1.381,30
1.011,26
491,93
82,87
1.042,86
1.833,07
82,87
1.042,86
1.376,78
916,53
1.851,86
811,11
718,41
916,53
718,41
1.134,50
916,53
82,87
139,75
1.158,73
1.561,02
140,45
718,41
400,29
3.122,04
140,45
613,07
718,41
400,29
408,71
2.341,-,31
Vat
1.379,47
30,90
167,97
13,26
22,36
221,01
161,80
78,71
13,26
166,86
293,29
13,26
166,86
220,28
146,65
296,30
129,78
114,95
146,65
114,95
181,52
146,65
13,26
22,36
185,40
249,76
22,47
114,95
64,05
499,53
22,47
98,09
114,95
64,05
65,39
374,70
6.138,13
Total
Amount
10.001,19
224,02
1.217,77
96,13
162,11
1.602,31
1.173,06
570,64
96,13
1.209,72
2.126,36
96,13
1.209,72
1.597,06
1.063,18
2.148,16
940,89
833,36
1.063,18
833,36
1.316,02
1.063,18
96,13
162,11
1.344,13
1.810,78
162,92
833,36
464,33
3.621,56
162,92
711,16
833,36
464,33
474,11
2.716,-,44