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 |
|---|---|---|---|---|---|---|---|---|---|
| 2025-01-09 | O/DRAFT INTEREST | rent | Rent | 5.0% | GBP 0.03 | GBP 0.00 | GBP 0.03 | GBP -41.76 | |
|
Client:
rent
Category:
Rent
VAT %:
5.0%
Net Amount:
GBP 0.03
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | SERVICE CHARGES REF : 445730885 | bank charge | Bank fees | 10.0% | GBP 7.73 | GBP 0.77 | GBP 8.50 | GBP -64.26 | |
|
Client:
bank charge
Category:
Bank fees
VAT %:
10.0%
Net Amount:
GBP 7.73
VAT Amount:
GBP 0.77
|
|||||||||
| 2025-01-28 | M LOOBY LOAN TO BUSINESS 200000001494738980 309871 | mistie looby | DLA | 20.0% | GBP 136.83 | GBP 27.37 | GBP 164.20 | GBP 99.94 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 136.83
VAT Amount:
GBP 27.37
|
|||||||||
| 2025-01-28 | M LOOBY LOAN TO BUSINESS 300000001502178972 309871 | mistie looby | DLA | 20.0% | GBP 0.17 | GBP 0.03 | GBP 0.20 | GBP 100.14 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 0.17
VAT Amount:
GBP 0.03
|
|||||||||
| 2025-01-28 | ALICJA KORBINSKA 400000001503597776 MISTY | no_match | Uncategorized | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 0.14 | |
|
Client:
no_match
Category:
Uncategorized
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-03 | Canva* 04412-44936 CD 1438 01FEB25 | canva | IT software | 0.0% | GBP 13.00 | GBP 0.00 | GBP 13.00 | GBP -12.86 | |
|
Client:
canva
Category:
IT software
VAT %:
0.0%
Net Amount:
GBP 13.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-04 | M LOOBY LOAN TO BUSINESS 300000001506745433 309871 | mistie looby | DLA | 20.0% | GBP 16.67 | GBP 3.33 | GBP 20.00 | GBP 7.14 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 16.67
VAT Amount:
GBP 3.33
|
|||||||||
| 2025-02-06 | DNH*GODADDY#356586 CD 1438 | go daddy | IT software | 0.0% | GBP 8.99 | GBP 0.00 | GBP 8.99 | GBP -1.85 | |
|
Client:
go daddy
Category:
IT software
VAT %:
0.0%
Net Amount:
GBP 8.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-07 | Adobe CD 1438 | adobe | IT software | 0.0% | GBP 29.96 | GBP 0.00 | GBP 29.96 | GBP -31.81 | |
|
Client:
adobe
Category:
IT software
VAT %:
0.0%
Net Amount:
GBP 29.96
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-10 | O/DRAFT INTEREST | rent | Rent | 5.0% | GBP 0.24 | GBP 0.01 | GBP 0.25 | GBP -32.06 | |
|
Client:
rent
Category:
Rent
VAT %:
5.0%
Net Amount:
GBP 0.24
VAT Amount:
GBP 0.01
|
|||||||||
| 2025-02-18 | SERVICE CHARGES REF : 448401996 | bank charge | Bank fees | 10.0% | GBP 7.73 | GBP 0.77 | GBP 8.50 | GBP -40.56 | |
|
Client:
bank charge
Category:
Bank fees
VAT %:
10.0%
Net Amount:
GBP 7.73
VAT Amount:
GBP 0.77
|
|||||||||
| 2025-02-28 | M LOOBY LOAN TO BUSINESS 100000001507344299 309871 | mistie looby | DLA | 20.0% | GBP 34.17 | GBP 6.83 | GBP 41.00 | GBP 0.44 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 34.17
VAT Amount:
GBP 6.83
|
|||||||||
| 2025-03-03 | 400000001523169291 309871 M LOOBY LOAN TO BUSINESS | mistie looby | DLA | 20.0% | GBP 10.83 | GBP 2.17 | GBP 13.00 | GBP 13.44 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 10.83
VAT Amount:
GBP 2.17
|
|||||||||
| 2025-03-04 | DNH*GODADDY#362065 CD 1438 | go daddy | IT software | 0.0% | GBP 8.99 | GBP 0.00 | GBP 8.99 | GBP 4.45 | |
|
Client:
go daddy
Category:
IT software
VAT %:
0.0%
Net Amount:
GBP 8.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-05 | M LOOBY LOAN TO BUSINESS 200000001515511291 309871 | mistie looby | DLA | 20.0% | GBP 16.67 | GBP 3.33 | GBP 20.00 | GBP 24.45 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 16.67
VAT Amount:
GBP 3.33
|
|||||||||
| 2025-03-05 | Canva* 04441-58829 CD 1438 | canva | IT software | 0.0% | GBP 13.00 | GBP 0.00 | GBP 13.00 | GBP 11.45 | |
|
Client:
canva
Category:
IT software
VAT %:
0.0%
Net Amount:
GBP 13.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-06 | COMPANIESHOUSE WEB CD 1438 | companies house | Sundry Expense | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP -8.55 | |
|
Client:
companies house
Category:
Sundry Expense
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-07 | Adobe CD 1438 | adobe | IT software | 0.0% | GBP 29.96 | GBP 0.00 | GBP 29.96 | GBP -38.51 | |
|
Client:
adobe
Category:
IT software
VAT %:
0.0%
Net Amount:
GBP 29.96
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-10 | O/DRAFT INTEREST | rent | Rent | 5.0% | GBP 0.49 | GBP 0.02 | GBP 0.51 | GBP -0.02 | |
|
Client:
rent
Category:
Rent
VAT %:
5.0%
Net Amount:
GBP 0.49
VAT Amount:
GBP 0.02
|
|||||||||
| 2025-03-10 | 300000001525487913 309871 M LOOBY LOAN TO BUSINESS | mistie looby | DLA | 20.0% | GBP 32.50 | GBP 6.50 | GBP 39.00 | GBP 0.49 | |
|
Client:
mistie looby
Category:
DLA
VAT %:
20.0%
Net Amount:
GBP 32.50
VAT Amount:
GBP 6.50
|
|||||||||