Office mockups excel.outline
Spreadsheet

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