GPT Analysis: Excel data processed directly from structured columns; Date Gap Analysis: Found 7 gaps > 7 days: 04/23/2025 to 05/02/2025 (9 days), 06/23/2025 to 07/01/2025 (8 days), 11/17/2025 to 12/05/2025 (18 days), 12/05/2025 to 12/15/2025 (10 days), 12/15/2025 to 01/08/2026 (24 days), 01/15/2026 to 02/04/2026 (20 days), 02/16/2026 to 03/09/2026 (21 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2026-01-09 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 3300.00 | GBP 0.00 | GBP 3300.00 | GBP -3604.08 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 3300.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-01-09 | Direct Credit From Coyle Personnel Ref: Coyles Payroll | coyle personnel | Sales | 0.0% | GBP 3652.80 | GBP 0.00 | GBP 3652.80 | GBP 48.72 | |
|
Client:
coyle personnel
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 3652.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-01-12 | Card Purchase Fredericks Bar and On 10 Jan | FREDERICKS BAR AND | Travel | 0.0% | GBP 3.85 | GBP 0.00 | GBP 3.85 | GBP 44.87 | |
|
Client:
FREDERICKS BAR AND
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.85
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-01-12 | Card Purchase Premier Fountain S On 11 Jan | PPOINT FOUNTAIN | Travel | 0.0% | GBP 4.55 | GBP 0.00 | GBP 4.55 | GBP 40.32 | |
|
Client:
PPOINT FOUNTAIN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 4.55
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-01-12 | Card Purchase Hensol Golf Academ On 09 Jan | HENSOL GOLF | DLA | 0.0% | GBP 14.00 | GBP 0.00 | GBP 14.00 | GBP 26.32 | |
|
Client:
HENSOL GOLF
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 14.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-01-12 | Card Purchase Lbg L1149 Merthyr On 10 Jan | merthyr tydfil low | Fuel | 0.0% | GBP 25.00 | GBP 0.00 | GBP 25.00 | GBP 1.32 | |
|
Client:
merthyr tydfil low
Category:
Fuel
VAT %:
0.0%
Net Amount:
GBP 25.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-01-15 | Direct Debit to Barclays Ref: 0620A6538264745 | direct debit to barclays ref: 0620a6538264745 | BBL | 0.0% | GBP 142.50 | GBP 0.00 | GBP 142.50 | GBP -141.18 | |
|
Client:
direct debit to barclays ref: 0620a6538264745
Category:
BBL
VAT %:
0.0%
Net Amount:
GBP 142.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-04 | Interest Charged For The Period 15 Dec 2025 - 12 Jan 2026 | INTEREST CHARGED | Bank Charges | 0.0% | GBP 5.91 | GBP 0.00 | GBP 5.91 | GBP -147.09 | |
|
Client:
INTEREST CHARGED
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 5.91
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-04 | Commission Charges For The Period 15 Dec 2025/12 Jan 2026 | commission charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP -155.59 | |
|
Client:
commission charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-06 | Direct Credit From HMRC PAYE Ref: 120PD02931452 | hmrc paye | Paye | 0.0% | GBP 5357.02 | GBP 0.00 | GBP 5357.02 | GBP 5201.43 | |
|
Client:
hmrc paye
Category:
Paye
VAT %:
0.0%
Net Amount:
GBP 5357.02
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-09 | Card Purchase King Brychan On 07 Feb | KING BRYCHAN | Travel | 0.0% | GBP 18.38 | GBP 0.00 | GBP 18.38 | GBP 5183.05 | |
|
Client:
KING BRYCHAN
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 18.38
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-09 | Card Purchase Lbg L1149 Merthyr On 07 Feb | LBG L1149 MERTHYR | Other Expense | 0.0% | GBP 25.00 | GBP 0.00 | GBP 25.00 | GBP 5158.05 | |
|
Client:
LBG L1149 MERTHYR
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 25.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-09 | Card Purchase Lbg L1149 Merthyr On 07 Feb | LBG L1149 MERTHYR | Other Expense | 0.0% | GBP 30.00 | GBP 0.00 | GBP 30.00 | GBP 5128.05 | |
|
Client:
LBG L1149 MERTHYR
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 30.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-09 | Card Purchase Lbg L1149 Merthyr On 07 Feb | LBG L1149 MERTHYR | Other Expense | 0.0% | GBP 50.00 | GBP 0.00 | GBP 50.00 | GBP 5078.05 | |
|
Client:
LBG L1149 MERTHYR
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 50.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-09 | Card Purchase Lbg L1149 Merthyr On 07 Feb | LBG L1149 MERTHYR | Other Expense | 0.0% | GBP 50.00 | GBP 0.00 | GBP 50.00 | GBP 5028.05 | |
|
Client:
LBG L1149 MERTHYR
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 50.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-09 | Card Purchase Cr Ltd Alexand AV On 08 Feb | CR LTD | Repairs | 0.0% | GBP 50.00 | GBP 0.00 | GBP 50.00 | GBP 4978.05 | |
|
Client:
CR LTD
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 50.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-09 | Card Purchase Tyreman Merthyr LT On 06 Feb | tyreman merthyr lt | Motor | 0.0% | GBP 139.90 | GBP 0.00 | GBP 139.90 | GBP 4838.15 | |
|
Client:
tyreman merthyr lt
Category:
Motor
VAT %:
0.0%
Net Amount:
GBP 139.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-10 | On-Line Banking Bill Payment to Mr Kerry M Jones Ref: Kaagrace | Mr Kerry M Jones | DLA | 0.0% | GBP 4800.00 | GBP 0.00 | GBP 4800.00 | GBP 38.15 | |
|
Client:
Mr Kerry M Jones
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 4800.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-10 | Card Purchase PMG Catering On 10 Feb | PMG CATERING | Travel | 0.0% | GBP 3.25 | GBP 0.00 | GBP 3.25 | GBP 34.90 | |
|
Client:
PMG CATERING
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 3.25
VAT Amount:
GBP 0.00
|
|||||||||
| 2026-02-12 | Card Purchase Nyx*Pmgcatering On 11 Feb | PMG CATERING | Travel | 0.0% | GBP 0.80 | GBP 0.00 | GBP 0.80 | GBP 34.10 | |
|
Client:
PMG CATERING
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 0.80
VAT Amount:
GBP 0.00
|
|||||||||