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-09-12 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 1295.60 | GBP 0.00 | GBP 1295.60 | GBP 27.52 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 1295.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-15 | Direct Debit to Barclays Ref: 0620A6538264745 | direct debit to barclays ref: 0620a6538264745 | BBL | 0.0% | GBP 143.59 | GBP 0.00 | GBP 143.59 | GBP -116.07 | |
|
Client:
direct debit to barclays ref: 0620a6538264745
Category:
BBL
VAT %:
0.0%
Net Amount:
GBP 143.59
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-15 | Card Purchase Nyx*Tesco On 13 Sep | TESCO STORE | Travel | 0.0% | GBP 1.00 | GBP 0.00 | GBP 1.00 | GBP -117.07 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 1.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-15 | Card Purchase Nyx*Hensolgolfacad On 14 Sep | HENSOL GOLF | DLA | 0.0% | GBP 1.25 | GBP 0.00 | GBP 1.25 | GBP -118.32 | |
|
Client:
HENSOL GOLF
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1.25
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-15 | Card Purchase Nyx*Hensolgolfacad On 14 Sep | HENSOL GOLF | DLA | 0.0% | GBP 1.45 | GBP 0.00 | GBP 1.45 | GBP -119.77 | |
|
Client:
HENSOL GOLF
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-15 | Card Purchase Morlais Castle Gol On 13 Sep | MORLAIS CASTLE | Travel | 0.0% | GBP 4.55 | GBP 0.00 | GBP 4.55 | GBP -124.32 | |
|
Client:
MORLAIS CASTLE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.55
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-15 | Card Purchase Tesco Store On 12 Sep | TESCO STORE | Travel | 0.0% | GBP 7.25 | GBP 0.00 | GBP 7.25 | GBP -131.57 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 7.25
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-15 | Card Purchase Subway42487 On 12 Sep+ | Subway | Travel | 0.0% | GBP 8.39 | GBP 0.00 | GBP 8.39 | GBP -139.96 | |
|
Client:
Subway
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 8.39
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-19 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 1140.00 | GBP 0.00 | GBP 1140.00 | GBP -1279.96 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1140.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-19 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 1295.60 | GBP 0.00 | GBP 1295.60 | GBP 15.64 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 1295.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-22 | ) Card Purchase Morlais Castle Gol On 19 Sep | MORLAIS CASTLE | Travel | 0.0% | GBP 0.90 | GBP 0.00 | GBP 0.90 | GBP 14.74 | |
|
Client:
MORLAIS CASTLE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 0.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-22 | Card Purchase Parc Golf Centre On 20 Sep | Golf | DLA | 0.0% | GBP 2.20 | GBP 0.00 | GBP 2.20 | GBP 12.54 | |
|
Client:
Golf
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 2.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-22 | Card Purchase Morlais Castle Gol On 19 Sep | MORLAIS CASTLE | Travel | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP 2.54 | |
|
Client:
MORLAIS CASTLE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-24 | Card Payment to Nyx*Tesco On 23 Sep | TESCO STORE | Travel | 0.0% | GBP 1.00 | GBP 0.00 | GBP 1.00 | GBP 1.54 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 1.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-26 | ATM Cash Machine Withdrawal On 26 Sep at 11.04 at Tesco Personal Finance Tesco Merthyr T BP | cash machine withdrawal | Cash | 0.0% | GBP 40.00 | GBP 0.00 | GBP 40.00 | GBP -38.46 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 40.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-26 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 940.00 | GBP 0.00 | GBP 940.00 | GBP -978.46 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 940.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-26 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 992.00 | GBP 0.00 | GBP 992.00 | GBP 13.54 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 992.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-29 | Card Purchase Sparstorenarberths On 26 Sep | SPARSTORENARBERTHS | Travel | 0.0% | GBP 3.50 | GBP 0.00 | GBP 3.50 | GBP 10.04 | |
|
Client:
SPARSTORENARBERTHS
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-29 | Card Purchase Clwb Golff Caerfyr On 26 Sep | Golf | DLA | 0.0% | GBP 4.00 | GBP 0.00 | GBP 4.00 | GBP 6.04 | |
|
Client:
Golf
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-29 | Card Purchase The Hean On 27 Sep | THE HEAN | Travel | 0.0% | GBP 4.00 | GBP 0.00 | GBP 4.00 | GBP 2.04 | |
|
Client:
THE HEAN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.00
|
|||||||||