GPT Analysis: Excel data processed directly from structured columns; Balance Analysis: Statement incomplete: Balance difference of £24766.82 exceeds acceptable tolerance (£0.1). Calculated closing balance: £29823.03, Stated closing balance: £5056.21; Date Gap Analysis: Found 18 gaps > 7 days: 10/17/2024 to 10/28/2024 (11 days), 10/28/2024 to 11/05/2024 (8 days), 11/18/2024 to 11/27/2024 (9 days), 12/10/2024 to 12/18/2024 (8 days), 12/18/2024 to 01/03/2025 (16 days), 01/10/2025 to 01/20/2025 (10 days), 01/20/2025 to 02/05/2025 (16 days), 02/10/2025 to 02/19/2025 (9 days), 03/20/2025 to 04/07/2025 (18 days), 04/25/2025 to 05/06/2025 (11 days), 05/18/2025 to 05/27/2025 (9 days), 05/27/2025 to 06/05/2025 (9 days), 06/10/2025 to 06/18/2025 (8 days), 06/18/2025 to 06/28/2025 (10 days), 06/28/2025 to 07/07/2025 (9 days), 07/21/2025 to 08/05/2025 (15 days), 08/11/2025 to 08/19/2025 (8 days), 08/19/2025 to 09/05/2025 (17 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2024-10-07 | ALDERMORE BANK COL ref: 105508245&01R24279 | bank charge | Bank fees | 0.0% | GBP 657.83 | GBP 0.00 | GBP 657.83 | GBP 5056.21 | |
|
Client:
bank charge
Category:
Bank fees
VAT %:
0.0%
Net Amount:
GBP 657.83
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-10 | SIMMONDS N ref: 35MIZZYMEAD | no_match | Uncategorized | 0.0% | GBP 1450.00 | GBP 0.00 | GBP 1450.00 | GBP 5714.04 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 1450.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-17 | Charge of 0.60 for Bank Transfers usage from 2024-09-01 to 2024-09-30 | train | Travel | 0.0% | GBP 0.60 | GBP 0.00 | GBP 0.60 | GBP 4264.04 | |
|
Client:
train
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 0.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-28 | CURRYS ONLINE - KNOLL HOUSE, HEMEL HEMPSTE | no_match | Uncategorized | 0.0% | GBP 299.00 | GBP 0.00 | GBP 299.00 | GBP 4264.64 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 299.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-05 | ALDERMORE BANK COL ref: 105508245&01R24310 | bank charge | Bank fees | 0.0% | GBP 657.83 | GBP 0.00 | GBP 657.83 | GBP 4563.64 | |
|
Client:
bank charge
Category:
Bank fees
VAT %:
0.0%
Net Amount:
GBP 657.83
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-11 | SIMMONDS N ref: 35MIZZYMEAD | no_match | Uncategorized | 0.0% | GBP 1450.00 | GBP 0.00 | GBP 1450.00 | GBP 5221.47 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 1450.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-17 | Davies-Hart & Co Ltd ref: Confirmation state | no_match | Uncategorized | 0.0% | GBP 65.20 | GBP 0.00 | GBP 65.20 | GBP 3771.47 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 65.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-18 | Charge of 0.40 for Bank Transfers usage from 2024-10-01 to 2024-10-31 | train | Travel | 0.0% | GBP 0.40 | GBP 0.00 | GBP 0.40 | GBP 3836.67 | |
|
Client:
train
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 0.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-27 | SCREWFIX DIRECT - Trade House MEAD AVENUE, WWW.SCREWFIX. | pret | Travel | 0.0% | GBP 59.77 | GBP 0.00 | GBP 59.77 | GBP 3837.07 | |
|
Client:
pret
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 59.77
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-28 | TOOLSTATION UK - Lodge Way House Lodge Way, NORTHAMPTON | taxi | Travel | 0.0% | GBP 12.52 | GBP 0.00 | GBP 12.52 | GBP 3896.84 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 12.52
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-05 | ALDERMORE BANK COL ref: 105508245&01R24340 | bank charge | Bank fees | 0.0% | GBP 657.83 | GBP 0.00 | GBP 657.83 | GBP 3909.36 | |
|
Client:
bank charge
Category:
Bank fees
VAT %:
0.0%
Net Amount:
GBP 657.83
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-10 | SIMMONDS N ref: 35MIZZYMEAD | no_match | Uncategorized | 0.0% | GBP 1450.00 | GBP 0.00 | GBP 1450.00 | GBP 4567.19 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 1450.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-18 | CardRefund: TOOLSTATION UK - Lodge Way House Lodge Way, NORTHAMPTON | taxi | Travel | 0.0% | GBP 9.94 | GBP 0.00 | GBP 9.94 | GBP 3117.79 | |
|
Client:
taxi
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 9.94
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-18 | Charge of 0.60 for Bank Transfers usage from 2024-11-01 to 2024-11-30 | train | Travel | 0.0% | GBP 0.60 | GBP 0.00 | GBP 0.60 | GBP 3117.19 | |
|
Client:
train
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 0.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-03 | ICO ref: ZB837781 | no_match | Uncategorized | 0.0% | GBP 35.00 | GBP 0.00 | GBP 35.00 | GBP 3107.85 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 35.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-06 | ALDERMORE BANK COL ref: 105508245&01R25005 | bank charge | Bank fees | 0.0% | GBP 657.83 | GBP 0.00 | GBP 657.83 | GBP 3142.85 | |
|
Client:
bank charge
Category:
Bank fees
VAT %:
0.0%
Net Amount:
GBP 657.83
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-10 | SIMMONDS N ref: 35MIZZYMEAD | no_match | Uncategorized | 0.0% | GBP 1450.00 | GBP 0.00 | GBP 1450.00 | GBP 3800.68 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 1450.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | Charge of 0.40 for Bank Transfers usage from 2024-12-01 to 2024-12-31 | train | Travel | 0.0% | GBP 0.40 | GBP 0.00 | GBP 0.40 | GBP 2350.68 | |
|
Client:
train
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 0.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-05 | ALDERMORE BANK COL ref: 105508245&01R25036 | bank charge | Bank fees | 0.0% | GBP 657.83 | GBP 0.00 | GBP 657.83 | GBP 2351.08 | |
|
Client:
bank charge
Category:
Bank fees
VAT %:
0.0%
Net Amount:
GBP 657.83
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-10 | SIMMONDS N ref: 35MIZZYMEAD | no_match | Uncategorized | 0.0% | GBP 1450.00 | GBP 0.00 | GBP 1450.00 | GBP 3008.91 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 1450.00
VAT Amount:
GBP 0.00
|
|||||||||