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-06-23 | Card Purchase Premier Fountain S On 20 Jun | PPOINT FOUNTAIN | Travel | 0.0% | GBP 3.75 | GBP 0.00 | GBP 3.75 | GBP 21.03 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.75
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-23 | Card Purchase Merthyr Tydfil Low On 20 Jun | merthyr tydfil low | Fuel | 0.0% | GBP 20.01 | GBP 0.00 | GBP 20.01 | GBP 1.02 | |
|
Client:
merthyr tydfil low
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 20.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-01 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 830.00 | GBP 0.00 | GBP 830.00 | GBP -828.98 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 830.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-01 | Direct Credit From Coyle Personnel Ref: Coyles | coyle personnel | Sales | 0.0% | GBP 840.00 | GBP 0.00 | GBP 840.00 | GBP 11.02 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 840.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-02 | Card Purchase Tesco Store On 01 Jul | TESCO STORE | Travel | 0.0% | GBP 6.00 | GBP 0.00 | GBP 6.00 | GBP 5.02 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 6.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-04 | ATM Cash Machine Withdrawal On 04 Jul at 15.53 at Notemachine Notemachine | cash machine withdrawal | Cash | 0.0% | GBP 90.00 | GBP 0.00 | GBP 90.00 | GBP -84.98 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 90.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-04 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 1236.00 | GBP 0.00 | GBP 1236.00 | GBP 21.02 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 1236.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-04 | 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 -1304.98 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1220.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-04 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 90.00 | GBP 0.00 | GBP 90.00 | GBP -1214.98 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 90.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | Card Purchase Ppoint _* Fountain S On 06 Jul | PPOINT FOUNTAIN | Travel | 0.0% | GBP 2.10 | GBP 0.00 | GBP 2.10 | GBP 18.92 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 2.10
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | Card Purchase Tesco Store On 05 Jul | TESCO STORE | Travel | 0.0% | GBP 3.40 | GBP 0.00 | GBP 3.40 | GBP 15.52 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | Card Purchase Tesco Store On 04 Jul | TESCO STORE | Travel | 0.0% | GBP 4.70 | GBP 0.00 | GBP 4.70 | GBP 10.82 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.70
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | Interest Charged For The Period 13 May - 12 Jun | INTEREST CHARGED | Bank Charges | 0.0% | GBP 0.02 | GBP 0.00 | GBP 0.02 | GBP 10.80 | |
|
Client:
INTEREST CHARGED
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 0.02
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | Commission Charges For The Period 13 May /12 Jun | commission charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 2.30 | |
|
Client:
commission charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-11 | ATM Cash Machine Withdrawal On 11 Jul at 09.51 at Cardtronics UK Ltd Principality - Mer | cash machine withdrawal | Cash | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP -17.70 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-11 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 1280.00 | GBP 0.00 | GBP 1280.00 | GBP 10.30 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 1280.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-11 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 1260.00 | GBP 0.00 | GBP 1260.00 | GBP -1277.70 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1260.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-11 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 8.00 | GBP 0.00 | GBP 8.00 | GBP -1269.70 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 8.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-14 | Card Purchase Arc Car Wash Merth On 11 Jul | Car Wash | Motor | 0.0% | GBP 8.00 | GBP 0.00 | GBP 8.00 | GBP 0.92 | |
|
Client:
Car Wash
Category:
Motor
VAT %:
0.0%
Net Amount:
GBP 8.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-14 | Card Purchase Sumup *Wisebuys PE On 12 Jul | SUMUP WISEBUYS | Travel | 0.0% | GBP 1.38 | GBP 0.00 | GBP 1.38 | GBP 8.92 | |
|
Client:
SUMUP WISEBUYS
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 1.38
VAT Amount:
GBP 0.00
|
|||||||||