Office mockups excel.narrow
Spreadsheet

Saved
File
=E9-F9
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
1
Property claims ledger — Q3 2026
2
Claim
Policyholder
Peril
Reported
Reserve (£)
Paid (£)
Outstanding (£)
Status
Handler
Days
Region
3
CS-2031
Okafor, Daniel
Storm
02 Jul
3,100.00
3,100.00
0.00
Settled
Priya Shah
92
North
4
CS-2036
Lindqvist, Maja
Escape of water
09 Jul
6,800.00
2,500.00
4,300.00
Open
Jane Doe
85
South
5
CS-2041
Marsh, Eleanor
Escape of water
11 Aug
4,250.00
0.00
4,250.00
Assessed
Jane Doe
52
West
6
CS-2044
Patel, Rohan
Theft
14 Aug
1,180.00
1,180.00
0.00
Settled
Mark Rivera
49
North
7
CS-2051
Brennan, Siobhan
Fire
19 Aug
7,940.00
4,000.00
3,940.00
Open
Priya Shah
44
East
8
CS-2057
Hughes, Gareth
Accidental damage
27 Aug
620.00
0.00
620.00
Declined
Mark Rivera
36
West
9
CS-2063
Novak, Petra
Subsidence
03 Sep
12,400.00
1,500.00
10,900.00
Open
Jane Doe
29
South
10
CS-2068
Adeyemi, Tolu
Storm
10 Sep
2,150.00
2,150.00
0.00
Settled
Priya Shah
22
East
11
CS-2071
Fischer, Jonas
Escape of water
18 Sep
4,950.00
0.00
4,950.00
Open
Mark Rivera
14
North
12
CS-2075
Marlowe, Ruth
Theft
24 Sep
890.00
0.00
890.00
In review
Jane Doe
8
West
13
CS-2079
Kowalski, Anna
Fire
26 Sep
9,300.00
2,000.00
7,300.00
Open
Priya Shah
6
South
14
CS-2082
Osei, Kwame
Accidental damage
28 Sep
540.00
540.00
0.00
Settled
Mark Rivera
4
East
15
CS-2086
Duarte, Inês
Escape of water
29 Sep
3,720.00
0.00
3,720.00
Assessed
Jane Doe
3
North
16
CS-2090
Whitaker, Tom
Storm
30 Sep
1,860.00
0.00
1,860.00
Open
Priya Shah
2
West
17
CS-2093
Haddad, Leila
Theft
30 Sep
2,475.00
0.00
2,475.00
In review
Mark Rivera
2
South
18
CS-2097
Byrne, Ciarán
Subsidence
01 Oct
15,800.00
0.00
15,800.00
Open
Jane Doe
1
East
19
Total
77,975.00
16,970.00
61,005.00
20
21
Reserves on open claims are reviewed every Friday by the claims manager.
22
23
24
25
26
27
28
29
30
31
32