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-08-27 | PRET A MANGER CD 1438 | pret | Travel | 15.0% | GBP 2.35 | GBP 0.35 | GBP 2.70 | GBP 342.03 | |
|
Client:
pret
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 2.35
VAT Amount:
GBP 0.35
|
|||||||||
| 2025-08-27 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.00 | GBP 0.60 | GBP 4.60 | GBP 337.43 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.60
|
|||||||||
| 2025-08-27 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.17 | GBP 0.63 | GBP 4.80 | GBP 332.63 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.17
VAT Amount:
GBP 0.63
|
|||||||||
| 2025-08-27 | Wasabi_LimeStreet CD 1438 | ee limited | Phone | 0.0% | GBP 23.60 | GBP 0.00 | GBP 23.60 | GBP 309.03 | |
|
Client:
ee limited
Category:
Phone
VAT %:
0.0%
Net Amount:
GBP 23.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-27 | EAST MIDS RAILWAY CD 1438 | east midland rail | Travel | 15.0% | GBP 224.17 | GBP 33.63 | GBP 257.80 | GBP 51.23 | |
|
Client:
east midland rail
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 224.17
VAT Amount:
GBP 33.63
|
|||||||||
| 2025-08-28 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.17 | GBP 0.63 | GBP 4.80 | GBP 46.43 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.17
VAT Amount:
GBP 0.63
|
|||||||||
| 2025-08-29 | HIGH FINANCE UK LI 71010 TRN143130219413244 042928 | 1 red door lane | IRD | 0.0% | GBP 23496.00 | GBP 0.00 | GBP 23496.00 | GBP 23542.43 | |
|
Client:
1 red door lane
Category:
IRD
VAT %:
0.0%
Net Amount:
GBP 23496.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.52 | GBP 0.68 | GBP 5.20 | GBP 23537.23 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.52
VAT Amount:
GBP 0.68
|
|||||||||
| 2025-08-29 | 5 TORTILLA LEADENH CD 1438 | no_match | Uncategorized | 0.0% | GBP 2.20 | GBP 0.00 | GBP 2.20 | GBP 23535.03 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 2.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.00 | GBP 0.60 | GBP 4.60 | GBP 23530.43 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.60
|
|||||||||
| 2025-08-29 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.17 | GBP 0.63 | GBP 4.80 | GBP 23525.63 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.17
VAT Amount:
GBP 0.63
|
|||||||||
| 2025-08-29 | PRET A MANGER CD 1438 | pret | Travel | 15.0% | GBP 6.26 | GBP 0.94 | GBP 7.20 | GBP 23518.43 | |
|
Client:
pret
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 6.26
VAT Amount:
GBP 0.94
|
|||||||||
| 2025-08-29 | 5 TORTILLA LEADENH CD 1438 | no_match | Uncategorized | 0.0% | GBP 18.90 | GBP 0.00 | GBP 18.90 | GBP 23499.53 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 18.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | CLIFFORD HAMILTON 309781 60565968 30AUG25 | fabrics for product | Direct Exp | 0.0% | GBP 13254.62 | GBP 0.00 | GBP 13254.62 | GBP 36754.15 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 13254.62
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | MISTIE LOOBY 200000001616855170 SALARY | mistie looby | DLA | 20.0% | GBP 2000.00 | GBP 400.00 | GBP 2400.00 | GBP 34354.15 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 2000.00
VAT Amount:
GBP 400.00
|
|||||||||
| 2025-09-01 | EE LIMITED CD 1438 31AUG25 | ee limited | Phone | 0.0% | GBP 28.27 | GBP 0.00 | GBP 28.27 | GBP 34325.88 | |
|
Client:
ee limited
Category:
Phone
VAT %:
0.0%
Net Amount:
GBP 28.27
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | CLIFFORD HAMILTON 309781 60565968 31AUG25 | fabrics for product | Direct Exp | 0.0% | GBP 10000.00 | GBP 0.00 | GBP 10000.00 | GBP 24325.88 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 10000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | CLIFFORD HAMILTON 309781 60565968 31AUG25 | fabrics for product | Direct Exp | 0.0% | GBP 6000.00 | GBP 0.00 | GBP 6000.00 | GBP 18325.88 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 6000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | HMRC GOV.UK COTAX CD 1438 | hmrc | CT | 20.0% | GBP 12978.16 | GBP 2595.63 | GBP 15573.79 | GBP 2752.09 | |
|
Client:
hmrc
Category:
CT
VAT %:
20.0%
Net Amount:
GBP 12978.16
VAT Amount:
GBP 2595.63
|
|||||||||
| 2025-09-02 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.00 | GBP 0.60 | GBP 4.60 | GBP 2747.49 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.60
|
|||||||||