GPT Analysis: Excel data processed directly from structured columns; Date Gap Analysis: Found 10 gaps > 7 days: 12/09/2024 to 12/17/2024 (8 days), 12/18/2024 to 01/02/2025 (15 days), 01/09/2025 to 01/20/2025 (11 days), 01/20/2025 to 01/28/2025 (8 days), 02/10/2025 to 02/18/2025 (8 days), 02/18/2025 to 02/28/2025 (10 days), 04/09/2025 to 04/17/2025 (8 days), 04/22/2025 to 05/06/2025 (14 days), 05/09/2025 to 05/19/2025 (10 days), 05/19/2025 to 06/06/2025 (18 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2024-10-21 | RETURNED DD | returned hmrc | CT | 0.0% | GBP 45.49 | GBP 0.00 | GBP 45.49 | GBP 29.27 | |
|
Client:
returned hmrc
Category:
CT
VAT %:
0.0%
Net Amount:
GBP 45.49
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-21 | SERVICE CHARGES REF : 438541276 | bank charge | Bank fees | 10.0% | GBP 7.73 | GBP 0.77 | GBP 8.50 | GBP 20.77 | |
|
Client:
bank charge
Category:
Bank fees
VAT %:
10.0%
Net Amount:
GBP 7.73
VAT Amount:
GBP 0.77
|
|||||||||
| 2024-10-25 | QDOS CONTRACTOR 127994 | qdos | Insurance | 20.0% | GBP 37.91 | GBP 7.58 | GBP 45.49 | GBP -24.72 | |
|
Client:
qdos
Category:
Insurance
VAT %:
20.0%
Net Amount:
GBP 37.91
VAT Amount:
GBP 7.58
|
|||||||||
| 2024-10-25 | MISTY LOOBY LIMITE 309781 60565968 | mistie looby | DLA | 20.0% | GBP 83.33 | GBP 16.67 | GBP 100.00 | GBP 75.28 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 83.33
VAT Amount:
GBP 16.67
|
|||||||||
| 2024-10-25 | MISTY LOOBY LIMITE 309781 60565968 | mistie looby | DLA | 20.0% | GBP 25.00 | GBP 5.00 | GBP 30.00 | GBP 105.28 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 25.00
VAT Amount:
GBP 5.00
|
|||||||||
| 2024-10-25 | ALICJA KORBINSKA 300000001448857932 MISTY | no_match | Uncategorized | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 5.28 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-28 | ASDA STORES CD 1438 27OCT24 | no_match | Uncategorized | 20.0% | GBP 20.83 | GBP 4.17 | GBP 25.00 | GBP 0.28 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
20.0%
Net Amount:
GBP 20.83
VAT Amount:
GBP 4.17
|
|||||||||
| 2024-10-28 | M LOOBY LOAN TO BUSINESS 100000001436908710 309871 | mistie looby | DLA | 20.0% | GBP 16.67 | GBP 3.33 | GBP 20.00 | GBP 25.28 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 16.67
VAT Amount:
GBP 3.33
|
|||||||||
| 2024-10-28 | MISTY LOOBY LIMITE 309781 60565968 26OCT24 | mistie looby | DLA | 20.0% | GBP 16.67 | GBP 3.33 | GBP 20.00 | GBP 25.28 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 16.67
VAT Amount:
GBP 3.33
|
|||||||||
| 2024-10-28 | MISTIE LOOBY 300000001449509127 SALARY | mistie looby | DLA | 20.0% | GBP 16.67 | GBP 3.33 | GBP 20.00 | GBP 5.28 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 16.67
VAT Amount:
GBP 3.33
|
|||||||||
| 2024-10-29 | M LOOBY LOAN TO BUSINESS 400000001452717825 309871 | mistie looby | DLA | 20.0% | GBP 18.33 | GBP 3.67 | GBP 22.00 | GBP 22.28 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 18.33
VAT Amount:
GBP 3.67
|
|||||||||
| 2024-10-30 | EE LIMITED CD 1438 | ee limited | Phone | 0.0% | GBP 22.00 | GBP 0.00 | GBP 22.00 | GBP 0.28 | |
|
Client:
ee limited
Category:
Phone
VAT %:
0.0%
Net Amount:
GBP 22.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-31 | MISTY LOOBY LIMITE 309781 60565968 | mistie looby | DLA | 20.0% | GBP 65.00 | GBP 13.00 | GBP 78.00 | GBP 78.28 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 65.00
VAT Amount:
GBP 13.00
|
|||||||||
| 2024-10-31 | M LOOBY LOAN TO BUSINESS 100000001439771603 309871 | mistie looby | DLA | 20.0% | GBP 0.83 | GBP 0.17 | GBP 1.00 | GBP 79.28 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 0.83
VAT Amount:
GBP 0.17
|
|||||||||
| 2024-10-31 | MISTY LOOBY LIMITE 309781 60565968 | mistie looby | DLA | 20.0% | GBP 1.00 | GBP 0.20 | GBP 1.20 | GBP 80.48 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 1.00
VAT Amount:
GBP 0.20
|
|||||||||
| 2024-11-01 | Canva* 04320-56080 CD 1438 | canva | IT software | 0.0% | GBP 13.00 | GBP 0.00 | GBP 13.00 | GBP 67.48 | |
|
Client:
canva
Category:
IT software
VAT %:
0.0%
Net Amount:
GBP 13.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-01 | EE LIMITED CD 1438 | ee limited | Phone | 0.0% | GBP 65.85 | GBP 0.00 | GBP 65.85 | GBP 1.63 | |
|
Client:
ee limited
Category:
Phone
VAT %:
0.0%
Net Amount:
GBP 65.85
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-04 | MISTY LOOBY LIMITE 309781 60565968 | mistie looby | DLA | 20.0% | GBP 6.67 | GBP 1.33 | GBP 8.00 | GBP 9.63 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 6.67
VAT Amount:
GBP 1.33
|
|||||||||
| 2024-11-04 | DNH*GODADDY#338796 CD 1438 | go daddy | IT software | 0.0% | GBP 8.99 | GBP 0.00 | GBP 8.99 | GBP 0.64 | |
|
Client:
go daddy
Category:
IT software
VAT %:
0.0%
Net Amount:
GBP 8.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-05 | MISTY LOOBY LIMITE 309781 60565968 | mistie looby | DLA | 20.0% | GBP 216.67 | GBP 43.33 | GBP 260.00 | GBP 9.05 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 216.67
VAT Amount:
GBP 43.33
|
|||||||||