GPT Analysis: Excel data processed directly from structured columns; Balance Analysis: Statement incomplete: Balance difference of £1485.80 exceeds acceptable tolerance (£0.1). Calculated closing balance: £6817.89, Stated closing balance: £5332.09; Date Gap Analysis: Found 15 gaps > 7 days: 02/10/2025 to 02/24/2025 (14 days), 03/04/2025 to 03/31/2025 (27 days), 04/01/2025 to 04/11/2025 (10 days), 04/11/2025 to 05/01/2025 (20 days), 05/08/2025 to 06/01/2025 (24 days), 06/02/2025 to 06/13/2025 (11 days), 06/13/2025 to 06/25/2025 (12 days), 07/17/2025 to 07/30/2025 (13 days), 08/01/2025 to 08/15/2025 (14 days), 08/15/2025 to 08/31/2025 (16 days), 09/02/2025 to 10/01/2025 (29 days), 10/05/2025 to 10/28/2025 (23 days), 11/03/2025 to 11/28/2025 (25 days), 12/05/2025 to 12/30/2025 (25 days), 01/09/2026 to 01/28/2026 (19 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2025-02-01 | Service Charges Ref:707771975 | SERVICE CHARGES | Bank charges | - | - | - | GBP 87717.17 | ||
|
Client:
SERVICE CHARGES
Category:
Bank charges
|
|||||||||
| 2025-02-03 | THE MORTGAGE LENDE REFERENCE: M00142811901R25032 | the mortgage lende | Mortgage Interest | 0.0% | GBP 476.42 | GBP 0.00 | GBP 476.42 | GBP 87240.75 | |
|
Client:
the mortgage lende
Category:
Mortgage Interest
VAT %:
0.0%
Net Amount:
GBP 476.42
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-03 | FRAMEWORK GROUP LIMITED Zhilko limited | FRAMEWORK GROUP LIMITED | Other Expenses | 0.0% | GBP 650.00 | GBP 0.00 | GBP 650.00 | GBP 86590.75 | |
|
Client:
FRAMEWORK GROUP LIMITED
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 650.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-06 | JOHN SHEPHERD APARTMENT 106 FOX | john shepherd | Sales | 0.0% | GBP 754.80 | GBP 0.00 | GBP 754.80 | GBP 87345.55 | |
|
Client:
john shepherd
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 754.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-10 | KEYSTONE PROPERTY FINA CD 0481 | KEYSTONE PROPERTY FINA | Other Expenses | 0.0% | GBP 645.00 | GBP 0.00 | GBP 645.00 | GBP 86700.55 | |
|
Client:
KEYSTONE PROPERTY FINA
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 645.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-24 | FRAMEWORK MORTGAGING CD 048 | FRAMEWORK GROUP LIMITED | Other Expenses | 0.0% | GBP 649.00 | GBP 0.00 | GBP 649.00 | GBP 86051.55 | |
|
Client:
FRAMEWORK GROUP LIMITED
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 649.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-01 | Service Charges Ref:707866178 | SERVICE CHARGES | Bank charges | - | - | - | GBP 86051.55 | ||
|
Client:
SERVICE CHARGES
Category:
Bank charges
|
|||||||||
| 2025-03-03 | THE MORTGAGE LENDE REFERENCE: M00142811901R25060 | the mortgage lende | Mortgage Interest | 0.0% | GBP 476.42 | GBP 0.00 | GBP 476.42 | GBP 85575.13 | |
|
Client:
the mortgage lende
Category:
Mortgage Interest
VAT %:
0.0%
Net Amount:
GBP 476.42
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-04 | CO REFERENCE: ZB662551 | Other expenses | Other Expenses | 0.0% | GBP 47.00 | GBP 0.00 | GBP 47.00 | GBP 85528.13 | |
|
Client:
Other expenses
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 47.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-31 | JOHN SHEPHERD APARTMENT 106 FOX | john shepherd | Sales | 0.0% | GBP 320.00 | GBP 0.00 | GBP 320.00 | GBP 85848.13 | |
|
Client:
john shepherd
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 320.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-01 | THE MORTGAGE LENDE REFERENCE: M00142811901R25091 | the mortgage lende | Mortgage Interest | 0.0% | GBP 476.42 | GBP 0.00 | GBP 476.42 | GBP 85114.11 | |
|
Client:
the mortgage lende
Category:
Mortgage Interest
VAT %:
0.0%
Net Amount:
GBP 476.42
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-01 | Service Charges Ref:707958996 | SERVICE CHARGES | Bank charges | - | - | - | GBP 85271.11 | ||
|
Client:
SERVICE CHARGES
Category:
Bank charges
|
|||||||||
| 2025-04-01 | JOHN SHEPHERD APARTMENT 106 FOX | john shepherd | Sales | 0.0% | GBP 157.00 | GBP 0.00 | GBP 157.00 | GBP 85271.11 | |
|
Client:
john shepherd
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 157.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-01 | DCC COUNCIL TAX REFERENCE: 807541542 | Other expenses | Rates | 0.0% | GBP 257.60 | GBP 0.00 | GBP 257.60 | GBP 85590.53 | |
|
Client:
Other expenses
Category:
Rates
VAT %:
0.0%
Net Amount:
GBP 257.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-11 | DERBY CITY COUNCIL REFERENCE: 362179 | Other expenses | Rates | 0.0% | GBP 169.07 | GBP 0.00 | GBP 169.07 | GBP 85440.18 | |
|
Client:
Other expenses
Category:
Rates
VAT %:
0.0%
Net Amount:
GBP 169.07
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-01 | THE MORTGAGE LENDE REFERENCE: M00142811901R25121 | the mortgage lende | Mortgage Interest | 0.0% | GBP 476.42 | GBP 0.00 | GBP 476.42 | GBP 84963.76 | |
|
Client:
the mortgage lende
Category:
Mortgage Interest
VAT %:
0.0%
Net Amount:
GBP 476.42
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-01 | JOHN SHEPHERD APARTMENT 106 FOX | john shepherd | Sales | 0.0% | GBP 460.50 | GBP 0.00 | GBP 460.50 | GBP 85424.26 | |
|
Client:
john shepherd
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 460.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-01 | Service Charges Ref:708050832 | SERVICE CHARGES | Bank charges | - | - | - | GBP 85424.26 | ||
|
Client:
SERVICE CHARGES
Category:
Bank charges
|
|||||||||
| 2025-05-07 | Carters PM Limited NGB-106 | Other expenses | Other Expenses | 0.0% | GBP 943.67 | GBP 0.00 | GBP 943.67 | GBP 84480.59 | |
|
Client:
Other expenses
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 943.67
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-08 | JOHN SHEPHERD APARTMENT 106 FOX | john shepherd | Sales | 0.0% | GBP 27.55 | GBP 0.00 | GBP 27.55 | GBP 84508.14 | |
|
Client:
john shepherd
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 27.55
VAT Amount:
GBP 0.00
|
|||||||||