GPT Analysis: Excel data processed directly from structured columns; Date Gap Analysis: Found 10 gaps > 7 days: 12/09/2024 to 12/17/2024 (8 days), 12/18/2024 to 01/02/2025 (15 days), 01/09/2025 to 01/20/2025 (11 days), 01/20/2025 to 01/28/2025 (8 days), 02/10/2025 to 02/18/2025 (8 days), 02/18/2025 to 02/28/2025 (10 days), 04/09/2025 to 04/17/2025 (8 days), 04/22/2025 to 05/06/2025 (14 days), 05/09/2025 to 05/19/2025 (10 days), 05/19/2025 to 06/06/2025 (18 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2025-06-17 | SERVICE CHARGES REF : 457850264 | bank charge | Bank fees | 10.0% | GBP 7.73 | GBP 0.77 | GBP 8.50 | GBP 6.05 | |
|
Client:
bank charge
Category:
Bank fees
VAT %:
10.0%
Net Amount:
GBP 7.73
VAT Amount:
GBP 0.77
|
|||||||||
| 2025-06-18 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 26.05 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-18 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 257.00 | GBP 0.00 | GBP 257.00 | GBP 283.05 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 257.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-18 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 50.00 | GBP 0.00 | GBP 50.00 | GBP 333.05 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 50.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-19 | PRET A MANGER CD 1438 | pret | Travel | 15.0% | GBP 4.78 | GBP 0.72 | GBP 5.50 | GBP 310.45 | |
|
Client:
pret
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.78
VAT Amount:
GBP 0.72
|
|||||||||
| 2025-06-19 | EAST MIDS RAILWAY CD 1438 | east midland rail | Travel | 15.0% | GBP 224.17 | GBP 33.63 | GBP 257.80 | GBP 52.65 | |
|
Client:
east midland rail
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 224.17
VAT Amount:
GBP 33.63
|
|||||||||
| 2025-06-19 | SumUp *Silver sta CD 1438 | no_match | Uncategorized | 0.0% | GBP 5.40 | GBP 0.00 | GBP 5.40 | GBP 315.95 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 5.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-19 | CONVEX GROUP CD 1438 | no_match | Uncategorized | 0.0% | GBP 4.00 | GBP 0.00 | GBP 4.00 | GBP 326.55 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-19 | SAINSBURYS S/MKTS CD 1438 | no_match | Uncategorized | 20.0% | GBP 2.08 | GBP 0.42 | GBP 2.50 | GBP 330.55 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
20.0%
Net Amount:
GBP 2.08
VAT Amount:
GBP 0.42
|
|||||||||
| 2025-06-19 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.52 | GBP 0.68 | GBP 5.20 | GBP 321.35 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.52
VAT Amount:
GBP 0.68
|
|||||||||
| 2025-06-20 | CMT UK LTD TAXI FA CD 1438 | taxi | Travel | 15.0% | GBP 23.30 | GBP 3.50 | GBP 26.80 | GBP 59.35 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 23.30
VAT Amount:
GBP 3.50
|
|||||||||
| 2025-06-20 | TAXIS* TAXIS CD 1438 | taxi | Travel | 15.0% | GBP 4.70 | GBP 0.70 | GBP 5.40 | GBP 86.15 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.70
VAT Amount:
GBP 0.70
|
|||||||||
| 2025-06-20 | CONVEX GROUP CD 1438 | no_match | Uncategorized | 0.0% | GBP 4.50 | GBP 0.00 | GBP 4.50 | GBP 96.15 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 4.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-20 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 48.00 | GBP 0.00 | GBP 48.00 | GBP 100.65 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 48.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-20 | SUMUP *A2B PRIVAT CD 1438 | no_match | Uncategorized | 0.0% | GBP 4.60 | GBP 0.00 | GBP 4.60 | GBP 91.55 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 4.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-23 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 50.00 | GBP 0.00 | GBP 50.00 | GBP 61.35 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 50.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-23 | 500000001582168124 MISTY 10 CANN LIMITED | ee limited | Phone | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 111.35 | |
|
Client:
ee limited
Category:
Phone
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-23 | SMALLFIRMSSERVICES CD 1438 21JUN25 | 1 red door lane | IRD | 0.0% | GBP 48.00 | GBP 0.00 | GBP 48.00 | GBP 11.35 | |
|
Client:
1 red door lane
Category:
IRD
VAT %:
0.0%
Net Amount:
GBP 48.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-23 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 150.00 | GBP 0.00 | GBP 150.00 | GBP 211.35 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 150.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-24 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.52 | GBP 0.68 | GBP 5.20 | GBP 96.85 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.52
VAT Amount:
GBP 0.68
|
|||||||||