GPT Analysis: Excel data processed directly from structured columns; Date Gap Analysis: Found 3 gaps > 7 days: 10/18/2024 to 10/27/2024 (9 days), 02/04/2025 to 02/17/2025 (13 days), 06/04/2025 to 06/17/2025 (13 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2025-07-22 | B Tarlton (A TARLTON) | unknown | Suspense | 0.0% | GBP 168.00 | GBP 0.00 | GBP 168.00 | GBP 23752.22 | |
|
Client:
unknown
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 168.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-23 | L Langley (Lily Langley) | L LANGLEY LILY LANGLEY | Suspense | 0.0% | GBP 84.00 | GBP 0.00 | GBP 84.00 | GBP 23836.22 | |
|
Client:
L LANGLEY LILY LANGLEY
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 84.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-23 | Claire Imhasly (July 25) | CLAIRE IMHASLY | Wages | 0.0% | GBP 1500.00 | GBP 0.00 | GBP 1500.00 | GBP 22336.22 | |
|
Client:
CLAIRE IMHASLY
Category:
Wages
VAT %:
0.0%
Net Amount:
GBP 1500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-24 | PROPER JOB RADSTOCK | PROPER JOB | Suspense | 0.0% | GBP 13.98 | GBP 0.00 | GBP 13.98 | GBP 22322.24 | |
|
Client:
PROPER JOB
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 13.98
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-24 | AMZNMktplace*RS5Y38HI4 | AMZNMKTPLACERS5Y38HI4 | Suspense | 0.0% | GBP 42.11 | GBP 0.00 | GBP 42.11 | GBP 22280.13 | |
|
Client:
AMZNMKTPLACERS5Y38HI4
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 42.11
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-30 | Chanti England-Johns (NUSHEJ SEPTEMBER25) | CHANTI ENGLANDJOHNS NUSHEJ | Suspense | 0.0% | GBP 84.00 | GBP 0.00 | GBP 84.00 | GBP 22364.13 | |
|
Client:
CHANTI ENGLANDJOHNS NUSHEJ
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 84.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-31 | HUMPHREY SP (Betsy Waller) | HUMPHREY | Suspense | 0.0% | GBP 180.00 | GBP 0.00 | GBP 180.00 | GBP 22544.13 | |
|
Client:
HUMPHREY
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-01 | Emma Still (Mia Steel Mondays) | EMMA STILL | Suspense | 0.0% | GBP 253.33 | GBP 0.00 | GBP 253.33 | GBP 22797.46 | |
|
Client:
EMMA STILL
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 253.33
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-01 | Jenny Aranha (AIDAN) | JENNY ARANHA | Suspense | 0.0% | GBP 72.00 | GBP 0.00 | GBP 72.00 | GBP 22869.46 | |
|
Client:
JENNY ARANHA
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 72.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-01 | R BAHADUR (REUBEN BAHADUR) | R BAHADUR REUBEN | Suspense | 0.0% | GBP 140.00 | GBP 0.00 | GBP 140.00 | GBP 23009.46 | |
|
Client:
R BAHADUR REUBEN
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 140.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-01 | MISS THOMAS & MR CLARK (THAYEN) | miss c j thomas | Sales | 0.0% | GBP 140.00 | GBP 0.00 | GBP 140.00 | GBP 23149.46 | |
|
Client:
miss c j thomas
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 140.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-01 | M MCCREADY (ROBIN) | m mccready | Sales | 0.0% | GBP 253.33 | GBP 0.00 | GBP 253.33 | GBP 23402.79 | |
|
Client:
m mccready
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 253.33
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-01 | Rachel Leonard (HARRY LEONARD) | leonard rachel | Sales | 0.0% | GBP 140.00 | GBP 0.00 | GBP 140.00 | GBP 23542.79 | |
|
Client:
leonard rachel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 140.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-04 | All Tree Services Ltd (Otter Brook) | ALL TREE SERVICES LTD | Suspense | 0.0% | GBP 1140.00 | GBP 0.00 | GBP 1140.00 | GBP 22402.79 | |
|
Client:
ALL TREE SERVICES LTD
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 1140.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-04 | Tansy Megaw & Orijit Banerji (Rishi and Kavi) | TANSY MEGAW | Suspense | 0.0% | GBP 152.00 | GBP 0.00 | GBP 152.00 | GBP 22554.79 | |
|
Client:
TANSY MEGAW
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 152.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-05 | M McCready (Trial Day) | m mccready | Sales | 0.0% | GBP 70.00 | GBP 0.00 | GBP 70.00 | GBP 22624.79 | |
|
Client:
m mccready
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 70.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | S Mills (CARVEL) | S MILLS CARVEL | Suspense | 0.0% | GBP 180.00 | GBP 0.00 | GBP 180.00 | GBP 22804.79 | |
|
Client:
S MILLS CARVEL
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-13 | COMPANIESHOUSE WEB FIL | COMPANIESHOUSE WEB | Suspense | 0.0% | GBP 34.00 | GBP 0.00 | GBP 34.00 | GBP 22770.79 | |
|
Client:
COMPANIESHOUSE WEB
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 34.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-13 | Pat Bailey (Accounts cheque) | PAT BAILEY | Suspense | 0.0% | GBP 15.00 | GBP 0.00 | GBP 15.00 | GBP 22755.79 | |
|
Client:
PAT BAILEY
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 15.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-14 | Amelia Bawden (Bursary repayment) | amelia bawden | Sales | 0.0% | GBP 140.00 | GBP 0.00 | GBP 140.00 | GBP 22895.79 | |
|
Client:
amelia bawden
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 140.00
VAT Amount:
GBP 0.00
|
|||||||||