Office mockups shared.print-excel
Spreadsheet

Saved
File
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
1
Property claims ledger — Q3 2026
2
Claim
Policyholder
Peril
Reported
Reserve (£)
Paid (£)
Outstanding (£)
3
CS-2031
Okafor, Daniel
Storm
02 Jul
3,100.00
3,100.00
0.00
Settled
4
CS-2036
Lindqvist, Maja
Escape of water
09 Jul
6,800.00
2,500.00
4,300.00
Open
5
CS-2041
Marsh, Eleanor
Escape of water
11 Aug
4,250.00
0.00
4,250.00
Assessed
6
CS-2044
Patel, Rohan
Theft
14 Aug
1,180.00
1,180.00
0.00
Settled
7
CS-2051
Brennan, Siobhan
Fire
19 Aug
7,940.00
4,000.00
3,940.00
Open
8
CS-2057
Hughes, Gareth
Accidental damage
27 Aug
620.00
0.00
620.00
Declined
9
CS-2063
Novak, Petra
Subsidence
03 Sep
12,400.00
1,500.00
10,900.00
Open
10
CS-2068
Adeyemi, Tolu
Storm
10 Sep
2,150.00
2,150.00
0.00
Settled
11
CS-2071
Fischer, Jonas
Escape of water
18 Sep
4,950.00
0.00
4,950.00
Open
12
CS-2075
Marlowe, Ruth
Theft
24 Sep
890.00
0.00
890.00
In review
13
Total
44,280.00
14,430.00
14
15
Reserve held on open claims is reviewed every Friday by the claims manager.
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
=SUM(E3:E12)-SUM(F3:F12)
Page 1 of 2
Print what
Page setup…