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-02 | EAST MIDS RAILWAY CD 1438 | east midland rail | Travel | 15.0% | GBP 860.87 | GBP 129.13 | GBP 990.00 | GBP 1757.49 | |
|
Client:
east midland rail
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 860.87
VAT Amount:
GBP 129.13
|
|||||||||
| 2025-09-03 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 5228.00 | GBP 0.00 | GBP 5228.00 | GBP 6985.49 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 5228.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-03 | HENDERSON CONNELLA 400000001628034597 11 THE | henderson connell | Rent | 5.0% | GBP 4979.05 | GBP 248.95 | GBP 5228.00 | GBP 1757.49 | |
|
Client:
henderson connell
Category:
Rent
VAT %:
5.0%
Net Amount:
GBP 4979.05
VAT Amount:
GBP 248.95
|
|||||||||
| 2025-09-03 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.17 | GBP 0.63 | GBP 4.80 | GBP 1752.69 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.17
VAT Amount:
GBP 0.63
|
|||||||||
| 2025-09-03 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.17 | GBP 0.63 | GBP 4.80 | GBP 1747.89 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.17
VAT Amount:
GBP 0.63
|
|||||||||
| 2025-09-03 | SQ *OIE TRULY THAI CD 1438 | no_match | Uncategorized | 0.0% | GBP 12.19 | GBP 0.00 | GBP 12.19 | GBP 1735.70 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 12.19
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-04 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.17 | GBP 0.63 | GBP 4.80 | GBP 1730.90 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.17
VAT Amount:
GBP 0.63
|
|||||||||
| 2025-09-04 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.52 | GBP 0.68 | GBP 5.20 | GBP 1725.70 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.52
VAT Amount:
GBP 0.68
|
|||||||||
| 2025-09-04 | PRET A MANGER CD 1438 | pret | Travel | 15.0% | GBP 5.35 | GBP 0.80 | GBP 6.15 | GBP 1719.55 | |
|
Client:
pret
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 5.35
VAT Amount:
GBP 0.80
|
|||||||||
| 2025-09-08 | Adobe CD 1438 07SEP25 | adobe | IT software | 0.0% | GBP 29.96 | GBP 0.00 | GBP 29.96 | GBP 1689.59 | |
|
Client:
adobe
Category:
IT software
VAT %:
0.0%
Net Amount:
GBP 29.96
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-08 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 300.00 | GBP 0.00 | GBP 300.00 | GBP 1989.59 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 300.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-08 | KCC 400000001631005020 ML/ CHARITY 204577 10 08SEP25 | no_match | Uncategorized | 0.0% | GBP 1890.00 | GBP 0.00 | GBP 1890.00 | GBP 99.59 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 1890.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-10 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 5397.00 | GBP 0.00 | GBP 5397.00 | GBP 5496.59 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 5397.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-10 | 10 CANN LIMITED 400000001631807044 | ee limited | Phone | 0.0% | GBP 1341.60 | GBP 0.00 | GBP 1341.60 | GBP 4154.99 | |
|
Client:
ee limited
Category:
Phone
VAT %:
0.0%
Net Amount:
GBP 1341.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-10 | MISTIE LOOBY 600000001626933170 DIVIDEND | mistie looby | DLA | 20.0% | GBP 1125.00 | GBP 225.00 | GBP 1350.00 | GBP 2804.99 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 1125.00
VAT Amount:
GBP 225.00
|
|||||||||
| 2025-09-11 | HMRC ETMP CD 1438 | hmrc | CT | 20.0% | GBP 1741.12 | GBP 348.22 | GBP 2089.34 | GBP 715.65 | |
|
Client:
hmrc
Category:
CT
VAT %:
20.0%
Net Amount:
GBP 1741.12
VAT Amount:
GBP 348.22
|
|||||||||
| 2025-09-15 | CLIFFORD HAMILTON 309781 60565968 14SEP25 | fabrics for product | Direct Exp | 0.0% | GBP 615.00 | GBP 0.00 | GBP 615.00 | GBP 100.65 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 615.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-15 | HMRC NDDS 108950977756602428 | hmrc | CT | 20.0% | GBP 6554.27 | GBP 1310.86 | GBP 7865.13 | GBP -7764.48 | |
|
Client:
hmrc
Category:
CT
VAT %:
20.0%
Net Amount:
GBP 6554.27
VAT Amount:
GBP 1310.86
|
|||||||||
| 2025-09-15 | RETURNED DD | returned hmrc | CT | 0.0% | GBP 7865.13 | GBP 0.00 | GBP 7865.13 | GBP 100.65 | |
|
Client:
returned hmrc
Category:
CT
VAT %:
0.0%
Net Amount:
GBP 7865.13
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-16 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.00 | GBP 0.60 | GBP 4.60 | GBP 96.05 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.60
|
|||||||||