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 |
|---|---|---|---|---|---|---|---|---|---|
| 2024-10-01 | Savings account | SAVINGS ACCOUNT | Bank charges | 0.0% | GBP 1000.00 | GBP 0.00 | GBP 1000.00 | GBP 252.81 | |
|
Client:
SAVINGS ACCOUNT
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 1000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-10 | COMPANIESHOUSE CHS - G - CROWN WAY, CARDIFF Tide Card: **** **** **** 1897 | COMPANIESHOUSE CHS | Sundry Expenses | 0.0% | GBP 34.00 | GBP 0.00 | GBP 34.00 | GBP 218.81 | |
|
Client:
COMPANIESHOUSE CHS
Category:
Sundry Expenses
VAT %:
0.0%
Net Amount:
GBP 34.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-19 | ref: Charge of 0.40 for Bank Transfers usage from 2024-09-01 to 2024-09-30 | charges 27feb a/c 86685104 | Bank charges | 0.0% | GBP 0.40 | GBP 0.00 | GBP 0.40 | GBP 218.41 | |
|
Client:
charges 27feb a/c 86685104
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 0.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-25 | TMW DDR / ref: 20404137/2222074 | TMW DDR | Interest | 0.0% | GBP 188.88 | GBP 0.00 | GBP 188.88 | GBP 29.53 | |
|
Client:
TMW DDR
Category:
Interest
VAT %:
0.0%
Net Amount:
GBP 188.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-28 | PAYPROP CLIENT ACC / ref: 11 TAFF TERRACE | PAYPROP CLIENT | Sales | 0.0% | GBP 373.80 | GBP 0.00 | GBP 373.80 | GBP -10806.52 | |
|
Client:
PAYPROP CLIENT
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 373.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-01 | Savings account | SAVINGS ACCOUNT | Bank charges | 0.0% | GBP 214.00 | GBP 0.00 | GBP 214.00 | GBP -184.47 | |
|
Client:
SAVINGS ACCOUNT
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 214.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-18 | ref: Charge of 0.40 for Bank Transfers usage from 2024-10-01 to 2024-10-31 | charges 27feb a/c 86685104 | Bank charges | 0.0% | GBP 0.40 | GBP 0.00 | GBP 0.40 | GBP -184.87 | |
|
Client:
charges 27feb a/c 86685104
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 0.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-27 | TMW DDR / ref: 20404137/2222074 | TMW DDR | Interest | 0.0% | GBP 188.88 | GBP 0.00 | GBP 188.88 | GBP -373.75 | |
|
Client:
TMW DDR
Category:
Interest
VAT %:
0.0%
Net Amount:
GBP 188.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-28 | Savings account | SAVINGS ACCOUNT | Bank charges | 0.0% | GBP 300.00 | GBP 0.00 | GBP 300.00 | GBP -673.75 | |
|
Client:
SAVINGS ACCOUNT
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 300.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-28 | PAYPROP CLIENT ACC / ref: 11 TAFF TERRACE | PAYPROP CLIENT | Sales | 0.0% | GBP 505.00 | GBP 0.00 | GBP 505.00 | GBP -10301.52 | |
|
Client:
PAYPROP CLIENT
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 505.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-18 | ref: Charge of 0.40 for Bank Transfers usage from 2024-11-01 to 2024-11-30 | charges 27feb a/c 86685104 | Bank charges | 0.0% | GBP 0.40 | GBP 0.00 | GBP 0.40 | GBP -674.15 | |
|
Client:
charges 27feb a/c 86685104
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 0.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-27 | TMW DDR / ref: 20404137/2222074 | TMW DDR | Interest | 0.0% | GBP 188.88 | GBP 0.00 | GBP 188.88 | GBP -863.03 | |
|
Client:
TMW DDR
Category:
Interest
VAT %:
0.0%
Net Amount:
GBP 188.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-30 | Savings account | SAVINGS ACCOUNT | Bank charges | 0.0% | GBP 411.00 | GBP 0.00 | GBP 411.00 | GBP -1274.03 | |
|
Client:
SAVINGS ACCOUNT
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 411.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-30 | PAYPROP CLIENT ACC / ref: 11 TAFF TERRACE | PAYPROP CLIENT | Sales | 0.0% | GBP 585.00 | GBP 0.00 | GBP 585.00 | GBP -9716.52 | |
|
Client:
PAYPROP CLIENT
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 585.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | ref: Charge of 0.40 for Bank Transfers usage from 2024-12-01 to 2024-12-31 | charges 27feb a/c 86685104 | Bank charges | 0.0% | GBP 0.40 | GBP 0.00 | GBP 0.40 | GBP -1274.43 | |
|
Client:
charges 27feb a/c 86685104
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 0.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-27 | TMW DDR / ref: 20404137/2222074 | TMW DDR | Interest | 0.0% | GBP 188.88 | GBP 0.00 | GBP 188.88 | GBP -1463.31 | |
|
Client:
TMW DDR
Category:
Interest
VAT %:
0.0%
Net Amount:
GBP 188.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-28 | PAYPROP CLIENT ACC / ref: 11 TAFF TERRACE | PAYPROP CLIENT | Sales | 0.0% | GBP 585.00 | GBP 0.00 | GBP 585.00 | GBP -9131.52 | |
|
Client:
PAYPROP CLIENT
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 585.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-30 | Savings account | SAVINGS ACCOUNT | Bank charges | 0.0% | GBP 396.00 | GBP 0.00 | GBP 396.00 | GBP -1859.31 | |
|
Client:
SAVINGS ACCOUNT
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 396.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-03 | Stephen Hollister / ref: Paying DL account | STEPHEN HOLLISTER PAYING | Stephen Hollister | 0.0% | GBP 2200.00 | GBP 0.00 | GBP 2200.00 | GBP -4059.31 | |
|
Client:
STEPHEN HOLLISTER PAYING
Category:
Stephen Hollister
VAT %:
0.0%
Net Amount:
GBP 2200.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-03 | Savings account | SAVINGS ACCOUNT | Bank charges | 0.0% | GBP 2200.00 | GBP 0.00 | GBP 2200.00 | GBP -6931.52 | |
|
Client:
SAVINGS ACCOUNT
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 2200.00
VAT Amount:
GBP 0.00
|
|||||||||