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 |
|---|---|---|---|---|---|---|---|---|---|
| 2024-09-05 | Joanne Rogers (COHEN deposit) | joanne rogers | Sales | 0.0% | GBP 60.00 | GBP 0.00 | GBP 60.00 | GBP 9590.37 | |
|
Client:
joanne rogers
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 60.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-05 | Jenny Aranha (Overpayment refund) | JENNY ARANHA OVERPAYMENT | Suspense | 0.0% | GBP 42.00 | GBP 0.00 | GBP 42.00 | GBP 9548.37 | |
|
Client:
JENNY ARANHA OVERPAYMENT
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 42.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-05 | Smith Samantha (WILLOW DEPOSIT) | smith samantha | Sales | 0.0% | GBP 60.00 | GBP 0.00 | GBP 60.00 | GBP 9608.37 | |
|
Client:
smith samantha
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 60.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-06 | ONLINEDBSCHECKS.CO.UK | ONLINEDBSCHECKSCOUK | Suspense | 0.0% | GBP 69.80 | GBP 0.00 | GBP 69.80 | GBP 9538.57 | |
|
Client:
ONLINEDBSCHECKSCOUK
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 69.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-10 | Hannah Matthews (RU) | HANNAH MATTHEWS | Suspense | 0.0% | GBP 44.00 | GBP 0.00 | GBP 44.00 | GBP 9582.57 | |
|
Client:
HANNAH MATTHEWS
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 44.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-15 | giffgaff | GIFFGAFF | Suspense | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP 9572.57 | |
|
Client:
GIFFGAFF
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-17 | Bon O'hara (Bons update servic) | bon o'hara | Wages | 0.0% | GBP 13.00 | GBP 0.00 | GBP 13.00 | GBP 9585.57 | |
|
Client:
bon o'hara
Category:
Wages
VAT %:
0.0%
Net Amount:
GBP 13.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-18 | DISCLOSURE & BARRING | DISCLOSURE BARRING | Suspense | 0.0% | GBP 13.00 | GBP 0.00 | GBP 13.00 | GBP 9562.60 | |
|
Client:
DISCLOSURE BARRING
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 13.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-18 | AMAZON* T612X9M54 | AMAZON | Suspense | 0.0% | GBP 49.87 | GBP 0.00 | GBP 49.87 | GBP 9512.73 | |
|
Client:
AMAZON
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 49.87
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-18 | AMZNMktplace*T68529VG4 | unknown | Suspense | 0.0% | GBP 9.97 | GBP 0.00 | GBP 9.97 | GBP 9575.60 | |
|
Client:
unknown
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 9.97
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-19 | AMAZON* T63G09QX4 | AMAZON | Suspense | 0.0% | GBP 17.99 | GBP 0.00 | GBP 17.99 | GBP 9494.74 | |
|
Client:
AMAZON
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 17.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-19 | MACDONALD NJ (RESILIENCE REFUND) | MACDONALD | Suspense | 0.0% | GBP 33.00 | GBP 0.00 | GBP 33.00 | GBP 9527.74 | |
|
Client:
MACDONALD
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 33.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-19 | Dean Brodrick (17 sep) | DEAN | Suspense | 0.0% | GBP 90.00 | GBP 0.00 | GBP 90.00 | GBP 9437.74 | |
|
Client:
DEAN
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 90.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-20 | NSPCC | NSPCC | Charitable donations | 0.0% | GBP 30.00 | GBP 0.00 | GBP 30.00 | GBP 9032.29 | |
|
Client:
NSPCC
Category:
Charitable donations
VAT %:
0.0%
Net Amount:
GBP 30.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-20 | AMAZON* T62FG1754 | AMAZON | Suspense | 0.0% | GBP 7.99 | GBP 0.00 | GBP 7.99 | GBP 9024.30 | |
|
Client:
AMAZON
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 7.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-20 | MORTON MICHEL LTD | morton michel ltd | Insurance | 0.0% | GBP 375.45 | GBP 0.00 | GBP 375.45 | GBP 9062.29 | |
|
Client:
morton michel ltd
Category:
Insurance
VAT %:
0.0%
Net Amount:
GBP 375.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-22 | BAWDEN AL (LILLIE C) | amelia bawden | Sales | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 9044.30 | |
|
Client:
amelia bawden
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-24 | AMAZON* TH67M90V4 | AMAZON | Suspense | 0.0% | GBP 32.67 | GBP 0.00 | GBP 32.67 | GBP 9011.63 | |
|
Client:
AMAZON
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 32.67
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-24 | Southern Co-op Retail | SOUTHERN COOP | Suspense | 0.0% | GBP 10.25 | GBP 0.00 | GBP 10.25 | GBP 9001.38 | |
|
Client:
SOUTHERN COOP
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 10.25
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-09-25 | Sonja Burniston (059) | SONJA BURNISTON | Suspense | 0.0% | GBP 210.00 | GBP 0.00 | GBP 210.00 | GBP 8701.38 | |
|
Client:
SONJA BURNISTON
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 210.00
VAT Amount:
GBP 0.00
|
|||||||||