Date
Description
Ledger (USD)
Bank (USD)
Variance (USD)
Source
Status
4
01 Oct
1200 Trade debtors - Aldermere Ltd
$142,800.00
$142,800.00
$0.00
INV-40118
Matched
5
01 Oct
1200 Trade debtors - Vantor BV
$88,150.00
$88,150.00
$0.00
INV-40119
Matched
6
02 Oct
6200 Rent - Q4 prepayment
$42,000.00
$42,000.00
$0.00
PRP-0412
Matched
7
03 Oct
1200 Trade debtors - Helion SA
$58,240.00
$58,240.00
$0.00
INV-40122
Matched
8
03 Oct
2100 Trade creditors - Kestrel Print
-
$9,420.00
$9,420.00
No document
Unmatched payment
9
04 Oct
7000 Payroll - October run 1
$204,800.00
$204,800.00
$0.00
HRIS-1044
Matched
10
05 Oct
2100 Trade creditors - Hallam Freight
$31,600.00
$31,600.00
$0.00
PO-8871
Matched
11
06 Oct
7100 Insurance - annual premium
$18,650.00
$18,650.00
$0.00
INS-2210
Matched
12
07 Oct
1200 Trade debtors - Aldermere Ltd
$142,800.00
$142,800.00
$0.00
INV-40118
Possible duplicate
13
07 Oct
2100 Trade creditors - Delta Freight
$6,120.40
$6,120.40
$0.00
AP-7781
Matched
14
08 Oct
4000 Revenue - Orbis Group SOW 4
$124,500.00
$124,500.00
$0.00
INV-40158
Matched
15
09 Oct
2202 VAT control - Q3 provision
$46,300.00
$41,670.00
$4,630.00
VAT rate 21% vs 9%
VAT code mismatch
16
10 Oct
7400 Travel and fuel - card settlement
$4,318.55
$4,318.55
$0.00
EXP-2210
Matched
17
10 Oct
7400 Travel and fuel - Q4 advances
$2,880.00
$2,880.00
$0.00
EXP-2208
Matched
18
11 Oct
1200 Trade debtors - Kestrel Print
$11,300.00
$11,300.00
$0.00
INV-40163
Matched
19
12 Oct
2100 Trade creditors - Northgate Ltd
$52,000.00
$52,900.00
$900.00
PO-8902
Variance over 1%
20
13 Oct
4900 Interest received - treasury
-
$1,244.10
$1,244.10
BANK-76
Unposted
21
14 Oct
1200 Trade debtors - Orbis Group
$76,500.00
$76,500.00
$0.00
INV-40131
Matched
22
14 Oct
6100 Utilities - October
$3,940.75
$3,940.75
$0.00
UTL-0910
Matched
23
15 Oct
2100 Trade creditors - Kestrel Print
$9,420.00
-
$9,420.00
PO-8918
Missing document
24
16 Oct
2202 VAT control - October accrual
$21,480.00
$21,480.00
$0.00
VAT-1004
Matched
25
17 Oct
7902 FX revaluation - GBP/USD
$8,410.00
$8,410.00
$0.00
FX-0088
Matched
26
17 Oct
1200 Trade debtors - Vantor BV
€76,900.00
$88,150.00
$11,250.00
Booked in EUR
Currency mismatch
27
18 Oct
2100 Trade creditors - Hallam Freight
$14,760.00
$14,760.00
$0.00
AP-7802
Matched
28
19 Oct
7902 FX revaluation - EUR/GBP
$12,940.00
$11,208.00
$1,732.00
Rate 31 Aug
Stale FX rate
29
20 Oct
2100 Trade creditors - Hallam Freight
$18,240.00
$18,240.00
$0.00
PO-8931
Matched
30
20 Oct
4000 Revenue - Vantor BV retainer
$36,000.00
$36,000.00
$0.00
INV-40170
Matched
31
21 Oct
7906 Bank charges - October
-
$1,180.00
$1,180.00
Sept charges
Wrong period
32
22 Oct
1200 Trade debtors - Larkfield Ltd
$63,900.00
$63,900.00
$0.00
INV-40156
Matched
33
23 Oct
2100 Trade creditors - Quorum Legal
$24,500.00
$24,500.00
$0.00
PO-8944
Matched
34
24 Oct
1810 Intercompany - BV to Ltd
$150,000.00
-
$150,000.00
ICO-0042
Unmatched transfer
35
24 Oct
7502 Software subscriptions - card
$7,806.20
$7,806.20
$0.00
EXP-2231
Matched
36
25 Oct
7000 Payroll - October run 2
$198,400.00
$198,400.00
$0.00
HRIS-1051
Matched
37
26 Oct
1200 Trade debtors - Orbis Group
$76,500.00
$76,500.00
$0.00
INV-40161
Matched