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-11-03 | Card Purchase Dlw Retail Limited On 01 Nov | DLW RETAIL | Travel | 0.0% | GBP 2.65 | GBP 0.00 | GBP 2.65 | GBP 19.98 | |
|
Client:
DLW RETAIL
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 2.65
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-03 | Card Purchase New Inn Convenienc On 02 Nov | New Inn | Travel | 0.0% | GBP 2.65 | GBP 0.00 | GBP 2.65 | GBP 17.33 | |
|
Client:
New Inn
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 2.65
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-03 | Card Purchase B&M 257 - Carmarth On 31 Oct | BQ | Repairs | 0.0% | GBP 3.89 | GBP 0.00 | GBP 3.89 | GBP 13.44 | |
|
Client:
BQ
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 3.89
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-03 | Interest Charged For The Period 15 Sep - 12 Oct | INTEREST CHARGED | Bank Charges | 0.0% | GBP 0.45 | GBP 0.00 | GBP 0.45 | GBP 12.99 | |
|
Client:
INTEREST CHARGED
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 0.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-03 | Commission Charges For The Period 15 Sep /12 Oct | commission charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 4.49 | |
|
Client:
commission charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-04 | Card Purchase Aldi 2 780 On 03 Nov | aldi | DLA | 0.0% | GBP 2.35 | GBP 0.00 | GBP 2.35 | GBP 2.14 | |
|
Client:
aldi
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 2.35
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-07 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 850.00 | GBP 0.00 | GBP 850.00 | GBP -847.86 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 850.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-07 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 874.00 | GBP 0.00 | GBP 874.00 | GBP 26.14 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 874.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-10 | Card Purchase Jollyes - The Pet On 07 Nov | JOLLYES | DLA | 0.0% | GBP 3.00 | GBP 0.00 | GBP 3.00 | GBP 23.14 | |
|
Client:
JOLLYES
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 3.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-10 | Card Purchase Merthyr Tydfil Low On 07 Nov | merthyr tydfil low | Fuel | 0.0% | GBP 15.01 | GBP 0.00 | GBP 15.01 | GBP 8.13 | |
|
Client:
merthyr tydfil low
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 15.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-14 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 300.00 | GBP 0.00 | GBP 300.00 | GBP -291.87 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 300.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-14 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 303.60 | GBP 0.00 | GBP 303.60 | GBP 11.73 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 303.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-17 | Direct Debit to Barclays Ref: 0620A6538264745 | direct debit to barclays ref: 0620a6538264745 | BBL | 0.0% | GBP 143.04 | GBP 0.00 | GBP 143.04 | GBP -131.31 | |
|
Client:
direct debit to barclays ref: 0620a6538264745
Category:
BBL
VAT %:
0.0%
Net Amount:
GBP 143.04
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-17 | Card Purchase Aldi 2 780 On 16 Nov | aldi | DLA | 0.0% | GBP 3.89 | GBP 0.00 | GBP 3.89 | GBP -135.20 | |
|
Client:
aldi
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 3.89
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-17 | Card Purchase The Drop Zone Golf On 14 Nov | Golf | DLA | 0.0% | GBP 6.10 | GBP 0.00 | GBP 6.10 | GBP -141.30 | |
|
Client:
Golf
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 6.10
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-05 | Interest Charged For The Period 13 Oct - 12 Nov | INTEREST CHARGED | Bank Charges | 0.0% | GBP 0.23 | GBP 0.00 | GBP 0.23 | GBP -141.53 | |
|
Client:
INTEREST CHARGED
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 0.23
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-05 | Commission Charges For The Period 13 Oct /12 Nov | commission charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP -150.03 | |
|
Client:
commission charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-15 | Direct Debit to Barclays Ref: 0620A6538264745 | direct debit to barclays ref: 0620a6538264745 | BBL | 0.0% | GBP 142.29 | GBP 0.00 | GBP 142.29 | GBP -292.32 | |
|
Client:
direct debit to barclays ref: 0620a6538264745
Category:
BBL
VAT %:
0.0%
Net Amount:
GBP 142.29
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-01-08 | Interest Charged For The Period 13 Nov - 14 Dec | INTEREST CHARGED | Bank Charges | 0.0% | GBP 3.26 | GBP 0.00 | GBP 3.26 | GBP -295.58 | |
|
Client:
INTEREST CHARGED
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 3.26
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-01-08 | Commission Charges For The Period 13 Nov /14 Dec | commission charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP -304.08 | |
|
Client:
commission charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||