Transaction sitting in an account code with no other history this period - confirm correct coding.
| Type | Severity | Detail | £ Impact | Xero record |
|---|---|---|---|---|
| novel_account_activity | medium | Repairs & Maintenance almost never has activity, but £1,850.00 was coded there in 2025-05 - worth checking it's not miscoded. | £1,850.00 | transaction ↗ |
Two payments to the same payee, same amount, within 14 days - confirm not a duplicate before next reconciliation.
| Type | Severity | Detail | £ Impact | Xero record |
|---|---|---|---|---|
| duplicate_payment | high | Zurich Insurance paid twice: £1,800.00 on 2026-03-10 and again on 2026-03-13, 3 days apart. | £1,800.00 | transaction ↗ · transaction ↗ |
Customer invoice overdue - action per credit control policy.
| Type | Severity | Detail | £ Impact | Xero record |
|---|---|---|---|---|
| aged_receivable | high | The Camden Collective - Corporate Events owes £3,250.00, 42 days overdue (due 2026-05-24) - worth chasing before it becomes a write-off. | £3,250.00 | invoice ↗ |
| aged_receivable | high | The Camden Collective - Corporate Events owes £1,180.00, 79 days overdue (due 2026-04-17) - worth chasing before it becomes a write-off. | £1,180.00 | invoice ↗ |
Supplier bill unpaid past normal terms - confirm status (paid outside system, disputed, or genuinely outstanding).
| Type | Severity | Detail | £ Impact | Xero record |
|---|---|---|---|---|
| aged_payable | high | Bright Electric Co: £2,140.55 unpaid, 994 days overdue (due 2023-10-15). | £2,140.55 | invoice ↗ |
Statistical deviation from trailing average - not necessarily an error, but worth a look during review.
| Type | Severity | Detail | £ Impact | Xero record |
|---|---|---|---|---|
| variance | high | Bank Fees in 2026-03: £189.14 vs trailing 3-month average £134.51 (+41%). | £54.63 | transaction ↗ |
| variance | high | Bank Fees in 2026-04: £232.86 vs trailing 3-month average £155.12 (+50%). | £77.74 | transaction ↗ |
| variance | high | Card Processing Fees in 2025-12: £948.93 vs trailing 3-month average £376.95 (+152%). | £571.98 | transaction ↗ |
| variance | high | Card Processing Fees in 2026-03: £392.38 vs trailing 3-month average £777.68 (-50%). | £385.30 | transaction ↗ |
| variance | high | Comps & Complimentary in 2024-08: £222.71 vs trailing 3-month average £415.96 (-46%). | £193.25 | transaction ↗ |
| variance | high | Comps & Complimentary in 2025-04: £458.17 vs trailing 3-month average £269.99 (+70%). | £188.18 | transaction ↗ |
| variance | high | Comps & Complimentary in 2025-12: £535.78 vs trailing 3-month average £341.41 (+57%). | £194.37 | transaction ↗ |
| variance | high | Comps & Complimentary in 2026-01: £1,424.99 vs trailing 3-month average £408.99 (+248%). | £1,016.00 | transaction ↗ |
| variance | high | Comps & Complimentary in 2026-02: £255.79 vs trailing 3-month average £764.38 (-67%). | £508.59 | transaction ↗ |
| variance | high | Comps & Complimentary in 2026-03: £366.51 vs trailing 3-month average £738.85 (-50%). | £372.34 | transaction ↗ |
| variance | high | Comps & Complimentary in 2026-04: £260.95 vs trailing 3-month average £682.43 (-62%). | £421.48 | transaction ↗ |
| variance | high | Insurance in 2026-03: £3,600.00 vs trailing 3-month average £1,800.00 (+100%). | £1,800.00 | transaction ↗ · transaction ↗ |
| ratio_anomaly | high | Card fee rate (of sales) in 2025-12: 1.6% vs usual 0.9% (+88%), even though the raw pound amounts alone might look fine. | £444.85 | transaction ↗ |
| ratio_anomaly | high | Card fee rate (of sales) in 2026-01: 1.7% vs usual 1.1% (+53%), even though the raw pound amounts alone might look fine. | £240.90 | transaction ↗ |
| ratio_anomaly | high | Card fee rate (of sales) in 2026-03: 0.8% vs usual 1.7% (-53%), even though the raw pound amounts alone might look fine. | £446.66 | transaction ↗ |
| ratio_anomaly | high | Comps rate (of sales) in 2025-04: 0.9% vs usual 0.6% (+54%), even though the raw pound amounts alone might look fine. | £160.03 | transaction ↗ |
| ratio_anomaly | high | Comps rate (of sales) in 2026-01: 3.4% vs usual 0.8% (+314%), even though the raw pound amounts alone might look fine. | £1,080.81 | transaction ↗ |
| ratio_anomaly | high | Comps rate (of sales) in 2026-02: 0.7% vs usual 1.7% (-62%), even though the raw pound amounts alone might look fine. | £410.22 | transaction ↗ |
| ratio_anomaly | high | Comps rate (of sales) in 2026-03: 0.7% vs usual 1.7% (-56%), even though the raw pound amounts alone might look fine. | £463.30 | transaction ↗ |
| ratio_anomaly | high | Comps rate (of sales) in 2026-04: 0.6% vs usual 1.6% (-65%), even though the raw pound amounts alone might look fine. | £474.32 | transaction ↗ |
| variance | medium | Cost of Goods Sold in 2024-08: £10,558.16 vs trailing 3-month average £13,939.60 (-24%). | £3,381.44 | transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ |
| variance | medium | Cost of Goods Sold in 2025-07: £16,387.25 vs trailing 3-month average £13,311.47 (+23%). | £3,075.78 | transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ |
| variance | medium | Cost of Goods Sold in 2025-10: £11,997.31 vs trailing 3-month average £15,195.97 (-21%). | £3,198.66 | transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ |
| variance | medium | Cost of Goods Sold in 2025-12: £16,816.77 vs trailing 3-month average £12,499.75 (+35%). | £4,317.02 | transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ |
| variance | medium | Wet Cost of Sales (drinks) in 2024-08: £3,089.53 vs trailing 3-month average £4,120.04 (-25%). | £1,030.51 | transaction ↗ |
| variance | medium | Wet Cost of Sales (drinks) in 2025-07: £4,733.32 vs trailing 3-month average £3,787.02 (+25%). | £946.30 | transaction ↗ |
| variance | medium | Wet Cost of Sales (drinks) in 2025-10: £3,180.97 vs trailing 3-month average £4,354.79 (-27%). | £1,173.82 | transaction ↗ |
| variance | medium | Wet Cost of Sales (drinks) in 2025-12: £4,765.56 vs trailing 3-month average £3,572.48 (+33%). | £1,193.08 | transaction ↗ |
| variance | medium | Wet Cost of Sales (drinks) in 2026-02: £3,124.97 vs trailing 3-month average £4,010.36 (-22%). | £885.39 | transaction ↗ |
| variance | medium | Dry Cost of Sales (food) in 2023-12: £11,292.82 vs trailing 3-month average £9,348.27 (+21%). | £1,944.55 | transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ |
| variance | medium | Dry Cost of Sales (food) in 2024-01: £7,691.84 vs trailing 3-month average £9,810.34 (-22%). | £2,118.50 | transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ |
| variance | medium | Dry Cost of Sales (food) in 2024-08: £7,468.63 vs trailing 3-month average £9,819.56 (-24%). | £2,350.93 | transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ |
| variance | medium | Dry Cost of Sales (food) in 2025-07: £11,653.93 vs trailing 3-month average £9,524.45 (+22%). | £2,129.48 | transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ |
| variance | medium | Dry Cost of Sales (food) in 2025-12: £12,051.21 vs trailing 3-month average £8,927.27 (+35%). | £3,123.94 | transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ |
| variance | medium | Direct Wages in 2025-07: £14,807.01 vs trailing 3-month average £11,632.53 (+27%). | £3,174.48 | transaction ↗ |
| variance | medium | Direct Wages in 2026-01: £10,491.03 vs trailing 3-month average £14,004.53 (-25%). | £3,513.50 | transaction ↗ |
| variance | medium | Bank Fees in 2026-02: £156.22 vs trailing 3-month average £128.18 (+22%). | £28.04 | transaction ↗ |
| variance | medium | Bank Fees in 2026-05: £260.63 vs trailing 3-month average £192.74 (+35%). | £67.89 | transaction ↗ |
| variance | medium | Bank Fees in 2026-06: £291.01 vs trailing 3-month average £227.54 (+28%). | £63.47 | transaction ↗ |
| drift | medium | Bank Fees has crept up £127.32 (2025-12) to £291.01 (2026-06), a slow +129% rise a monthly snapshot wouldn't catch. | £493.26 | transaction ↗ · transaction ↗ |
| variance | medium | Card Processing Fees in 2024-08: £320.08 vs trailing 3-month average £429.81 (-26%). | £109.73 | transaction ↗ |
| variance | medium | Card Processing Fees in 2026-01: £694.68 vs trailing 3-month average £558.67 (+24%). | £136.01 | transaction ↗ |
| variance | medium | Card Processing Fees in 2026-04: £369.24 vs trailing 3-month average £592.17 (-38%). | £222.93 | transaction ↗ |
| variance | medium | Card Processing Fees in 2026-06: £469.08 vs trailing 3-month average £385.33 (+22%). | £83.75 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2023-10: £269.22 vs trailing 3-month average £356.07 (-24%). | £86.85 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2024-01: £240.02 vs trailing 3-month average £323.47 (-26%). | £83.45 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2024-02: £407.86 vs trailing 3-month average £313.74 (+30%). | £94.12 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2024-04: £431.82 vs trailing 3-month average £326.14 (+32%). | £105.68 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2024-07: £505.46 vs trailing 3-month average £391.41 (+29%). | £114.05 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2024-09: £288.75 vs trailing 3-month average £381.66 (-24%). | £92.91 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2024-10: £416.25 vs trailing 3-month average £338.97 (+23%). | £77.28 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2024-12: £446.95 vs trailing 3-month average £326.41 (+37%). | £120.54 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2025-01: £268.63 vs trailing 3-month average £379.14 (-29%). | £110.51 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2025-02: £225.40 vs trailing 3-month average £329.94 (-32%). | £104.54 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2025-06: £293.54 vs trailing 3-month average £383.92 (-24%). | £90.38 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2026-05: £411.50 vs trailing 3-month average £294.42 (+40%). | £117.08 | transaction ↗ |
| variance | medium | Comps & Complimentary in 2026-06: £454.17 vs trailing 3-month average £346.32 (+31%). | £107.85 | transaction ↗ |
| variance | medium | Insurance in 2026-06: £1,800.00 vs trailing 3-month average £2,400.00 (-25%). | £600.00 | transaction ↗ |
| ratio_anomaly | medium | Wages-to-sales ratio in 2024-08: 33.1% vs usual 26.4% (+26%), even though the raw pound amounts alone might look fine. | £2,408.51 | transaction ↗ |
| ratio_anomaly | medium | Wages-to-sales ratio in 2025-10: 37.0% vs usual 27.3% (+36%), even though the raw pound amounts alone might look fine. | £4,212.03 | transaction ↗ |
| ratio_anomaly | medium | Card fee rate (of sales) in 2026-02: 1.8% vs usual 1.4% (+29%), even though the raw pound amounts alone might look fine. | £155.54 | transaction ↗ |
| ratio_anomaly | medium | Card fee rate (of sales) in 2026-04: 0.8% vs usual 1.4% (-43%), even though the raw pound amounts alone might look fine. | £274.05 | transaction ↗ |
| ratio_anomaly | medium | Card fee rate (of sales) in 2026-05: 0.9% vs usual 1.1% (-22%), even though the raw pound amounts alone might look fine. | £110.34 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2023-11: 0.9% vs usual 0.7% (+26%), even though the raw pound amounts alone might look fine. | £78.03 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2023-12: 0.6% vs usual 0.7% (-20%), even though the raw pound amounts alone might look fine. | £78.92 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2024-02: 1.0% vs usual 0.7% (+44%), even though the raw pound amounts alone might look fine. | £123.84 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2024-04: 0.9% vs usual 0.8% (+21%), even though the raw pound amounts alone might look fine. | £73.83 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2024-07: 1.0% vs usual 0.9% (+20%), even though the raw pound amounts alone might look fine. | £82.72 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2024-08: 0.6% vs usual 0.9% (-30%), even though the raw pound amounts alone might look fine. | £96.95 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2024-09: 0.6% vs usual 0.8% (-30%), even though the raw pound amounts alone might look fine. | £122.94 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2024-10: 0.9% vs usual 0.7% (+19%), even though the raw pound amounts alone might look fine. | £67.23 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2024-11: 0.6% vs usual 0.7% (-19%), even though the raw pound amounts alone might look fine. | £62.37 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2024-12: 0.9% vs usual 0.7% (+25%), even though the raw pound amounts alone might look fine. | £89.51 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2025-01: 0.6% vs usual 0.8% (-25%), even though the raw pound amounts alone might look fine. | £89.66 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2025-09: 0.8% vs usual 0.6% (+22%), even though the raw pound amounts alone might look fine. | £59.99 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2025-10: 0.8% vs usual 0.7% (+18%), even though the raw pound amounts alone might look fine. | £56.01 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2026-05: 0.9% vs usual 0.7% (+40%), even though the raw pound amounts alone might look fine. | £116.55 | transaction ↗ |
| ratio_anomaly | medium | Comps rate (of sales) in 2026-06: 0.9% vs usual 0.7% (+20%), even though the raw pound amounts alone might look fine. | £74.29 | transaction ↗ |
Not a bookkeeping item - flagged for revenue forecasting and credit-control awareness.
| Type | Severity | Detail | £ Impact | Xero record |
|---|---|---|---|---|
| customer_churn | high | Borough Films Ltd - Wrap Parties: 6 bookings averaging £3,087.50, then nothing for 418 days (last booked 2025-05-13) - a high-value customer who's gone quiet. | £3,087.50 | transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ · transaction ↗ |