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-05-08 | Interest Charged For The Period 13 Mar - 13 Apr | INTEREST CHARGED | Bank Charges | 0.0% | GBP 0.04 | GBP 0.00 | GBP 0.04 | GBP 0.89 | |
|
Client:
INTEREST CHARGED
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 0.04
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-08 | Commission Charges For The Period 13 Mar /13 Apr | commission charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP -7.61 | |
|
Client:
commission charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-12 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 15.00 | GBP 0.00 | GBP 15.00 | GBP 7.39 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 15.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-14 | Card Purchase Marks&Spencer PLC On 13 May | MARKSSPENCER | Travel | 0.0% | GBP 6.10 | GBP 0.00 | GBP 6.10 | GBP 1.29 | |
|
Client:
MARKSSPENCER
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 6.10
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-15 | Direct Debit to Barclays Ref: 0620A6538264745 | direct debit to barclays ref: 0620a6538264745 | BBL | 0.0% | GBP 15.50 | GBP 0.00 | GBP 15.50 | GBP -14.21 | |
|
Client:
direct debit to barclays ref: 0620a6538264745
Category:
BBL
VAT %:
0.0%
Net Amount:
GBP 15.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-16 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 520.00 | GBP 0.00 | GBP 520.00 | GBP -534.21 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 520.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-16 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 560.00 | GBP 0.00 | GBP 560.00 | GBP 25.79 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 560.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-19 | Card Purchase Merthyr Food Store On 16 May | merthyr tydfil low | Fuel | 0.0% | GBP 3.75 | GBP 0.00 | GBP 3.75 | GBP 22.04 | |
|
Client:
merthyr tydfil low
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 3.75
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-19 | Card Purchase Tesco Store On 18 May | TESCO STORE | Travel | 0.0% | GBP 5.40 | GBP 0.00 | GBP 5.40 | GBP 16.64 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 5.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-19 | Card Purchase Hensol Golf Academ On 17 May | HENSOL GOLF | DLA | 0.0% | GBP 13.50 | GBP 0.00 | GBP 13.50 | GBP 3.14 | |
|
Client:
HENSOL GOLF
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 13.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-23 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 852.00 | GBP 0.00 | GBP 852.00 | GBP 35.14 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 852.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-23 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 820.00 | GBP 0.00 | GBP 820.00 | GBP -816.86 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 820.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-27 | Card Purchase Ppoint _* Fountain S On 26 May | PPOINT FOUNTAIN | Travel | 0.0% | GBP 2.50 | GBP 0.00 | GBP 2.50 | GBP 32.64 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 2.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-27 | Card Purchase Rose & Crown On 25 May | ROSE CROWN | Travel | 0.0% | GBP 3.85 | GBP 0.00 | GBP 3.85 | GBP 28.79 | |
|
Client:
ROSE CROWN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.85
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-27 | Card Purchase Greggs PLC On 23 May | GREGGS | Travel | 0.0% | GBP 4.30 | GBP 0.00 | GBP 4.30 | GBP 24.49 | |
|
Client:
GREGGS
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.30
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-27 | Card Purchase Morlais Castle Gol On 25 May | MORLAIS CASTLE | Travel | 0.0% | GBP 4.55 | GBP 0.00 | GBP 4.55 | GBP 19.94 | |
|
Client:
MORLAIS CASTLE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.55
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-27 | Card Purchase The Celtic Manor R On 23 May | CELTIC MANOR | Travel | 0.0% | GBP 7.00 | GBP 0.00 | GBP 7.00 | GBP 12.94 | |
|
Client:
CELTIC MANOR
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 7.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-27 | Card Payment to Premier Fountain S On 23 May | PPOINT FOUNTAIN | Travel | 0.0% | GBP 4.99 | GBP 0.00 | GBP 4.99 | GBP 7.95 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-28 | Card Purchase W M Morrison Store On 27 May | W M MORRISON | Travel | 0.0% | GBP 7.79 | GBP 0.00 | GBP 7.79 | GBP 0.16 | |
|
Client:
W M MORRISON
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 7.79
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-30 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 280.00 | GBP 0.00 | GBP 280.00 | GBP 20.16 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 280.00
VAT Amount:
GBP 0.00
|
|||||||||