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-06 | BRIGHTER CONSULTAN HEX BACS | no_match | Uncategorized | 0.0% | GBP 2700.00 | GBP 0.00 | GBP 2700.00 | GBP 2642.50 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 2700.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-09 | CLIFFORD HAMILTON 309781 60565968 08JUN25 | fabrics for product | Direct Exp | 0.0% | GBP 1185.00 | GBP 0.00 | GBP 1185.00 | GBP 110.04 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 1185.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-09 | O/DRAFT INTEREST | rent | Rent | 5.0% | GBP 0.49 | GBP 0.02 | GBP 0.51 | GBP 19.54 | |
|
Client:
rent
Category:
Rent
VAT %:
5.0%
Net Amount:
GBP 0.49
VAT Amount:
GBP 0.02
|
|||||||||
| 2025-06-09 | NORTON *AP16132661 CD 1438 | norton | IT software | 0.0% | GBP 89.99 | GBP 0.00 | GBP 89.99 | GBP 20.05 | |
|
Client:
norton
Category:
IT software
VAT %:
0.0%
Net Amount:
GBP 89.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-09 | MISTIE LOOBY 200000001570025349 309871 | mistie looby | DLA | 20.0% | GBP 872.92 | GBP 174.58 | GBP 1047.50 | GBP 1565.04 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 872.92
VAT Amount:
GBP 174.58
|
|||||||||
| 2025-06-09 | Adobe CD 1438 07JUN25 | adobe | IT software | 0.0% | GBP 29.96 | GBP 0.00 | GBP 29.96 | GBP 2612.54 | |
|
Client:
adobe
Category:
IT software
VAT %:
0.0%
Net Amount:
GBP 29.96
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-09 | KCC 100000001564890288 MISTY LOOBY 204577 10 | mistie looby | DLA | 20.0% | GBP 225.00 | GBP 45.00 | GBP 270.00 | GBP 1295.04 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 225.00
VAT Amount:
GBP 45.00
|
|||||||||
| 2025-06-10 | CONVEX GROUP CD 1438 | no_match | Uncategorized | 0.0% | GBP 4.50 | GBP 0.00 | GBP 4.50 | GBP 15.04 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 4.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-10 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.00 | GBP 0.60 | GBP 4.60 | GBP 10.44 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.60
|
|||||||||
| 2025-06-10 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.17 | GBP 0.63 | GBP 4.80 | GBP 5.64 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.17
VAT Amount:
GBP 0.63
|
|||||||||
| 2025-06-11 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 303.00 | GBP 0.00 | GBP 303.00 | GBP 308.64 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 303.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-12 | EE LIMITED CD 1438 | ee limited | Phone | 0.0% | GBP 28.09 | GBP 0.00 | GBP 28.09 | GBP 287.45 | |
|
Client:
ee limited
Category:
Phone
VAT %:
0.0%
Net Amount:
GBP 28.09
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-12 | EAST MIDS RAILWAY CD 1438 | east midland rail | Travel | 15.0% | GBP 224.17 | GBP 33.63 | GBP 257.80 | GBP 29.65 | |
|
Client:
east midland rail
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 224.17
VAT Amount:
GBP 33.63
|
|||||||||
| 2025-06-12 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.35 | GBP 0.65 | GBP 5.00 | GBP 315.54 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.35
VAT Amount:
GBP 0.65
|
|||||||||
| 2025-06-12 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.00 | GBP 0.60 | GBP 4.60 | GBP 320.54 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.60
|
|||||||||
| 2025-06-12 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 328.64 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-12 | PRET A MANGER CD 1438 | pret | Travel | 15.0% | GBP 3.04 | GBP 0.46 | GBP 3.50 | GBP 325.14 | |
|
Client:
pret
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 3.04
VAT Amount:
GBP 0.46
|
|||||||||
| 2025-06-13 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.52 | GBP 0.68 | GBP 5.20 | GBP 19.95 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.52
VAT Amount:
GBP 0.68
|
|||||||||
| 2025-06-13 | SQ *LA TAXIS CD 1438 | taxi | Travel | 15.0% | GBP 4.70 | GBP 0.70 | GBP 5.40 | GBP 14.55 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.70
VAT Amount:
GBP 0.70
|
|||||||||
| 2025-06-13 | CONVEX GROUP CD 1438 | no_match | Uncategorized | 0.0% | GBP 4.50 | GBP 0.00 | GBP 4.50 | GBP 25.15 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 4.50
VAT Amount:
GBP 0.00
|
|||||||||