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-07-11 | JAPANESE PLACE CD 1438 | no_match | Uncategorized | 0.0% | GBP 8.95 | GBP 0.00 | GBP 8.95 | GBP 7918.29 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 8.95
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-14 | TFL TRAVEL CH CD 1438 12JUL25 | 1 red door lane | IRD | 0.0% | GBP 5.80 | GBP 0.00 | GBP 5.80 | GBP 7912.49 | |
|
Client:
1 red door lane
Category:
IRD
VAT %:
0.0%
Net Amount:
GBP 5.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-14 | TFL TRAVEL CH CD 1438 13JUL25 | 1 red door lane | IRD | 0.0% | GBP 5.80 | GBP 0.00 | GBP 5.80 | GBP 7906.69 | |
|
Client:
1 red door lane
Category:
IRD
VAT %:
0.0%
Net Amount:
GBP 5.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-14 | CLIFFORD HAMILTON 309781 60565968 13JUL25 | fabrics for product | Direct Exp | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 7926.69 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-14 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 800.00 | GBP 0.00 | GBP 800.00 | GBP 8726.69 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 800.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-14 | MISTIE LOOBY 500000001594129421 SALARY- | mistie looby | DLA | 0.0% | GBP 800.00 | GBP 0.00 | GBP 800.00 | GBP 7926.69 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 800.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-14 | CCS*Premier Tax x7 CD 1438 | pret | Travel | 0.0% | GBP 4.60 | GBP 0.00 | GBP 4.60 | GBP 7922.09 | |
|
Client:
pret
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-15 | HMRC NDDS 108950977852330783 | hmrc | CT | 0.0% | GBP 7865.13 | GBP 0.00 | GBP 7865.13 | GBP 56.96 | |
|
Client:
hmrc
Category:
CT
VAT %:
0.0%
Net Amount:
GBP 7865.13
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-15 | CCS*Premier Taxis CD 1438 | taxi | Travel | 0.0% | GBP 4.60 | GBP 0.00 | GBP 4.60 | GBP 52.36 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-15 | CCS*Premier Taxis CD 1438 | taxi | Travel | 0.0% | GBP 5.20 | GBP 0.00 | GBP 5.20 | GBP 47.16 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 5.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-16 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 280.00 | GBP 0.00 | GBP 280.00 | GBP 327.16 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 280.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-16 | TFL TRAVEL CH CD 1438 | business travel | Travel | 0.0% | GBP 5.80 | GBP 0.00 | GBP 5.80 | GBP 321.36 | |
|
Client:
business travel
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 5.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-16 | CCS*Premier Taxis CD 1438 | taxi | Travel | 0.0% | GBP 4.60 | GBP 0.00 | GBP 4.60 | GBP 316.76 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-16 | SQ *LA TAXIS CD 1438 | taxi | Travel | 0.0% | GBP 5.40 | GBP 0.00 | GBP 5.40 | GBP 311.36 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 5.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-17 | CCS*Premier Taxis CD 1438 | taxi | Travel | 0.0% | GBP 4.60 | GBP 0.00 | GBP 4.60 | GBP 306.76 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-17 | CCS*Premier Taxis CD 1438 | taxi | Travel | 0.0% | GBP 5.00 | GBP 0.00 | GBP 5.00 | GBP 301.76 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 5.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-17 | 5 TORTILLA LEADENH CD 1438 | no_match | Uncategorized | 0.0% | GBP 15.20 | GBP 0.00 | GBP 15.20 | GBP 286.56 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 15.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-17 | EAST MIDS RAILWAY CD 1438 | east midland rail | Travel | 0.0% | GBP 257.80 | GBP 0.00 | GBP 257.80 | GBP 28.76 | |
|
Client:
east midland rail
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 257.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-21 | TFL TRAVEL CH CD 1438 19JUL25 | 1 red door lane | IRD | 0.0% | GBP 13.30 | GBP 0.00 | GBP 13.30 | GBP 15.46 | |
|
Client:
1 red door lane
Category:
IRD
VAT %:
0.0%
Net Amount:
GBP 13.30
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-21 | CLIFFORD HAMILTON 309781 60565968 20JUL25 | fabrics for product | Direct Exp | 0.0% | GBP 15.00 | GBP 0.00 | GBP 15.00 | GBP 30.46 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 15.00
VAT Amount:
GBP 0.00
|
|||||||||