Solavel Docs
English

How do I track costs by department and compare them with a budget?

Last updated

App: SolaCount. Outcome: every cost line carries a department, each department has its own budget, and Budget vs Actual shows which department is over plan.

#The situation

Palm Grove Furnishings LLC has three departments: Sales, Operations and Administration. Mona Fares (finance manager) wants to see each department's spending every month and to know when an expense account goes over its plan. Layla Haddad (accountant) enters the bills and expenses. This is a separate practice case: October 2026, AED, amounts exclude VAT.

#How a department plan works

Since 20 November 2026 a budget can be limited to one value of a dimension, so each department gets its own plan.

Question Answer in the product
Can I tag a cost with a department? Yes. A dimension (for example Department) is chosen on each bill, expense or journal line.
Can I see spending per department? Yes. Expenses by Dimension and P&L by Dimension group posted cost by one or two dimensions.
Can a budget be limited to one department? Yes. On the budget form, Dimension value (optional) scopes the budget to one value such as Department: Sales. Its actuals are the posted lines tagged with that value.
Is there a roll-up from child values to a parent value? No. Each value has its own budget; nothing is added up for you.

A dimension named "Cost center" works exactly like "Department". Create it in the same way if you prefer that word.

#What you need first

  • Dimensions and Budgets both depend on the plan. If Settings → Dimensions or Accounting Budgets is missing, check Settings → Plan & Features.
  • Permissions: dimensions.manage to create the dimension, dimensions.assign to tag lines, dimensions.view to open the reports, budgets.manage to create the budget and budgets.view to read it.
  • Expense accounts for the costs you want to watch. This example uses Travel and Marketing.

#Steps

  1. Open Settings → Dimensions. In Create Dimension Type, enter Department and click Create. Leave Allow multiple values per line off, so each line belongs to exactly one department and totals are never counted twice.
  2. In the new dimension's Values section, add Sales, Operations and Administration with Add Value.
  3. Under Required Accounts, choose Travel and click Require. Repeat for Marketing. From now on a line posted to these accounts cannot be saved without a Department.
  4. Create one plan per department. Open Projects → Financial control → Accounting Budgets → New Accounting Budget and enter:
Field Value
Budget name Q4 2026 Sales department
Start date / End date 1 October 2026 – 31 December 2026
Period type Monthly
Accounting basis Accrual
Status Active
Dimension value (optional) Department: Sales

In Accounts, tick Travel and Marketing. In the Budget Grid enter Travel 4,000 and Marketing 4,000 for October, then click Copy first period to fill November and December. Click Save Finance Budget. Repeat for Operations (Travel 1,500) and Administration (Travel 1,000), each with its own Dimension value (optional). 5. Record the October costs. On every bill or expense, use the Department field in the document header (it applies to all lines), or set it per line from the line's allocation control when one document covers several departments. A header that shows Mixed (per line) means the lines differ.

Date Document Account Department Amount
4 Oct Expense: airfares Travel Sales 3,200
11 Oct Bill from Skyline Travel Agency Travel Sales 2,000
18 Oct Expense: delivery van trips Travel Operations 1,400
25 Oct Expense: visa renewal trip Travel Administration 500
20 Oct Bill: showroom campaign Marketing Sales 3,600
  1. Post the documents. Only posted entries appear in budgets and reports.

#Worked numbers

Open Reports → Budgets → Budget vs Actuals and set Scope to All scopes, or pick one value such as Department: Sales. October rows:

Scope Account Budget Actual Variance Used % Status
Department: Sales Travel 4,000.00 5,200.00 −1,200.00 130% Over budget
Department: Sales Marketing 4,000.00 3,600.00 400.00 90% Near limit
Department: Operations Travel 1,500.00 1,400.00 100.00 93% Near limit
Department: Administration Travel 1,000.00 500.00 500.00 50% On track

Each actual is the posted lines tagged with that department, so Sales travel is 3,200 + 2,000 = 5,200. Sales caused the overrun, and the budget itself says so.

For one table, set View to Combined by Department. The page Budget vs actual by dimension lists the budgets of each department next to the company-wide budgets, with the totals Dimension-scoped budget, Dimension-scoped actual, Company-wide budget and Company-wide actual. For October the scoped actual is 5,200 + 3,600 + 1,400 + 500 = 10,700. The totals cover the whole period you select, so filter to October to match the table.

Expenses by Dimension still gives the same split from the report side: Accounts → Travel only, Group By → Department shows Sales 5,200, Operations 1,400, Administration 500, total 7,100.

#What to check

  • For a scoped budget, Actual equals the Expenses by Dimension figure for the same account, department and dates. If they differ, check the dates and unposted drafts.
  • No Unassigned row, or only a row you understand. Unassigned means posted lines with no Department value.
  • The report lists the transaction lines behind each figure (up to 300 rows), so you can open any one.
  • PDF, Print and Excel buttons export the same view for the monthly pack.

#Common variations

  • A company-wide limit as well. Keep a normal budget with Company-wide (no dimension) for the account total. It counts every posted line of the account, whatever its Department, and sits beside the department budgets in the combined view.
  • Project-specific plan. The budget form's Project dimension (finance tagging only) limits actuals to lines tagged with one project. That is a project, not a Department value, and it does not replace Project Budget Control inside the project.
  • Two dimensions at once. In Group By pick Department and a second dimension such as Branch; the report becomes a matrix. See Sales by channel and branch for how to read it.

#Mistakes to avoid

  • Expecting a parent value to add up its child values. There is no roll-up: give each department its own budget.
  • Forgetting Dimension value (optional) on the form. The budget then counts the whole account, not one department.
  • Leaving a dimension optional on cost accounts. Add the Required Accounts rule so nothing slips into Unassigned.
  • Allowing several values on a line for a cost split. A multi-value line counts 1/n under each value; to split by exact amounts, use separate lines, one per department.
  • Using Cash basis for the budget. Cash-basis budgets cannot show actuals yet; use Accrual.
  • Comparing a quarterly total with a monthly column. Actuals are matched to the month's column, so use Monthly for variance.
  • Retagging history. Posted documents keep their original tags; correct a wrong department through the posted-correction route, not by editing the report.

Dimensions & custom fields, Budgets, Expenses, Bills, Reports, Sales by channel and branch, Business Solutions & Examples.