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-02-18 | Jillian Hollister / ref: Pay director loan | JILLIAN HOLLISTER | Jillian Hollister | 0.0% | GBP 390.00 | GBP 0.00 | GBP 390.00 | GBP -4449.31 | |
|
Client:
JILLIAN HOLLISTER
Category:
Jillian Hollister
VAT %:
0.0%
Net Amount:
GBP 390.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-18 | Savings account | SAVINGS ACCOUNT | Bank charges | 0.0% | GBP 390.00 | GBP 0.00 | GBP 390.00 | GBP -6541.52 | |
|
Client:
SAVINGS ACCOUNT
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 390.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-18 | HOLL J + HOLL S / ref: CHARGES | HOLL | Other income | 0.0% | GBP 2.00 | GBP 0.00 | GBP 2.00 | GBP -6539.52 | |
|
Client:
HOLL
Category:
Other income
VAT %:
0.0%
Net Amount:
GBP 2.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-19 | ref: Charge of 0.40 for Bank Transfers usage from 2025-01-01 to 2025-01-31 | charges 27feb a/c 86685104 | Bank charges | 0.0% | GBP 0.40 | GBP 0.00 | GBP 0.40 | GBP -4449.71 | |
|
Client:
charges 27feb a/c 86685104
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 0.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-26 | TMW DDR / ref: 20404137/2222074 | TMW DDR | Interest | 0.0% | GBP 188.88 | GBP 0.00 | GBP 188.88 | GBP -4638.59 | |
|
Client:
TMW DDR
Category:
Interest
VAT %:
0.0%
Net Amount:
GBP 188.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-28 | Savings account | SAVINGS ACCOUNT | Bank charges | 0.0% | GBP 397.73 | GBP 0.00 | GBP 397.73 | GBP -5036.32 | |
|
Client:
SAVINGS ACCOUNT
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 397.73
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-28 | PAYPROP CLIENT ACC / ref: 11 TAFF TERRACE | PAYPROP CLIENT | Sales | 0.0% | GBP 585.00 | GBP 0.00 | GBP 585.00 | GBP -5954.52 | |
|
Client:
PAYPROP CLIENT
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 585.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-20 | ref: Charge of 1.00 for Bank Transfers usage from 2025-02-01 to 2025-02-28 | charges 27feb a/c 86685104 | Bank charges | 0.0% | GBP 1.00 | GBP 0.00 | GBP 1.00 | GBP -5037.32 | |
|
Client:
charges 27feb a/c 86685104
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 1.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-21 | Savings account | SAVINGS ACCOUNT | Bank charges | 0.0% | GBP 1.00 | GBP 0.00 | GBP 1.00 | GBP -5953.52 | |
|
Client:
SAVINGS ACCOUNT
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 1.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-26 | TMW DDR / ref: 20404137/2222074 | TMW DDR | Interest | 0.0% | GBP 188.88 | GBP 0.00 | GBP 188.88 | GBP -5226.20 | |
|
Client:
TMW DDR
Category:
Interest
VAT %:
0.0%
Net Amount:
GBP 188.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-28 | Savings account | SAVINGS ACCOUNT | Bank charges | 0.0% | GBP 385.00 | GBP 0.00 | GBP 385.00 | GBP -5611.20 | |
|
Client:
SAVINGS ACCOUNT
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 385.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-28 | PAYPROP CLIENT ACC / ref: 11 TAFF TERRACE | PAYPROP CLIENT | Sales | 0.0% | GBP 585.00 | GBP 0.00 | GBP 585.00 | GBP -5368.52 | |
|
Client:
PAYPROP CLIENT
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 585.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-17 | ref: Charge of 0.40 for Bank Transfers usage from 2025-03-01 to 2025-03-31 | charges 27feb a/c 86685104 | Bank charges | 0.0% | GBP 0.40 | GBP 0.00 | GBP 0.40 | GBP -5611.60 | |
|
Client:
charges 27feb a/c 86685104
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 0.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-25 | TMW DDR / ref: 20404137/2222074 | TMW DDR | Interest | 0.0% | GBP 198.55 | GBP 0.00 | GBP 198.55 | GBP -5810.15 | |
|
Client:
TMW DDR
Category:
Interest
VAT %:
0.0%
Net Amount:
GBP 198.55
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-28 | PAYPROP CLIENT ACC / ref: 11 TAFF TERRACE | PAYPROP CLIENT | Sales | 0.0% | GBP 585.00 | GBP 0.00 | GBP 585.00 | GBP -4783.52 | |
|
Client:
PAYPROP CLIENT
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 585.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-28 | Savings account | SAVINGS ACCOUNT | Bank charges | 0.0% | GBP 387.00 | GBP 0.00 | GBP 387.00 | GBP -6197.15 | |
|
Client:
SAVINGS ACCOUNT
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 387.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-16 | ref: Charge of 0.40 for Bank Transfers usage from 2025-04-01 to 2025-04-30 | charges 27feb a/c 86685104 | Bank charges | 0.0% | GBP 0.40 | GBP 0.00 | GBP 0.40 | GBP -6197.55 | |
|
Client:
charges 27feb a/c 86685104
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 0.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-19 | REWARDS / ref: Your TIS Cash bonus is here! | REWARDS YOUR | Other income | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP -4773.52 | |
|
Client:
REWARDS YOUR
Category:
Other income
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-27 | Stephen Hollister / ref: Buildings insuranc | STEPHEN HOLLISTER | Insurance | 0.0% | GBP 152.22 | GBP 0.00 | GBP 152.22 | GBP -6349.77 | |
|
Client:
STEPHEN HOLLISTER
Category:
Insurance
VAT %:
0.0%
Net Amount:
GBP 152.22
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-27 | Savings account | SAVINGS ACCOUNT | DLA | 0.0% | GBP 152.22 | GBP 0.00 | GBP 152.22 | GBP -4621.30 | |
|
Client:
SAVINGS ACCOUNT
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 152.22
VAT Amount:
GBP 0.00
|
|||||||||