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 |
|---|---|---|---|---|---|---|---|---|---|
| 2024-12-03 | CLOSE - UINSURE , 78110937 | close - uinsure | Insurance | 0.0% | GBP 24.45 | GBP 0.00 | GBP 24.45 | GBP 1845.15 | |
|
Client:
close - uinsure
Category:
Insurance
VAT %:
0.0%
Net Amount:
GBP 24.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-06 | NEWCASTLE CITY COU, 1800012632434 , VIA MOBILE - PYMT , FP 06/12/24 10 , 64095030499949000N | NEWCASTLE CITY | Rent and rates | 0.0% | GBP 1002.00 | GBP 0.00 | GBP 1002.00 | GBP 843.15 | |
|
Client:
NEWCASTLE CITY
Category:
Rent and rates
VAT %:
0.0%
Net Amount:
GBP 1002.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-06 | From A/C 52018385 , BRADY C , Via Mobile Xfer | brady c | DLA | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP 1343.15 | |
|
Client:
brady c
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-09 | 205 BLINDS , BLINDS 205 , VIA MOBILE - PYMT , FP 07/12/24 10 , 62171228190853000N | 205 Blinds | Repairs | 0.0% | GBP 550.80 | GBP 0.00 | GBP 550.80 | GBP 792.35 | |
|
Client:
205 Blinds
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 550.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-11 | VODAFONE LTD , 7088926977-1001 | VODAFONE LTD | Telephone | 0.0% | GBP 73.77 | GBP 0.00 | GBP 73.77 | GBP 718.58 | |
|
Client:
VODAFONE LTD
Category:
Telephone
VAT %:
0.0%
Net Amount:
GBP 73.77
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-18 | BUPA CENTRAL A/C , 0796331949 | BUPA CENTRAL | DLA | 0.0% | GBP 368.30 | GBP 0.00 | GBP 368.30 | GBP 350.28 | |
|
Client:
BUPA CENTRAL
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 368.30
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-19 | TMW DDR , 17571666/1651767 | tmw ddr | Rent and rates | 0.0% | GBP 347.78 | GBP 0.00 | GBP 347.78 | GBP 2.50 | |
|
Client:
tmw ddr
Category:
Rent and rates
VAT %:
0.0%
Net Amount:
GBP 347.78
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-30 | From A/C 52018385 , BRADY C , Via Mobile Xfer | brady c | DLA | 0.0% | GBP 1000.00 | GBP 0.00 | GBP 1000.00 | GBP 1002.50 | |
|
Client:
brady c
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 1000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-31 | UNPAID ITEM FEE , 29NOV A/C 61188832 | UNPAID ITEM | Bank charges | 0.0% | GBP 12.00 | GBP 0.00 | GBP 12.00 | GBP 990.50 | |
|
Client:
UNPAID ITEM
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 12.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-31 | 29NOV A/C 61188832 | Bank charges | Bank charges | 0.0% | GBP 2.80 | GBP 0.00 | GBP 2.80 | GBP 987.70 | |
|
Client:
Bank charges
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 2.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-31 | 01DEC A/C 61188832 | Bank charges | Bank charges | 0.0% | GBP 0.90 | GBP 0.00 | GBP 0.90 | GBP 986.80 | |
|
Client:
Bank charges
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 0.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-03 | CLOSE - UINSURE , 78110937 | close - uinsure | Insurance | 0.0% | GBP 24.45 | GBP 0.00 | GBP 24.45 | GBP 962.35 | |
|
Client:
close - uinsure
Category:
Insurance
VAT %:
0.0%
Net Amount:
GBP 24.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-07 | THE MORTGAGE WORKS, 18811717 , VIA MOBILE - PYMT , FP 07/01/25 10 , 49163737598980000N | Other expense | Other Expense | 0.0% | GBP 3620.61 | GBP 0.00 | GBP 3620.61 | GBP -2658.26 | |
|
Client:
Other expense
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 3620.61
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-07 | THE MORTGAGE WORKS, 17571666 , VIA MOBILE - PYMT , FP 07/01/25 10 , 53163857367303000N | tmw ddr | Rent and rates | 0.0% | GBP 347.78 | GBP 0.00 | GBP 347.78 | GBP -3006.04 | |
|
Client:
tmw ddr
Category:
Rent and rates
VAT %:
0.0%
Net Amount:
GBP 347.78
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-07 | From A/C 53128737 , HURST CB , Via Mobile Xfer | hurst | DLA | 0.0% | GBP 4000.00 | GBP 0.00 | GBP 4000.00 | GBP 993.96 | |
|
Client:
hurst
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 4000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-09 | VODAFONE LTD , 7088926977-1001 | VODAFONE LTD | Telephone | 0.0% | GBP 37.12 | GBP 0.00 | GBP 37.12 | GBP 956.84 | |
|
Client:
VODAFONE LTD
Category:
Telephone
VAT %:
0.0%
Net Amount:
GBP 37.12
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | BUPA CENTRAL A/C , 0796331949 | BUPA CENTRAL | DLA | 0.0% | GBP 368.30 | GBP 0.00 | GBP 368.30 | GBP 588.54 | |
|
Client:
BUPA CENTRAL
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 368.30
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-21 | TMW DDR , 17571666/1651767 | tmw ddr | Rent and rates | 0.0% | GBP 347.78 | GBP 0.00 | GBP 347.78 | GBP 240.76 | |
|
Client:
tmw ddr
Category:
Rent and rates
VAT %:
0.0%
Net Amount:
GBP 347.78
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-22 | JACOB REES-EVANS , RENT - JACOB , FP 22/01/25 1500 , PXCQ50ILJ3GLN0FYTB | jacob rees-evans rent | Rental Income | 0.0% | GBP 900.00 | GBP 0.00 | GBP 900.00 | GBP 1140.76 | |
|
Client:
jacob rees-evans rent
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 900.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-24 | CLIENT ACCOUNT , 29 LEOPOLD ROAD , FP 24/01/25 0232 , 62023153877032000N, 29 LEOPOLD ROAD | Other expense | Other Expense | 0.0% | GBP 119.00 | GBP 0.00 | GBP 119.00 | GBP 1259.76 | |
|
Client:
Other expense
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 119.00
VAT Amount:
GBP 0.00
|
|||||||||