GPT Analysis: Excel data processed directly from structured columns; Date Gap Analysis: Found 7 gaps > 7 days: 04/23/2025 to 05/02/2025 (9 days), 06/23/2025 to 07/01/2025 (8 days), 11/17/2025 to 12/05/2025 (18 days), 12/05/2025 to 12/15/2025 (10 days), 12/15/2025 to 01/08/2026 (24 days), 01/15/2026 to 02/04/2026 (20 days), 02/16/2026 to 03/09/2026 (21 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2025-10-13 | Card Purchase W M Morrison Store On 10 Oct | W M MORRISON | Travel | 0.0% | GBP 8.55 | GBP 0.00 | GBP 8.55 | GBP 8.92 | |
|
Client:
W M MORRISON
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 8.55
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-13 | Card Purchase The Trading Post On 11 Oct | THE STRADEY ARMS | Travel | 0.0% | GBP 8.64 | GBP 0.00 | GBP 8.64 | GBP 0.28 | |
|
Client:
THE STRADEY ARMS
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 8.64
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-15 | Direct Debit to Barclays Ref: 0620A6538264745 | direct debit to barclays ref: 0620a6538264745 | BBL | 0.0% | GBP 142.81 | GBP 0.00 | GBP 142.81 | GBP -142.53 | |
|
Client:
direct debit to barclays ref: 0620a6538264745
Category:
BBL
VAT %:
0.0%
Net Amount:
GBP 142.81
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-17 | ATM Cash Machine Withdrawal On 17 Oct at 13.49 at Notemachine Notemachine | cash machine withdrawal | Cash | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP -152.53 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-17 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 1220.00 | GBP 0.00 | GBP 1220.00 | GBP -1372.53 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1220.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-17 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 1419.60 | GBP 0.00 | GBP 1419.60 | GBP 47.07 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 1419.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-20 | Card Purchase Greggs PLC On 17 Oct | GREGGS | Travel | 0.0% | GBP 7.24 | GBP 0.00 | GBP 7.24 | GBP 39.83 | |
|
Client:
GREGGS
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 7.24
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-20 | Card Purchase Rontec Penrhos On 19 Oct | RONTEC PENRHOS | Fuel | 0.0% | GBP 8.05 | GBP 0.00 | GBP 8.05 | GBP 31.78 | |
|
Client:
RONTEC PENRHOS
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 8.05
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-20 | Card Purchase Rontec Penrhos On 17 Oct | RONTEC PENRHOS | Fuel | 0.0% | GBP 31.27 | GBP 0.00 | GBP 31.27 | GBP 0.51 | |
|
Client:
RONTEC PENRHOS
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 31.27
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-24 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 1120.00 | GBP 0.00 | GBP 1120.00 | GBP -1119.49 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1120.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-24 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 1156.80 | GBP 0.00 | GBP 1156.80 | GBP 37.31 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 1156.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-27 | Card Purchase Ppoint _* Fountain S On 26 Oct | PPOINT FOUNTAIN | Travel | 0.0% | GBP 1.90 | GBP 0.00 | GBP 1.90 | GBP 35.41 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 1.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-27 | Card Purchase Morlais Castle Gol On 26 Oct | MORLAIS CASTLE | Travel | 0.0% | GBP 5.75 | GBP 0.00 | GBP 5.75 | GBP 29.66 | |
|
Client:
MORLAIS CASTLE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 5.75
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-27 | Card Purchase Ppoint _* Nisa Local On 26 Oct | PPOINT FOUNTAIN | Travel | 0.0% | GBP 6.99 | GBP 0.00 | GBP 6.99 | GBP 22.67 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 6.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-27 | Card Payment to Amazon* JT9W34IO5 On 24 Oct | amazon | Repairs | 0.0% | GBP 5.90 | GBP 0.00 | GBP 5.90 | GBP 16.77 | |
|
Client:
amazon
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 5.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-27 | Card Payment to Amazon* JW94Q0635 On 24 Oct | amazon | Repairs | 0.0% | GBP 8.49 | GBP 0.00 | GBP 8.49 | GBP 8.28 | |
|
Client:
amazon
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 8.49
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-28 | Card Purchase Rontec South Corne On 27 Oct | RONTEC PENRHOS | Fuel | 0.0% | GBP 5.00 | GBP 0.00 | GBP 5.00 | GBP 3.28 | |
|
Client:
RONTEC PENRHOS
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 5.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-31 | Card Purchase Esso Neath On 30 Oct | ESSO NEATH | Fuel | 0.0% | GBP 3.05 | GBP 0.00 | GBP 3.05 | GBP 0.23 | |
|
Client:
ESSO NEATH
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 3.05
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-31 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 1500.00 | GBP 0.00 | GBP 1500.00 | GBP -1499.77 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-31 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 1522.40 | GBP 0.00 | GBP 1522.40 | GBP 22.63 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 1522.40
VAT Amount:
GBP 0.00
|
|||||||||