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-06 | PRET A MANGER CD 1438 | pret | Travel | 0.0% | GBP 7.40 | GBP 0.00 | GBP 7.40 | GBP 2896.01 | |
|
Client:
pret
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 7.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-06 | CMT UK LTD TAXI FA CD 1438 | taxi | Travel | 0.0% | GBP 12.40 | GBP 0.00 | GBP 12.40 | GBP 2883.61 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 12.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-06 | CMT UK LTD TAXI FA CD 1438 | taxi | Travel | 0.0% | GBP 15.60 | GBP 0.00 | GBP 15.60 | GBP 2868.01 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 15.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-06 | TXW*LONDON TAXI 79 CD 1438 | london taxi | Travel | 0.0% | GBP 18.60 | GBP 0.00 | GBP 18.60 | GBP 2849.41 | |
|
Client:
london taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 18.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-06 | EAST MIDS RAILWAY CD 1438 | east midland rail | Travel | 0.0% | GBP 990.00 | GBP 0.00 | GBP 990.00 | GBP 1859.41 | |
|
Client:
east midland rail
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 990.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-06 | LONDON BRIDGE HOSP CD 1438 | no_match | Uncategorized | 0.0% | GBP 1730.50 | GBP 0.00 | GBP 1730.50 | GBP 128.91 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 1730.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-07 | Adobe CD 1438 | adobe | IT software | 0.0% | GBP 29.96 | GBP 0.00 | GBP 29.96 | GBP 98.95 | |
|
Client:
adobe
Category:
IT software
VAT %:
0.0%
Net Amount:
GBP 29.96
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-08 | BRIGHTER CONSULTAN HEX BACS | no_match | Uncategorized | 0.0% | GBP 1800.00 | GBP 0.00 | GBP 1800.00 | GBP 1898.95 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 1800.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-08 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 900.00 | GBP 0.00 | GBP 900.00 | GBP 998.95 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 900.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | CCS*Premier Taxis CD 1438 09AUG25 | taxi | Travel | 0.0% | GBP 5.40 | GBP 0.00 | GBP 5.40 | GBP 993.55 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 5.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | SPECSAVERS 0003700 CD 1438 09AUG25 | no_match | Uncategorized | 0.0% | GBP 41.99 | GBP 0.00 | GBP 41.99 | GBP 951.56 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 41.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 950.00 | GBP 0.00 | GBP 950.00 | GBP 1901.56 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 950.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | KCC 500000001609977355 ML/ CHARITY 204577 10 | no_match | Uncategorized | 0.0% | GBP 1890.00 | GBP 0.00 | GBP 1890.00 | GBP 11.56 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 1890.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 60.00 | GBP 0.00 | GBP 60.00 | GBP 71.56 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 60.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-12 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 7865.00 | GBP 0.00 | GBP 7865.00 | GBP 7936.56 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 7865.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-12 | CCS*Premier Taxis CD 1438 | taxi | Travel | 0.0% | GBP 4.60 | GBP 0.00 | GBP 4.60 | GBP 7931.96 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-12 | CCS*Premier Taxis CD 1438 | taxi | Travel | 0.0% | GBP 4.80 | GBP 0.00 | GBP 4.80 | GBP 7927.16 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-12 | PRET A MANGER CD 1438 | pret | Travel | 0.0% | GBP 8.10 | GBP 0.00 | GBP 8.10 | GBP 7919.06 | |
|
Client:
pret
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 8.10
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-13 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 7939.06 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-13 | CCS*Premier Taxis CD 1438 | taxi | Travel | 0.0% | GBP 5.20 | GBP 0.00 | GBP 5.20 | GBP 7933.86 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 5.20
VAT Amount:
GBP 0.00
|
|||||||||