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-08-29 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 1200.00 | GBP 0.00 | GBP 1200.00 | GBP -1199.53 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1200.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 1224.00 | GBP 0.00 | GBP 1224.00 | GBP 24.47 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 1224.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | Card Purchase Ppoint _* Fountain S On 29 Aug | PPOINT FOUNTAIN | Travel | 0.0% | GBP 3.85 | GBP 0.00 | GBP 3.85 | GBP 20.62 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.85
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | Card Purchase Merthyr Tydfil Low On 29 Aug | merthyr tydfil low | Fuel | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 0.62 | |
|
Client:
merthyr tydfil low
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | ATM Cash Machine Withdrawal On 30 Aug at 13.15 at Notemachine Notemachine | cash machine withdrawal | Cash | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP -9.38 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | ATM Cash Machine Withdrawal On 31 Aug at 13.41 at Link Post Office | cash machine withdrawal | Cash | 0.0% | GBP 50.00 | GBP 0.00 | GBP 50.00 | GBP -59.38 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 50.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | Card Payment to Lifestyle George T On 31 Aug | LIFESTYLE GEORGE | DLA | 0.0% | GBP 6.00 | GBP 0.00 | GBP 6.00 | GBP -65.38 | |
|
Client:
LIFESTYLE GEORGE
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 6.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP -55.38 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP -45.38 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 50.00 | GBP 0.00 | GBP 50.00 | GBP 4.62 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 50.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-02 | Card Purchase Tesco Store On 01 Sep | TESCO STORE | Travel | 0.0% | GBP 3.85 | GBP 0.00 | GBP 3.85 | GBP 0.77 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.85
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-05 | Interest Charged For The Period 14 Jul - 12 Aug | INTEREST CHARGED | Bank Charges | 0.0% | GBP 0.05 | GBP 0.00 | GBP 0.05 | GBP 0.72 | |
|
Client:
INTEREST CHARGED
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 0.05
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-05 | Commission Charges For The Period 14 Jul /12 Aug | commission charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP -7.78 | |
|
Client:
commission charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-05 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 860.00 | GBP 0.00 | GBP 860.00 | GBP -867.78 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 860.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-05 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 892.80 | GBP 0.00 | GBP 892.80 | GBP 25.02 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 892.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-08 | Card Purchase Premier Fountain S On 05 Sep | PPOINT FOUNTAIN | Travel | 0.0% | GBP 2.65 | GBP 0.00 | GBP 2.65 | GBP 22.37 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 2.65
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-08 | Card Purchase Morlais Castle Gol On 06 Sep | MORLAIS CASTLE | Travel | 0.0% | GBP 4.55 | GBP 0.00 | GBP 4.55 | GBP 17.82 | |
|
Client:
MORLAIS CASTLE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.55
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-08 | Card Purchase Premier Fountain S On 06 Sep | PPOINT FOUNTAIN | Travel | 0.0% | GBP 8.95 | GBP 0.00 | GBP 8.95 | GBP 8.87 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 8.95
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-09 | CARD PURCHASE ppoint_*fountain s on 08 sep | PPOINT FOUNTAIN | Travel | 0.0% | GBP 6.95 | GBP 0.00 | GBP 6.95 | GBP 1.92 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 6.95
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-12 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 1270.00 | GBP 0.00 | GBP 1270.00 | GBP -1268.08 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1270.00
VAT Amount:
GBP 0.00
|
|||||||||