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-12-02 | LOWE B (LUCA) | lowe b | Sales | 0.0% | GBP 315.00 | GBP 0.00 | GBP 315.00 | GBP 9852.64 | |
|
Client:
lowe b
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 315.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | Taylor A P (OSCAR TAYLOR) | r taylor | Sales | 0.0% | GBP 99.00 | GBP 0.00 | GBP 99.00 | GBP 9274.64 | |
|
Client:
r taylor
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 99.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | Joanne Rogers (Cohen) | joanne rogers | Sales | 0.0% | GBP 126.00 | GBP 0.00 | GBP 126.00 | GBP 9175.64 | |
|
Client:
joanne rogers
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 126.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | M MEREDITH (RHYS MEREDITH) | m meredith | Sales | 0.0% | GBP 105.00 | GBP 0.00 | GBP 105.00 | GBP 9049.64 | |
|
Client:
m meredith
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 105.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | Emma Still (Mia Steel Mondays) | EMMA STILL | Suspense | 0.0% | GBP 198.00 | GBP 0.00 | GBP 198.00 | GBP 8944.64 | |
|
Client:
EMMA STILL
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 198.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | E BLACKMORE (MAIYA) | E BLACKMORE MAIYA | Suspense | 0.0% | GBP 198.00 | GBP 0.00 | GBP 198.00 | GBP 8746.64 | |
|
Client:
E BLACKMORE MAIYA
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 198.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | R BAHADUR (REUBEN BAHADUR) | R BAHADUR REUBEN | Suspense | 0.0% | GBP 108.90 | GBP 0.00 | GBP 108.90 | GBP 8548.64 | |
|
Client:
R BAHADUR REUBEN
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 108.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | M MCCREADY (ROBIN) | m mccready | Sales | 0.0% | GBP 263.00 | GBP 0.00 | GBP 263.00 | GBP 9537.64 | |
|
Client:
m mccready
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 263.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-03 | Crystal Errington-Deamer (Refund deposit) | CRYSTAL ERRINGTONDEAMER | Suspense | 0.0% | GBP 120.00 | GBP 0.00 | GBP 120.00 | GBP 9968.74 | |
|
Client:
CRYSTAL ERRINGTONDEAMER
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 120.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-03 | Rendall-Jones Rebecca (JOSH RENDALL JONES) | rendall-jones rebe | Sales | 0.0% | GBP 51.00 | GBP 0.00 | GBP 51.00 | GBP 10019.74 | |
|
Client:
rendall-jones rebe
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 51.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-05 | Adams Cindy (REX ADAMS) | ADAMS CINDY | Suspense | 0.0% | GBP 84.00 | GBP 0.00 | GBP 84.00 | GBP 10103.74 | |
|
Client:
ADAMS CINDY
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 84.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-05 | Hannah Matthews (RU) | HANNAH MATTHEWS | Suspense | 0.0% | GBP 44.00 | GBP 0.00 | GBP 44.00 | GBP 10147.74 | |
|
Client:
HANNAH MATTHEWS
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 44.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-09 | Amelia Bawden (Lillie) | amelia bawden | Sales | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 10247.74 | |
|
Client:
amelia bawden
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-09 | LIDL GB FROME | LIDL GB FROME | Suspense | 0.0% | GBP 3.98 | GBP 0.00 | GBP 3.98 | GBP 10585.00 | |
|
Client:
LIDL GB FROME
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 3.98
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-09 | LUTHER R M (BAY LUTHER) | unknown | Suspense | 0.0% | GBP 341.24 | GBP 0.00 | GBP 341.24 | GBP 10588.98 | |
|
Client:
unknown
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 341.24
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-10 | SAINSBURYS S/MKTS | SAINSBURYS | Travel and subsistence expenses | 0.0% | GBP 10.85 | GBP 0.00 | GBP 10.85 | GBP 10574.15 | |
|
Client:
SAINSBURYS
Category:
Travel and subsistence expenses
VAT %:
0.0%
Net Amount:
GBP 10.85
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-11 | Dean Brodrick (Dec) | DEAN | Suspense | 0.0% | GBP 180.00 | GBP 0.00 | GBP 180.00 | GBP 10394.15 | |
|
Client:
DEAN
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-12 | HMRC GOV.UK COTAX | HMRC GOVUK | Suspense | 0.0% | GBP 11.79 | GBP 0.00 | GBP 11.79 | GBP 10276.94 | |
|
Client:
HMRC GOVUK
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 11.79
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-12 | Victoria Delgado-scott (Dec) | victoria delgado-s | Wages | 0.0% | GBP 129.00 | GBP 0.00 | GBP 129.00 | GBP 10265.15 | |
|
Client:
victoria delgado-s
Category:
Wages
VAT %:
0.0%
Net Amount:
GBP 129.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-13 | Jennifer Davies (Dec) | JENNIFER DAVIES | Suspense | 0.0% | GBP 180.00 | GBP 0.00 | GBP 180.00 | GBP 10096.94 | |
|
Client:
JENNIFER DAVIES
Category:
Suspense
VAT %:
0.0%
Net Amount:
GBP 180.00
VAT Amount:
GBP 0.00
|
|||||||||