Planning, Allocations, and Budgets

Plans and budgets compare expected performance with posted actuals. They remain outside the ledger. Allocations are different: approved allocation runs create journals that redistribute posted balances.

Budgets

Open Planning & Assets → Budgets. Filter by branch, fiscal year, account, or dimension. Columns show branch, year, account, dimension, month, amount, currency, and created date.

Create a row with branch, fiscal year, account, optional dimension, month, and amount. For bulk work choose Import Budget, download the CSV template, replace sample IDs and amounts, and upload CSV/TXT/XLS/XLSX. Review import errors by row; do not assume rejected rows were saved.

Budgets do not post journals. Review them in Budget vs Actual.

Plans and Forecasts

Plans are versioned grids with maker-checker control.

Create or import

Enter branch, fiscal year, plan type (Budget or Forecast), scenario, name, and comments. Add rows with period, account, optional dimensions, amount, optional driver and driver value, and comment. A period/account/dimension combination can appear once.

Scenarios include Baseline, Optimistic, Conservative, Custom, Upside, and Rolling. Drivers include covers, average check, sales %, food-cost %, labor hours, employee count, delivery orders, fixed amount, and revenue growth.

Import accepts CSV/XLSX/XLS up to 20 MB and 10,000 rows. Use exact required columns and database IDs; separate multiple dimension IDs with | or comma. Import creates a Draft and never posts journals.

Workflow and tools

Lifecycle: Draft → Pending Approval → Approved → Locked, with Rejected, Superseded, and Archived alternatives.

• Submit stops draft editing and requests approval.
• Approve/Reject records reviewer reason.
• Lock preserves the approved version as controlled evidence.
• Create Revision copies it into a new Draft and supersedes the prior version.
• Actual Comparison compares every planning row with posted ledger amounts.
• Roll Forecast replaces closed periods through the chosen date with actuals and creates a new scenario/version for remaining periods.

Allocation Rules

An allocation distributes one source account balance to destination accounts/dimensions. Enter branch, code/name, source account and direction, driver type, effective dates, recurring flag, and destinations. Each destination has account, dimensions, and driver value.

Driver types are fixed amount, percentage, revenue, headcount, area, transaction volume, labor hours, or custom. Percentages must total 100%; fixed amounts must equal the frozen source at preparation; other values act as relative weights.

Create a new effective-dated version to change a rule already used.

Allocation Runs

1. Open a rule and Prepare Preview for an accounting period.
2. Review frozen source balance, driver evidence, destination share/amount, dimensions, and controlled rounding.
3. Submit → Approve or Reject → Post Journal.
4. If a posted run is wrong, Reverse with an explanation.

Statuses are Prepared, Pending Approval, Approved, Posted, Rejected, and Reversed. Preparation is idempotent for the same rule and period. Posting creates the balanced reclassification journal; reversal creates a linked opposite journal.

Example: Allocate JOD 1,000 rent

Create a Percentage rule sourcing Rent Expense and destinations Dining 60%, Delivery 25%, and Administration 15% using dimensions. Prepare the month: amounts are 600, 250, and 150. After approval/posting, total rent remains JOD 1,000 but its analytical/destination distribution changes. Allocation Audit proves source and destinations reconcile.

Dimension Analysis

Use Dimension Profit and Loss, Dimension to GL Reconciliation, Budget vs Actual, Scenario Comparison, and Allocation Audit. Unassigned shows posted activity without the selected dimension; it is useful for finding incomplete rules or source data.