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-04-10 | Card Purchase Tesco Stores 6492 On 09 Apr | TESCO STORE | Travel | 0.0% | GBP 6.80 | GBP 0.00 | GBP 6.80 | GBP 3.86 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 6.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-10 | ATM Cash Machine Withdrawal On 10 Apr at 06.41 at Cardtronics UK Ltd ASDA Cardiff PFS | cash machine withdrawal | Cash | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP -16.14 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-10 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 30.00 | GBP 0.00 | GBP 30.00 | GBP 13.86 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 30.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-11 | Card Purchase Sumup *A1 Chipy PL On 10 Apr | A1 Chipy PL | Other Expense | 0.0% | GBP 6.15 | GBP 0.00 | GBP 6.15 | GBP 7.71 | |
|
Client:
A1 Chipy PL
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 6.15
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-11 | ATM Cash Machine Withdrawal On 11 Apr at 14.49 at Notemachine Notemachine | cash machine withdrawal | Cash | 0.0% | GBP 80.00 | GBP 0.00 | GBP 80.00 | GBP -72.29 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 80.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-11 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 550.00 | GBP 0.00 | GBP 550.00 | GBP -622.29 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 550.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-11 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 80.00 | GBP 0.00 | GBP 80.00 | GBP -542.29 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 80.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-11 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 558.40 | GBP 0.00 | GBP 558.40 | GBP 16.11 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 558.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-14 | Card Purchase McDonalds On 13 Apr | MCDONALDS | Travel | 0.0% | GBP 3.49 | GBP 0.00 | GBP 3.49 | GBP 12.62 | |
|
Client:
MCDONALDS
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.49
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-14 | Card Payment to Amazon Prime*R6831 On 11 Apr | amazon | Repairs | 0.0% | GBP 8.99 | GBP 0.00 | GBP 8.99 | GBP 3.63 | |
|
Client:
amazon
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 8.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-15 | Direct Debit to Barclays Ref: 0620A6538264745 | direct debit to barclays ref: 0620a6538264745 | BBL | 0.0% | GBP 16.02 | GBP 0.00 | GBP 16.02 | GBP -12.39 | |
|
Client:
direct debit to barclays ref: 0620a6538264745
Category:
BBL
VAT %:
0.0%
Net Amount:
GBP 16.02
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-16 | Direct Credit From K Jones Ref: Penta | k jones ref: penta | DLA | 0.0% | GBP 26.00 | GBP 0.00 | GBP 26.00 | GBP 13.61 | |
|
Client:
k jones ref: penta
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 26.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-17 | ATM Cash Machine Withdrawal On 17 Apr at 08.46 at Tesco Personal Finance Tesco Merthyr T BP | cash machine withdrawal | Cash | 0.0% | GBP 150.00 | GBP 0.00 | GBP 150.00 | GBP -140.13 | |
|
Client:
cash machine withdrawal
Category:
Cash
VAT %:
0.0%
Net Amount:
GBP 150.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-17 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 294.40 | GBP 0.00 | GBP 294.40 | GBP 54.27 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 294.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-17 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP -240.13 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-17 | Card Purchase Nantgarw Convenien On 16 Apr | NANTGARW CONVENIEN | Travel | 0.0% | GBP 3.74 | GBP 0.00 | GBP 3.74 | GBP 9.87 | |
|
Client:
NANTGARW CONVENIEN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.74
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-22 | Card Purchase Tesco Store On 17 Apr | TESCO STORE | Travel | 0.0% | GBP 39.08 | GBP 0.00 | GBP 39.08 | GBP 15.19 | |
|
Client:
TESCO STORE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 39.08
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-23 | Card Purchase Dfds Calais Duty F France EUR 8.39 On 21 Apr at VISA Exchange Rate 1.16 The Final GBP Amount Includes A Non-Sterling Transaction Fee of 0.20 | Dfds Calais Duty F France | Travel | 0.0% | GBP 7.41 | GBP 0.00 | GBP 7.41 | GBP 7.78 | |
|
Client:
Dfds Calais Duty F France
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 7.41
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-23 | Card Payment to M&S Simply Food On 21 Apr | SIMPLY FOOD | Travel | 0.0% | GBP 5.15 | GBP 0.00 | GBP 5.15 | GBP 2.63 | |
|
Client:
SIMPLY FOOD
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 5.15
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-02 | Card Purchase Decorum Vending PA On 01 May | DECORUM VENDING | Travel | 0.0% | GBP 1.70 | GBP 0.00 | GBP 1.70 | GBP 0.93 | |
|
Client:
DECORUM VENDING
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 1.70
VAT Amount:
GBP 0.00
|
|||||||||