looped.shDocs
Looped Financials

Budgets

Set a budget for the financial year, phase it into months and track actuals against it

A budget is set per financial year for each income and expense account. Open it from Reports → Budget; it follows the financial year picked in the header. Amounts are in each account's normal sign, so income and expenses are both entered as positive amounts.

Annual figure and phasing

In the Year view (the default), each account has an annual budget and a phasing that turns it into months:

  • Even: twelve equal months.
  • Like last year: the months follow last year's actuals for the account, so a seasonal account keeps its shape. An account with no history is spread evenly.
  • By quarter: four quarter shares (percentages or amounts), each spread evenly over its months.
  • Custom: whatever the months say. Editing any month makes an account custom.

Cents left over from a split go on the last month of the period: the year, or each quarter.

Phase sets the phasing for every account or a section (all operating expenses, say) in one go. Custom accounts keep their months.

Quarters and months

Quarters and Months show the same budget in more detail. Typing a quarter phases the account by quarter; typing a month makes it custom. Typing into Total spreads the year evenly.

In Months you can paste a block of cells copied from Excel or Google Sheets into any cell. It fills right and down from that cell. Amounts like 1 250.50, 1,250.50 and (300) are read; cells that aren't amounts are left out.

Copy last year's actuals sets every account's annual budget to last year's actuals, raised or lowered by a percentage, phased like last year.

Changes wait in a bar at the top until you Save or Discard them.

Tracking

The Tracking tab shows each account's and section's actual as a percentage of budget for a month, a quarter, the year to date or the full year. Income under budget and spending over budget show in the warning colour. Bars stop at 150%, and the number shows the rest. On the full year a dark line marks where you'd be by now if the year ran evenly.

The dashboard shows an Against budget card when the year has a budget: net profit for the year to date against budget, with income and expenses as bars.

Budget on the income statement

Income statement → Budget lays out the statement with its sections, subtotals and gross and net profit, with Actual, Budget, Variance and Variance % columns for a month, a quarter, the year to date or the full year. Variance is favourable when positive: more income or less spending than budgeted. Budgeted shows the statement from the budget alone, the year as the plan sees it. Both export to CSV, PDF and Excel.

The management report gets a "Budget and actual" section after the profit and loss when the year has a budget, for the report's month, the quarter to date and the year to date.

With an AI assistant

Over MCP, get_budget, set_budget and get_budget_vs_actual read and save the budget and compare it with actuals. The Draft a budget from last year playbook builds a draft from last year's actuals and your growth assumptions for each section and shows it to you before anything is saved.

Are you an AI? Visit llms.txt — these docs as plain markdown.

On this page