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-09-17 | CCS*Raju Joseph CD 1438 | no_match | Uncategorized | 0.0% | GBP 4.80 | GBP 0.00 | GBP 4.80 | GBP 91.25 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 4.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-17 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.52 | GBP 0.68 | GBP 5.20 | GBP 86.05 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.52
VAT Amount:
GBP 0.68
|
|||||||||
| 2025-09-17 | SQ *OIE TRULY THAI CD 1438 | no_match | Uncategorized | 0.0% | GBP 10.20 | GBP 0.00 | GBP 10.20 | GBP 75.85 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 10.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-18 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.17 | GBP 0.63 | GBP 4.80 | GBP 71.05 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.17
VAT Amount:
GBP 0.63
|
|||||||||
| 2025-09-18 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.35 | GBP 0.65 | GBP 5.00 | GBP 66.05 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.35
VAT Amount:
GBP 0.65
|
|||||||||
| 2025-09-19 | EMR ONBOARD CD 1438 | no_match | Uncategorized | 0.0% | GBP 22.70 | GBP 0.00 | GBP 22.70 | GBP 43.35 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 22.70
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-19 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 143.35 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-19 | SERVICE CHARGES REF : 465287003 | bank charge | Bank fees | 10.0% | GBP 7.73 | GBP 0.77 | GBP 8.50 | GBP 134.85 | |
|
Client:
bank charge
Category:
Bank fees
VAT %:
10.0%
Net Amount:
GBP 7.73
VAT Amount:
GBP 0.77
|
|||||||||
| 2025-09-22 | TXW*LONDON TAXI 70 CD 1438 20SEP25 | london taxi | Travel | 15.0% | GBP 40.17 | GBP 6.03 | GBP 46.20 | GBP 88.65 | |
|
Client:
london taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 40.17
VAT Amount:
GBP 6.03
|
|||||||||
| 2025-09-22 | QDOS CONTRACTOR 127994 | qdos | Insurance | 20.0% | GBP 23.96 | GBP 4.79 | GBP 28.75 | GBP 59.90 | |
|
Client:
qdos
Category:
Insurance
VAT %:
20.0%
Net Amount:
GBP 23.96
VAT Amount:
GBP 4.79
|
|||||||||
| 2025-09-22 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 2940.00 | GBP 0.00 | GBP 2940.00 | GBP 2999.90 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 2940.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-22 | HENDERSON CONNELLA 200000001629747594 | henderson connell | Rent | 5.0% | GBP 2800.00 | GBP 140.00 | GBP 2940.00 | GBP 59.90 | |
|
Client:
henderson connell
Category:
Rent
VAT %:
5.0%
Net Amount:
GBP 2800.00
VAT Amount:
GBP 140.00
|
|||||||||
| 2025-09-23 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.17 | GBP 0.63 | GBP 4.80 | GBP 55.10 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.17
VAT Amount:
GBP 0.63
|
|||||||||
| 2025-09-23 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.35 | GBP 0.65 | GBP 5.00 | GBP 50.10 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.35
VAT Amount:
GBP 0.65
|
|||||||||
| 2025-09-23 | SQ *OIE TRULY THAI CD 1438 | no_match | Uncategorized | 0.0% | GBP 10.66 | GBP 0.00 | GBP 10.66 | GBP 39.44 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 10.66
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-24 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 25.00 | GBP 0.00 | GBP 25.00 | GBP 64.44 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 25.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-24 | CCS*Premier Tax 8y CD 1438 | pret | Travel | 15.0% | GBP 4.00 | GBP 0.60 | GBP 4.60 | GBP 59.84 | |
|
Client:
pret
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.60
|
|||||||||
| 2025-09-24 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.17 | GBP 0.63 | GBP 4.80 | GBP 55.04 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.17
VAT Amount:
GBP 0.63
|
|||||||||
| 2025-09-24 | JAPANESE PLACE CD 1438 | no_match | Uncategorized | 0.0% | GBP 14.40 | GBP 0.00 | GBP 14.40 | GBP 40.64 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 14.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-25 | PRET A MANGER CD 1438 | pret | Travel | 15.0% | GBP 3.87 | GBP 0.58 | GBP 4.45 | GBP 36.19 | |
|
Client:
pret
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 3.87
VAT Amount:
GBP 0.58
|
|||||||||