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-08-17 | GWAAC KEYNSHAM | GWAAC KEYNSHAM | Suspense | 0.0% | GBP 4.00 | GBP 0.00 | GBP 4.00 | GBP 22891.79 | |
|
Client:
GWAAC KEYNSHAM
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-17 | OXFAM F2809 | OXFAM F2809 | Suspense | 0.0% | GBP 4.00 | GBP 0.00 | GBP 4.00 | GBP 22887.79 | |
|
Client:
OXFAM F2809
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 4.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-18 | THE BRITISH RED CROSS | THE BRITISH | sundry | 0.0% | GBP 1.50 | GBP 0.00 | GBP 1.50 | GBP 22886.29 | |
|
Client:
THE BRITISH
Category:
sundry
VAT %:
0.0%
Net Amount:
GBP 1.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-23 | Amelia Bawden (Lillie) | amelia bawden | Sales | 0.0% | GBP 140.00 | GBP 0.00 | GBP 140.00 | GBP 23026.29 | |
|
Client:
amelia bawden
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 140.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-24 | FIELD STUDIES COUNCIL | FIELD STUDIES COUNCIL | Suspense | 0.0% | GBP 24.00 | GBP 0.00 | GBP 24.00 | GBP 23002.29 | |
|
Client:
FIELD STUDIES COUNCIL
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 24.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-24 | Amazon.co.uk*RU6X29RL4 | AMAZONCOUKRU6X29RL4 | Suspense | 0.0% | GBP 10.45 | GBP 0.00 | GBP 10.45 | GBP 22991.84 | |
|
Client:
AMAZONCOUKRU6X29RL4
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 10.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-24 | AMZNMktplace*RU2NO2R34 | unknown | Suspense | 0.0% | GBP 79.98 | GBP 0.00 | GBP 79.98 | GBP 22911.86 | |
|
Client:
unknown
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 79.98
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-24 | AMZNMktplace*RU72O8R54 | AMZNMKTPLACERU72O8R54 | Suspense | 0.0% | GBP 90.20 | GBP 0.00 | GBP 90.20 | GBP 22821.66 | |
|
Client:
AMZNMKTPLACERU72O8R54
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 90.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-24 | BAKER ROSS | BAKER ROSS | Suspense | 0.0% | GBP 25.90 | GBP 0.00 | GBP 25.90 | GBP 22795.76 | |
|
Client:
BAKER ROSS
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 25.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-24 | Amazon.co.uk*RU0T25WL4 | AMAZONCOUKRU0T25WL4 | Suspense | 0.0% | GBP 45.38 | GBP 0.00 | GBP 45.38 | GBP 22750.38 | |
|
Client:
AMAZONCOUKRU0T25WL4
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 45.38
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-24 | Bon O'hara (August 25) | bon o'hara | Wages | 0.0% | GBP 59.50 | GBP 0.00 | GBP 59.50 | GBP 22690.88 | |
|
Client:
bon o'hara
Category:
Wages
VAT %:
0.0%
Net Amount:
GBP 59.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-24 | Debbie Forster (August 25) | DEBBIE FORSTER | Suspense | 0.0% | GBP 180.00 | GBP 0.00 | GBP 180.00 | GBP 22510.88 | |
|
Client:
DEBBIE FORSTER
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-25 | Claire Imhasly (5m flooring, yurt) | CLAIRE IMHASLY | Wages | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 22410.88 | |
|
Client:
CLAIRE IMHASLY
Category:
Wages
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-25 | S Mills (Cecily) | S MILLS CECILY | Suspense | 0.0% | GBP 84.00 | GBP 0.00 | GBP 84.00 | GBP 22494.88 | |
|
Client:
S MILLS CECILY
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 84.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | M McCready (Rowan Deposit) | m mccready | Sales | 0.0% | GBP 180.00 | GBP 0.00 | GBP 180.00 | GBP 22674.88 | |
|
Client:
m mccready
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | S Mills (Carvel) | S MILLS CARVEL | Suspense | 0.0% | GBP 137.45 | GBP 0.00 | GBP 137.45 | GBP 22812.33 | |
|
Client:
S MILLS CARVEL
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 137.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | Claire Imhasly (Aug 25) | CLAIRE IMHASLY | Wages | 0.0% | GBP 1300.00 | GBP 0.00 | GBP 1300.00 | GBP 21512.33 | |
|
Client:
CLAIRE IMHASLY
Category:
Wages
VAT %:
0.0%
Net Amount:
GBP 1300.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | Jenny Aranha (Refund for August) | JENNY ARANHA REFUND | Suspense | 0.0% | GBP 72.00 | GBP 0.00 | GBP 72.00 | GBP 21440.33 | |
|
Client:
JENNY ARANHA REFUND
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 72.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | Ruth Bahadur (Refund for August) | RUTH BAHADUR | Suspense | 0.0% | GBP 140.00 | GBP 0.00 | GBP 140.00 | GBP 21300.33 | |
|
Client:
RUTH BAHADUR
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 140.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | Mel McCready (Refund for August) | m mccready | Sales | 0.0% | GBP 253.33 | GBP 0.00 | GBP 253.33 | GBP 21047.00 | |
|
Client:
m mccready
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 253.33
VAT Amount:
GBP 0.00
|
|||||||||