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 |
|---|---|---|---|---|---|---|---|---|---|
| 2024-12-30 | Primecare Domiciliary Services Ltd / ref: Primecare week 52 | Primecare Domiciliary Services Ltd | Sales | 0.0% | GBP 1006.00 | GBP 0.00 | GBP 1006.00 | GBP 1300.42 | |
|
Client:
Primecare Domiciliary Services Ltd
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 1006.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-30 | 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 1200.42 | |
|
Client:
mr rhys c morgan salary
Category:
Directors Salary
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-30 | 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 1100.42 | |
|
Client:
mr rhys c morgan salary
Category:
Directors Salary
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-30 | MR RHYS C MORGAN / ref: Holiday | mr rhys c morgan salary | Directors Salary | 0.0% | GBP 230.00 | GBP 0.00 | GBP 230.00 | GBP 870.42 | |
|
Client:
mr rhys c morgan salary
Category:
Directors Salary
VAT %:
0.0%
Net Amount:
GBP 230.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-31 | GREGGS PLC - Western Avenue Retail Park, CARDIFF Tide Card: **** **** **** 6433 | GREGGS | TRAVEL | 0.0% | GBP 6.15 | GBP 0.00 | GBP 6.15 | GBP 864.27 | |
|
Client:
GREGGS
Category:
TRAVEL
VAT %:
0.0%
Net Amount:
GBP 6.15
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-31 | 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 714.27 | |
|
Client:
mr rhys c morgan salary
Category:
Directors Salary
VAT %:
0.0%
Net Amount:
GBP 150.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-31 | MR RHYS C MORGAN / ref: Rent | mr rhys c morgan salary | Directors Salary | 0.0% | GBP 200.00 | GBP 0.00 | GBP 200.00 | GBP 514.27 | |
|
Client:
mr rhys c morgan salary
Category:
Directors Salary
VAT %:
0.0%
Net Amount:
GBP 200.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-01 | MR RHYS C MORGAN / ref: Food | mr rhys c morgan salary | Directors Salary | 0.0% | GBP 40.00 | GBP 0.00 | GBP 40.00 | GBP 417.81 | |
|
Client:
mr rhys c morgan salary
Category:
Directors Salary
VAT %:
0.0%
Net Amount:
GBP 40.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-01 | GREGGS - 37 DUNRAVEN STREET, TONYPANDY Tide Card: **** **** **** 6433 | GREGGS | TRAVEL | 0.0% | GBP 4.85 | GBP 0.00 | GBP 4.85 | GBP 457.81 | |
|
Client:
GREGGS
Category:
TRAVEL
VAT %:
0.0%
Net Amount:
GBP 4.85
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-01 | TESCO PFS 3747 - WESTERN AVENUE, CARDIFF 3 Tide Card: **** **** **** 6433 | tesco pfs | Fuel | 0.0% | GBP 51.61 | GBP 0.00 | GBP 51.61 | GBP 462.66 | |
|
Client:
tesco pfs
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 51.61
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-02 | GOCARDLESS / ref: PROGRESSIVEP-N75SS | GOCARDLESS PROGRESSIVEPN75SS | Insurance | 0.0% | GBP 145.00 | GBP 0.00 | GBP 145.00 | GBP 233.83 | |
|
Client:
GOCARDLESS PROGRESSIVEPN75SS
Category:
Insurance
VAT %:
0.0%
Net Amount:
GBP 145.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-02 | MR RHYS C MORGAN / ref: Food | mr rhys c morgan salary | Directors Salary | 0.0% | GBP 50.00 | GBP 0.00 | GBP 50.00 | GBP 183.83 | |
|
Client:
mr rhys c morgan salary
Category:
Directors Salary
VAT %:
0.0%
Net Amount:
GBP 50.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-02 | IGNITIONPAY / ref: 2B6D754FB28A | ignitionpay | Accountancy | 0.0% | GBP 38.98 | GBP 0.00 | GBP 38.98 | GBP 378.83 | |
|
Client:
ignitionpay
Category:
Accountancy
VAT %:
0.0%
Net Amount:
GBP 38.98
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-03 | SPAR SOUTH MOLTON - 3-4 BROAD STREET, MOLTON Tide Card: **** **** **** 6433 | SPAR SOUTH MOLTON | TRAVEL | 0.0% | GBP 6.03 | GBP 0.00 | GBP 6.03 | GBP 177.80 | |
|
Client:
SPAR SOUTH MOLTON
Category:
TRAVEL
VAT %:
0.0%
Net Amount:
GBP 6.03
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-04 | SIPP FOOD (CORBY) LTD - 1 BRAUNTON ROAD, DEVON Tide Card: **** **** **** 6433 | SIPP FOOD | TRAVEL | 0.0% | GBP 16.88 | GBP 0.00 | GBP 16.88 | GBP 160.92 | |
|
Client:
SIPP FOOD
Category:
TRAVEL
VAT %:
0.0%
Net Amount:
GBP 16.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-04 | STIKLEPATH - 28 Sticklepath Hill, BARNSTAPLE Tide Card: **** **** **** 6433 | STIKLEPATH | TRAVEL | 0.0% | GBP 43.04 | GBP 0.00 | GBP 43.04 | GBP 117.88 | |
|
Client:
STIKLEPATH
Category:
TRAVEL
VAT %:
0.0%
Net Amount:
GBP 43.04
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-04 | MCDONALDS 1136 - John Penrose Road, BARNSTAPLE Tide Card: **** **** **** 6433 | MCDONALDS | TRAVEL | 0.0% | GBP 12.37 | GBP 0.00 | GBP 12.37 | GBP 105.51 | |
|
Client:
MCDONALDS
Category:
TRAVEL
VAT %:
0.0%
Net Amount:
GBP 12.37
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-05 | ASDA PETROL 5132 - TAW WHARF, BARNSTAPLE Tide Card: **** **** **** 6433 | petrol | Fuel | 0.0% | GBP 4.50 | GBP 0.00 | GBP 4.50 | GBP 101.01 | |
|
Client:
petrol
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 4.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-06 | BP PEREGRINE ROUNDSWEL - A39 ATLANTIC HIGHWAY, BARNSTAPLE Tide Card: **** **** **** 6433 | BP MOTO TIVERTON SERVI | Fuel | 0.0% | GBP 30.19 | GBP 0.00 | GBP 30.19 | GBP 1084.82 | |
|
Client:
BP MOTO TIVERTON SERVI
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 30.19
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-06 | MR RHYS C MORGAN / ref: Pay | mr rhys c morgan salary | Directors Salary | 0.0% | GBP 70.00 | GBP 0.00 | GBP 70.00 | GBP 31.01 | |
|
Client:
mr rhys c morgan salary
Category:
Directors Salary
VAT %:
0.0%
Net Amount:
GBP 70.00
VAT Amount:
GBP 0.00
|
|||||||||