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-04 | Commission Charges For The Period 13 Jun /13 Jul | commission charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP -3.27 | |
|
Client:
commission charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-08 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 600.00 | GBP 0.00 | GBP 600.00 | GBP -603.27 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 600.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-08 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 620.00 | GBP 0.00 | GBP 620.00 | GBP 16.73 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 620.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | Card Purchase Premier Fountain S On 09 Aug | PPOINT FOUNTAIN | Travel | 0.0% | GBP 4.25 | GBP 0.00 | GBP 4.25 | GBP 12.48 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.25
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | Card Purchase Rss Whion Down On 08 Aug | rss dowlais | Fuel | 0.0% | GBP 5.35 | GBP 0.00 | GBP 5.35 | GBP 7.13 | |
|
Client:
rss dowlais
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 5.35
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-12 | Card Purchase McDonalds On 11 Aug | MCDONALDS | Travel | 0.0% | GBP 5.32 | GBP 0.00 | GBP 5.32 | GBP 1.81 | |
|
Client:
MCDONALDS
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 5.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-15 | Direct Debit to Barclays Ref: 0620A6538264745 | direct debit to barclays ref: 0620a6538264745 | BBL | 0.0% | GBP 143.85 | GBP 0.00 | GBP 143.85 | GBP -142.04 | |
|
Client:
direct debit to barclays ref: 0620a6538264745
Category:
BBL
VAT %:
0.0%
Net Amount:
GBP 143.85
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-15 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 1120.00 | GBP 0.00 | GBP 1120.00 | GBP -1262.04 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1120.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-15 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 1280.00 | GBP 0.00 | GBP 1280.00 | GBP 17.96 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 1280.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-18 | Card Purchase Merthyr Tydfil Low On 16 Aug | merthyr tydfil low | Fuel | 0.0% | GBP 0.75 | GBP 0.00 | GBP 0.75 | GBP 17.21 | |
|
Client:
merthyr tydfil low
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 0.75
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-18 | Card Purchase Morlais Castle Gol On 16 Aug | MORLAIS CASTLE | Travel | 0.0% | GBP 1.65 | GBP 0.00 | GBP 1.65 | GBP 15.56 | |
|
Client:
MORLAIS CASTLE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 1.65
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-18 | Card Purchase Ppoint _* Fountain S On 16 Aug | PPOINT FOUNTAIN | Travel | 0.0% | GBP 4.25 | GBP 0.00 | GBP 4.25 | GBP 11.31 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.25
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-19 | Card Purchase Ppoint _* Fountain S On 18 Aug | PPOINT FOUNTAIN | Travel | 0.0% | GBP 3.85 | GBP 0.00 | GBP 3.85 | GBP 7.46 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.85
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | Card Purchase Nyx*Tesco On 22 Aug | TESCO STORE | Travel | 0.0% | GBP 1.00 | GBP 0.00 | GBP 1.00 | GBP 6.46 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 1.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | Card Purchase Max Spielmann 3560 On 23 Aug | MAX SPIELMANN | DLA | 0.0% | GBP 1.00 | GBP 0.00 | GBP 1.00 | GBP 5.46 | |
|
Client:
MAX SPIELMANN
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | Card Purchase Premier Llanbradac On 22 Aug | PREMIER LLANBRADAC | Travel | 0.0% | GBP 3.34 | GBP 0.00 | GBP 3.34 | GBP 2.12 | |
|
Client:
PREMIER LLANBRADAC
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.34
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | Card Purchase Co-Op Group 190317 On 25 Aug | COOP GROUP | Travel | 0.0% | GBP 28.65 | GBP 0.00 | GBP 28.65 | GBP -26.53 | |
|
Client:
COOP GROUP
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 28.65
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 30.00 | GBP 0.00 | GBP 30.00 | GBP 3.47 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 30.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-27 | Card Purchase Greggs PLC On 26 Aug | GREGGS | Travel | 0.0% | GBP 2.05 | GBP 0.00 | GBP 2.05 | GBP 1.42 | |
|
Client:
GREGGS
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 2.05
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | Card Purchase Aldi 2 780 On 28 Aug | aldi | DLA | 0.0% | GBP 0.95 | GBP 0.00 | GBP 0.95 | GBP 0.47 | |
|
Client:
aldi
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 0.95
VAT Amount:
GBP 0.00
|
|||||||||