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-01-31 | UNPAID ITEM FEE , 03JAN A/C 61188832 | UNPAID ITEM | Bank charges | 0.0% | GBP 24.00 | GBP 0.00 | GBP 24.00 | GBP 1235.76 | |
|
Client:
UNPAID ITEM
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 24.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-31 | 03JAN A/C 61188832 | Bank charges | Bank charges | 0.0% | GBP 3.50 | GBP 0.00 | GBP 3.50 | GBP 1232.26 | |
|
Client:
Bank charges
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 3.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-03 | CLOSE - UINSURE , 78110937 | close - uinsure | Insurance | 0.0% | GBP 24.45 | GBP 0.00 | GBP 24.45 | GBP 1207.81 | |
|
Client:
close - uinsure
Category:
Insurance
VAT %:
0.0%
Net Amount:
GBP 24.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-03 | JACOB REES-EVANS , RENT - JACOB , FP 01/02/25 0315 , PH1AVEC7ZJVTPRJ9G2 | jacob rees-evans rent | Rental Income | 0.0% | GBP 900.00 | GBP 0.00 | GBP 900.00 | GBP 2107.81 | |
|
Client:
jacob rees-evans rent
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 900.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-11 | VODAFONE LTD , 7088926977-1001 | VODAFONE LTD | Telephone | 0.0% | GBP 41.44 | GBP 0.00 | GBP 41.44 | GBP 2066.37 | |
|
Client:
VODAFONE LTD
Category:
Telephone
VAT %:
0.0%
Net Amount:
GBP 41.44
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-17 | TMW DDR , 18811717/1879546 | TMW DDR | Loan repayment | 0.0% | GBP 1206.87 | GBP 0.00 | GBP 1206.87 | GBP 859.50 | |
|
Client:
TMW DDR
Category:
Loan repayment
VAT %:
0.0%
Net Amount:
GBP 1206.87
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-19 | TMW DDR , 17571666/1651767 | tmw ddr | Rent and rates | 0.0% | GBP 347.78 | GBP 0.00 | GBP 347.78 | GBP 511.72 | |
|
Client:
tmw ddr
Category:
Rent and rates
VAT %:
0.0%
Net Amount:
GBP 347.78
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-19 | BUPA CENTRAL A/C , 0796331949 | BUPA CENTRAL | DLA | 0.0% | GBP 368.30 | GBP 0.00 | GBP 368.30 | GBP 143.42 | |
|
Client:
BUPA CENTRAL
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 368.30
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-25 | From A/C 53128737 , HURST CB , Via Mobile Xfer , For mortgage | hurst | DLA | 0.0% | GBP 2000.00 | GBP 0.00 | GBP 2000.00 | GBP 2143.42 | |
|
Client:
hurst
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 2000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-28 | UNPAID ITEM FEE , 31JAN A/C 61188832 | UNPAID ITEM | Bank charges | 0.0% | GBP 12.00 | GBP 0.00 | GBP 12.00 | GBP 2131.42 | |
|
Client:
UNPAID ITEM
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 12.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-28 | 31JAN A/C 61188832 | Bank charges | Bank charges | 0.0% | GBP 2.80 | GBP 0.00 | GBP 2.80 | GBP 2128.62 | |
|
Client:
Bank charges
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 2.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-03 | CLOSE - UINSURE , 78110937 | close - uinsure | Insurance | 0.0% | GBP 24.45 | GBP 0.00 | GBP 24.45 | GBP 2104.17 | |
|
Client:
close - uinsure
Category:
Insurance
VAT %:
0.0%
Net Amount:
GBP 24.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-03 | JACOB REES-EVANS , RENT - JACOB , FP 01/03/25 0324 , PYFZUQKOA96QDRD849 | jacob rees-evans rent | Rental Income | 0.0% | GBP 900.00 | GBP 0.00 | GBP 900.00 | GBP 3004.17 | |
|
Client:
jacob rees-evans rent
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 900.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-12 | VODAFONE LTD , 7088926977-1001 | VODAFONE LTD | Telephone | 0.0% | GBP 41.54 | GBP 0.00 | GBP 41.54 | GBP 2962.63 | |
|
Client:
VODAFONE LTD
Category:
Telephone
VAT %:
0.0%
Net Amount:
GBP 41.54
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-12 | Flat 10 , 0603251 , VIA MOBILE - PYMT , FP 12/03/25 10 , 03151502354566000N | Other expense | Other Expense | 0.0% | GBP 85.00 | GBP 0.00 | GBP 85.00 | GBP 2877.63 | |
|
Client:
Other expense
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 85.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-12 | 10CA LIMITED , LTK PROPERTIES , VIA MOBILE - PYMT , FP 11/03/25 10 , 40193342023985000N | 10ca limited | Accountancy Fees | 0.0% | GBP 154.80 | GBP 0.00 | GBP 154.80 | GBP 2722.83 | |
|
Client:
10ca limited
Category:
Accountancy Fees
VAT %:
0.0%
Net Amount:
GBP 154.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-12 | David Adams survey, Cathie Brady 331 , VIA MOBILE - PYMT , FP 11/03/25 10 , 60193133574139000N | brady c | DLA | 0.0% | GBP 2885.26 | GBP 0.00 | GBP 2885.26 | GBP -162.43 | |
|
Client:
brady c
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 2885.26
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-12 | From A/C 53128737 , HURST CB , Via Mobile Xfer , 331 service | hurst | DLA | 0.0% | GBP 2000.00 | GBP 0.00 | GBP 2000.00 | GBP 1837.57 | |
|
Client:
hurst
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 2000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-17 | TMW DDR , 18811717/1879546 | TMW DDR | Loan repayment | 0.0% | GBP 1206.87 | GBP 0.00 | GBP 1206.87 | GBP 630.70 | |
|
Client:
TMW DDR
Category:
Loan repayment
VAT %:
0.0%
Net Amount:
GBP 1206.87
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-31 | 28FEB A/C 61188832 | Bank charges | Bank charges | 0.0% | GBP 2.45 | GBP 0.00 | GBP 2.45 | GBP 628.25 | |
|
Client:
Bank charges
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 2.45
VAT Amount:
GBP 0.00
|
|||||||||