GPT Analysis: Excel data processed directly from structured columns; Date Gap Analysis: Found 8 gaps > 7 days: 12/19/2024 to 12/30/2024 (11 days), 01/09/2025 to 01/20/2025 (11 days), 02/03/2025 to 02/11/2025 (8 days), 03/03/2025 to 03/12/2025 (9 days), 03/17/2025 to 03/31/2025 (14 days), 04/09/2025 to 04/22/2025 (13 days), 05/21/2025 to 05/30/2025 (9 days), 06/03/2025 to 06/11/2025 (8 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2025-04-01 | THAMES WATER , 900061584594 | THAMES WATER | Rent and rates | 0.0% | GBP 588.52 | GBP 0.00 | GBP 588.52 | GBP 39.73 | |
|
Client:
THAMES WATER
Category:
Rent and rates
VAT %:
0.0%
Net Amount:
GBP 588.52
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-01 | JACOB REES-EVANS , RENT - JACOB , FP 01/04/25 0406 , P2JQY14OXXYICP5RPJ | jacob rees-evans rent | Rental Income | 0.0% | GBP 900.00 | GBP 0.00 | GBP 900.00 | GBP 939.73 | |
|
Client:
jacob rees-evans rent
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 900.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-03 | CLOSE - UINSURE , 78110937 | close - uinsure | Insurance | 0.0% | GBP 24.45 | GBP 0.00 | GBP 24.45 | GBP 915.28 | |
|
Client:
close - uinsure
Category:
Insurance
VAT %:
0.0%
Net Amount:
GBP 24.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-03 | BUPA CENTRAL A/C , 0796331949 | BUPA CENTRAL | DLA | 0.0% | GBP 368.30 | GBP 0.00 | GBP 368.30 | GBP 546.98 | |
|
Client:
BUPA CENTRAL
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 368.30
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-09 | VODAFONE LTD , 7088926977-1001 | VODAFONE LTD | Telephone | 0.0% | GBP 43.12 | GBP 0.00 | GBP 43.12 | GBP 503.86 | |
|
Client:
VODAFONE LTD
Category:
Telephone
VAT %:
0.0%
Net Amount:
GBP 43.12
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-22 | BUPA CENTRAL A/C , 0796331949 | BUPA CENTRAL | DLA | 0.0% | GBP 368.30 | GBP 0.00 | GBP 368.30 | GBP 135.56 | |
|
Client:
BUPA CENTRAL
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 368.30
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-23 | TMW DDR , 17571666/1651767 | tmw ddr | Rent and rates | 0.0% | GBP 347.78 | GBP 0.00 | GBP 347.78 | GBP -212.22 | |
|
Client:
tmw ddr
Category:
Rent and rates
VAT %:
0.0%
Net Amount:
GBP 347.78
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-23 | From A/C 53128737 , HURST CB , Via Mobile Xfer | hurst | DLA | 0.0% | GBP 2000.00 | GBP 0.00 | GBP 2000.00 | GBP 1787.78 | |
|
Client:
hurst
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 2000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-28 | HMRC SHIPLEY , XS006947905883 , VIA MOBILE - PYMT , FP 27/04/25 10 , 43035908723089000N | HMRC SHIPLEY | HMRC | 0.0% | GBP 4600.00 | GBP 0.00 | GBP 4600.00 | GBP -2812.22 | |
|
Client:
HMRC SHIPLEY
Category:
HMRC
VAT %:
0.0%
Net Amount:
GBP 4600.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-28 | To A/C 52018385 , BRADY C , Via Mobile Xfer , Have paid tax | brady c | DLA | 0.0% | GBP 5000.00 | GBP 0.00 | GBP 5000.00 | GBP -7812.22 | |
|
Client:
brady c
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 5000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-28 | From A/C 52018385 , BRADY C , Via Mobile Xfer , Tax payment | brady c | DLA | 0.0% | GBP 10000.00 | GBP 0.00 | GBP 10000.00 | GBP 2187.78 | |
|
Client:
brady c
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 10000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-30 | UNPAID ITEM FEE , 04APR A/C 61188832 | UNPAID ITEM | Bank charges | 0.0% | GBP 24.00 | GBP 0.00 | GBP 24.00 | GBP 2163.78 | |
|
Client:
UNPAID ITEM
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 24.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-30 | 04APR A/C 61188832 | Bank charges | Bank charges | 0.0% | GBP 4.20 | GBP 0.00 | GBP 4.20 | GBP 2159.58 | |
|
Client:
Bank charges
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 4.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-01 | JACOB REES-EVANS , RENT - JACOB , FP 01/05/25 0426 , PR89H0UF7G8CSQK9FT | jacob rees-evans rent | Rental Income | 0.0% | GBP 900.00 | GBP 0.00 | GBP 900.00 | GBP 3059.58 | |
|
Client:
jacob rees-evans rent
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 900.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-06 | CLOSE - UINSURE , 78110937 | close - uinsure | Insurance | 0.0% | GBP 24.45 | GBP 0.00 | GBP 24.45 | GBP 3035.13 | |
|
Client:
close - uinsure
Category:
Insurance
VAT %:
0.0%
Net Amount:
GBP 24.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-12 | VODAFONE LTD , 7088926977-1001 | VODAFONE LTD | Telephone | 0.0% | GBP 58.84 | GBP 0.00 | GBP 58.84 | GBP 2976.29 | |
|
Client:
VODAFONE LTD
Category:
Telephone
VAT %:
0.0%
Net Amount:
GBP 58.84
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-15 | TMW DDR , 18811717/1879546 | TMW DDR | Loan repayment | 0.0% | GBP 1206.87 | GBP 0.00 | GBP 1206.87 | GBP 1769.42 | |
|
Client:
TMW DDR
Category:
Loan repayment
VAT %:
0.0%
Net Amount:
GBP 1206.87
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-19 | From A/C 53128737 , HURST CB , Via Mobile Xfer | hurst | DLA | 0.0% | GBP 1000.00 | GBP 0.00 | GBP 1000.00 | GBP 2769.42 | |
|
Client:
hurst
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-20 | BUPA CENTRAL A/C , 0796331949 | BUPA CENTRAL | DLA | 0.0% | GBP 368.30 | GBP 0.00 | GBP 368.30 | GBP 2401.12 | |
|
Client:
BUPA CENTRAL
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 368.30
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-21 | TMW DDR , 17571666/1651767 | tmw ddr | Rent and rates | 0.0% | GBP 347.78 | GBP 0.00 | GBP 347.78 | GBP 2053.34 | |
|
Client:
tmw ddr
Category:
Rent and rates
VAT %:
0.0%
Net Amount:
GBP 347.78
VAT Amount:
GBP 0.00
|
|||||||||