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-09-30 | ATM Cash Machine Withdrawal On 30 Sep at 01.58 at Notemachine Notemachine | cash machine withdrawal | Cash | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP -7.96 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-30 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP 2.04 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-03 | Card Purchase Premier Fountain S On 02 Oct | PPOINT FOUNTAIN | Travel | 0.0% | GBP 1.20 | GBP 0.00 | GBP 1.20 | GBP 0.84 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 1.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-03 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 960.00 | GBP 0.00 | GBP 960.00 | GBP -959.16 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 960.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-03 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 5.00 | GBP 0.00 | GBP 5.00 | GBP -954.16 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 5.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-03 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 992.00 | GBP 0.00 | GBP 992.00 | GBP 37.84 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 992.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-06 | Card Purchase Premier Fountain S On 03 Oct | PPOINT FOUNTAIN | Travel | 0.0% | GBP 3.64 | GBP 0.00 | GBP 3.64 | GBP 34.20 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.64
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-06 | Card Purchase Tesco Store On 05 Oct | TESCO STORE | Travel | 0.0% | GBP 7.13 | GBP 0.00 | GBP 7.13 | GBP 27.07 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 7.13
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-06 | ATM Cash Machine Withdrawal On 03 Oct at 18.29 at Notemachine Notemachine | cash machine withdrawal | Cash | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP 17.07 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-06 | ATM Cash Machine Withdrawal On 03 Oct at 18.14 at Cardtronics UK Ltd ASDA Merthyr Tydfi | cash machine withdrawal | Cash | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP -2.93 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-06 | Commission Charges For The Period 13 Aug /14 Sep | commission charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP -11.43 | |
|
Client:
commission charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-06 | Correction to 18.1403Octlkbkb000 ASDA Merthyr Tydfi We Apologise For This Error On Your Account Which We Have Corrected. You Have Not Been Charged For Either of These Entries. | cash machine withdrawal | Cash | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 8.57 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-08 | Card Purchase One Stop Stores On 07 Oct | ONE STOP | Travel | 0.0% | GBP 3.05 | GBP 0.00 | GBP 3.05 | GBP 5.52 | |
|
Client:
ONE STOP
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.05
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-09 | Card Purchase Sainsburys S/Mkts On 08 Oct | sainsburys s/mkts | Fuel | 0.0% | GBP 1.20 | GBP 0.00 | GBP 1.20 | GBP 4.32 | |
|
Client:
sainsburys s/mkts
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 1.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-09 | ATM Cash Withdrawal On 09 Oct at 12.51 at Pay Point 38944409 82194Terr | cash machine withdrawal | Cash | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP -5.68 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-09 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP 4.32 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-10 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 970.00 | GBP 0.00 | GBP 970.00 | GBP -965.68 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 970.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-10 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 992.00 | GBP 0.00 | GBP 992.00 | GBP 26.32 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 992.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-13 | Card Purchase W M Morrison Store On 10 Oct | W M MORRISON | Travel | 0.0% | GBP 1.20 | GBP 0.00 | GBP 1.20 | GBP 25.12 | |
|
Client:
W M MORRISON
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 1.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-13 | Card Purchase Tesco Stores 3476 On 11 Oct | TESCO STORE | Travel | 0.0% | GBP 7.65 | GBP 0.00 | GBP 7.65 | GBP 17.47 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 7.65
VAT Amount:
GBP 0.00
|
|||||||||