Reports & closing · Guide 43 of 53
Budgets: planning and variance without changing the books
Build monthly account or project plans, import scenarios, apply formulas, and compare them with accrual or cash actuals.
A budget is a plan beside the ledger, never a journal inside it. IQ Books stores monthly base-currency targets against the same revenue and expense accounts your reports use, then joins those targets to posted actuals when you ask for a variance. Editing, importing, copying or deleting a budget cannot change the trial balance.
Enable the planning workspace
Go to Settings → Features and enable Budgets. Two items appear under Reports: Budget manager and Budget variance. The dashboard adds one current-month signal. Turning the feature off removes those surfaces and stops budget API traffic; it retains plans and audit history.
Overall, scenario and project budgets
- Overall Budget is created automatically, cannot be renamed, copied or deleted, and is the default organisation plan.
- Named budgets are alternative whole-organisation scenarios such as Conservative, Target or Stretch. They can be copied and deleted.
- Project budgets use an IQ Books project as the natural equivalent of a tracking-filtered budget. Their actuals include only journal lines tagged to that project.
All budgets use the organisation base currency and whole calendar months. Amounts retain pence; unlike Xero, IQ Books does not round every budget cell to whole pounds.
Enter and fill monthly values
Open Reports → Budget manager, choose the start month and a 3, 6, 12, 18 or 24-month window, then enter positive or negative values beside revenue and expense accounts. The window opens aligned to your financial year (an April year-end plans April to March) until you pick a different start. Save writes all visible cells atomically and increments the budget version, so a stale browser cannot overwrite another user’s work.
The wand beside an account — or the Fill… button in the toolbar for every account at once — fills the chosen months using one of six formulas: same fixed amount, increase by a fixed amount, compound by a percentage, spread an annual total evenly (any rounding remainder lands on the final month so the row still sums to the total), copy from prior actuals (accrual, mapped month by month from the source month you pick — the fastest way to seed next year from this year), or clear to zero. Formula operations are server-side and audited, so the result is consistent for every client.
Import and export
Import accepts CSV, Excel and OpenDocument spreadsheets. The first worksheet is used. Column one must identify the account as Account name (code); remaining headers are months and populated cells are pound amounts. Blank cells are ignored; explicit zero replaces the existing value. Account names or codes must match active revenue or expense accounts.
The file is parsed in your browser, then IQ Books sends normalised rows and a SHA-256 fingerprint. Each import records its filename, fingerprint, row count and cells replaced. Export the visible window as CSV, Excel or OpenDocument; spreadsheet support loads only when you request import/export, so ordinary bookkeeping carries no spreadsheet-library cost.
Budget summary and variance
Reports → Budget variance shows each account by month and in total. Budget Summary hides actual and variance values. Variance follows the standard formula actual minus budget; percentage variance divides that result by budget. A zero budget shows no percentage rather than an invented infinite result.
Favourability is contextual: revenue above plan is favourable, while expenses below plan are favourable. Green and red therefore describe business meaning, not the mathematical sign alone. Net variance compares budgeted profit with actual profit.
Accrual and cash actuals
Accrual uses posted revenue and expense journal lines in the month they are recognised. Cash moves sales and bill lines into the months their invoice allocations are received or paid, pro-rated for part payments. Employee expense claims follow reimbursement dates; company-card claims follow their paid expense date. Direct bank-coded transactions, manual journals, depreciation and realised FX follow their posted journal treatment. Reversals and year-end-close journals are excluded.
Overspend alerts
What RiQ found tells you when a cost has spent past its line in this year’s company budget so far (the whole-organisation budget covering most of the year, the Overall Budget when two tie), by how much and by what share. It compares only the months that have postings, and waits until a line is over by 5% and £100 (both can be changed under Settings → Automation). Where the budget has sales in it, the part of a cost that moves with sales is allowed for, as LedgerIQ’s flexed budget does: a busier month is not called an overspend. A budget with no sales in it compares each line with its own budget. A notice you have seen comes back only when the overspend passes a quarter, a half, then double the line.
Permissions and audit
Every organisation member who can read reports may view budgets. Owner, admin and bookkeeper can create, edit, fill, import, copy and delete. Additional-budget deletion is a soft archive: it disappears from planning surfaces but remains audit evidence. Every mutation records actor, scope and affected periods without posting to the ledger.
RiQ boundaries
RiQ can explain a variance, identify favourable and unfavourable accounts, and navigate to the manager or report. It must never describe a budget as booked income, committed cash or a forecast produced by the ledger. Budget writes, imports and deletion remain explicit interface actions until typed preview operations are deliberately added.