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-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
|
|||||||||
| 2025-06-02 | Card Purchase Farmfoods 812 On 30 May | FARMFOODS | Travel | 0.0% | GBP 2.64 | GBP 0.00 | GBP 2.64 | GBP 17.52 | |
|
Client:
FARMFOODS
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 2.64
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-02 | Card Purchase B & Q 1348 On 31 May | BQ | Repairs | 0.0% | GBP 7.00 | GBP 0.00 | GBP 7.00 | GBP 10.52 | |
|
Client:
BQ
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 7.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-02 | Card Purchase Vue Cinemas On 31 May | VUE CINEMAS | Set off | 0.0% | GBP 8.00 | GBP 0.00 | GBP 8.00 | GBP 2.52 | |
|
Client:
VUE CINEMAS
Category:
Set off
VAT %:
0.0%
Net Amount:
GBP 8.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-02 | Card Refund Vue Cinemas On 31 May | VUE CINEMAS | Set off | 0.0% | GBP 8.00 | GBP 0.00 | GBP 8.00 | GBP 10.52 | |
|
Client:
VUE CINEMAS
Category:
Set off
VAT %:
0.0%
Net Amount:
GBP 8.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-05 | Interest Charged For The Period 14 Apr - 12 May | INTEREST CHARGED | Bank Charges | 0.0% | GBP 0.04 | GBP 0.00 | GBP 0.04 | GBP 1.07 | |
|
Client:
INTEREST CHARGED
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 0.04
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-05 | Commission Charges For The Period 14 Apr /12 May | commission charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP -7.43 | |
|
Client:
commission charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-05 | Card Payment to Sainsburys S/Mkts On 04 Jun | sainsburys s/mkts | Fuel | 0.0% | GBP 3.65 | GBP 0.00 | GBP 3.65 | GBP 1.11 | |
|
Client:
sainsburys s/mkts
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 3.65
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-05 | Card Purchase Aldi 2 780 On 04 Jun | aldi | DLA | 0.0% | GBP 5.76 | GBP 0.00 | GBP 5.76 | GBP 4.76 | |
|
Client:
aldi
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 5.76
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-06 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 792.80 | GBP 0.00 | GBP 792.80 | GBP 35.37 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 792.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-06 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 750.00 | GBP 0.00 | GBP 750.00 | GBP -757.43 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 750.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-09 | Card Purchase B&M 066 - Pwllheli On 07 Jun | BQ | Repairs | 0.0% | GBP 1.89 | GBP 0.00 | GBP 1.89 | GBP 33.48 | |
|
Client:
BQ
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 1.89
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-09 | Card Purchase Builth Wells Servi On 07 Jun | Builth Wells Servi | Fuel | 0.0% | GBP 5.14 | GBP 0.00 | GBP 5.14 | GBP 28.34 | |
|
Client:
Builth Wells Servi
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 5.14
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-09 | Card Purchase Morlais Castle Gol On 06 Jun | MORLAIS CASTLE | Travel | 0.0% | GBP 5.75 | GBP 0.00 | GBP 5.75 | GBP 22.59 | |
|
Client:
MORLAIS CASTLE
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 5.75
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-09 | Card Payment to BP Exeter MWSA On 06 Jun | EXETER MWSA | Fuel | 0.0% | GBP 19.99 | GBP 0.00 | GBP 19.99 | GBP 2.60 | |
|
Client:
EXETER MWSA
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 19.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-11 | Card Purchase Lifestyle George T On 10 Jun | LIFESTYLE GEORGE | DLA | 0.0% | GBP 0.80 | GBP 0.00 | GBP 0.80 | GBP 1.80 | |
|
Client:
LIFESTYLE GEORGE
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 0.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-11 | Card Purchase Anduff Car Wash LI On 10 Jun | Car Wash | Motor | 0.0% | GBP 1.00 | GBP 0.00 | GBP 1.00 | GBP 0.80 | |
|
Client:
Car Wash
Category:
Motor
VAT %:
0.0%
Net Amount:
GBP 1.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-16 | 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 -15.22 | |
|
Client:
direct debit to barclays ref: 0620a6538264745
Category:
BBL
VAT %:
0.0%
Net Amount:
GBP 16.02
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-20 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 240.00 | GBP 0.00 | GBP 240.00 | GBP -255.22 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 240.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-20 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 280.00 | GBP 0.00 | GBP 280.00 | GBP 24.78 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 280.00
VAT Amount:
GBP 0.00
|
|||||||||