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-21 | QDOS CONTRACTOR 127994 | qdos | Insurance | 20.0% | GBP 23.96 | GBP 4.79 | GBP 28.75 | GBP 1.71 | |
|
Client:
qdos
Category:
Insurance
VAT %:
20.0%
Net Amount:
GBP 23.96
VAT Amount:
GBP 4.79
|
|||||||||
| 2025-07-21 | SERVICE CHARGES REF : 460318935 | bank charge | Bank fees | 10.0% | GBP 7.73 | GBP 0.77 | GBP 8.50 | GBP -6.79 | |
|
Client:
bank charge
Category:
Bank fees
VAT %:
10.0%
Net Amount:
GBP 7.73
VAT Amount:
GBP 0.77
|
|||||||||
| 2025-07-22 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 40.00 | GBP 0.00 | GBP 40.00 | GBP 33.21 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 40.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-22 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.35 | GBP 0.65 | GBP 5.00 | GBP 28.21 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.35
VAT Amount:
GBP 0.65
|
|||||||||
| 2025-07-22 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.52 | GBP 0.68 | GBP 5.20 | GBP 23.01 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.52
VAT Amount:
GBP 0.68
|
|||||||||
| 2025-07-23 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 1000.00 | GBP 0.00 | GBP 1000.00 | GBP 1023.01 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 1000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-23 | HENDERSON CONNELLA 300000001602550881 11 THE | henderson connell | Rent | 5.0% | GBP 952.38 | GBP 47.62 | GBP 1000.00 | GBP 23.01 | |
|
Client:
henderson connell
Category:
Rent
VAT %:
5.0%
Net Amount:
GBP 952.38
VAT Amount:
GBP 47.62
|
|||||||||
| 2025-07-23 | EMR MOBILE EPOS 80 CD 1438 | no_match | Uncategorized | 0.0% | GBP 1.60 | GBP 0.00 | GBP 1.60 | GBP 21.41 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 1.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-23 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.17 | GBP 0.63 | GBP 4.80 | GBP 16.61 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.17
VAT Amount:
GBP 0.63
|
|||||||||
| 2025-07-23 | SumUp *Central Ta CD 1438 | rent | Rent | 5.0% | GBP 4.95 | GBP 0.25 | GBP 5.20 | GBP 11.41 | |
|
Client:
rent
Category:
Rent
VAT %:
5.0%
Net Amount:
GBP 4.95
VAT Amount:
GBP 0.25
|
|||||||||
| 2025-07-25 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 297.00 | GBP 0.00 | GBP 297.00 | GBP 308.41 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 297.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-28 | EMR MOBILE EPOS 80 CD 1438 26JUL25 | no_match | Uncategorized | 0.0% | GBP 4.20 | GBP 0.00 | GBP 4.20 | GBP 304.21 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 4.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-28 | CCS*Premier Taxis CD 1438 26JUL25 | taxi | Travel | 15.0% | GBP 4.00 | GBP 0.60 | GBP 4.60 | GBP 299.61 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.60
|
|||||||||
| 2025-07-28 | TAXIS* TAXIS CD 1438 26JUL25 | taxi | Travel | 15.0% | GBP 4.87 | GBP 0.73 | GBP 5.60 | GBP 294.01 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.87
VAT Amount:
GBP 0.73
|
|||||||||
| 2025-07-28 | EAST MIDS RAILWAY CD 1438 26JUL25 | east midland rail | Travel | 15.0% | GBP 224.17 | GBP 33.63 | GBP 257.80 | GBP 36.21 | |
|
Client:
east midland rail
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 224.17
VAT Amount:
GBP 33.63
|
|||||||||
| 2025-07-28 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 2.93 | GBP 0.00 | GBP 2.93 | GBP 39.14 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 2.93
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-29 | CLIFFORD HAMILTON 309781 60565968 | fabrics for product | Direct Exp | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 59.14 | |
|
Client:
fabrics for product
Category:
Direct Exp
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-29 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.00 | GBP 0.60 | GBP 4.60 | GBP 54.54 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.60
|
|||||||||
| 2025-07-29 | CCS*Premier Taxis CD 1438 | taxi | Travel | 15.0% | GBP 4.00 | GBP 0.60 | GBP 4.60 | GBP 49.94 | |
|
Client:
taxi
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.60
|
|||||||||
| 2025-07-29 | PRET A MANGER CD 1438 | pret | Travel | 15.0% | GBP 6.08 | GBP 0.91 | GBP 6.99 | GBP 42.95 | |
|
Client:
pret
Category:
Travel
VAT %:
15.0%
Net Amount:
GBP 6.08
VAT Amount:
GBP 0.91
|
|||||||||