MRBR Ageing overview
Quantity
1-15 days
11.9%
Ageing in % of total lines
Count of Crcy
Area
Plnt
Region
3010
3011
3012
3013
3024
3026
3027
3028
3034
3035
3050
3054
3060
3053
3059
3061
3052
Region Total
Grand Total
16-30 days
36.8%
30-45 days
25.3%
46-60 days
11.5%
Invoice ageing (group)
1-15 days
16-30 days
10
54
31
2
13
38
30-45 days
41
25
4
8
46-60 days
27
9
4
2
1
1
3
3
89
89
1
4
4
11
3
4
67
6
20
16
3
1
276
276
190
190
2
86
86
1-15 days
2.4%
16-30 days
31.4%
30-45 days
9.9%
46-60 days
14.3%
Invoice ageing (group)
1-15 days
16-30 days
4,914
17,170
3,866
368
2,031
9,242
30-45 days
7,424
2,008
149
929
8,062
16,216
552
455
1,456
3,503
1,120
50
1,676
46-60 days
9,720
506
1,107
166
19
11,571
13,260
349
75
3
7
1
4
1
72
5
17
2
24
7
3
Cash value
Ageing in % of total cash
Sum of Amount
Area
Plnt
Region
3010
3011
3012
3013
3024
3026
3027
3028
3034
3035
81
Region
Region Total
Grand Total
3050
3054
3060
3053
3059
3061
3052
3,218
8,581
8,581
29,021
9,294
974
8,678
1,603
320
2,936
111,875
111,875
720
4,537
665
12,273
332
35,386
35,386
1,985
7,951
55
4,404
51,093
51,093
over 60 days
14.5%
Grand Total
100%
over 60 days
31
31
5
11
109
109
Grand Total
163
96
28
59
1
14
18
19
14
8
5
238
12
47
22
3
3
750
750
over 60 days
42.0%
Grand Total
100%
over 60 days
20,152
18,994
3,085
2,977
Grand Total
59,380
25,373
6,740
13,315
19
89,691
60,730
6,585
586
4,127
12
8
5
1
1
3
1
70,057
27,752
4,565
996
505
610
27
149,720
149,720
29,741
19,034
2,144
29,512
2,017
320
7,340
356,654
356,654
MRBR Ageing overview
Area
Plnt
(All)
(All)
Count of Crcy
Name
Brake Bros Foodservice Ltd
M & J Seafoods Ltd
Paul Rhodes London Ltd
POURSHINS Ltd
SEAFOOD HOLDINGS T/A DIRECT SEAFOOD
Fairfax Meadow
SCORPIO WORLDWIDE LTD
PK TRADING UK LTD.
Dina Foods Ltd
H & B Foods Ltd t/a Cheese Cellar
Fresh Direct
Yoshikawa UK Ltd t/a TK Trading
Lasting Impressions Food Co
LSG-Sky Food GmbH
Heathbrook
Manor Bakeries Ltd
Kellogg Marketing & Sales Co (UK) L
Daniels Chilled Foods Ltd
Leathams Plc
Sandy'S Bakehouse
3663
Frankenberg Handels GmbH
Heathrow Bakery
Hermolis & Co Ltd
Medina Foods
En Route International Ltd
Superior Food Ltd.
Food Partners Group Ltd
Ennis Foods T/as Skytrac
WK Thomas
Loch Fyne Oysters Ltd
Lyreco UK Ltd
Compass Supply Solutions Ltd
Starbucks Coffee Co (UK) Ltd
Dawn Foods Limited
JuiceWorks Ltd
Retail In Motion
HJ Heinz Company Ltd
The London Meat Co
The Good Food Co Harefield
Spl Ltd
Lindt & Sprungli UK Ltd
Invoice ageing (group)
1-15 days
16-30 days
32
8
22
75
7
42
22
12
4
2
7
10
12
8
3
2
9
8
2
2
2
30-45 days
43
34
18
25
20
2
6
6
1
2
6
2
2
5
5
2
6
4
5
3
2
2
4
3
2
2
2
2
3
2
1
1
2
1
1
2
2
WG White Ltd
Ultra Ice (UK) Ltd
Green Gourmet Ltd
Town & Country Fine Foods
Matthew Clark Wholesale Ltd
Fulfil Group
Watershed Packaging Ltd
Red Rose Packaging Ltd
Delice De France plc
Didier's Patisserie
Tasties of Chester Ltd
Mondelez UK Ltd
DSI Foods
HC Slingsby plc
R P Adam Ltd
Seahawk Marine Foods Ltd
RS Components UK Ltd
Pierce Jenkins Ltd
Nijjar Dairies Ltd t/a Freshways
Vestey Foods UK
The Paper Cup Factory Ltd
Love Bites Foods
BD Foods Ltd
Pinguin Foods UK Ltd
Plane Catering Ltd
Noon Aviation Catering Service
Grand Total
1
1
2
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
89
276
190
Area
Plnt
46-60 days
20
15
over 60 days
30
31
8
9
2
4
4
12
11
1
5
2
2
1
8
1
3
1
2
2
1
1
1
1
Grand Total
125
110
82
80
56
34
21
19
16
13
10
10
9
9
8
8
8
8
7
7
7
6
6
5
5
4
4
4
4
3
3
3
3
3
3
3
2
2
2
2
2
2
Sum of Amount
Name
SCORPIO WORLDWIDE LTD
M & J Seafoods Ltd
Green Gourmet Ltd
Brake Bros Foodservice Ltd
POURSHINS Ltd
Fairfax Meadow
Frankenberg Handels GmbH
Lasting Impressions Food Co
Kellogg Marketing & Sales Co (UK) L
Dawn Foods Limited
SEAFOOD HOLDINGS T/A DIRECT SEAFOOD
Paul Rhodes London Ltd
Watershed Packaging Ltd
LSG-Sky Food GmbH
Dina Foods Ltd
Vestey Foods UK
Pinguin Foods UK Ltd
Starbucks Coffee Co (UK) Ltd
Retail In Motion
PK TRADING UK LTD.
En Route International Ltd
Sandy'S Bakehouse
Lindt & Sprungli UK Ltd
H & B Foods Ltd t/a Cheese Cellar
Manor Bakeries Ltd
Mondelez UK Ltd
Hermolis & Co Ltd
Leathams Plc
3663
Compass Supply Solutions Ltd
Lyreco UK Ltd
Yoshikawa UK Ltd t/a TK Trading
The Paper Cup Factory Ltd
JuiceWorks Ltd
Spl Ltd
Loch Fyne Oysters Ltd
Matthew Clark Wholesale Ltd
Fresh Direct
Ultra Ice (UK) Ltd
Medina Foods
The Good Food Co Harefield
Ennis Foods T/as Skytrac
1
1
1
1
86
1
109
2
2
2
2
2
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
750
Seahawk Marine Foods Ltd
Heathbrook
The London Meat Co
Superior Food Ltd.
HJ Heinz Company Ltd
Red Rose Packaging Ltd
Daniels Chilled Foods Ltd
Noon Aviation Catering Service
Pierce Jenkins Ltd
Heathrow Bakery
WG White Ltd
Fulfil Group
DSI Foods
R P Adam Ltd
WK Thomas
Didier's Patisserie
Town & Country Fine Foods
Nijjar Dairies Ltd t/a Freshways
Delice De France plc
Plane Catering Ltd
Love Bites Foods
Tasties of Chester Ltd
BD Foods Ltd
Food Partners Group Ltd
HC Slingsby plc
RS Components UK Ltd
Grand Total
(All)
(All)
Invoice ageing (group)
1-15 days 16-30 days 30-45 days 46-60 days over 60 days Grand Total
24,112.40
2,984.80 24,831.30
88,966.56 140,895.06
4,864.00
7,630.93
5,608.62
8,389.92
20,152.20
46,645.67
28,802.32
28,802.32
3,559.32
3,323.38
2,036.88
16,639.89
25,559.47
11,359.76
2,787.80
968.37
5,330.79
20,446.72
2,592.98 11,293.71
5,138.88
19,025.57
9,704.60
9,704.60
1,266.40
1,424.00
5,903.29
8,593.69
8,180.80
8,180.80
2,936.00
4,404.00
7,340.00
1,628.35
1,392.22
1,229.90
4,250.47
3,218.27
226.80
3,445.07
2,960.50
2,960.50
2,637.63
2,637.63
1,101.25
765.00
1,866.25
1,642.60
1,642.60
1,548.00
1,548.00
165.36
518.40
661.44
1,345.20
1,153.44
1,153.44
368.00
389.25
182.30
138.68
1,078.23
573.92
486.72
1,060.64
653.20
382.40
1,035.60
477.36
551.35
1,028.71
965.91
54.00
1,019.91
269.04
325.68
325.68
84.96
1,005.36
995.50
995.50
978.90
978.90
716.46
256.31
972.77
26.84
343.20
37.90
505.47
913.41
699.24
213.60
912.84
876.00
876.00
136.55
581.59
27.60
745.74
720.00
720.00
311.04
322.56
633.60
287.50
287.50
575.00
437.47
437.47
303.95
128.79
432.74
350.36
74.90
425.26
208.00
208.00
416.00
50.00
365.95
415.95
42.75
300.00
342.75
333.52
333.52
280.20
80.64
275.14
266.80
138.86
218.75
208.80
83.16
57.98
174.60
89.06
15.70
122.04
36.48
27.36
202.50
82.16
120.00
102.48
97.00
46.80
82.50
48.36
38.84
25.04
60.80
45.50
45.00
42.30
32.90
31.59
28.46
26.49
21.08
8,580.91 111,874.90
35,385.84
51,092.98
149,719.70
280.20
275.14
266.80
219.50
218.75
208.80
204.98
202.50
174.60
171.22
135.70
122.04
102.48
97.00
85.64
82.50
73.40
60.80
45.50
45.00
42.30
32.90
31.59
28.46
26.49
21.08
356,654.33
Top 25 materials with issues
Top 15 materials as % of total lines
Material Description
Material
Salmon Supreme -S RW Fr 100g
12021873
Cookie Choc/H/nut 2Pk Amb QF P/W 20g
12022569
Crm Sgl Yew Tree Fr 250ml
12021106
Brd Spelt Fig & Prune Slc Amb QF PJ
12021881
Salmon Delice -S-B Fr 120g
12005336
Prawn King Raw 31/40 TailOff Fz 1kg
12021906
Ssge Chix 8s Brakes Fz 1x80
12016701
Bev Mix Bl/Mary IPR Amb AA 330mlx24
12017418
Chix Kiev Med Fz 125gx16
12013714
Tobacco Golden Virginia TOM 500gx8
12000117
Trout Rainbow -S-B Fr 120g
12005346
Water Spr Cristaline AA 1.5Ltrx6
12017624
Fatayer Spinach 35g
12001611
Pkl Makdous Eggplant Stuffed 2.5kg
12019078
Bream Sea Fil Scaled Fr 110-130g
12022028
Cake Tart Jam Kipling Amb 41gx6
12017204
Bisc Nutrigrain Kelloggs TOM 1x16
12020054
Salad Tuna S/corn Pasta Tub Fr 2kg
12021103
ChzCroxtonMild20gSpreadCrackPkTOM20gx100
12023317
Chix Strip Julienne Halal Fr 1kg
12003078
Chix Diced 50/50 25mm Halal Fr 1kg
12017104
Fruit Bag Melon P/apple Grape 60g
12022562
Cookie Dough Raisin LemLaboPucksFz56gx90
12013958
Egg Poached 40gx48
12001269
Ent PizzaSpinachGarlicFzIPR AA FCBC 1x48
12017508
Roll Wht Plt Wrp Amb 30g
12015928
Transport/Freight Costs
12006842
Bttr Alpine Kerry Fr DL 10gx100
12007982
Pots Rosti Fritters Fz 1kg
12023170
Grand Total
Area
Region
Region Total
Grand Total
Order type
Regular
Name
M & J Seafoods Ltd
Paul Rhodes London Ltd
Brake Bros Foodservice Ltd
Paul Rhodes London Ltd
SEAFOOD HOLDINGS T/A DIRECT SEAFOOD
M & J Seafoods Ltd
Brake Bros Foodservice Ltd
POURSHINS Ltd
Brake Bros Foodservice Ltd
SCORPIO WORLDWIDE LTD
SEAFOOD HOLDINGS T/A DIRECT SEAFOOD
POURSHINS Ltd
Dina Foods Ltd
PK TRADING UK LTD.
M & J Seafoods Ltd
Manor Bakeries Ltd
Kellogg Marketing & Sales Co (UK) L
Brake Bros Foodservice Ltd
H & B Foods Ltd t/a Cheese Cellar
Fairfax Meadow
Fairfax Meadow
Daniels Chilled Foods Ltd
Brake Bros Foodservice Ltd
Brake Bros Foodservice Ltd
POURSHINS Ltd
Sandy'S Bakehouse
Dina Foods Ltd
POURSHINS Ltd
Brake Bros Foodservice Ltd
Count of Crcy
750
750
750
60.8%
Count of Crcy
74
43
42
36
32
22
22
19
17
15
15
13
12
11
10
8
8
7
6
5
5
5
5
4
4
4
4
4
4
456
Sum of
Amount
356,654
356,654
356,654
Count of Crcy
Area
Region
Region Total
Grand Total
Plnt
Reason
Invoice ageing (group)
QTY
1-15 days
16-30 days
30-45 days
3010
10
51
40
3011
26
21
3012
1
9
3
3013
18
3
3024
3026
1
3027
4
2
3028
4
6
3034
4
3035
3
4
3050
2
3054
72
61
70
3060
6
4
3053
6
9
3059
16
1
3061
2
3052
1
83
214
163
83
214
163
46-60 days
26
8
4
2
1
1
3
3
23
7
3
2
83
83
QTY
QTY Total
over 60 days
31
158
31
86
5
22
11
34
1
12
14
7
16
5
18
4
1
8
2
226
10
3
25
1
21
2
3
107
650
107
650
1-15 days
16-30 days
3
5
4
20
30-45 days
1
4
1
5
1
1
1
2
6
14
1
2
1
8
1
46-60 days
1
1
1
6
6
62
62
27
27
3
3
Total
Grand Total
over 60 days
5
10
6
25
2
2
2
1
10
3
12
2
22
1
1
100
100
163
96
28
59
1
14
18
19
14
8
5
238
12
47
22
3
3
750
750
MRBR REPORT 06.01.2014
Concatenate
302650104073450003724012020054
302650104388450003822312020054
302650104388450003822312020054
302691698696450003964212020054
302691703206450004093912020054
302691754475450005695112020054
3026SI59651450006854912000117
3026SI60194450007331112000117
3026SI60449450007593912000117
3026SI60703450007885312000117
3026SI60898450008148112000117
3026SI61143450008426912000117
3026SI62077450009467512000118
302610145006423450008115112019959
Qty Prc PBk Plnt Doc. No.
RfIt
X
3026 5105636968 1
X
3026 5105639459 1
X
X
3026 5105639520 1
X
3026 5105644381 1
X
3026 5105644384 1
X
3026 5105661664 1
X
3026 5105671628 2
X
3026 5105675103 2
X
3026 5105678547 2
X
3026 5105684367 2
X
3026 5105685758 2
X
3026 5105689821 2
X
3026 5105699032 1
X
3026 5105685005 1
Inv. date
03.05.2013
10.05.2013
10.05.2013
16.05.2013
23.05.2013
09.08.2013
20.09.2013
04.10.2013
11.10.2013
18.10.2013
25.10.2013
01.11.2013
29.11.2013
21.10.2013
Pstng Date
08.05.2013
17.05.2013
17.07.2013
17.06.2013
17.06.2013
21.08.2013
04.10.2013
14.10.2013
18.10.2013
06.11.2013
07.11.2013
14.11.2013
11.12.2013
07.11.2013
Reference
50104073
50104388
50104388
91698696
91703206
91754475
SI59651
SI60194
SI60449
SI60703
SI60898
SI61143
SI62077
1.01E+10
Purch.Doc.
4500037240
4500038223
4500038223
4500039642
4500040939
4500056951
4500068549
4500073311
4500075939
4500078853
4500081481
4500084269
4500094675
4500081151
Ref. Doc.
5300025402
5300026643
5300026643
5300029222
5300030466
5300048719
5300061889
5300067603
5300069861
5300073789
5300078096
5300078196
5300091490
5300074232
Inv. Pty
324086
324086
324086
324086
324086
324086
300100
300100
300100
300100
300100
300100
300100
341951
Name
Kellogg Marketing & Sales Co (UK) L
Kellogg Marketing & Sales Co (UK) L
Kellogg Marketing & Sales Co (UK) L
Kellogg Marketing & Sales Co (UK) L
Kellogg Marketing & Sales Co (UK) L
Kellogg Marketing & Sales Co (UK) L
SCORPIO WORLDWIDE LTD
SCORPIO WORLDWIDE LTD
SCORPIO WORLDWIDE LTD
SCORPIO WORLDWIDE LTD
SCORPIO WORLDWIDE LTD
SCORPIO WORLDWIDE LTD
SCORPIO WORLDWIDE LTD
Starbucks Coffee Co (UK) Ltd
User
U658057
U658057
U657664
U658141
U658141
U657610
U658767
U658767
U658767
U658767
U658767
U658767
U658767
U658767
Material
12020054
12020054
12020054
12020054
12020054
12020054
12000117
12000117
12000117
12000117
12000117
12000117
12000118
12019959
Vend. Mat.
5.008E+09
5.008E+09
5.008E+09
5.008E+09
5.008E+09
5.008E+09
TOB194910
TOB194910
TOB194910
TOB194910
TOB194910
TOB194910
TOB310854
11004503
Material Description
Bisc Nutrigrain Kelloggs TOM 1x16
Bisc Nutrigrain Kelloggs TOM 1x16
Bisc Nutrigrain Kelloggs TOM 1x16
Bisc Nutrigrain Kelloggs TOM 1x16
Bisc Nutrigrain Kelloggs TOM 1x16
Bisc Nutrigrain Kelloggs TOM 1x16
Tobacco Golden Virginia TOM 500gx8
Tobacco Golden Virginia TOM 500gx8
Tobacco Golden Virginia TOM 500gx8
Tobacco Golden Virginia TOM 500gx8
Tobacco Golden Virginia TOM 500gx8
Tobacco Golden Virginia TOM 500gx8
Tobacco B&H Gold TOM 400x15
Choc Gold Coin Starbucks TOM 25gx100
OUn
CS
CS
CS
CS
CS
CS
CS
CS
CS
CS
CS
CS
CS
CS
Crcy
GBP
GBP
GBP
GBP
GBP
GBP
GBP
GBP
GBP
GBP
GBP
GBP
GBP
GBP
Net Price
5.60
5.60
5.60
5.60
5.60
5.60
126.88
126.88
126.88
126.88
126.88
126.88
203.55
25.00
Amount
739.20
492.80
492.80
1842.00
1842.00
924.00
17356.80
13885.44
13885.44
9835.52
8099.84
11571.20
8062.20
661.44
Quantity
Diff. Qty
Diff.Val
120 0
67.20
80 0
89.60
80 80 89.60
300 0
162.00
300 0
162.00
150 0
84.00
120 0
2131.20
96 0
1704.96
96 0
1704.96
68 0
1207.68
56 0
994.56
80 0
1420.80
36 0
734.40
24 0
61.44
Amt/Qty
6.16
6.16
6.16
6.14
6.14
6.16
144.64
144.64
144.64
144.64
144.64
144.64
223.95
27.56
CHERYLS COMMENTS
request credit as invoice price not agreed-Thomson line- speak to S Hargreaves
request credit as invoice price not agreed-Thomson line- speak to S Hargreaves
quantity variance-send to local purchasing unit
request credit as invoice price not agreed-Thomson line- speak to S Hargreaves
request credit as invoice price not agreed-Thomson line- speak to S Hargreaves
request credit as invoice price not agreed-Thomson line- speak to S Hargreaves
request credit as invoice price not agreed-Thomson line- speak to S Hargreaves
request credit as invoice price not agreed-Thomson line- speak to S Hargreaves
request credit as invoice price not agreed-Thomson line- speak to S Hargreaves
request credit as invoice price not agreed-Thomson line- speak to S Hargreaves
request credit as invoice price not agreed-Thomson line- speak to S Hargreaves
request credit as invoice price not agreed-Thomson line- speak to S Hargreaves
request credit as invoice price not agreed-Thomson line- speak to S Hargreaves
request credit as invoice price not agreed with supplier-S Hargreaves to review as Thomson line
UNITS COMMENTS
Please use PO4500038448 for this invoice.
Invoice date Invoice ageing (days)
5/8/2013
261
5/17/2013
252
7/17/2013
191
6/17/2013
221
6/17/2013
221
8/21/2013
156
10/4/2013
112
10/14/2013
102
10/18/2013
98
11/6/2013
79
11/7/2013
78
11/14/2013
71
12/11/2013
44
11/7/2013
78
Invoice ageing (group)
over 60 days
over 60 days
over 60 days
over 60 days
over 60 days
over 60 days
over 60 days
over 60 days
over 60 days
over 60 days
over 60 days
over 60 days
30-45 days
over 60 days
Order type Reason Area
Regular
QTY
Region
Regular
QTY
Region
Regular
QTY
Region
Regular
QTY
Region
Regular
QTY
Region
Regular
QTY
Region
Regular
QTY
Region
Regular
QTY
Region
Regular
QTY
Region
Regular
QTY
Region
Regular
QTY
Region
Regular
QTY
Region
Regular
QTY
Region
Regular
QTY
Region
1/24/2014
