GPT Analysis: Excel data processed directly from structured columns; Date Gap Analysis: Found 5 gaps > 7 days: 07/02/2025 to 07/15/2025 (13 days), 07/29/2025 to 08/19/2025 (21 days), 08/19/2025 to 08/27/2025 (8 days), 09/02/2025 to 09/16/2025 (14 days), 09/16/2025 to 09/26/2025 (10 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2025-01-13 | Primecare Domiciliary Services Ltd / ref: Primecare week 1 | Primecare Domiciliary Services Ltd | Sales | 0.0% | GBP 813.00 | GBP 0.00 | GBP 813.00 | GBP 813.61 | |
|
Client:
Primecare Domiciliary Services Ltd
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 813.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-13 | MR RHYS C MORGAN / ref: Pay | mr rhys c morgan salary | Directors Salary | 0.0% | GBP 150.00 | GBP 0.00 | GBP 150.00 | GBP 663.61 | |
|
Client:
mr rhys c morgan salary
Category:
Directors Salary
VAT %:
0.0%
Net Amount:
GBP 150.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-15 | IGNITIONPAY / ref: 2B6D754FB28A | ignitionpay | Accountancy | 0.0% | GBP 38.98 | GBP 0.00 | GBP 38.98 | GBP 624.63 | |
|
Client:
ignitionpay
Category:
Accountancy
VAT %:
0.0%
Net Amount:
GBP 38.98
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-16 | TESCO PFS 4075 - TALBOT GREEN BYPASS/A4119, LLANTRISANT Tide Card: **** **** **** 6433 | tesco pfs | Fuel | 0.0% | GBP 44.24 | GBP 0.00 | GBP 44.24 | GBP 580.39 | |
|
Client:
tesco pfs
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 44.24
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-17 | WESSEX RETAIL LTD - SPAR, WHITESTONE Tide Card: **** **** **** 6433 | WESSEX RETAIL LTD | Fuel | 0.0% | GBP 3.50 | GBP 0.00 | GBP 3.50 | GBP 576.89 | |
|
Client:
WESSEX RETAIL LTD
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 3.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-17 | MR RHYS C MORGAN / ref: Pay | mr rhys c morgan salary | Directors Salary | 0.0% | GBP 150.00 | GBP 0.00 | GBP 150.00 | GBP 416.59 | |
|
Client:
mr rhys c morgan salary
Category:
Directors Salary
VAT %:
0.0%
Net Amount:
GBP 150.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-17 | WESSEX RETAIL LTD - SPAR, WHITESTONE Tide Card: **** **** **** 6433 | WESSEX RETAIL LTD | Fuel | 0.0% | GBP 2.35 | GBP 0.00 | GBP 2.35 | GBP 574.54 | |
|
Client:
WESSEX RETAIL LTD
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 2.35
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-17 | WAITROSE 480 - STATION ROAD, HOLSWORTHY Tide Card: **** **** **** 6433 | WAITROSE | TRAVEL | 0.0% | GBP 7.95 | GBP 0.00 | GBP 7.95 | GBP 566.59 | |
|
Client:
WAITROSE
Category:
TRAVEL
VAT %:
0.0%
Net Amount:
GBP 7.95
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-18 | WESSEX RETAIL LTD - SPAR, WHITESTONE Tide Card: **** **** **** 6433 | WESSEX RETAIL LTD | Fuel | 0.0% | GBP 4.45 | GBP 0.00 | GBP 4.45 | GBP 412.14 | |
|
Client:
WESSEX RETAIL LTD
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 4.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-18 | WESSEX RETAIL LTD - SPAR, WHITESTONE Tide Card: **** **** **** 6433 | WESSEX RETAIL LTD | Fuel | 0.0% | GBP 3.10 | GBP 0.00 | GBP 3.10 | GBP 409.04 | |
|
Client:
WESSEX RETAIL LTD
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 3.10
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-18 | BP HOLSWORTHY SF CONNE - BUDE ROAD, HOLSWORTHY Tide Card: **** **** **** 6433 | BP MOTO TIVERTON SERVI | Fuel | 0.0% | GBP 54.36 | GBP 0.00 | GBP 54.36 | GBP 354.68 | |
|
Client:
BP MOTO TIVERTON SERVI
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 54.36
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-19 | MCDONALDS 1136 - John Penrose Road, BARNSTAPLE Tide Card: **** **** **** 6433 | MCDONALDS | TRAVEL | 0.0% | GBP 22.55 | GBP 0.00 | GBP 22.55 | GBP 332.13 | |
|
Client:
MCDONALDS
Category:
TRAVEL
VAT %:
0.0%
Net Amount:
GBP 22.55
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | HMRC Shipley / ref: 5112667582K | HMRC SHIPLEY | CT | 0.0% | GBP 221.38 | GBP 0.00 | GBP 221.38 | GBP 1023.75 | |
|
Client:
HMRC SHIPLEY
Category:
CT
VAT %:
0.0%
Net Amount:
GBP 221.38
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | ref: Charge of 6.20 for Bank Transfers usage from 2024-12-01 to 2024-12-31 | CHARGE | Bank Charges | 0.0% | GBP 6.20 | GBP 0.00 | GBP 6.20 | GBP 812.55 | |
|
Client:
CHARGE
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 6.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | MR RHYS C MORGAN / ref: Pay | mr rhys c morgan salary | Directors Salary | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 818.75 | |
|
Client:
mr rhys c morgan salary
Category:
Directors Salary
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | MR RHYS C MORGAN / ref: Pay | mr rhys c morgan salary | Directors Salary | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 918.75 | |
|
Client:
mr rhys c morgan salary
Category:
Directors Salary
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | Primecare Domiciliary Services Ltd / ref: Primecare week 2 | Primecare Domiciliary Services Ltd | Sales | 0.0% | GBP 952.00 | GBP 0.00 | GBP 952.00 | GBP 1284.13 | |
|
Client:
Primecare Domiciliary Services Ltd
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 952.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | MCDONALDS 491 - Hollowtree Road, BARNSTAPLE Tide Card: **** **** **** 6433 | MCDONALDS | TRAVEL | 0.0% | GBP 5.00 | GBP 0.00 | GBP 5.00 | GBP 1018.75 | |
|
Client:
MCDONALDS
Category:
TRAVEL
VAT %:
0.0%
Net Amount:
GBP 5.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | TEXBIDEFORDS/STN - KINGSLEY ROAD, 887025EX392PJ Tide Card: **** **** **** 6433 | texbidefords/stn | Fuel | 0.0% | GBP 39.00 | GBP 0.00 | GBP 39.00 | GBP 1245.13 | |
|
Client:
texbidefords/stn
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 39.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-21 | STARBUCKS - MCARTHURGLEN, BRIDGEND Tide Card: **** **** **** 6433 | STARBUCKS | TRAVEL | 0.0% | GBP 6.85 | GBP 0.00 | GBP 6.85 | GBP 805.70 | |
|
Client:
STARBUCKS
Category:
TRAVEL
VAT %:
0.0%
Net Amount:
GBP 6.85
VAT Amount:
GBP 0.00
|
|||||||||