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-24 | CCS*Raju Joseph CD 1438 | no_match | Uncategorized | 0.0% | GBP 4.80 | GBP 0.00 | GBP 4.80 | GBP 102.05 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 4.80
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
|
|||||||||
| 2025-07-01 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 50.00 | GBP 0.00 | GBP 50.00 | GBP 146.85 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 50.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-02 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.17 | GBP 0.63 | GBP 4.80 | GBP 142.05 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.17
VAT Amount:
GBP 0.63
|
|||||||||
| 2025-07-02 | M&S SIMPLY FOOD - CD 1438 | no_match | Uncategorized | 0.0% | GBP 4.80 | GBP 0.00 | GBP 4.80 | GBP 137.25 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 4.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-02 | EAST MIDLANDS RAIL CD 1438 | east midland rail | Travel | 15.0% | GBP 17.57 | GBP 2.63 | GBP 20.20 | GBP 117.05 | |
|
Client:
east midland rail
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 17.57
VAT Amount:
GBP 2.63
|
|||||||||
| 2025-07-02 | TXW*LONDON TAXI 76 CD 1438 | london taxi | Travel | 15.0% | GBP 35.30 | GBP 5.30 | GBP 40.60 | GBP 76.45 | |
|
Client:
london taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 35.30
VAT Amount:
GBP 5.30
|
|||||||||
| 2025-07-02 | TXW*LONDON TAXI 76 CD 1438 | london taxi | Travel | 15.0% | GBP 49.04 | GBP 7.36 | GBP 56.40 | GBP 20.05 | |
|
Client:
london taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 49.04
VAT Amount:
GBP 7.36
|
|||||||||
| 2025-07-03 | BRIGHTER CONSULTAN HEX BACS | no_match | Uncategorized | 0.0% | GBP 18000.00 | GBP 0.00 | GBP 18000.00 | GBP 18020.05 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 18000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-03 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 15600.00 | GBP 0.00 | GBP 15600.00 | GBP 2420.05 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 15600.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-03 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 300.00 | GBP 0.00 | GBP 300.00 | GBP 2720.05 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 300.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-03 | MISTIE LOOBY 300000001591600779 309871 | mistie looby | DLA | 20.0% | GBP 872.92 | GBP 174.58 | GBP 1047.50 | GBP 1672.55 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 872.92
VAT Amount:
GBP 174.58
|
|||||||||
| 2025-07-03 | 10 CANN LIMITED 100000001579056111 MISTY | ee limited | Phone | 0.0% | GBP 1178.00 | GBP 0.00 | GBP 1178.00 | GBP 494.55 | |
|
Client:
ee limited
Category:
Phone
VAT %:
0.0%
Net Amount:
GBP 1178.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-03 | MISTIE LOOBY 200000001584229660 | mistie looby | DLA | 20.0% | GBP 408.33 | GBP 81.67 | GBP 490.00 | GBP 4.55 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 408.33
VAT Amount:
GBP 81.67
|
|||||||||
| 2025-07-03 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 45.00 | GBP 0.00 | GBP 45.00 | GBP 49.55 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 45.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-03 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 45.00 | GBP 0.00 | GBP 45.00 | GBP 94.55 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 45.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-03 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 4.00 | GBP 0.00 | GBP 4.00 | GBP 98.55 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-04 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 1980.00 | GBP 0.00 | GBP 1980.00 | GBP 2078.55 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 1980.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-04 | KCC 400000001594038225 ML/ CHARITY 204577 10 04JUL25 | no_match | Uncategorized | 0.0% | GBP 1980.00 | GBP 0.00 | GBP 1980.00 | GBP 98.55 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 1980.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-04 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 1470.00 | GBP 0.00 | GBP 1470.00 | GBP 1568.55 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 1470.00
VAT Amount:
GBP 0.00
|
|||||||||