GPT Analysis: Excel data processed directly from structured columns; Balance Analysis: Statement incomplete: Balance difference of £8067.44 exceeds acceptable tolerance (£0.1). Calculated closing balance: £-7867.44, Stated closing balance: £200.00; Date Gap Analysis: Found 19 gaps > 7 days: 10/01/2024 to 10/10/2024 (9 days), 10/10/2024 to 10/19/2024 (9 days), 11/01/2024 to 11/18/2024 (17 days), 11/18/2024 to 11/27/2024 (9 days), 11/28/2024 to 12/18/2024 (20 days), 12/18/2024 to 12/27/2024 (9 days), 12/30/2024 to 01/20/2025 (21 days), 02/03/2025 to 02/18/2025 (15 days), 02/28/2025 to 03/20/2025 (20 days), 03/28/2025 to 04/17/2025 (20 days), 04/17/2025 to 04/25/2025 (8 days), 04/28/2025 to 05/16/2025 (18 days), 05/19/2025 to 05/27/2025 (8 days), 05/28/2025 to 06/17/2025 (20 days), 06/30/2025 to 07/17/2025 (17 days), 07/17/2025 to 07/25/2025 (8 days), 07/28/2025 to 08/19/2025 (22 days), 08/19/2025 to 08/28/2025 (9 days), 08/29/2025 to 09/25/2025 (27 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2025-08-28 | PAYPROP CLIENT ACC / ref: 11 TAFF TERRACE | PAYPROP CLIENT | Sales | 0.0% | GBP 579.80 | GBP 0.00 | GBP 579.80 | GBP -883.55 | |
|
Client:
PAYPROP CLIENT
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 579.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | Jillian Hollister / ref: Pay director loan | JILLIAN HOLLISTER | Jillian Hollister | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP -10601.17 | |
|
Client:
JILLIAN HOLLISTER
Category:
Jillian Hollister
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | ref: Tide fee for the transaction of £500 amount | TIDE FEE | Bank charges | 0.0% | GBP 0.20 | GBP 0.00 | GBP 0.20 | GBP -10601.37 | |
|
Client:
TIDE FEE
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 0.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | Savings account | SAVINGS ACCOUNT | DLA | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP -383.55 | |
|
Client:
SAVINGS ACCOUNT
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | Savings account | SAVINGS ACCOUNT | DLA | 0.0% | GBP 3.75 | GBP 0.00 | GBP 3.75 | GBP -379.80 | |
|
Client:
SAVINGS ACCOUNT
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 3.75
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-25 | TMW DDR / ref: 20404137/2222074 | TMW DDR | Interest | 0.0% | GBP 198.55 | GBP 0.00 | GBP 198.55 | GBP -10799.92 | |
|
Client:
TMW DDR
Category:
Interest
VAT %:
0.0%
Net Amount:
GBP 198.55
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-25 | ref: Tide fee for the transaction of £198.55 amount | TIDE FEE | Bank charges | 0.0% | GBP 0.20 | GBP 0.00 | GBP 0.20 | GBP -10800.12 | |
|
Client:
TIDE FEE
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 0.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-29 | ref: Tide fee for the transaction of £579.8 amount | TIDE FEE | Bank charges | 0.0% | GBP 0.20 | GBP 0.00 | GBP 0.20 | GBP -10800.32 | |
|
Client:
TIDE FEE
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 0.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-29 | Savings account | SAVINGS ACCOUNT | DLA | 0.0% | GBP 380.00 | GBP 0.00 | GBP 380.00 | GBP -11180.32 | |
|
Client:
SAVINGS ACCOUNT
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 380.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-29 | PAYPROP CLIENT ACC / ref: 11 TAFF TERRACE | PAYPROP CLIENT | Sales | 0.0% | GBP 579.80 | GBP 0.00 | GBP 579.80 | GBP 200.00 | |
|
Client:
PAYPROP CLIENT
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 579.80
VAT Amount:
GBP 0.00
|
|||||||||