Demo workspace · synthetic data · Foresail, FP&A that sets itself up
FY27Actuals to Sep-26Budget: FY27 budgetNWES · entity budgetGrid basis: Partner cross-sales are a memo lineGBP thousandsXero

Account review · Sep-26

1 flag: 1 possible missing invoice, 0 unusual swings · 0 of 1 flag explained · 5 mapped accounts in NWES · click a figure to see its months

AccountLineActualBudget*Var3-month avgvs avgFlagExplanation
430 · AdvertisingSales & marketing0.0−9.7+9.7−11.3+11.3Missing invoice?
200 · Withdrawal feesRevenue157.7157.70.0158.6−0.8
310 · HostingDirect costs−20.7−19.0−1.7−20.6−0.1
401 · Salaries: salesSales staff−50.5−58.8+8.3−50.8+0.3
497 · Foreign currency gains and lossesFX gains and losses3.10.0+3.11.8+1.3

Flags: an account with nothing this month after 3 months with activity (possible missing invoice), or more than 30% and £2k away from its 3-month average. *Budget is set per line, so each account's share follows its last 3 months, or an equal split when those are empty or mixed. Positive variance is favourable.

Draft accruals · Sep-26

Supplier cost accounts with no invoice in Sep-26 after a cost in each of the 3 months before, accrued at their 3-month average, in each entity's own currency · finance and admins

AccountLineAccrueGBPk
430 · AdvertisingSales & marketing€13,440.1111.3
⤓ NWES journal for Xero

Each file is a manual journal in Xero's import layout (Accounting, Manual journals, Import) dated Sep-26's last day: a debit to each cost account and one credit to NWES: 810 Accruals. Tax rate is "No VAT". Foresail never posts it: check the amounts, import it as a draft in Xero and set it to reverse next month. Accounts already explained above may not need one.

Draft prepayments · Sep-26

Supplier cost accounts with a cost in Sep-26 at least 3 times their 3-month average, such as a year's licence or policy invoiced at once: the cost above the average spread over 12 months, in each entity's own currency · finance and admins

No supplier cost account has a cost in Sep-26 far above its usual run for NWES.